Re: Installing DBD::mysql on leopard server
You probably need to install the MySQL client libraries and headers first on Leopard server: http://docs.info.apple.com/article.html?artnum=306782 Enrique On Feb 18, 2008, at 4:23 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi I see that people are having trouble installing DBD::mysql on Leopard. Following the hints on this forum I successfully installed it on my laptop but can't do the same on X Server on our server. Has anyone made the breakthrough on Leopard X Server - the include directory etc that were deplaced on the home version of Leopard are not even there (or I can;t find them) on X Server 5.1 I've installed XCode etc. I want to use the built in Mysql and Perl if possible but if not then any suggestions welcome. On going through perl Makefile.PL etc I get the following: sh-3.2# perl Makefile.PL I will use the following settings for compiling and testing: cflags(mysql_config) = -I/usr/include -fno-omit-frame- pointer -pipe embedded (mysql_config) = libs (mysql_config) = -pipe -L/usr/lib -lmysqlclient -lz - lm mysql_config (guessed ) = mysql_config nocatchstderr (default ) = 0 nofoundrows (default ) = 0 ssl (guessed ) = 0 testdb(default ) = test testhost (default ) = testpassword (default ) = testsocket(default ) = testuser (default ) = To change these settings, see 'perl Makefile.PL --help' and 'perldoc INSTALL'. Checking if your kit is complete... Looks good Unrecognized argument in LIBS ignored: '-pipe' Note (probably harmless): No library found for -lmysqlclient Using DBI 1.52 (for perl 5.008008 on darwin-thread-multi-2level) installed in /System/Library/Perl/Extras/5.8.8/darwin-thread- multi-2level/auto/DBI/ Writing Makefile for DBD::mysql sh-3.2# 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/System/Library/Perl/Extras/5.8.8/darwin-thread-multi-2level/ auto/DBI -I/usr/include -fno-omit-frame-pointer -pipe - DDBD_MYSQL_INSERT_ID_IS_GOOD -g -arch i386 -arch ppc -g -pipe -fno- common -DPERL_DARWIN -no-cpp-precomp -fno-strict-aliasing - Wdeclaration-after-statement -I/usr/local/include -O3 -DVERSION= \4.006\ -DXS_VERSION=\4.006\ -I/System/Library/Perl/5.8.8/ darwin- thread-multi-2level/CORE dbdimp.c In file included from dbdimp.c:20In file included from dbdimp.c:20: : dbdimp.h:22:49:dbdimp.h:22:49: error: error: mysql.h: No such file or directorymysql.h: No such file or directory dbdimp.h:23:45:dbdimp.h:23:45: error: error: mysqld_error.h: No such file or directorymysqld_error.h: No such file or directory dbdimp.h:25:49: dbdimp.h:25:49:error: errmsg.h: No such file or directoryerror: errmsg.h: No such file or directory In file included from dbdimp.c:20: dbdimp.h:144: error: syntax error before 'MYSQL'In file included from dbdimp.c:20: dbdimp.h:144: error: syntax error before 'MYSQL' dbdimp.h:144: warning: no semicolon at end of struct or uniondbdimp.h: 144: warning: no semicolon at end of struct or union dbdimp.h:165: error: syntax error before '}' token dbdimp.h:165: error: syntax error before '}' token dbdimp.h:237: error: syntax error before 'MYSQL_RES' dbdimp.h:237: warning: no semicolon at end of struct or union dbdimp.h:237: error: syntax error before 'MYSQL_RES' dbdimp.h:237: warning: no semicolon at end of struct or union dbdimp.h:240: error: syntax error before 'row_num' dbdimp.h:240: error: syntax error before 'row_num' dbdimp.h:240: warning: data definition has no type or storage class dbdimp.h:240: warning: data definition has no type or storage class dbdimp.h:245: error: syntax error before 'insertid'dbdimp.h:245: error: syntax error before 'insertid' etc etc hundreds of errors -- Enrique Terrazas, MD, MS Director, Laboratory Medicine Residency Program Director, NCPL Laboratories Chief, Laboratory Information Systems HS Associate Clinical Professor University of California, San Francisco Clinical Laboratories, Box 0100 415.353.1375(UCSF/China Basin phone) 415.353.1620(UCSF/Parnassus phone) 415.353.4826(fax) 415.443.0913(pager) [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: The information contained in this transmission, including any enclosed files, is confidential and intended solely for the addressee. If you are not the intended recipient, you are hereby notified that any distribution, copying, disclosure and use of, the contents of this transmission is strictly prohibited. If you have received this communication in error, please notify the sender immediately by reply email and permanently delete this message, enclosures and all copies.
Re: Can't Install DBD::mysql
Take a look at the following to specify the makefile flags: http://jayallen.org/journey/2006/04/dbd-mysql-build-problems-on-mac- book-pro Enrique On Nov 28, 2007, at 2:58 PM, Charlie Minow wrote: On Nov 28, 2007, at 3:51 PM, Lola J. Lee Beno wrote: Charlie Minow wrote: I ran into this on Tiger as well. For some reason, it's looking for the MySQL libraries in the wrong place. MySQL puts them in�/ usr/local/mysql/lib, but the make file for DBD::mysql looks a little deeper, in�/usr/local/mysql/lib/mysql. I could never figure out how to fix that path in the makefile, so, in the interest of getting on with my life, I made a mysql directory in /usr/local/mysql/lib, then copied all the dylib files into that. As in copy all the files that already exist in /lib into /mysql directory which I need to create, right? Right. I just copied the .dylib files and none of the other ones into the new mysql directory, though. So far, it's all good. charlie -- Charlie Minow [EMAIL PROTECTED] http://www.cminow.org ...it may well be doubted whether human ingenuity can construct an enigma of the kind which human ingenuity may not, by proper application, resolve. - Edgar Allen Poe, The Gold Bug -- Enrique Terrazas, MD, MS Director, Laboratory Medicine Residency Program Director, NCPL Laboratories Chief, Laboratory Information Systems HS Associate Clinical Professor University of California, San Francisco Clinical Laboratories, Box 0100 415.353.1375(UCSF/China Basin phone) 415.353.1620(UCSF/Parnassus phone) 415.353.4826(fax) 415.443.0913(pager) [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: The information contained in this transmission, including any enclosed files, is confidential and intended solely for the addressee. If you are not the intended recipient, you are hereby notified that any distribution, copying, disclosure and use of, the contents of this transmission is strictly prohibited. If you have received this communication in error, please notify the sender immediately by reply email and permanently delete this message, enclosures and all copies.
Can't Install DBD::mysql
I installed the intel version of mysql (mysql-5.0.41-osx10.4- i686.dmg) which went fine. I then tried to install DBD::mysql with the following parameters: perl Makefile.PL --testdb=test --testuser=testuser -- testpassword=password --libs -L/usr/local/mysql/lib --cflags -I/usr/ local/mysql/include and got the following errors ... help! Enrique Terrazas -- make test PERL_DL_NONLAZY=1 /usr/local/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/00base.ok 1/5install_driver(mysql) failed: Can't load '/ Users/eterr/Desktop/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/ mysql.bundle' for module DBD::mysql: dlopen(/Users/eterr/Desktop/DBD- mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _mysql_stmt_store_result Referenced from: /Users/eterr/Desktop/DBD-mysql-4.005/blib/arch/ auto/DBD/mysql/mysql.bundle Expected in: dynamic lookup at (eval 3) line 3 Compilation failed in require at (eval 3) line 3. Perhaps a required shared library or dll isn't installed where expected at t/00base.t line 38 t/00base.dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 4-5 Failed 2/5 tests, 60.00% okay t/10connect..install_driver(mysql) failed: Can't load '/Users/ eterr/Desktop/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/eterr/Desktop/DBD-mysql-4.005/ blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _mysql_stmt_store_result Referenced from: /Users/eterr/Desktop/DBD-mysql-4.005/blib/arch/ auto/DBD/mysql/mysql.bundle Expected in: dynamic lookup at (eval 5) line 3 Compilation failed in require at (eval 5) line 3. Perhaps a required shared library or dll isn't installed where expected at t/10connect.t line 25 # Looks like your test died before it could output anything. t/10connect..dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-2 Failed 2/2 tests, 0.00% okay t/20createdrop...install_driver(mysql) failed: Can't load '/Users/ eterr/Desktop/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/eterr/Desktop/DBD-mysql-4.005/ blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _mysql_stmt_store_result Referenced from: /Users/eterr/Desktop/DBD-mysql-4.005/blib/arch/ auto/DBD/mysql/mysql.bundle Expected in: dynamic lookup at (eval 5) line 3 Compilation failed in require at (eval 5) line 3. Perhaps a required shared library or dll isn't installed where expected at t/20createdrop.t line 21 # Looks like your test died before it could output anything. t/20createdrop...dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-4 Failed 4/4 tests, 0.00% okay t/30insertfetch..install_driver(mysql) failed: Can't load '/Users/ eterr/Desktop/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/eterr/Desktop/DBD-mysql-4.005/ blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _mysql_stmt_store_result Referenced from: /Users/eterr/Desktop/DBD-mysql-4.005/blib/arch/ auto/DBD/mysql/mysql.bundle Expected in: dynamic lookup at (eval 5) line 3 Compilation failed in require at (eval 5) line 3. Perhaps a required shared library or dll isn't installed where expected at t/30insertfetch.t line 21 # Looks like your test died before it could output anything. t/30insertfetch..dubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-9 Failed 9/9 tests, 0.00% okay t/35limitinstall_driver(mysql) failed: Can't load '/Users/ eterr/Desktop/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/eterr/Desktop/DBD-mysql-4.005/ blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _mysql_stmt_store_result Referenced from: /Users/eterr/Desktop/DBD-mysql-4.005/blib/arch/ auto/DBD/mysql/mysql.bundle Expected in: dynamic lookup at (eval 5) line 3 Compilation failed in require at (eval 5) line 3. Perhaps a required shared library or dll isn't installed where expected at t/35limit.t line 24 # Looks like your test died before it could output anything. t/35limitdubious Test returned status 255 (wstat 65280, 0xff00) DIED. FAILED tests 1-111 Failed 111/111 tests, 0.00% okay t/35prepare..install_driver(mysql) failed: Can't load '/Users/ eterr/Desktop/DBD-mysql-4.005/blib/arch/auto/DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/eterr/Desktop/DBD-mysql-4.005/ blib/arch/auto/DBD/mysql/mysql.bundle, 2): Symbol not found: _mysql_stmt_store_result Referenced from: /Users/eterr/Desktop/DBD-mysql-4.005/blib/arch/ auto/DBD/mysql/mysql.bundle Expected in: dynamic lookup at (eval 5) line 3 Compilation failed in require at (eval 5) line 3. Perhaps a required shared library
Re: Can't Install DBD::mysql
Thanks all! The link below set me on the right track to get DBD::mysql installed. http://jayallen.org/journey/2006/04/dbd-mysql-build-problems-on- mac-book-pro -- Enrique Terrazas, MD, MS Director, Laboratory Medicine Residency Program Chief, Laboratory Information Systems HS Associate Clinical Professor University of California, San Francisco Clinical Laboratories, Box 0100 415.353.1375(UCSF/China Basin phone) 415.353.1620(UCSF/Parnassus phone) 415.353.4826(fax) 415.443.0913(pager) [EMAIL PROTECTED] CONFIDENTIALITY NOTICE: The information contained in this transmission, including any enclosed files, is confidential and intended solely for the addressee. If you are not the intended recipient, you are hereby notified that any distribution, copying, disclosure and use of, the contents of this transmission is strictly prohibited. If you have received this communication in error, please notify the sender immediately by reply email and permanently delete this message, enclosures and all copies.
Re: Test Mac::Carbon build for me?
Hi, I tried installing using cpan (Jaguar 10.2.2, perl 5.8.0) and ran into the following problem: CPAN.pm: Going to build C/CN/CNANDOR/Mac-Carbon-0.02.tar.gz [...] cp Carbon.pm blib/lib/Mac/Carbon.pm cp AppleEvents.pm ../blib/lib/Mac/AppleEvents.pm /usr/local/bin/perl /Library/Perl/ExtUtils/xsubpp -noprototypes -typemap /Library/Perl/ExtUtils/typemap AppleEvents.xs AppleEvents.xsc mv AppleEvents.xsc AppleEvents.c cc -c -I/Developer/Headers/FlatCarbon/ -pipe -fno-common -no-cpp-precomp -fno-strict-aliasing -O3 -DVERSION=\1.23\ -DXS_VERSION=\1.23\ -I/Library/Perl/darwin/CORE AppleEvents.c AppleEvents.xs: In function `XS_Mac__AppleEvents_AEGetNthDesc': AppleEvents.xs:424: parse error before AEDesc AppleEvents.xs:426: parse error before OSType make[1]: *** [AppleEvents.o] Error 1 make: *** [subdirs] Error 2 /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 -- Enrique Terrazas, MD, MS mailto:[EMAIL PROTECTED] http://pangloss.ucsfmedicalcenter.org/~terrazas/
Re: Test Mac::Carbon build for me?
Hi, The original message mentioned the version on the web site, which isn't on the CPAN. http://dev.macperl.org/tmp/Mac-Carbon-0.02_01.tar.gz The errors you got were expected with the version you used. Thanks, Whoops! Sorry about that. Builds and installs fine on 10.2.2 perl 5.8.0. Enrique -- Enrique Terrazas, MD, MS mailto:[EMAIL PROTECTED] http://pangloss.ucsfmedicalcenter.org/~terrazas/
