Ok the system is Solaris 9. I have installe mysql at /usr/local/mysql/. I have complied and installed my own version of perl (to get arround complier issues when trying to install DBI, since sun's version of perl is complied with Forte (i believe) i couldnt complie DBI with gcc.) located at /usr/local/bin/perl this was compiled with gcc, i have also complied and installed the DBI using my local version of perl. I then installed DBD::mysql by downloading the source and installing using the mysql_config file, all the locations to the libs looked good.
Now when i try to run my perl script (verified to work on another system) that is trying to load the mysql driver i get the following error:
install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.5/sun4-solaris/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: /usr/local/bin/perl: fatal: libmysqlclient.so.12: open failed: No such file or directory at /usr/local/lib/perl5/5.8.5/sun4-solaris/DynaLoader.pm line 230.
at (eval 1) line 3
Compilation failed in require at (eval 1) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /usr/local/fax/bin/c_faxsend line 27
i have checked the location of all the libs and files and they all look good (to me) i have also googled about 100 times, and havnt come up with anything.
any tips or resources would be greatly appreciated, as i need to get this server back up asap