[Bacula-users] error connecting to database

Hey guys,

I have no trouble at all getting the bacula director running if I connect to a local datbase running on the bacula server itself.

However if I try connecting to a database living on another host is where I run into an isssue.

If I try to setup a database that's not running on localhost, this is what I get in the logs:

05-Aug 01:14 bacula-dir JobId 0: Fatal error: mysql.c:210 Unable to connect to MySQL server.

Database=bacula User=admin_ssl

MySQL connect failed either server not running or your authorization is incorrect.

05-Aug 01:14 bacula-dir ERROR TERMINATION

Please correct configuration file: /etc/bacula/bacula-dir.conf

This is how I tried to specify this in the director config:

# Generic catalog service

Catalog {

Name = MyCatalog

# Uncomment the following line if you want the dbi driver

dbdriver = "dbi:mysql"; dbaddress = "db.example.com"; dbport = 3306

dbname = "bacula"; dbuser = "admin_ssl"; dbpassword = "secret"

}

I also tried specifying it this way:

# Generic catalog service

Catalog {

Name = MyCatalog

# Uncomment the following line if you want the dbi driver

#dbdriver = "dbi:mysql"; dbaddress = "db.jokefire.com"; dbport = 3306

dbname = "bacula"; dbuser = "admin_ssl"; dbpassword = "secret" ; dbaddress = "db.example.com"

}

With the exact same result in the logs.

I have verified that I can connect to the database I'm trying to specify in the config on the command line using the same credentials:

#mysql -uadmin_ssl -p -h db.example.com -e "show databases"

Enter password:

+--------------------+

| Database |

+--------------------+

| bacula |

| certs |

| information_schema |

| mysql |

| performance_schema |

+--------------------+

Can someone please let me know where I am going wrong in the config?

Thanks!

Tim

GPG me!!

gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B

------------------------------------------------------------------------------

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users