Re: Installing DBD::mysql with cygwin

Patrick,

I see I still have 2 more newbie free questions so
I'll keep them for future use.
I solved my problem with no need to add any directory
to the path. The solution is to use the command:
./configure --prefix=/usr/local/mysql --enable-server

and not:
./configure --prefix=/usr/local/mysql

when installing mysql linux source on cygwin. After
that, installation of DBD::mysql is smooth.

Regards,
Fungazid

 

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

> 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
> 
=== message truncated ===


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