Bacula-users

Re: [Bacula-users] mysql authorization fail ("Could not open Catalog") on a clean 5.2.5 install. what did i miss in my config?

2012-02-11 23:12:16
Subject: Re: [Bacula-users] mysql authorization fail ("Could not open Catalog") on a clean 5.2.5 install. what did i miss in my config?
From: p50bac AT 150ml DOT com
To: Phil Stracchino <alaric AT metrocast DOT net>, bacula-users AT lists.sourceforge DOT net
Date: Sat, 11 Feb 2012 20:10:45 -0800
hi

On Sat, Feb 11, 2012, at 10:55 PM, Phil Stracchino wrote:
> >     perl -pi -e 's|^(db_password=).*|$1\"DbPass"|g'
>
>
> >             Catalog {
> >               Name = MyCatalog
> >               dbname = "bacula"; dbuser = "bacula"; dbpassword =
> >               "DBPass"
> >             }
>
> Notice anything...?

yes.  a really bad case of fat thumbs copying from my notes to email on
my part.

verifying that,

  grep ^db_password grant_mysql_privileges
    db_password="DbPass"

and,

  grep "Catalog {" bacula-dir.conf -B1 -A4
    # Generic catalog service
    Catalog {
      Name = MyCatalog
      dbname = "bacula"; dbuser = "bacula"; dbpassword = "DbPass"
    }

then, clean-re-xecing up to and including,

  ./grant_mysql_privileges

subsequent exec of,

  bacula-dir -d -v -t -c bacula-dir.conf

still returns,

  bacula-dir: dird.c:954 Could not open Catalog "MyCatalog", database
  "bacula".
  bacula-dir: dird.c:959 mysql.c:203 Unable to connect to MySQL server.
  Database=bacula User=bacula
  MySQL connect failed either server not running or your authorization
  is incorrect.
  11-Feb 20:03 bacula-dir ERROR TERMINATION
  Please correct configuration file: bacula-dir.conf

despite being able to immediately connect using those credentials

 mysqlshow -u bacula -h localhost --password="DbPass" bacula
        Database: bacula
        +----------------+
        |     Tables     |
        +----------------+
        | BaseFiles      |
        ...
        | Version        |
        +----------------+

 mysqlshow -u bacula -h bksvr.loc --password="DbPass" bacula
        Database: bacula
        +----------------+
        |     Tables     |
        +----------------+
        | BaseFiles      |
        ...
        | Version        |
        +----------------+

------------------------------------------------------------------------------
Virtualization & Cloud Management Using Capacity Planning
Cloud computing makes use of virtualization - but cloud computing 
also focuses on allowing computing to be delivered as a service.
http://www.accelacomm.com/jaw/sfnl/114/51521223/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users