issues compiling the DBD::mysql

------_=_NextPart_001_01C365D7.A21B7BB0
Content-Type: text/plain;
charset="iso-8859-1"

I'm having issues compiling the DBD::mysql.

Box - mysql 4.0.14/perl 5.8.0/modperl1.28/apache1.38/DBI 1.37

At first installing via cpan or source would bomb during perl makefile
without finding the mysql_config script. I installed mysql 4.0.14 via
rpm....mysql_config script didn't install; although it is working properly.
So then I downloaded and untare mysql-standard-4.0.14-pc-linux-i686 and
found the missing script in
.../mysql-standard-4.0.14-pc-linux-i686/bin/mysql_config.

After copying the script into my /usr/bin/ I find the make file gets
created, but the make is bombing out with the following:

Using DBI 1.37 installed in
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto
Writing Makefile for DBD::mysql
lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # make
cc -c
-I/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
-I -DPERL_Y2KW-DPERL_POLLUTE_MALLOC
-fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOU-D_FILE_OFFSET_BITS=64 -O3
-DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic
usr/local/lib/perl5/5.8.0/i686-linux/CORE" dbdimp.c
In file included from dbdimp.c:29:
dbdimp.h:31: mysql.h: No such file or directory
dbdimp.h:32: errmsg.h: No such file or directory
make: *** [dbdimp.o] Error 1
lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # perl
Makefile.PL --cflags -I /bin/ -L /usr/lib/
I will use the following settings for compiling and
testing:

cflags (Users choice) = -I
libs (Users choice) = /usr/lib/
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'.

Unrecognized argument in LIBS ignored: '/usr/lib/'
Using DBI 1.37 installed in
/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto
Writing Makefile for DBD::mysql
lamp:/home/jhodge/dloads/ap_mp/DBD-mysql-2.9002 # make
cc -c
-I/usr/local/lib/perl5/site_perl/5.8.0/i686-linux/auto/DBI
-I -DPERL_Y2KW-DPERL_POLLUTE_MALLOC
-fno-strict-aliasing -I/usr/local/include
-D_LARGEFILE_SOU-D_FILE_OFFSET_BITS=64 -O3
-DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic
usr/local/lib/perl5/5.8.0/i686-linux/CORE" dbdimp.c
In file included from dbdimp.c:29:
dbdimp.h:31: mysql.h: No such file or directory
dbdimp.h:32: errmsg.h: No such file or directory
make: *** [dbdimp.o] Error 1


Does anybody have any suggestions?

I'm also thinking of compileing the source from
mysql-standard-4.0.14-pc-linux-i686 and try to re-build mysql first.
Although mysql is running, so this might be the wrong thing to do

thanks,

JH

------_=_NextPart_001_01C365D7.A21B7BB0--