Another set of installation questions

I had a working 3.23.x mysql installation, with DBI DBD::mysql. I
decided to scrap that in favour of mysql 4.1. My goal was to take
advantage of the native perl 5.8.0 support for Unicode semantics and
the newer mysql support for multibyte character sets. In my case utf-8.

My first question is with which combination -- if any -- of DBI and
DBD will I achieve this?

My second is more about compilation. I first decided to install the
most recent versions of both packages: DBD-mysql-2.9002 together with
DBI-1.38 on my fresh almost out of the box SUSE 8.2 linux [2]
with the perl installation from the OS vendor. I use mysql-max
installed from MySQL.com's rpm packages[1] from a mirror near me.

making perl Makefile.PL yields

I will use the following settings for compiling and testing:

cflags (mysql_config) = -I'/usr/include/mysql'
libs (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz -lcrypt \
-lnsl -lm -lc -lnss_files -lnss_dns -lresolv -lc \
-lnss_files -lnss_dns -lresolv
nocatchstderr (default ) = 0
nofoundrows (default ) = 0
ssl (guessed ) = 0
testdb (default ) = test
testhost (default ) =
testpassword (default ) =
testuser (default ) =

perl Makefile.PL concludes that my distribution looks fine. Make
yields the warnings

usr/bin/perl /usr/lib/perl5/5.8.0/ExtUtils/xsubpp -typemap \
/usr/lib/perl5/5.8.0/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

but ends without any warning or error messages, by stating

Running Mkbootstrap for DBD::mysql ()
chmod 644 mysql.bs
rm -f blib/arch/auto/DBD/mysql/mysql.so
LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared \
dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \
-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc \
-lnss_files -lnss_dns -lresolv -lc -lnss_files -lnss_dns -lresolv
make: *** [blib/arch/auto/DBD/mysql/mysql.so] Error 1

Any hints as to what when wrong are appreciated.

Yours


Sigge

------

Notes:

[1] This is what I installed:

MySQL-Max-4.1.0-0.i386.rpm
MySQL-bench-4.1.0-0.i386.rpm
MySQL-client-4.1.0-0.i386.rpm
MySQL-devel-4.1.0-0.i386.rpm
MySQL-embedded-4.1.0-0.i386.rpm
MySQL-server-4.1.0-0.i386.rpm
MySQL-shared-4.1.0-0.i386.rpm
MySQL-shared-compat-4.1.0-0.i386.rpm

[2]
uname -a:

Linux bourree 2.4.20-4GB-athlon #1 Wed Aug 6 18:27:52 UTC 2003 \
i686 unknown unknown GNU/Linux



________________
Sigfrid Lundberg, Ph.D., Docent
email: sigfrid.lundberg@lub.lu.se; phone: +46 (0)46 222 36 83
Lund University Libraries, Head Office/LuCEP http://www.lub.lu.se/lucep/
PO Box 134, SE-221 00 Lund,Sweden http://sigge.lub.lu.se/


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Another set of installation questions

On Tue, 9 Sep 2003 I wrote:

>
> I had a working 3.23.x mysql installation, with DBI DBD::mysql. I
> decided to scrap that in favour of mysql 4.1. My goal was to take
> advantage of the native perl 5.8.0 support for Unicode semantics and
> the newer mysql support for multibyte character sets. In my case utf-8.
>
> My first question is with which combination -- if any -- of DBI and
> DBD will I achieve this?

I'm still very keen to get info on this. I resolved my installation
problem by manually replacing the command

LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared \
dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \
-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc \
-lnss_files -lnss_dns -lresolv -lc \
-lnss_files -lnss_dns -lresolv

with

gcc -shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so
\ -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc \
-lresolv -lc -lresolv

on the command line. Then I successfully made 'make test' and 'make
install'

I suppose that mysql_config returned something unwanted on my platform
namely -lnss_files -lnss_dns. It surprices me that

ldd blib/arch/auto/DBD/mysql/mysql.so

among other dependencies yielded

libnss_files.so.2 => /lib/libnss_files.so.2 (0x403d5000)
libnss_dns.so.2 => /lib/libnss_dns.so.2 (0x403df000)

Anyway, my scripts no works nicely.

Sigge


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Another set of installation questions

On Tue, 9 Sep 2003 I wrote:

>
> I had a working 3.23.x mysql installation, with DBI DBD::mysql. I
> decided to scrap that in favour of mysql 4.1. My goal was to take
> advantage of the native perl 5.8.0 support for Unicode semantics and
> the newer mysql support for multibyte character sets. In my case utf-8.
>
> My first question is with which combination -- if any -- of DBI and
> DBD will I achieve this?

I'm still very keen to get info on this. I resolved my installation
problem by manually replacing the command

LD_RUN_PATH="/usr/lib/mysql:/lib" /usr/bin/perl myld cc -shared \
dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so \
-L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc \
-lnss_files -lnss_dns -lresolv -lc \
-lnss_files -lnss_dns -lresolv

with

gcc -shared dbdimp.o mysql.o -o blib/arch/auto/DBD/mysql/mysql.so
\ -L/usr/lib/mysql -lmysqlclient -lz -lcrypt -lnsl -lm -lc \
-lresolv -lc -lresolv

on the command line. Then I successfully made 'make test' and 'make
install'

I suppose that mysql_config returned something unwanted on my platform
namely -lnss_files -lnss_dns. It surprices me that

ldd blib/arch/auto/DBD/mysql/mysql.so

among other dependencies yielded

libnss_files.so.2 => /lib/libnss_files.so.2 (0x403d5000)
libnss_dns.so.2 => /lib/libnss_dns.so.2 (0x403df000)

Anyway, my scripts no works nicely.

Sigge


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org