Kern:
Your complaints are well noted and warranted. In an effort to be concise, I
left out pertinent information that would have been helpful for you to help me.
In the future, I will post the information you’ve mentioned. Apologies. Also, I
did not mean to send you an off list email. I fat fingered reply instead of
reply-all.
In the meantime, Phil Stracchino on the list replied with what I needed. I was
grepping for ‘mysql’ and I should have been grepping for ‘password’ or
‘dbpassword’ and I would have found what I was looking for.
For future searchers:
When bacula-dir –f –c /etc/bacula/bacula-dir.conf timesout and produces the
following error:
MySQL connect failed either server not running or your authorization is
incorrect.
ERROR TERMINATION
Please correct configuration file /etc/bacula/bacula-dir.conf
You need to a) make sure MySQL is running b) make sure you have the proper
configuration for the tables (GRANT ALL ON Bacula.* TO ‘youruser’@’localhost’
IDENTIFIED BY ‘oh please anything but 12345).
And THEN (my problem) update / fix the dbpassword configuration in
/etc/Bacula/Bacula-dir.conf.
> # Generic catalog service
> Catalog {
> Name = Catalog
> DB Address = yourhost.yourdomain
> DB Socket = /var/run/mysqld/mysqld.sock
> dbname = "bacula"
> dbuser = "bacula-user"
> dbpassword = "oh please anything but 12345"
> }
Lastly, restart bacula-dir.
Incidentally, 12345 is the same combination I have on my luggage.
Michael Munger, dCAP, MCPS, MCNPS, MBSS
High Powered Help, Inc.
Microsoft Certified Professional
Microsoft Certified Small Business Specialist
Digium Certified Asterisk Professional
[email protected]<mailto:[email protected]>
From: Kern Sibbald [mailto:[email protected]]
Sent: Monday, October 3, 2016 8:30 AM
To: Michael Munger <[email protected]>
Cc: bacula-users <[email protected]>
Subject: Re: [Bacula-users] Where are the MySQL credentials?
I am sorry to complain, but the basic thing you need to do when requesting help
is to provide the basic information needed to resolve your problem.
It is the lack of this information and the the time it takes to get it that has
forced me due to time constraints to stop giving support. Also, I never answer
support messages, such as this one, off-list. When I spend the little free
time I have to help people, which I love to do, all bacula users should be able
to benefit from it.
In your case, you mention that you do not have the right Bacula credentials,
which unfortunately by itself does not help someone trying to resolve your,
since to the best of my knowledge Bacula produces no output concerning MySQL
regarding credentials, unless you are perhaps trying to us an encrypted
connection, which you did not mention.
The critical first step is to always show the exact error messages that are
printed, and to show any relevant configuration and other important points you
may have.
So, with that, hopefully you will be able to get the help you deserve from the
list. Good luck.
Best regards,
Kern
On 10/03/2016 12:41 PM, Michael Munger wrote:
Kern:
Since you're the author of the manual, I am very confident it's there, but, I
have honestly tried to find this, and can't.
A link to the docs you've referenced would be greatly appreciated.
I have found (and read):
*
http://www.bacula.org/7.4.x-manuals/en/main/Installing_Configuring_MySQ.html
*
http://www.bacula.org/7.4.x-manuals/en/main/Catalog_Maintenance.html#SECTION004520000000000000000
But, nothing in either of those tells me how to specify the user / pass for
bacula so it can connect.
Reading the source for the scripts that create the databases, I see the GRANT
statement, but that just tells MySQL what user / pass to use. Bacula still
doesn't know about it at that point. How do I tell bacula?
Michael Munger, dCAP, MCPS, MCNPS, MBSS
High Powered Help, Inc.
Microsoft Certified Professional
Microsoft Certified Small Business Specialist
Digium Certified Asterisk Professional
[email protected]<mailto:[email protected]>
On 10/03/2016 01:40 AM, Kern Sibbald wrote:
The manual has a very complete chapter on MySQL that tells you how to resolve
connection problems.
On 10/03/2016 05:19 AM, Michael Munger wrote:
I have restored the bacula mysql tables to a new installation of MySQL
server, but the director cannot connect and is complaining that the
MySQL credentials are not correct.
Where is this in the conf files? I have grepped and googled, and cannot
figure it out.
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/bacula-users
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users
