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]