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 <[email protected] <mailto:[email protected]>> 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
[email protected]
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to