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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
