[gentoo-user] dev-db/mysql giving problems after upgrading from 4.1.21 to 5.0.26-r1

[bijayant kumar]

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