can't connected to DB

Hi,

I have simple script , trying to get connection to DB.

#!/usr/bin/perl
use DBI;
my $database="billing";
my $data_source = "DBI:mysql:$database;host=165.21.101.47";
my $dbh = DBI->connect( $data_source,"root","G08hhABC", {RaiseError => 1, PrintError => 1,AutoCommit => 1} ) or die "Unable to connect: " . $DBI::errstr . "\n";

I get this error from DB connection.
install_driver(mysql) failed: Can't load '/usr/lib64/perl5/site_perl/5.8.5/x86_64-linux-thread-multi/auto/DBD/mysql/mysql.so' for module DBD::mysql: libmysqlclient.so.15: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.5/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at (eval 3) line 3
Compilation failed in require at (eval 3) line 3.
Perhaps a required shared library or dll isn't installed where expected
at ./m_Relay.pl line 38

Anyone can help me how to solve it. Thanks



Rgds
Keng Hee

Relevant Pages

  • Re: dialup solution (as seconary connection / iptables )
    ... ip-down is launched by pppd only after the PPP link no longer available ... first with MINICOM or is PAP and script not mutualy exclusive? ... do have to "make the connection first with MINICOM." ... If you use the Linux box and route the news IP address to it on each ...
    (comp.os.linux.networking)
  • Re: mysqli connections and oop
    ... need to do all processing in a script before I display a page that will ... But it will most probably NOT terminated the execution of the script. ... this means that NO lasting connection is build ... Why does it not carry the mysqli connection? ...
    (comp.lang.php)
  • Re: mysqli connections and oop
    ... And here is the script that execute this ... lose a mysqli connection upon the reload of the page? ...
    (comp.lang.php)
  • fetchrow_array warning and error in cleanup
    ... I am quite new to using DBI and am running into something odd. ... I get the following warning: ... Then at the very end of the script, even after the disconnect, I get: ... The database connection and queries seem to be working fine, ...
    (perl.dbi.users)
  • Re: Does apache stop a script mid execution ?
    ... If the user calls a time consuming script and then stops or refreshes ... How does it relate to e.g. a script performing a large mysql query? ... 2.b) how the connection is set up. ... the server stops the script execution. ...
    (comp.lang.php)