Installing DBD::mysql with cygwin

Installing DBD::mysql with cygwin

am 26.04.2007 23:01:56 von Fungazid

Hello to you perl@lists.mysql.com 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
 



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

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Installing DBD::mysql with cygwin

am 26.04.2007 23:43:55 von Patrick Galbraith

Fungazid wrote:

>Hello to you perl@lists.mysql.com 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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Installing DBD::mysql with cygwin

am 27.04.2007 00:40:12 von Fungazid

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 wrote:

> Fungazid wrote:
>
> >Hello to you perl@lists.mysql.com 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/perl?unsub=fungazid@yahoo.com
>
>


__________________________________________________
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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Installing DBD::mysql with cygwin

am 27.04.2007 21:25:19 von Patrick Galbraith

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 wrote:
>
>
>
>>Fungazid wrote:
>>
>>
>>
>>>Hello to you perl@lists.mysql.com 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/INSTAL L.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/perl?unsub=fungazid@yahoo.com
>>
>>
>>
>>
>
>
>__________________________________________________
>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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

RE: Installing DBD::mysql with cygwin

am 27.04.2007 21:30:14 von kevin.benton

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
=20
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.
=20

> -----Original Message-----
> From: Patrick Galbraith [mailto:patg@grazr.com]
> Sent: Friday, April 27, 2007 1:25 PM
> To: Fungazid
> Cc: perl@lists.mysql.com
> Subject: Re: Installing DBD::mysql with cygwin
>=20
> Fungazid,
>=20
> Ok, you're a new guy, so you get 3 free newbie questions!
>=20
> 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=3D$PATH:/usr/local/bin", then you should be
set.
>=20
> regards,
>=20
> Patrick
>=20
> Fungazid wrote:
>=20
> >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=3D/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 wrote:
> >
> >
> >
> >>Fungazid wrote:
> >>
> >>
> >>
> >>>Hello to you perl@lists.mysql.com 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/INSTAL L.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=3D/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=3D127.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=3D\"4.004\" -DXS_V
> >>>ERSION=3D\"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/perl?unsub=3Dfungazid@yahoo.com
> >>
> >>
> >>
> >>
> >
> >
> >__________________________________________________
> >Do You Yahoo!?
> >Tired of spam? Yahoo! Mail has the best spam protection around
> >http://mail.yahoo.com
> >
> >
>=20
>=20
> --
> Patrick Galbraith, Senior Programmer
> Grazr - Easy feed grazing and sharing
> http://www.grazr.com
>=20
> Satyam Eva Jayate - Truth Alone Triumphs
> Mundaka Upanishad
>=20
>=20
>=20
>=20
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe:
http://lists.mysql.com/perl?unsub=3Dkevin.benton@amd.com
>=20
>=20




--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org

Re: Installing DBD::mysql with cygwin

am 27.04.2007 21:41:32 von Patrick Galbraith

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:patg@grazr.com]
>>Sent: Friday, April 27, 2007 1:25 PM
>>To: Fungazid
>>Cc: perl@lists.mysql.com
>>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 wrote:
>>>
>>>
>>>
>>>
>>>
>>>>Fungazid wrote:
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Hello to you perl@lists.mysql.com 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/INST ALL.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/perl?unsub=fungazid@yahoo.com
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>__________________________________________________
>>>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/perl?unsub=kevin.benton@amd.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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Installing DBD::mysql with cygwin

am 29.04.2007 16:30:59 von Fungazid

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 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 wrote:
> >
> >
> >
> >>Fungazid wrote:
> >>
> >>
> >>
> >>>Hello to you perl@lists.mysql.com 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/INSTAL L.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/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org