Installing DBD::mysql on MacOSX 10.3.2 (panther)

[Eric]

I am having great difficulty installing DBD::mysql on MacOSX 10.3.2
Server (panther). The full build log is below. The command I used to
install was:

perl -MCPAN -e 'install "DBD::mysql"'

I am using the recent version of mysql installed from FINK.

Any ideas?



CPAN: Storable loaded ok
Going to read /Users/xadmin/.cpan/Metadata
Database was generated on Fri, 16 Jan 2004 09:52:41 GMT
LWP not available
CPAN: Net::FTP loaded ok
Fetching with Net::FTP:
[url]ftp://archive.progeny.com/CPAN/authors/01mailrc.txt.gz[/url]
Going to read /Users/xadmin/.cpan/sources/authors/01mailrc.txt.gz
LWP not available
Fetching with Net::FTP:
[url]ftp://archive.progeny.com/CPAN/modules/02packages.details.txt.gz[/url]
Going to read
/Users/xadmin/.cpan/sources/modules/02packages.details.txt.gz
Database was generated on Tue, 20 Jan 2004 09:53:29 GMT
HTTP:ate not available
LWP not available
Fetching with Net::FTP:
[url]ftp://archive.progeny.com/CPAN/modules/03modlist.data.gz[/url]
Going to read /Users/xadmin/.cpan/sources/modules/03modlist.data.gz
Going to write /Users/xadmin/.cpan/Metadata
Running install for module DBD::mysql
Running make for R/RU/RUDY/DBD-mysql-2.9003.tar.gz
CPAN: Digest::MD5 loaded ok
Checksum for
/Users/xadmin/.cpan/sources/authors/id/R/RU/RUDY/DBD-mysql-2.9003.tar.gz
ok
Scanning cache /Users/xadmin/.cpan/build for sizes
DBD-mysql-2.9003/
DBD-mysql-2.9003/t/
DBD-mysql-2.9003/t/mysql2.t
DBD-mysql-2.9003/t/akmisc.t
DBD-mysql-2.9003/t/60leaks.t
DBD-mysql-2.9003/t/10dsnlist.t
DBD-mysql-2.9003/t/ak-dbd.t
DBD-mysql-2.9003/t/50chopblanks.t
DBD-mysql-2.9003/t/mysql.t
DBD-mysql-2.9003/t/lib.pl
DBD-mysql-2.9003/t/40blobs.t
DBD-mysql-2.9003/t/40nulls.t
DBD-mysql-2.9003/t/insertid.t
DBD-mysql-2.9003/t/40listfields.t
DBD-mysql-2.9003/t/40bindparam.t
DBD-mysql-2.9003/t/mysql.dbtest
DBD-mysql-2.9003/t/dbdadmin.t
DBD-mysql-2.9003/t/20createdrop.t
DBD-mysql-2.9003/t/00base.t
DBD-mysql-2.9003/t/30insertfetch.t
DBD-mysql-2.9003/t/40numrows.t
DBD-mysql-2.9003/t/50commit.t
DBD-mysql-2.9003/t/mysql.mtest
DBD-mysql-2.9003/MANIFEST
DBD-mysql-2.9003/myld
DBD-mysql-2.9003/dbdimp.c
DBD-mysql-2.9003/lib/
DBD-mysql-2.9003/lib/DBD/
DBD-mysql-2.9003/lib/DBD/mysql/
DBD-mysql-2.9003/lib/DBD/mysql/GetInfo.pm
DBD-mysql-2.9003/lib/DBD/mysql/INSTALL.pod
DBD-mysql-2.9003/lib/DBD/mysql.pm
DBD-mysql-2.9003/lib/Mysql/
DBD-mysql-2.9003/lib/Mysql/Statement.pm
DBD-mysql-2.9003/lib/Bundle/
DBD-mysql-2.9003/lib/Bundle/DBD/
DBD-mysql-2.9003/lib/Bundle/DBD/mysql.pm
DBD-mysql-2.9003/lib/Mysql.pm
DBD-mysql-2.9003/dbdimp.h
DBD-mysql-2.9003/mysql.xs
DBD-mysql-2.9003/MANIFEST.SKIP
DBD-mysql-2.9003/README
DBD-mysql-2.9003/INSTALL.html
DBD-mysql-2.9003/Makefile.PL
DBD-mysql-2.9003/ChangeLog
DBD-mysql-2.9003/constants.h
DBD-mysql-2.9003/TODO
Removing previously used /Users/xadmin/.cpan/build/DBD-mysql-2.9003

