Re: DBD::mysql library issue on mod_perl2/Leopard
Patrick Galbraith <[email protected]> Sun, 16 Mar 2008 16:17:26 -0400
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Hi guys, this looks like an issue with embedded server support in the driver. I need to look at my patch queue - I think I might have a patch to fix this. Did any of you compile your driver with embedded support? --Patrick John McKisson wrote: >Hendrik, > >I also have the same problem as the previous poster, have followed your >build procedure and am still getting this in my apache error_log: > >[Sun Mar 16 16:00:18 2008] [notice] Apache/2.2.6 (Unix) mod_ssl/2.2.6 >OpenSSL/0.9.7l DAV/2 mod_perl/2.0.3 Perl/v5.8.8 configured -- resuming >normal operations >dyld: lazy symbol binding failed: Symbol not found: _mysql_server_init > Referenced from: >/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle > Expected in: dynamic lookup > >dyld: Symbol not found: _mysql_server_init > Referenced from: >/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle > Expected in: dynamic lookup > >[Sun Mar 16 16:00:23 2008] [notice] child pid 39407 exit signal Trace/BPT >trap (5) > > >Any other ideas? > > > >Hendrik Van Belleghem wrote: > > >>Patrick, >> >>In attachment I have retraced my steps of building DBD::Mysql. It's build >>on >>top of the latest DBI 1.601 and Mysql 5.0.51 (custom built). >> >>Let me know how it works out for you :) >>Hendrik >> >> >>On Dec 10, 2007 3:48 PM, Patrick Galbraith <[email protected]> wrote: >> >> >> >>>Hendrik Van Belleghem wrote: >>> >>> >>> >>>>Hi >>>> >>>>I'm having some trouble with DBD::Mysql under mod_perl2 on Leopard. >>>>The build process when just fine, make test didn't show any errors and >>>>running it in console and as CGI didn't show any errors. I already tried >>>>adding "PerlSetEnv LD_LIBRARY_PATH >>>> >>>> >>>'/usr/local/mysql/lib/mysql/:/usr/lib'" >>> >>> >>>>and "SetEnv LD_LIBRARY_PATH /usr/local/mysql/lib/mysql" to my >>>> >>>> >>>configuration >>> >>> >>>>(which points to the libmysqlclient.15.dylib file) >>>> >>>> >>>> >>>> >>>> >>>Strange - this error looks like it's trying to compile in embedded >>>support "_mysql_server_init" >>> >>>Are you trying to compile in embedded? What are the steps you're taking >>>to compile? >>> >>>I'm the maintainer of DBD:mysql and will be upgrading my own mac that I >>>do dev on to Leopard this week hopefully and can see if I can duplicate >>>this error. >>> >>> >>> >>> >>>>The error log includes these messages for every request sent: >>>> >>>>dyld: lazy symbol binding failed: Symbol not found: _mysql_server_init >>>> Referenced from: >>>> >>>> >>>>/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle >>>> Expected in: dynamic lookup >>>> >>>>dyld: Symbol not found: _mysql_server_init >>>> Referenced from: >>>> >>>> >>>>/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle >>>> Expected in: dynamic lookup >>>> >>>>[Sun Dec 09 23:16:22 2007] [notice] child pid 439 exit signal Trace/BPT >>>> >>>> >>>trap >>> >>> >>>>(5) >>>> >>>>Any ideas? >>>> >>>> >>>> >>>> >>>> >>>-- >>>Patrick Galbraith, Senior Programmer >>>Grazr - Easy feed grazing and sharing >>>http://www.grazr.com >>> >>>Satyam Eva Jayate - Truth Alone Triumphs >>>Mundaka Upanishad >>> >>> >>> >>> >>> >>> >>-- >>Hendrik Van Belleghem >>Spine - The backbone for your website - http://spine.sf.net >> >>Last login: Mon Dec 10 22:09:54 on ttys000 >>lenore:~ hendrik$ su - >>Password: >>lenore:~ root# cd /home/hendrik/Downloads/DBD-mysql-4.005 >>lenore:DBD-mysql-4.005 root# make clean >>make: *** No rule to make target `clean'. Stop. >>lenore:DBD-mysql-4.005 root# export CFLAGS="-arch i386 -arch ppc -arch >>ppc64 -arch x86_64" >>lenore:DBD-mysql-4.005 root# export ARCHFLAGS="-arch i386 -arch ppc -arch >>ppc64 -arch x86_64" >>lenore:DBD-mysql-4.005 root# export PATH="$PATH:/usr/local/mysql/bin" >>lenore:DBD-mysql-4.005 root# /usr/local/mysql/bin/mysqld_safe & >>[1] 1530 >>lenore:DBD-mysql-4.005 root# A mysqld process already exists >> >>[1]+ Done(1) /usr/local/mysql/bin/mysqld_safe >>lenore:DBD-mysql-4.005 root# perl Makefile.PL >>--CFLAGS="-I/usr/local/mysql/include -Os -arch i386 -arch ppc -arch ppc64 >>-arch x86_64 -fno-common" --libs="-L/usr/local/mysql/lib/mysql >>-lmysqlclient -lz -lm" --testpassword="foobar" >>I will use the following settings for compiling and testing: >> >> cflags (User's choice) = -I/usr/local/mysql/include -Os -arch >>i386 -arch ppc -arch ppc64 -arch x86_64 -fno-common >> embedded (mysql_config ) = >> libs (User's choice) = -L/usr/local/mysql/lib/mysql >>-lmysqlclient -lz -lm >> mysql_config (guessed ) = mysql_config >> nocatchstderr (default ) = 0 >> nofoundrows (default ) = 0 >> ssl (guessed ) = 0 >> testdb (default ) = test >> testhost (default ) = >> testpassword (User's choice) = foobar >> testsocket (default ) = >> testuser (default ) = >> >>To change these settings, see 'perl Makefile.PL --help' and >>'perldoc INSTALL'. >> >>Checking if your kit is complete... >>Looks good >>Using DBI 1.601 (for perl 5.008008 on darwin-thread-multi-2level) >>installed in /Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI/ >>Writing Makefile for DBD::mysql >>lenore:DBD-mysql-4.005 root# 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 >>cc -c -I/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI >>-I/usr/local/mysql/include -Os -arch i386 -arch ppc -arch ppc64 -arch >>x86_64 -fno-common -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -arch i386 -arch ppc >>-arch ppc64 -arch x86_64 -g -pipe -fno-common -DPERL_DARWIN >>-no-cpp-precomp -fno-strict-aliasing -Wdeclaration-after-statement >>-I/usr/local/include -O3 -DVERSION=\"4.005\" -DXS_VERSION=\"4.005\" >>"-I/System/Library/Perl/5.8.8/darwin-thread-multi-2level/CORE" dbdimp.c >>dbdimp.c: In function 'mysql_describe': >>dbdimp.c: In function 'mysql_describe': >>dbdimp.c:3250: warning: assignment from incompatible pointer type >>dbdimp.c:3250: warning: assignment from incompatible pointer type >>dbdimp.c: In function 'mysql_describe': >>dbdimp.c:3250: warning: assignment from incompatible pointer type >>dbdimp.c: In function 'mysql_describe': >>dbdimp.c:3250: warning: assignment from incompatible pointer type >>/usr/bin/perl -p -e "s/~DRIVER~/mysql/g" >>/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI/Driver.xst > >>mysql.xsi >>/usr/bin/perl /System/Library/Perl/5.8.8/ExtUtils/xsubpp -typemap >>/System/Library/Perl/5.8.8/ExtUtils/typemap mysql.xs > mysql.xsc && mv >>mysql.xsc mysql.c >>Warning: duplicate function definition 'do' detected in mysql.xs, line 225 >>Warning: duplicate function definition 'rows' detected in mysql.xs, line >>612 >>cc -c -I/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI >>-I/usr/local/mysql/include -Os -arch i386 -arch ppc -arch ppc64 -arch >>x86_64 -fno-common -DDBD_MYSQL_INSERT_ID_IS_GOOD -g -arch i386 -arch ppc >>-arch ppc64 -arch x86_64 -g -pipe -fno-common -DPERL_DARWIN >>-no-cpp-precomp -fno-strict-aliasing -Wdeclaration-after-statement >>-I/usr/local/include -O3 -DVERSION=\"4.005\" -DXS_VERSION=\"4.005\" >>"-I/System/Library/Perl/5.8.8/darwin-thread-multi-2level/CORE" mysql.c >>mysql.xs: In function 'XS_DBD__mysql__db_do': >>mysql.xs:315: warning: comparison is always false due to limited range of >>data type >>mysql.xs:316: warning: comparison is always false due to limited range of >>data type >>mysql.xs: In function 'XS_DBD__mysql__db_do': >>mysql.xs:315: warning: comparison is always false due to limited range of >>data type >>mysql.xs:316: warning: comparison is always false due to limited range of >>data type >>Running Mkbootstrap for DBD::mysql () >>chmod 644 mysql.bs >>rm -f blib/arch/auto/DBD/mysql/mysql.bundle >>LD_RUN_PATH="/usr/local/mysql/lib/mysql:/usr/lib" /usr/bin/perl myld cc >>-mmacosx-version-min=10.5 -arch i386 -arch ppc -arch ppc64 -arch x86_64 >>-bundle -undefined dynamic_lookup -L/usr/local/lib dbdimp.o mysql.o -o >>blib/arch/auto/DBD/mysql/mysql.bundle \ >> -L/usr/local/mysql/lib/mysql -lmysqlclient -lz -lm \ >> >>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 >>Manifying blib/man3/DBD::mysql.3pm >>Manifying blib/man3/DBD::mysql::INSTALL.3pm >>Manifying blib/man3/Bundle::DBD::mysql.3pm >>lenore:DBD-mysql-4.005 root# make test >>PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" >>"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t >>t/00base.............ok >>t/10connect..........ok >>t/20createdrop.......ok >>t/30insertfetch......ok >>t/35limit............ok >>t/35prepare..........ok >>t/40bindparam........ok >>t/40bindparam2.......ok >>t/40blobs............ok >>t/40catalog..........ok >>t/40listfields.......ok >>t/40nulls............ok >>t/40numrows..........ok >>t/41bindparam........ok >>t/41blobs_prepare....ok >>t/42bindparam........ok >>t/50chopblanks.......ok >>t/50commit...........ok >>t/60leaks............skipped >> all skipped: $ENV{SLOW_TESTS} is not set >>t/70takeimp..........skipped >> all skipped: test feature not implemented >>t/75supported_sql....ok >>t/80procs............ok >>t/insertid...........ok >>t/multi_statement....ok >>t/param_values.......ok >>t/prepare_noerror....ok >>t/texecute...........ok >>t/utf8...............ok >>All tests successful, 2 tests skipped. >>Files=28, Tests=584, 3 wallclock secs ( 1.71 cusr + 0.44 csys = 2.15 >>CPU) >>lenore:DBD-mysql-4.005 root# make install >>Installing >>/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBD/mysql/mysql.bundle >>Files found in blib/arch: installing files in blib/lib into architecture >>dependent library tree >>Writing >>/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBD/mysql/.packlist >>Appending installation info to >>/System/Library/Perl/5.8.8/darwin-thread-multi-2level/perllocal.pod >>lenore:DBD-mysql-4.005 root# >>lenore:DBD-mysql-4.005 root# echo $LD_LIBRARY_PATH >>/usr/local/mysql/lib: >>lenore:DBD-mysql-4.005 root# ls -lah /usr/local/mysql/lib >>total 0 >>drwxr-xr-x 3 root wheel 102B Dec 7 18:19 . >>drwxr-xr-x 12 root wheel 408B Dec 7 18:09 .. >>drwxr-xr-x 20 root wheel 680B Dec 7 18:21 mysql >>lenore:DBD-mysql-4.005 root# ls -lah /usr/local/mysql/lib/mysql/ >>total 15464 >>drwxr-xr-x 20 root wheel 680B Dec 7 18:21 . >>drwxr-xr-x 3 root wheel 102B Dec 7 18:19 .. >>lrwxr-xr-x 1 root wheel 20B Dec 7 18:21 lib -> /usr/local/mysql/lib >>-rw-r--r-- 1 root wheel 14K Dec 7 18:19 libdbug.a >>-rw-r--r-- 1 root wheel 44K Dec 7 18:19 libheap.a >>-rw-r--r-- 1 root wheel 381K Dec 7 18:19 libmyisam.a >>-rw-r--r-- 1 root wheel 21K Dec 7 18:19 libmyisammrg.a >>-rwxr-xr-x 1 root wheel 1.3M Dec 7 18:19 libmysqlclient.15.0.0.dylib >>lrwxr-xr-x 1 root wheel 27B Dec 7 18:19 libmysqlclient.15.dylib -> >>libmysqlclient.15.0.0.dylib >>-rw-r--r-- 1 root wheel 1.5M Dec 7 18:19 libmysqlclient.a >>lrwxr-xr-x 1 root wheel 27B Dec 7 18:19 libmysqlclient.dylib -> >>libmysqlclient.15.0.0.dylib >>-rwxr-xr-x 1 root wheel 877B Dec 7 18:19 libmysqlclient.la >>-rwxr-xr-x 1 root wheel 1.3M Dec 7 18:19 >>libmysqlclient_r.15.0.0.dylib >>lrwxr-xr-x 1 root wheel 29B Dec 7 18:19 libmysqlclient_r.15.dylib >>-> libmysqlclient_r.15.0.0.dylib >>-rw-r--r-- 1 root wheel 1.5M Dec 7 18:19 libmysqlclient_r.a >>lrwxr-xr-x 1 root wheel 29B Dec 7 18:19 libmysqlclient_r.dylib -> >>libmysqlclient_r.15.0.0.dylib >>-rwxr-xr-x 1 root wheel 891B Dec 7 18:19 libmysqlclient_r.la >>-rw-r--r-- 1 root wheel 1.2M Dec 7 18:19 libmystrings.a >>-rw-r--r-- 1 root wheel 289K Dec 7 18:19 libmysys.a >>-rw-r--r-- 1 root wheel 6.5K Dec 7 18:19 libvio.a >>lenore:DBD-mysql-4.005 root# >> >> >>-- >>MySQL Perl Mailing List >>For list archives: http://lists.mysql.com/perl >>To unsubscribe: http://lists.mysql.com/[email protected] >> >> >> > > > -- 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]