Re: DBI and DBD::MySQL (Panther)
To clear up any confusion for others that may pick up this thread, my previous email stated that a patch should not be made to perl sources... I mistook the details below as implying that each perl module (i.e. DBD::mysql) be patched for an error in the Config.pm module. In actuality, I believe, the patch is intended for the perl source itself... My bad. A demonstration of when to leave things up to those who know what they are talking about... C. On 10/15/03 6:28 PM, Edward Moy [EMAIL PROTECTED] wrote: In hints/darwin.sh, replace *) ld=MACOSX_DEPLOYMENT_TARGET=10.3 ${ld} ;; with *) ld=env MACOSX_DEPLOYMENT_TARGET=10.3 ${ld} ;; Hopefully, this will go into 5.8.2. Ed On Oct 15, 2003, at 5:05 PM, David Wheeler wrote: On Wednesday, October 15, 2003, at 04:58 PM, Edward Moy wrote: We recently discovered the DBD::mysql problem as well. The patch is to edit /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm, replacing: ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc' with ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc' Unfortunately, this change is too late to get into Panther. Is there a patch that could go into the Perl sources themselves? Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] Kineticode. Setting knowledge in motion.[sm]
Re: DBI and DBD::MySQL (Panther)
Mike, I was encountering the same errors as you in my quest to install DBD::mysql and discovered that under the following setup: Custom installed Perl 5.8.1 RC3 - No multi-threading ggc 2.95 - via /usr/sbin/gcc_select 2 Removing /sw/lib/perl5/Storable.pm /sw/lib/perl5/auto/Storable I was able to compile and install Bundle::Msql which installs DBD::mysql. I cannot isolate wich of the above steps actually fixed the problem but I noted this difference in the make procedure: Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f ../blib/arch/auto/DBD/mysql/mysql.bundle LD_RUN_PATH=/usr/lib MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -L/usr/local/mysql/lib -o ../blib/arch/auto/DBD/mysql/mysql.bundle -L/usr/local/mysql/lib -lmysqlclient -lm -lz chmod 755 ../blib/arch/auto/DBD/mysql/mysql.bundle cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.bundle LD_RUN_PATH=/usr/lib /usr/local/bin/perl myld MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.bundle -L/usr/local/lib -lz As you can see the first one carried on past the previous error point. I have a feeling that Bundle::Msql would successfully install under the default apple environment without switching gcc, without recompiling perl, and without removing Storable... I simply combined the methods of previous posts and hoped for the best. Later resorting to a memory of installing Bundle::Msql elsewhere. Someone should likely attempt to install Bundle::Msql under a clean OSX (Panther) install and report back on the outcome... cschilbe
Re: DBI and DBD::MySQL (Panther)
We recently discovered the DBD::mysql problem as well. The patch is to edit /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm, replacing: ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc' with ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc' Unfortunately, this change is too late to get into Panther. --- Edward Moy Apple On Oct 15, 2003, at 1:52 PM, Conrad Schilbe wrote: I was encountering the same errors as you in my quest to install DBD::mysql and discovered that under the following setup: Custom installed Perl 5.8.1 RC3 - No multi-threading ggc 2.95 - via /usr/sbin/gcc_select 2 Removing /sw/lib/perl5/Storable.pm /sw/lib/perl5/auto/Storable I was able to compile and install Bundle::Msql which installs DBD::mysql. I cannot isolate wich of the above steps actually fixed the problem but I noted this difference in the make procedure: Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f ../blib/arch/auto/DBD/mysql/mysql.bundle LD_RUN_PATH=/usr/lib MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -L/usr/local/mysql/lib -o ../blib/arch/auto/DBD/mysql/mysql.bundle -L/usr/local/mysql/lib -lmysqlclient -lm -lz chmod 755 ../blib/arch/auto/DBD/mysql/mysql.bundle cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.bundle LD_RUN_PATH=/usr/lib /usr/local/bin/perl myld MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.bundle -L/usr/local/lib -lz As you can see the first one carried on past the previous error point. I have a feeling that Bundle::Msql would successfully install under the default apple environment without switching gcc, without recompiling perl, and without removing Storable... I simply combined the methods of previous posts and hoped for the best. Later resorting to a memory of installing Bundle::Msql elsewhere. Someone should likely attempt to install Bundle::Msql under a clean OSX (Panther) install and report back on the outcome...
Re: DBI and DBD::MySQL (Panther)
On Wednesday, October 15, 2003, at 04:58 PM, Edward Moy wrote: We recently discovered the DBD::mysql problem as well. The patch is to edit /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm, replacing: ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc' with ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc' Unfortunately, this change is too late to get into Panther. Is there a patch that could go into the Perl sources themselves? Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] Kineticode. Setting knowledge in motion.[sm]
Re: DBI and DBD::MySQL (Panther)
In hints/darwin.sh, replace *) ld=MACOSX_DEPLOYMENT_TARGET=10.3 ${ld} ;; with *) ld=env MACOSX_DEPLOYMENT_TARGET=10.3 ${ld} ;; Hopefully, this will go into 5.8.2. Ed On Oct 15, 2003, at 5:05 PM, David Wheeler wrote: On Wednesday, October 15, 2003, at 04:58 PM, Edward Moy wrote: We recently discovered the DBD::mysql problem as well. The patch is to edit /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm, replacing: ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc' with ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc' Unfortunately, this change is too late to get into Panther. Is there a patch that could go into the Perl sources themselves? Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] Kineticode. Setting knowledge in motion.[sm]
Re: DBI and DBD::MySQL (Panther)
Edward, I edited /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm, switched perl back to the apple install and had no problems building DBD::mysql. Your information is greatly appreciated! c On 10/15/03 5:58 PM, Edward Moy [EMAIL PROTECTED] wrote: We recently discovered the DBD::mysql problem as well. The patch is to edit /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm, replacing: ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc' with ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc' Unfortunately, this change is too late to get into Panther. --- Edward Moy Apple On Oct 15, 2003, at 1:52 PM, Conrad Schilbe wrote: I was encountering the same errors as you in my quest to install DBD::mysql and discovered that under the following setup: Custom installed Perl 5.8.1 RC3 - No multi-threading ggc 2.95 - via /usr/sbin/gcc_select 2 Removing /sw/lib/perl5/Storable.pm /sw/lib/perl5/auto/Storable I was able to compile and install Bundle::Msql which installs DBD::mysql. I cannot isolate wich of the above steps actually fixed the problem but I noted this difference in the make procedure: Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f ../blib/arch/auto/DBD/mysql/mysql.bundle LD_RUN_PATH=/usr/lib MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -L/usr/local/mysql/lib -o ../blib/arch/auto/DBD/mysql/mysql.bundle -L/usr/local/mysql/lib -lmysqlclient -lm -lz chmod 755 ../blib/arch/auto/DBD/mysql/mysql.bundle cp mysql.bs ../blib/arch/auto/DBD/mysql/mysql.bs chmod 644 ../blib/arch/auto/DBD/mysql/mysql.bs Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.bundle LD_RUN_PATH=/usr/lib /usr/local/bin/perl myld MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.bundle -L/usr/local/lib -lz As you can see the first one carried on past the previous error point. I have a feeling that Bundle::Msql would successfully install under the default apple environment without switching gcc, without recompiling perl, and without removing Storable... I simply combined the methods of previous posts and hoped for the best. Later resorting to a memory of installing Bundle::Msql elsewhere. Someone should likely attempt to install Bundle::Msql under a clean OSX (Panther) install and report back on the outcome...
Re: DBI and DBD::MySQL (Panther)
I would think this should stay out of the perl sources since it is not a bug of perl's... Thoughts? I also just discovered that this fixes a build problem with Data::Dumper... Or so it would appear. It's possible this will effect several packages. The patch should not be put in all the perl sources should it? C On 10/15/03 6:28 PM, Edward Moy [EMAIL PROTECTED] wrote: In hints/darwin.sh, replace *) ld=MACOSX_DEPLOYMENT_TARGET=10.3 ${ld} ;; with *) ld=env MACOSX_DEPLOYMENT_TARGET=10.3 ${ld} ;; Hopefully, this will go into 5.8.2. Ed On Oct 15, 2003, at 5:05 PM, David Wheeler wrote: On Wednesday, October 15, 2003, at 04:58 PM, Edward Moy wrote: We recently discovered the DBD::mysql problem as well. The patch is to edit /System/Library/Perl/5.8.1/darwin-thread-multi-2level/Config.pm, replacing: ld='MACOSX_DEPLOYMENT_TARGET=10.3 cc' with ld='env MACOSX_DEPLOYMENT_TARGET=10.3 cc' Unfortunately, this change is too late to get into Panther. Is there a patch that could go into the Perl sources themselves? Regards, David -- David Wheeler AIM: dwTheory [EMAIL PROTECTED] ICQ: 15726394 http://www.kineticode.com/ Yahoo!: dew7e Jabber: [EMAIL PROTECTED] Kineticode. Setting knowledge in motion.[sm]
Re: DBI and DBD::MySQL (Panther)
On Friday, August 8, 2003, at 8:35 AM, Mike Schienle wrote: On Friday, August 8, 2003, at 7:28 AM, John Delacour wrote: At 4:09 pm -0600 7/8/03, Mike Schienle wrote: I'm having some trouble with DBI and DBD::MysqlPP (and DBD::MySQL) on 10.3. Can I get a sanity check response that some people are able to run one of these? 10.3 is not that important for what I'm working on, but MySQL is, so I can roll back to older versions of MacOS X, MySQL, etc., if necessary. I never got DBD::MySQL to make so I tried MySQLPP today, which installed fine. I'm about to check out DBI::PurePerl, as well. Any hints on getting this working so I don't have to roll back would be greatly appreciated. I haven't tried yet on Panther, but I guess nothing has changed and that you'll have to install Perl without threads in you wand to use DBI and MySQL. http://nathan.torkington.com/mac/ Thanks for the link, John. I'm also going to move back from an Alpha MySQL 4.1 to 4.0. I'll report back if anything works. Using MySQL 4.0, DBI 1.37 and DBD::mysqlPP worked for me. I'm getting a compile error with DBD::mysql listed below (I can spend a little time troubleshooting this, but not much): cpan install DBD::mysql Running install for module DBD::mysql Running make for R/RU/RUDY/DBD-mysql-2.9002.tar.gz ... Removing previously used /Users/mschienle/.cpan/build/DBD-mysql-2.9002 CPAN: Module::Signature security checks disabled because Module::Signature not installed. Please consider installing the Module::Signature module. CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9002.tar.gz I will use the following settings for compiling and testing: cflags(mysql_config) = -I'/usr/local/include/mysql' libs (mysql_config) = -L/usr/local/lib/mysql -lmysqlclient -lz -lm nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Argument 6.10_03 isn't numeric in numeric ge (=) at Makefile.PL line 89, PIPE line 58. Checking if your kit is complete... Looks good Using DBI 1.37 installed in /Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI Writing Makefile for DBD::mysql cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm cp lib/Mysql.pm blib/lib/Mysql.pm cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm cc -c -I/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI -I'/usr/local/include/mysql' -g -pipe -pipe -fno-common -no-cpp-precomp -fno-strict-aliasing -Os -DVERSION=\2.9002\ -DXS_VERSION=\2.9002\ -I/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE dbdimp.c /usr/local/bin/perl -p -e s/~DRIVER~/mysql/g /Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI/Driver.xst mysql.xsi /usr/local/bin/perl /System/Library/Perl/5.8.1/ExtUtils/xsubpp -typemap /System/Library/Perl/5.8.1/ExtUtils/typemap mysql.xs mysql.xsc mv mysql.xsc mysql.c Warning: duplicate function definition 'do' detected in mysql.xs, line 193 Warning: duplicate function definition 'rows' detected in mysql.xs, line 291 cc -c -I/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI -I'/usr/local/include/mysql' -g -pipe -pipe -fno-common -no-cpp-precomp -fno-strict-aliasing -Os -DVERSION=\2.9002\ -DXS_VERSION=\2.9002\ -I/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE mysql.c Running Mkbootstrap for DBD::mysql () chmod 644 mysql.bs rm -f blib/arch/auto/DBD/mysql/mysql.bundle LD_RUN_PATH=/usr/local/lib/mysql:/usr/lib /usr/local/bin/perl myld MACOSX_DEPLOYMENT_TARGET=10.3 cc -bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.bundle -L/usr/local/lib/mysql -lmysqlclient -lz -lm make: *** [blib/arch/auto/DBD/mysql/mysql.bundle] Error 1 /usr/bin/make -- NOT OK Running make test Can't test without successful make Running make install make had returned bad status, install seems impossible Mike Schienle
Re: DBI and DBD::MySQL (Panther)
Does this mean that the version of perl installed on Panther will not support DBI and DBD::MySQL? That would be a real pain. On Friday, Aug 8, 2003, at 15:28 Europe/Madrid, John Delacour wrote: At 4:09 pm -0600 7/8/03, Mike Schienle wrote: I'm having some trouble with DBI and DBD::MysqlPP (and DBD::MySQL) on 10.3. Can I get a sanity check response that some people are able to run one of these? 10.3 is not that important for what I'm working on, but MySQL is, so I can roll back to older versions of MacOS X, MySQL, etc., if necessary. I never got DBD::MySQL to make so I tried MySQLPP today, which installed fine. I'm about to check out DBI::PurePerl, as well. Any hints on getting this working so I don't have to roll back would be greatly appreciated. I haven't tried yet on Panther, but I guess nothing has changed and that you'll have to install Perl without threads in you wand to use DBI and MySQL. http://nathan.torkington.com/mac/ Robert Whittle BookAssist [EMAIL PROTECTED] http://www.bookassist.com
Re: DBI and DBD::MySQL (Panther)
On Friday, August 8, 2003, at 7:28 AM, John Delacour wrote: At 4:09 pm -0600 7/8/03, Mike Schienle wrote: I'm having some trouble with DBI and DBD::MysqlPP (and DBD::MySQL) on 10.3. Can I get a sanity check response that some people are able to run one of these? 10.3 is not that important for what I'm working on, but MySQL is, so I can roll back to older versions of MacOS X, MySQL, etc., if necessary. I never got DBD::MySQL to make so I tried MySQLPP today, which installed fine. I'm about to check out DBI::PurePerl, as well. Any hints on getting this working so I don't have to roll back would be greatly appreciated. I haven't tried yet on Panther, but I guess nothing has changed and that you'll have to install Perl without threads in you wand to use DBI and MySQL. http://nathan.torkington.com/mac/ Thanks for the link, John. I'm also going to move back from an Alpha MySQL 4.1 to 4.0. I'll report back if anything works. Mike Schienle
Re: DBI and DBD::MySQL (Panther)
On Friday, August 8, 2003, at 10:07 AM, Robert Whittle wrote: Does this mean that the version of perl installed on Panther will not support DBI and DBD::MySQL? I wouldn't try to read into my situation too much. I'm also using MySQL Alpha release 4.1.x. So, an alpha DB on a beta OS. I think I just walked past the edge. Mike Schienle
Re: DBI and DBD::MySQL (Panther)
At 4:09 pm -0600 7/8/03, Mike Schienle wrote: I'm having some trouble with DBI and DBD::MysqlPP (and DBD::MySQL) on 10.3. Can I get a sanity check response that some people are able to run one of these? 10.3 is not that important for what I'm working on, but MySQL is, so I can roll back to older versions of MacOS X, MySQL, etc., if necessary. I never got DBD::MySQL to make so I tried MySQLPP today, which installed fine. I'm about to check out DBI::PurePerl, as well. Any hints on getting this working so I don't have to roll back would be greatly appreciated. I haven't tried yet on Panther, but I guess nothing has changed and that you'll have to install Perl without threads in you wand to use DBI and MySQL. http://nathan.torkington.com/mac/