Dev-db/mysql giving problems after upgrading from 4.1.21 to 5.0.26-r1

Hi to all,
I am in very big problem, please help me. My dev-db/mysql has upgraded from dev-db/mysql-4.1.21 to dev-db/mysql-5.0.26-r1. Because of this, i am getting this error : -

Undefined subroutine &DBD::mysql::db::_login called at /usr/lib/perl5/vendor_perl/5.8.7/i686-linux/DBD/mysql.pm line 129.\n

→ Previously after upgrading i was getting the error like

[Thu Dec 14 12:41:35 2006] [error] [client 192.168.99.183] install_driver(mysql) failed: Can’t load ‘/usr/lib/perl5/vendor_perl/5.8.7/i686-linux/auto/DBD/mysql/mysql.so’ for module DBD::mysql: libmysqlclient.so.14: cannot open shared object file: No
such file or directory at /usr/lib/perl5/5.8.8/i686-linux/DynaLoader.pm line 230.\n at (eval 200) line 3\nCompilation failed
in require at (eval 200) line 3.\nPerhaps a required shared library or dll isn’t installed where expected\n at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 106\n

→ In order to removing this error, i have once again compiled DBD::mysql module. But it was giving me error although it is not compiled yet. I did some workaround after reading some archives msgs and the README file provided with DBD::mysql module. My workaround was something like that

mkdir /tmp/mysql-static
cp /usr/lib/mysql/*.a /tmp/mysql-static
perl Makefile.PL --libs=“-L/tmp/mysql-static -lmysqlclient”
make
make test
make install
rm -rf /tmp/mysql-static

→ After doing all these stuff, now i am getting the error above mentioned like

[Thu Dec 14 16:17:05 2006] [error] [client 192.168.99.183] Undefined subroutine &DBD::mysql::db::_login called at /usr/lib/perl5/vendor_perl/5.8.7/i686-linux/DBD/mysql.pm line 129.\n

Now, i dont know how to tackle this. Please Please help me. I have read all the archives till date, but didnt find any solution.

Bijayant Kumar
Send instant messages to your online friends http://uk.messenger.yahoo.com