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, enclosures and all copies.

Have you tried Net::MySQL and mysqlPP?

   Regards,
    Court [email protected]