Re: Installing DBD::mysql with cygwin
Patrick Galbraith <[email protected]> Fri, 27 Apr 2007 15:41:32 -0400
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Benton, Kevin wrote: >So - if I say that I'm a new guy, does that mean I get three free newbie >questions too? :-) J/K! > > Well, hmm.... Your email is 'amd.com', so I will give you all kinds of answers to questions as long as you send me some nice amd64 processors ;) regards, Patrick >Kevin Benton >MySQL DBA #5739 >Senior Software Developer >MSS Silicon Design Engineering >Advanced Micro Devices > >The opinions stated in this communication do not necessarily reflect the >view of Advanced Micro Devices and have not been reviewed by management. >This communication may contain sensitive and/or confidential and/or >proprietary information. Distribution of such information is strictly >prohibited without prior consent of Advanced Micro Devices. This >communication is for the intended recipient(s) only. If you have >received this communication in error, please notify the sender, then >destroy any remaining copies of this communication. > > > > >>-----Original Message----- >>From: Patrick Galbraith [mailto:[email protected]] >>Sent: Friday, April 27, 2007 1:25 PM >>To: Fungazid >>Cc: [email protected] >>Subject: Re: Installing DBD::mysql with cygwin >> >>Fungazid, >> >>Ok, you're a new guy, so you get 3 free newbie questions! >> >>Try to find mysql_config: "locate mysql_config" or "find / -name >>'mysql_config'". Once you find where it is, say it's in >> >> >/usr/local/bin, > > >>you would do "export PATH=$PATH:/usr/local/bin", then you should be >> >> >set. > > >>regards, >> >>Patrick >> >>Fungazid wrote: >> >> >> >>>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 >>> >>> >>> >>> >>-- >>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] > > >> >> > > > > > -- 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]