Re: Installing DBD::mysql on leopard server
On Feb 18, 2:06 pm, [EMAIL PROTECTED] (Enrique Terrazas) wrote: 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 installingDBD::mysqlon 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 forDBD::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,
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: Installing DBD::mysql on Leopard
Hi Charlie, I had the same problem on both Tiger and Leopard. It seems that the newer mysql builds have moved some of the libraries and the config files haven't caught up. The article/blog that helped me is: http://jayallen.org/journey/2006/04/dbd-mysql-build-problems-on-mac-book-pro The simplest solution for me is towards the end in the comments mentioning creating links from where it thinks it should be to the new location, the solution that I used. ln -s /usr/local/mysql/lib /usr/local/mysql/lib/mysql ln -s /usr/local/mysql/include /usr/local/mysql/include/mysql (use sudo as needed) Your mileage may vary so read all the comments, there are several different solutions that you could also use at compile time. Good Luck Good afternoon, I'm having trouble installing DBD::mysql on OS X Leopard, and I can't get any answers from Google that help. I've got a fresh Leopard install so there shouldn't be any legacy issues. I've tried compiling DBD::mysql against package version of mySQL (mysql-max-4.1.22-apple-darwin8.6.0-powerpc-64bit) as well as against mySQL compiled from source. I was getting errors caused by architecture mis-match which I fixed by setting ARCHFLAGS='-arch i386 -arch ppc -arch ppc64 -arch x86_64' before running perl Makefile.PL. I also tried setting it as ARCHFLAGS='-arch ppc64'. I get a few warnings during make, such as: cc -c -I/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI - arch i386 -arch ppc -arch ppc64 -arch x86_64 -I/usr/local/mysql/ include -Os -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.006\ - DXS_VERSION=\4.006\ -I/System/Library/Perl/5.8.8/darwin-thread- multi-2level/CORE dbdimp.c dbdimp.c: In function ‘alloc_param’: dbdimp.c:112: warning: comparison is always false due to limited range of data type dbdimp.c: In function ‘alloc_bind’: dbdimp.c:130: warning: comparison is always false due to limited range of data type dbdimp.c: In function ‘alloc_fbind’: dbdimp.c:146: warning: comparison is always false due to limited range of data type dbdimp.c: In function ‘alloc_fbuffer’: dbdimp.c:161: warning: comparison is always false due to limited range of data type dbdimp.c: In function ‘mysql_describe’: dbdimp.c:3252: warning: assignment from incompatible pointer type dbdimp.c: In function ‘mysql_describe’: dbdimp.c:3252: warning: assignment from incompatible pointer type dbdimp.c: In function ‘alloc_param’: dbdimp.c:112: warning: comparison is always false due to limited range of data type dbdimp.c: In function ‘alloc_bind’: dbdimp.c:130: warning: comparison is always false due to limited range of data type dbdimp.c: In function ‘alloc_fbind’: dbdimp.c:146: warning: comparison is always false due to limited range of data type dbdimp.c: In function ‘alloc_fbuffer’: dbdimp.c:161: warning: comparison is always false due to limited range of data type dbdimp.c: In function ‘mysql_describe’: dbdimp.c:3252: warning: assignment from incompatible pointer type dbdimp.c: In function ‘mysql_describe’: dbdimp.c:3252: warning: assignment from incompatible pointer type cc -c -I/Library/Perl/5.8.8/darwin-thread-multi-2level/auto/DBI - arch i386 -arch ppc -arch ppc64 -arch x86_64 -I/usr/local/mysql/ include -Os -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.006\ - DXS_VERSION=\4.006\ -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 I think those are just warnings though and not related the problems I'm having. The show-stopper is the make test stage when I get errors such as: PERL_DL_NONLAZY=1 /usr/bin/perl -MExtUtils::Command::MM -e test_harness(0, 'blib/lib', 'blib/arch') t/*.t t/00base1/5 install_driver(mysql) failed: Can't load '/Users/charlie/.cpan/build/DBD-mysql-4.006-Pcd0BT/blib/arch/auto/ DBD/mysql/mysql.bundle' for module DBD::mysql: dlopen(/Users/ charlie/.cpan/build/DBD-mysql-4.006-Pcd0BT/blib/arch/auto/DBD/mysql/ mysql.bundle, 2): Symbol not found: _is_prefix Referenced from: /Users/charlie/.cpan/build/DBD-mysql-4.006-Pcd0BT/ blib/arch/auto/DBD/mysql/mysql.bundle Expected in: dynamic lookup at (eval 3) line 3 Compilation failed in
