Re: Installing DBD::mysql with cygwin

Patrick Hello,


Sorry about this newbie question:
how do I put 'mysql_config' on my path ? Is it a
program ?

I think the problem is that make looks for header
files that are not existing, in existing folders. 
According to the instructions I used the command:
./configure --prefix=/usr/local/mysql --without-server
when I installed mysql linux source under cygwin. 
Maybe this command doesn't create all headers because
its "--without-server" ? 


Avi




--- Patrick Galbraith <[email protected]> wrote:

> 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]
> 
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

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