Problem installing DBD::mysql on Cygwin

Installing DBD::mysql in cygwin has always required a little extra
effort. But Cygwin's upgrade to perl 5.10 wiped out a number of CPAN
installs including DBD::mysql. This time around I'm stumped.

The instructions in the DBD::mysql-4.006 README file fail because
mysql_config cannot be found.

Following the instructions in the DBD::mysql-4.006 INSTALL.html file
starts better but then fails during compilation (see below).

I'm glad to post more or try things at this end to help sort this out,
but at this point the solution is beyond my skills. TIA -- David

Results for INSTALL.html method for installing on cygwin:
---------------------8<----------------------------------------------
admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
$ cp /usr/local/mysql/bin/mysql_config .

admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
$ perl Makefile.PL --testhost=127.0.0.1
I will use the following settings for compiling and testing:

cflags (mysql_config ) = -I/usr/local/mysql/include/mysql
embedded (mysql_config ) =
libs (mysql_config ) = -L/usr/local/mysql/lib/mysql
-lmysqlclient -lz
-lcrypt -lm
mysql_config (guessed ) = mysql_config
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (User's choice) = 127.0.0.1
testpassword (default ) =
testsocket (default ) =
testuser (default ) =

To change these settings, see 'perl Makefile.PL --help' and
'perldoc INSTALL'.

Using DBI 1.602 (for perl 5.010000 on cygwin-thread-multi-64int)
installed in /usr/lib/perl5/site_perl/5.10/cygwin/auto/DBI/
Writing Makefile for DBD::mysql

admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
$ make
gcc -c -I/usr/lib/perl5/site_perl/5.10/cygwin/auto/DBI
-I/usr/local/mysql/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
-DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -fno-strict-aliasing
-I/usr/local/include -DUSEIMPORTLIB -O3 -DVERSION=\"4.006\"
-DXS_VERSION=\"4.006\" "-I/usr/lib/perl5/5.10/cygwin/CORE" dbdimp.c
dbdimp.c: In function `mysql_db_FETCH_attrib':
dbdimp.c:2269: warning: cast from pointer to integer of different size
dbdimp.c: In function `mysql_st_prepare':
dbdimp.c:2482: error: `ER_UNSUPPORTED_PS' undeclared (first use in this
function)
dbdimp.c:2482: error: (Each undeclared identifier is reported only once
dbdimp.c:2482: error: for each function it appears in.)
dbdimp.c: In function `mysql_st_FETCH_attrib':
dbdimp.c:4073: warning: cast from pointer to integer of different size
make: *** [dbdimp.o] Error 1
---------------------8<----------------------------------------------

--
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: Problem installing DBD::mysql on Cygwin

Is this...
....poorly stated?
....insufficient information provided?
....insufficient effort?
....wrong venue?
....other?

Warnock's Dilemma applies. Please advise. ;-)

david

on 3/17/2008 5:01 PM David Vergin said the following:
> Installing DBD::mysql in cygwin has always required a little extra
> effort. But Cygwin's upgrade to perl 5.10 wiped out a number of CPAN
> installs including DBD::mysql. This time around I'm stumped.
>
> The instructions in the DBD::mysql-4.006 README file fail because
> mysql_config cannot be found.
>
> Following the instructions in the DBD::mysql-4.006 INSTALL.html file
> starts better but then fails during compilation (see below).
>
> I'm glad to post more or try things at this end to help sort this out,
> but at this point the solution is beyond my skills. TIA -- David
>
> Results for INSTALL.html method for installing on cygwin:
> ---------------------8<----------------------------------------------
> admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
> $ cp /usr/local/mysql/bin/mysql_config .
>
> admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
> $ perl Makefile.PL --testhost=127.0.0.1
> I will use the following settings for compiling and testing:
>
> cflags (mysql_config ) = -I/usr/local/mysql/include/mysql
> embedded (mysql_config ) =
> libs (mysql_config ) = -L/usr/local/mysql/lib/mysql
> -lmysqlclient -lz
> -lcrypt -lm
> mysql_config (guessed ) = mysql_config
> nocatchstderr (default ) = 0
> nofoundrows (default ) = 0
> ssl (guessed ) = 0
> testdb (default ) = test
> testhost (User's choice) = 127.0.0.1
> testpassword (default ) =
> testsocket (default ) =
> testuser (default ) =
>
> To change these settings, see 'perl Makefile.PL --help' and
> 'perldoc INSTALL'.
>
> Using DBI 1.602 (for perl 5.010000 on cygwin-thread-multi-64int)
> installed in /usr/lib/perl5/site_perl/5.10/cygwin/auto/DBI/
> Writing Makefile for DBD::mysql
>
> admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
> $ make
> gcc -c -I/usr/lib/perl5/site_perl/5.10/cygwin/auto/DBI
> -I/usr/local/mysql/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
> -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -fno-strict-aliasing
> -I/usr/local/include -DUSEIMPORTLIB -O3 -DVERSION=\"4.006\"
> -DXS_VERSION=\"4.006\" "-I/usr/lib/perl5/5.10/cygwin/CORE" dbdimp.c
> dbdimp.c: In function `mysql_db_FETCH_attrib':
> dbdimp.c:2269: warning: cast from pointer to integer of different size
> dbdimp.c: In function `mysql_st_prepare':
> dbdimp.c:2482: error: `ER_UNSUPPORTED_PS' undeclared (first use in this
> function)
> dbdimp.c:2482: error: (Each undeclared identifier is reported only once
> dbdimp.c:2482: error: for each function it appears in.)
> dbdimp.c: In function `mysql_st_FETCH_attrib':
> dbdimp.c:4073: warning: cast from pointer to integer of different size
> make: *** [dbdimp.o] Error 1
> ---------------------8<----------------------------------------------
>

--
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: Problem installing DBD::mysql on Cygwin

Ugh. Windows. Cygwin :)

I will look at this line of code to see what it does, and perhaps commit
something to subversion, maybe even send you a package with a fix (I
don't have a cygwin to check it) if you'd like.


David Vergin wrote:

> Is this...
> ...poorly stated?
> ...insufficient information provided?
> ...insufficient effort?
> ...wrong venue?
> ...other?
>
> Warnock's Dilemma applies. Please advise. ;-)
>
> david
>
> on 3/17/2008 5:01 PM David Vergin said the following:
>
>> Installing DBD::mysql in cygwin has always required a little extra
>> effort. But Cygwin's upgrade to perl 5.10 wiped out a number of CPAN
>> installs including DBD::mysql. This time around I'm stumped.
>>
>> The instructions in the DBD::mysql-4.006 README file fail because
>> mysql_config cannot be found.
>>
>> Following the instructions in the DBD::mysql-4.006 INSTALL.html file
>> starts better but then fails during compilation (see below).
>>
>> I'm glad to post more or try things at this end to help sort this
>> out, but at this point the solution is beyond my skills. TIA -- David
>>
>> Results for INSTALL.html method for installing on cygwin:
>> ---------------------8<----------------------------------------------
>> admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
>> $ cp /usr/local/mysql/bin/mysql_config .
>>
>> admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
>> $ perl Makefile.PL --testhost=127.0.0.1
>> I will use the following settings for compiling and testing:
>>
>> cflags (mysql_config ) = -I/usr/local/mysql/include/mysql
>> embedded (mysql_config ) =
>> libs (mysql_config ) = -L/usr/local/mysql/lib/mysql
>> -lmysqlclient -lz
>> -lcrypt -lm
>> mysql_config (guessed ) = mysql_config
>> nocatchstderr (default ) = 0
>> nofoundrows (default ) = 0
>> ssl (guessed ) = 0
>> testdb (default ) = test
>> testhost (User's choice) = 127.0.0.1
>> testpassword (default ) =
>> testsocket (default ) =
>> testuser (default ) =
>>
>> To change these settings, see 'perl Makefile.PL --help' and
>> 'perldoc INSTALL'.
>>
>> Using DBI 1.602 (for perl 5.010000 on cygwin-thread-multi-64int)
>> installed in /usr/lib/perl5/site_perl/5.10/cygwin/auto/DBI/
>> Writing Makefile for DBD::mysql
>>
>> admin@GatewayM275 /c/Docume~1/dvergin/Desktop/DBD-mysql-4.006
>> $ make
>> gcc -c -I/usr/lib/perl5/site_perl/5.10/cygwin/auto/DBI
>> -I/usr/local/mysql/include/mysql -DDBD_MYSQL_INSERT_ID_IS_GOOD -g
>> -DPERL_USE_SAFE_PUTENV -U__STRICT_ANSI__ -fno-strict-aliasing
>> -I/usr/local/include -DUSEIMPORTLIB -O3 -DVERSION=\"4.006\"
>> -DXS_VERSION=\"4.006\" "-I/usr/lib/perl5/5.10/cygwin/CORE" dbdimp.c
>> dbdimp.c: In function `mysql_db_FETCH_attrib':
>> dbdimp.c:2269: warning: cast from pointer to integer of different size
>> dbdimp.c: In function `mysql_st_prepare':
>> dbdimp.c:2482: error: `ER_UNSUPPORTED_PS' undeclared (first use in
>> this function)
>> dbdimp.c:2482: error: (Each undeclared identifier is reported only once
>> dbdimp.c:2482: error: for each function it appears in.)
>> dbdimp.c: In function `mysql_st_FETCH_attrib':
>> dbdimp.c:4073: warning: cast from pointer to integer of different size
>> make: *** [dbdimp.o] Error 1
>> ---------------------8<----------------------------------------------
>>
>


--
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: Problem installing DBD::mysql on Cygwin

on 3/22/2008 5:29 PM Patrick Galbraith said the following:
> I will look at this line of code to see what it does, and perhaps commit
> something to subversion, maybe even send you a package with a fix (I
> don't have a cygwin to check it) if you'd like.

Much obliged. Send something along when you have it and I'll be glad to
test.

dv

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