Trying to connect to mysql 5 with perl CGI script

[Francis Quayson]

Hello World,

I have MySQL 5.0.24 running successfully on Solaris 9 Sparc (I think so - have created test databases with tables and loaded data into). Also, on my Solaris platform, I have perl 5.8.8 and Apache 2.0.59 installed. I have successfully configured my Apache to use the MySQL database (apacheusrdb) for authentication, successfully.

Last week, I decided to configure a copy of the public-domain "user_manage", the perl CGI script, to employ the MySQL database. So I downloaded the MySQL driver, DBD-mysql-4.00, and believe installed it successfully.

My one problem is: When I execute the user_manage script through Apache I receive the following error:

"Realm MySQL could not be opened: install_driver(mysql) failed: Can't load '/usr/local/lib/perl5/site_perl/5.8.8/sun4-solaris/auto/DBD/mysql/mysql.so' for module DBD::mysql: ld.so.1: perl: fatal: libmysqlclient.so.15: open failed: No such file or directory at /usr/local/lib/perl5/5.8.8/sun4-solaris/DynaLoader.pm line 230. at (eval 24) line 3 Compilation failed in require at (eval 24) line 3. Perhaps a required shared library or dll isn't installed where expected at /usr/local/lib/perl5/site_perl/5.8.8/HTTPD/UserAdmin/SQL.pm line 50 (in cleanup) Can't call method "disconnect" on an undefined value at /usr/local/lib/perl5/site_perl/5.8.8/HTTPD/UserAdmin/SQL.pm line 30.".

I think the first couple of lines of the above is relevant, but I can't figure out the cause of this failure. I would appreciate any help towards a solution of this problem.

Thank you.
FCQ



Edited 1 time(s). Last edit at 01/04/2007 07:34PM by Francis Quayson.