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
>>
>> 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
