MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:gerald_clark Date:January 23 2006 2:41pm
Subject:Re: Unable to initialise database
View as plain text  
Jon Miller wrote:

>Having a problem connecting to a MySQL database from a mail server.  In the mail logs
> I'm getting:
>mail MailScanner[4904]: Unable to initialise database connection: Can't connect to
> MySQL server on '192.168.10.4' (110)
>
>In the script that is running it has a mysql_connect statement with the correct
> credentials.  From the command line of the mail server I can issue the command 
># MySQL -u mailwatch -h 192.168.10.4 mailscanner -p 
>then I give it the password  after which I have a MySQL prompt.
>I have in the database the user name with GRANT privileges on both local host and the
> mail server.
>
>So I'm trying to figure out why it does not work from within the script.  I think it
> may have to do with the DBI connector.
>Tried the following but getting errors
>
>#!/usr/bin/perl
>
>use DBI
>  
>
You forgot a semi-colon after 'use DBI'.

>$host = '192.168.10.4';
>$port = '3306';
>
>$dbh = DBI->connect ("DBI:mysql:mailscanner"; mailwatch, mailwatch);
>
>if ($dbh) {print "Connection successful! \n" }
>
>error message:
>DBI version 192.168.10.4 required--this is only version 1.46 at
> /usr/share/perl/5.8/Exporter/Heavy.pm line 107.
>BEGIN failed--compilation aborted at ./dbi.pl line 5.
>
>
>Any ideas?
>
>Jon
>
>
>  
>

Thread
Unable to initialise databaseJon  Miller22 Jan
  • Re: Unable to initialise databasegerald_clark23 Jan