RE: Installing DBD::mysql with cygwin

So - if I say that I'm a new guy, does that mean I get three free newbie
questions too?  :-)  J/K!

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




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