Re: [Bacula-users] error connecting to database

2015-08-20 Thread Tim Dunphy
Hi Ana, Thanks a lot for your response! So I was able to run your command that you were suggesting, and it was a success! I can connect to the database using the ssl enabled user and specifying the certs and keys on the command line: #mysql -uadmin_ssl -p --ssl-ca=/opt/mysql/ca.crt --ssl-cert=/

Re: [Bacula-users] error connecting to database

2015-08-19 Thread Ana Emília M . Arruda
Hello Tim, Could you check if you are able to connect to the database using the bellow command (please replace the .pem certificates with your server certificate - ​ db.example.com - and client certificate - ​ ops.jokefire.com)? ​ #mysql -uadmin_ssl -p --ssl-ca=server-ca.pem --ssl-cert=client-cer

Re: [Bacula-users] error connecting to database

2015-08-16 Thread Tim Dunphy
Hey guys, I finally have some progress to report! Not all the way there yet, but some good progress has been made. As of now I am able to use the external (load balanced) database from within bacula. However I still can't use the SSL enabled database user. Here's my catalog config: # Generic cat

Re: [Bacula-users] error connecting to database

2015-08-06 Thread Alex Domoradov
You could find out with which version of mysql client has been compiled your bacula with the following command # ldd /usr/sbin/bacula-dir | grep mysql libmysqlclient.so.18 => /lib64/libmysqlclient.so.18 (0x7f07abe3d000) # rpm -qf /lib64/libmysqlclient.so.18 Percona-Server-shared-55-5

Re: [Bacula-users] error connecting to database

2015-08-06 Thread Heitor Faria
> Hey Heitor, > Actually to 1, no they are not. I have mariadb-5.5.41 on the bacula server > (client side) and mariadb 10 on the db server. I might try upgrading the > client > on the bacula server tomorrow. I don't have SELinux enabled anywhere > currently. > I probably will enable that tho onc

Re: [Bacula-users] error connecting to database

2015-08-05 Thread Tim Dunphy
Hey Heitor, Actually to 1, no they are not. I have mariadb-5.5.41 on the bacula server (client side) and mariadb 10 on the db server. I might try upgrading the client on the bacula server tomorrow. I don't have SELinux enabled anywhere currently. I probably will enable that tho once I get everyth

Re: [Bacula-users] error connecting to database

2015-08-05 Thread Heitor Faria
>>> Em ter, 4 de ago de 2015 às 23:01, Tim Dunphy < bluethu...@gmail.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.

Re: [Bacula-users] error connecting to database

2015-08-05 Thread Heitor Faria
Hello Tim, > Hey Ana, >> ​Nice to hear from you too!​ > :-D >> Is this the same? >> dbname = "bacula"; dbuser = "admin_ssl"; dbpassword = "secret"; dbaddress = " >> db.example.com "; dbport = 3306 > Yep! It's exactly the same in my config: > bname = "bacula"; dbuser = "admin_ssl"; dbpasswor

Re: [Bacula-users] error connecting to database

2015-08-04 Thread Tim Dunphy
Hey Ana, ​Nice to hear from you too!​ > :-D > > Is this the same? > > dbname = "bacula"; dbuser = "admin_ssl"; dbpassword = "secret"; dbaddress > = "db.example.com"; dbport = 3306 > Yep! It's exactly the same in my config: bname = "bacula"; dbuser = "admin_ssl"; dbpassword = "secret"; dbadd

Re: [Bacula-users] error connecting to database

2015-08-04 Thread Ana Emília M . Arruda
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 wrote: > Hey guys, > > I have no trouble at all getting the bacula d

[Bacula-users] error connecting to database

2015-08-04 Thread Tim Dunphy
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