DBD::mysql install nightmare.

--=====================_659180812==.ALT
Content-Type: text/plain; charset="us-ascii"

Hi,

I am usually handed prebuilt servers with everything installed for me. But this time I am setting up my own development machine. I installed RH8.0 with Apache 1.3.28, mod_perl 1.28 and mod_ssl etc. RH8.0 comes with Perl 5.8.0 and there is a problem with Unicode support - I couldn't install a lot of modules I needed.

SO - I set out to do some upgrading. I installed Perl 5.8.1 from sources (that was easy!) Then MySQL 4.0.16 from sources, a little harder, but it works fine now!

BUT - then I tried installing modules, DBI installed okay, but DBD::mysql is a nightmare! Here is the START of what I get:

Checking if your kit is complete...
Looks good
Using DBI 1.38 installed in /usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI
Writing Makefile for DBD::mysql
cc -c -I/usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI -I'/usr/include' -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O3 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic "-I/usr/local/lib/perl5/5.8.1/i686-linux/CORE" dbdimp.c
Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
cp lib/DBD/mysql/INSTALL.pod blib/lib/DBD/mysql/INSTALL.pod
cp lib/Mysql/Statement.pm blib/lib/Mysql/Statement.pm
cp lib/DBD/mysql/GetInfo.pm blib/lib/DBD/mysql/GetInfo.pm
cp lib/Mysql.pm blib/lib/Mysql.pm
cp lib/Bundle/DBD/mysql.pm blib/lib/Bundle/DBD/mysql.pm
cp lib/DBD/mysql.pm blib/lib/DBD/mysql.pm
cp mysql.bs blib/arch/auto/DBD/mysql/mysql.bs
/usr/local/bin/perl -p -e "s/~DRIVER~/mysql/g" /usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI/Dri ver.xst > mysql.xsi
chmod 644 blib/arch/auto/DBD/mysql/mysql.bs
/usr/local/bin/perl /usr/local/lib/perl5/5.8.1/ExtUtils/xsubpp -typemap /usr/local/lib/perl5/5.8.1/ExtUtils/typemap mysql.xs > mysql.xsc && mv mysql.xsc mysql.c
Warning: duplicate function definition 'do' detected in mysql.xs, line 193
Warning: duplicate function definition 'rows' detected in mysql.xs, line 291
cc -c -I/usr/local/lib/perl5/site_perl/5.8.1/i686-linux/auto/DBI -I'/usr/include' -fno-strict-aliasing -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O3 -DVERSION=\"2.9002\" -DXS_VERSION=\"2.9002\" -fpic "-I/usr/local/lib/perl5/5.8.1/i686-linux/CORE" mysql.c
cc1: cc1: warning: changing search order for system directory "/usr/include"
cc1: warning: as it has already been specified as a non-system directory
warning: changing search order for system directory "/usr/include"
cc1: warning: as it has already been specified as a non-system directory
In file included from mysql.xs:15:
dbdimp.h:31:49: mysql.h: No such file or directory
dbdimp.h:32:49: errmsg.h: No such file or directory
In file included from dbdimp.c:29:
dbdimp.h:31:49: mysql.h: No such file or directory
dbdimp.h:32:49: errmsg.h: No such file or directory
In file included from mysql.xs:15:
dbdimp.h:116: parse error before "MYSQL"
dbdimp.h:116: warning: no semicolon at end of struct or union
In file included from dbdimp.c:29:
dbdimp.h:116: parse error before "MYSQL"
dbdimp.h:116: warning: no semicolon at end of struct or union
dbdimp.h:127: parse error before '}' token
dbdimp.h:127: parse error before '}' token
dbdimp.h:156: parse error before "MYSQL_RES"
dbdimp.h:156: warning: no semicolon at end of struct or union
dbdimp.h:169: parse error before '}' token
I am lost. Can anyone help?

Kindest regards,

John
--=====================_659180812==.ALT--