Re: Installing DBD::mysql with cygwin

Patrick Galbraith <[email protected]> Thu, 26 Apr 2007 17:43:55 -0400
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
Fungazid wrote:

>Hello to you [email protected] people
>   
>I am trying to install DBD::mysql under cygwin in
>windows xp. 
>I followed the instruction here:
>http://search.cpan.org/dist/DBD-mysql/lib/DBD/mysql/INSTALL.pod
>Everything worked OK except of the 'make' step for
>DBD::mysql
>   
>so this is what I did:
>   
>installing mysql and cygwin: -->OK
>1) installed mysql under windows xp successfully
>2) installed all cygwin modules successfully
>3) I installed and run perl scripts and modules on
>cygwin with no problems
>   
>DBI under cygwin: -->OK
>1) I installed DBI successfully (makefile, make, make
>test, make install)
>   
>installed mysql linux source under cygwin --> OK
>1) cygwin is installed under C:\cygwin folder. 
>2) I unpacked mysql linux source to C:\cygwin\home. 
>3) I CD to the new folder
>(C:\cygwin\home\mysql-5.0.37).
>4) run the command:
>./configure --prefix=/usr/local/mysql --without-server
>5)  make
>6) make install
>7) cd /usr/local/mysql/bin
>8) connected successfully to mysql server under cygwin
>by:
>./mysql -h 127.0.0.1 -u root
>9) tested mysql under cygwin (select,insert,use,
>etc..) and everything worked fine.
>   
>installing DBD --> PROBLEM IN STEP 5
>1) tar -xvf DBD-mysql-4.004.tar
>2) cd DBD-mysql-4.004
>3) cp /usr/local/mysql/bin/mysql_config .
>4) perl Makefile.PL --testhost=127.0.0.1 
>5) make ------------> got errors
>   
>this is the output I got from 'make':
>
>     
>$ make
>cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
>cp lib/DBD/mysql/GetInfo.pm
>blib/lib/DBD/mysql/GetInfo.pm
>cp lib/DBD/mysql/INSTALL.pod
>blib/lib/DBD/mysql/INSTALL.pod
>cp lib/Bundle/DBD/mysql.pm
>blib/lib/Bundle/DBD/mysql.pm
>gcc -c  -I/usr/lib/perl5/site_perl/5.8/cygwin/auto/DBI
>-I/usr/local/mysql/includ
>e/mysql -DDBD_MYSQL_INSERT_ID_IS_GOOD -g 
>-DPERL_USE_SAFE_PUTENV -fno-strict-ali
>asing -pipe -I/usr/local/include -DUSEIMPORTLIB -O3  
>-DVERSION=\"4.004\" -DXS_V
>ERSION=\"4.004\"  "-I/usr/lib/perl5/5.8/cygwin/CORE"  
>dbdimp.c
>In file included from dbdimp.c:20:
>dbdimp.h:23:45: mysqld_error.h: No such file or
>directory
>dbdimp.c: In function `mysql_db_FETCH_attrib':
>dbdimp.c:2296: warning: cast from pointer to integer
>of different size
>dbdimp.c: In function `mysql_st_prepare':
>dbdimp.c:2508: error: `ER_UNSUPPORTED_PS' undeclared
>(first use in this function
>)
>dbdimp.c:2508: error: (Each undeclared identifier is
>reported only once
>dbdimp.c:2508: error: for each function it appears
>in.)
>dbdimp.c: In function `mysql_st_FETCH_attrib':
>dbdimp.c:4136: warning: cast from pointer to integer
>of different size
>make: *** [dbdimp.o] Error 1
>   
>
>
>  
>
Hi,

Looks to me like 'make' is not finding your mysql header files. Do you 
have the program 'mysql_config' in your path? If you don't, make sure it 
is, and then re-run 'perl Makefile.PL', then 'make'. See if this helps.

regards,

Patrick

>I would be greatful for your help in solving this
>problem
>   
>  Thanks 
>  Avi
>   
>   
>   
>   
>  
>
>   
>
>
>
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around 
>http://mail.yahoo.com 
>
>  
>


-- 
Patrick Galbraith, Senior Programmer 
Grazr - Easy feed grazing and sharing
http://www.grazr.com 

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad




-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]