--=====================_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/Driver.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--

John Day wrote:

This quite looks like you need to install the mysql-devel RPM
or something similar.


Jochen



--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw

At 06:19 PM 10/22/2003 +0200, Jochen Wiedmann wrote:
I installed MySQL from sources. Not from RPM's! That is why I am stumped.
Could it be that the DBD::mysql needs to be installed manually so I can specify the directories?

Since my email I have been looking, I think that the DBD::mysql expects things to be in places where the standard install from source doesn't put them. Should I have installed from the X86 RPM's on the MySQL site and just install all the RPM's?

John







--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw

On Wed, 22 Oct 2003, John Day wrote:




It looks like DBD::mysql is not able to find mysql.h.


Maybe DBD::mysql is unable to find / (find the correct) mysql_config and
is therefore not able to locate the mysql header files.

Try setting your path to include the mysql binary directory (for the mysql
that you just installed) and then run 'perl Makefile.PL' and see if that
helps.

If that does not help could you send the output of 'perl Makefile.PL'.


Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw

John Day wrote:

If so, use the options --cflags and --libs when running "perl Makefile.PL".
See the INSTALL document for details. Or make sure, that mysql_config is
in your path.


Jochen


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=ms...ie.nctu.edu.tw