Hello Tim,

​Nice to hear from you too!​

Is this the same?

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

​This is your second try (from your first post), including dbport directive (I just saw this in your first try).​

​Also, could you try the mysql this way?

#mysql -uadmin_ssl -p -h db.example.com -P 3306 -D bacula -e "show tables"

Regards,

Ana​

Em ter, 4 de ago de 2015 às 23:01, Tim Dunphy <bluethundr AT gmail DOT com> escreveu:

Hey Ana,

 Nice to hear from you! 

Tried that:

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"; dbaddress = "db.example.com"; dbport = 3306

}

And restarted. Same result unfortunately! :(

[root@ops:~] #tail -f /var/log/bacula/bacula.log

Database=bacula User=admin_ssl

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

05-Aug 01:59 bacula-dir ERROR TERMINATION

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

05-Aug 01:59 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula".

05-Aug 01:59 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:59 bacula-dir ERROR TERMINATION

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

Any more ideas?

Thanks,

Tim

On Tue, Aug 4, 2015 at 9:42 PM, Ana Emília M. Arruda <emiliaarruda AT gmail DOT com> wrote:

Hello Tim,

Try this:

Catalog {

  Name = MyCatalog 

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

}

Best regards,

Ana

On Tue, Aug 4, 2015 at 10:21 PM, Tim Dunphy <bluethundr AT gmail DOT com> wrote:

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

--

GPG me!!

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