CPAN.pm: Going to build R/RU/RUDY/DBD-mysql-2.9003.tar.gz

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I/usr/include/mysql -O3
-fno-omit-frame-pointer -arch i386 -arch ppc -pipe
libs (mysql_config) = -arch i386 -arch ppc -pipe
-L/usr/lib/mysql -lmysqlclient -lz -lm
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (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: '-arch'
Unrecognized argument in LIBS ignored: 'i386'
Unrecognized argument in LIBS ignored: '-arch'
Unrecognized argument in LIBS ignored: 'ppc'
Unrecognized argument in LIBS ignored: '-pipe'
Using DBI 1.40 (for perl 5.008001 on darwin-thread-multi-2level)
installed in /Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI
Writing Makefile for DBD::mysql
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp lib/Mysql.pm blib/lib/Mysql.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
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cc -c -I/Library/Perl/5.8.1/darwin-thread-multi-2level/auto/DBI
-I/usr/include/mysql -O3 -fno-omit-frame-pointer -arch i386 -arch ppc
-pipe -g -pipe -pipe -fno-common -DPERL_DARWIN -no-cpp-precomp
-fno-strict-aliasing -I/usr/local/include -Os -DVERSION=\"2.9003\"
-DXS_VERSION=\"2.9003\"
"-I/System/Library/Perl/5.8.1/darwin-thread-multi-2level/CORE"
dbdimp.c
cc: cannot read specs file for arch `i386'
make: *** [dbdimp.o] Error 1
/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

[cp]

In article <1g7v12n.19szh9pq96hkoN%egusenet@verizon.net>, Eric
<egusenet@verizon.net> wrote:

> perl -MCPAN -e 'install "DBD::mysql"'

might want an 'sudo' before that command.

>
> I am using the recent version of mysql installed from FINK.
>
> Any ideas?
>

fink might have installed the wrong version of MySQL. It appears that
your version of MySQL thinks it is running on a Linux system.

MySQL has a Mac OSX package prebulit. I've had much better luck with
that version than I did with fink. YMMV

>

[snip ]

>
> I will use the following settings for compiling and testing:
>
> cflags (mysql_config) = -I/usr/include/mysql -O3
> -fno-omit-frame-pointer -arch i386 -arch ppc -pipe

^^^^^^^^^^

> libs (mysql_config) = -arch i386 -arch ppc -pipe

and ^^^^^^^^

> -L/usr/lib/mysql -lmysqlclient -lz -lm
> nocatchstderr (default ) = 0
> nofoundrows (default ) = 0
> ssl (guessed ) = 0
> testdb (default ) = test
> testhost (default ) =
> testpassword (default ) =
> testuser (default ) =
>
> To change these settings, see 'perl Makefile.PL --help' and
> 'perldoc INSTALL'.
>

--
cp

[Eric]

cp <cpryce@nospam.pryce.net> wrote:

> In article <1g7v12n.19szh9pq96hkoN%egusenet@verizon.net>, Eric
> <egusenet@verizon.net> wrote:
>

> > perl -MCPAN -e 'install "DBD::mysql"'

>
> might want an 'sudo' before that command.

Had already done a sudo -s :-)

> fink might have installed the wrong version of MySQL. It appears that
> your version of MySQL thinks it is running on a Linux system.

Whether I use the mySQL that came with 10.3.2 Server or the Fink
version, I see -arch i386.

> MySQL has a Mac OSX package prebulit. I've had much better luck with
> that version than I did with fink. YMMV

Actually, the fink version works and I did get DBD::mysql installed.
DBD::mysql did fail a couple of tests, but it does work.

I basically needed to do the 'env' fix.

<[url]http://www.macosxhints.com/article.php?story=20031015212910375&query=DB[/url]
D%3A%3Amysql>