Mac Forum / Programming / Perl / April 2008

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