DBD::Mysql module installation problem

Hello=20

I am using mysql 4.1.13 from mysql.com

operating system=20

SunOS sun-sl-dor-2 5.8 Generic_117350-27 sun4u sparc
SUNW,UltraSPARC-IIi-cEngine
perl version

This is perl, v5.8.7 built for sun4-solaris

gcc,make,DBI 1.18 ,DBD-mysql 2.9008

I am using following to compile to compile DBD::mysql=20

perl Makefile.PL --cflags=3D"-I/usr/local/mysql/include" =20
--libs=3D"-L/usr/local/mysql/include
-L/opt/csw/gcc3/lib/gcc-lib/sparc-sun-solaris2.8/3.3.3 -lgcc
-L/tmp/mysql-static -lz -lposix4 -lcrypt -lgen -lsocket -lnsl -lm
-lmysqlclient"=20

I checked lgcc path and given it in --libs as suggested by
install.html in DBD::module
also trying workaround is using a statically linked mysqlclient
libmysqlclient.a

as i do not have libmysqlclient.so in mysql/lib=20

i also have linked /usr/ucb/cc to gcc as all modules are compiled
using gcc.

still i am getting this error when i do make test

Please suggest

install_driver(mysql) failed: Can't load
'/software/modules/old/DBD_mysql/DBD-mysql-2.9008/blib/arch/ auto/DBD/m
ysql/mysql.so' for module DBD::mysql: ld.so.1: perl: fatal: relocation
error: file
/software/modules/old/DBD_mysql/DBD-mysql-2.9008/blib/arch/a uto/DBD/my
sql/mysql.so: symbol mysql_real_escape_string: referenced symbol not
found at /usr/local/lib/perl5/5.8.7/sun4-solaris/DynaLoader.pm line
230.

strange thing is I have got same setup working on other solaris 8
machine.

Please help me to identify the exact problem

Thanks
mali
____________________________________________________________ _____

This e-mail may contain confidential information and/or copyright materia=
l. This e-mail is intended for the use of the addressee only. Any unautho=
rised use may be unlawful.

If you receive this e-mail by mistake please advise the sender immediatel=
y by using the reply facility in your e-mail software.

The Friends Provident group of companies includes these Friends Provident=
=20plc subsidiary companies:

Friends Provident Life and Pensions Limited. Registered number 4096141.
Friends Provident Life Assurance Limited. Registered number 782698.
Friends Provident Pensions Limited. Registered number 475201.
Friends Provident Marketing Limited. Registered number 5059179.

Each of these subsidiary companies is authorised and regulated by the Fin=
ancial Services Authority.

The ultimate holding company is Friends Provident plc. Registered number =
4113107.

All are incorporated companies limited by shares and registered in Englan=
d.
Registered and Head Office: Pixham End, Dorking, Surrey RH4 1QA.
www.friendsprovident.com

____________________________________________________________ _____

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