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"; 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"
> Sure! And that works!
> [root@ops:~] #mysql -uadmin_ssl -p -h db.example.com -P 3306 -D bacula -e
> "show
> tables" | head -5
> Enter password:
> Tables_in_bacula
> BaseFiles
> CDImages
> Client
> Counters
> Still unclear as to why this isn't working unfortunately. Still open to more
> ideas. :-)
> Tim
> On Tue, Aug 4, 2015 at 10:14 PM, Ana Emília M. Arruda <
> emiliaarr...@gmail.com >
> wrote:
>> 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 < 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.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
1. Is your remote MySQL server version the same installed in your Bacula
Server?
2. From your Bacula server can you "telnet ip_address 3306" your MySQL server?
3. Do you have selinux or iptables enabled at MySQL Server? Someone wrote that
never had problems with selinux. Neither do I, since I always disable it. =)
>>> Any more ideas?
>>> Thanks,
>>> Tim
>>> On Tue, Aug 4, 2015 at 9:42 PM, Ana Emília M. Arruda <
>>> emiliaarr...@gmail.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 < bluethu...@gmail.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@lists.sourceforge.net
>>>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>> --
>>> GPG me!!
>>> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
> --
> 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------------------------------------------------------------------------------
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
