Re: [Bacula-users] moving bacula

Also, depending on how you had your MySQL authentication set up it may be looking for connections coming from a specific host. If the IP has changed or anything like that, and if Bacula was configured to connect to the actual address/name of the machine rather than localhost you may have issues either reaching the database or authenticating with it.

Bryn

On 2015-05-25 07:21 PM, Ana Emília M. Arruda wrote:

Hello Ken,

Did you move the whole /var/lib/mysql or just the /var/lib/mysql/bacula directory? All the information about user privilegies and other are in mysql database. And you need that the host/user/password you have configured in your bacula-dir.conf for the Catalog resource be correctly inserted into the mysql database.

You can try to create the database again, grant access and then move back just /var/lib/mysql/bacula directory.

Best regards,

Ana

On Mon, May 25, 2015 at 9:51 PM, Ken Mandelberg <km AT mathcs.emory DOT edu> wrote:

I switched to an updated Ubuntu on a different partition. mysql-server
and bacula are reinstalled, but I moved /var/lib/mysql and /etc/bacula.
The hostname is the same, and a manual invocation of mysql client shows
the bacula database as expected.

However, the bacula director doesn't start and fails with.

25-May 20:21 bacula-dir JobId 0: Fatal error: Could not open Catalog
"MyCatalog", database "".
25-May 20:21 bacula-dir JobId 0: Fatal error: mysql.c:210 Unable to
connect to MySQL server.
Database= User=
MySQL connect failed either server not running or your authorization is
incorrect.

What am I missing? If there was a password wouldn't it have moved with
/var/lib/mysql and the /etc/bacula/* config files?

------------------------------------------------------------------------------
One dashboard for servers and applications across Physical-Virtual-Cloud 
Widest out-of-the-box monitoring support with 50+ applications
Performance metrics, stats and reports that give you Actionable Insights
Deep dive visibility with transaction tracing using APM Insight.
http://ad.doubleclick.net/ddm/clk/290420510;117567292;y

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users