Bacula-users

[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 22:18:58
Subject: [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: Bacula-users AT lists.sourceforge DOT net
Date: Sat, 11 Feb 2012 18:56:54 -0800
i've installed bacula 5.2.5 dir/sd/fd on opensuse 12.1/64; all
components on the same machine, for the moment.

i'm having a Catalog-related authorization fail (Could not open
Catalog), and am stumped as to where the issue's hiding.

here's what i've done:

a clean install,
 
        cd /usr/lib64/bacula
        ./create_mysql_database
        ./make_mysql_tables
        mysqlshow bacula
                Database: bacula
                +----------------+
                |     Tables     |
                +----------------+
                | BaseFiles      |
                ...
                | Version        |
                +----------------+

assign priveleges with a non-empty passwd,

        perl -pi -e 's|^(db_password=).*|$1\"DbPass"|g'
        ./grant_mysql_privileges
        ./grant_mysql_privileges

verify,

        mysql -u bacula -p
                Enter password:  DbPass
                        Welcome to the MySQL monitor.  Commands end with
                        ; or \g.
                        Your MySQL connection id is 64
                        Server version: 5.6.4-m7-log Source distribution
                        ...
          mysql>  show grants for bacula;
                
+------------------------------------------------------------------------+
                | Grants for bacula@%                                   
                                |
                
+------------------------------------------------------------------------+
                | GRANT USAGE ON *.* TO 'bacula'@'%' IDENTIFIED BY
                PASSWORD '*9FC...4B0' |
                | GRANT ALL PRIVILEGES ON `bacula`.* TO 'bacula'@'%'    
                                |
                
+------------------------------------------------------------------------+
                2 rows in set (0.00 sec)
         quit;


start services,

        service bacula-sd  start
        service bacula-fd  start
        service bacula-dir start

check they're running,

        ps ax | grep bacula
                28295 ?        Ssl    0:00 /usr/sbin/bacula-sd -u bacula
                -g bacula -c /etc/bacula/bacula-sd.conf
                28335 ?        Ssl    0:00 /usr/sbin/bacula-fd -u root
                -g bacula -c /etc/bacula/bacula-fd.conf
                28370 ?        Ss     0:00 /usr/sbin/bacula-dir -u
                bacula -g bacula -c /etc/bacula/bacula-dir.conf

testing configs,

        bacula-fd  -t -c bacula-fd.conf

ok, and,

        bacula-sd  -t -c bacula-sd.conf

ok, but

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

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 18:39 bacula-dir ERROR TERMINATION
        Please correct configuration file: bacula-dir.conf

rtfm'ing at,

        "I'm Getting Authorization Errors. What is Going On?"
        
http://www.bacula.org/5.2.x-manuals/en/problems/problems/Bacula_Frequently_Asked_Que.html#SECTION00260000000000000000

i got my configs right/consistent.  at least, i think i do after staring
at them ...

        cat bconsole.conf
                --------------------------------------------
                Director {
                  Name = bksvr-dir
                  DIRport = 9101
                  address = localhost
                  Password = "DirPass"
                }
                --------------------------------------------

        cat bacula-sd.conf
                --------------------------------------------
                Storage {
                  Name = bksvr-sd
                  SDPort = 9103
                  WorkingDirectory = "/var/lib/bacula"
                  Pid Directory = "/var/run"
                  Maximum Concurrent Jobs = 20
                }
                Director {
                  Name = bksvr-dir
                  Password = "SdPass"
                }
                ...
                Device {
                  Name = FileStorage
                  Media Type = File
                  Archive Device = /tmp
                  LabelMedia = yes;
                  Random Access = Yes;
                  AutomaticMount = yes;
                  RemovableMedia = no;
                  AlwaysOpen = no;
                }
                ...
                --------------------------------------------

        cat bacula-fd.conf
                --------------------------------------------
                FileDaemon {
                  Name = bksvr-fd
                  FDport = 9102
                  WorkingDirectory = /var/lib/bacula
                  Pid Directory = /var/run
                  Maximum Concurrent Jobs = 20
                }
                Director {
                  Name = bksvr-dir
                  Password = "FdPass"
                }
                ...
                --------------------------------------------

        cat bacula-dir.conf
                --------------------------------------------
                Director {
                  Name = bksvr-dir
                  DIRport = 9101
                  QueryFile = "/usr/lib64/bacula/query.sql"
                  WorkingDirectory = "/var/lib/bacula"
                  PidDirectory = "/var/run"
                  Maximum Concurrent Jobs = 1
                  Password = "DirPass"
                  Messages = Daemon
                }
                ...
                Client {
                  Name = bksvr-fd
                  Address = bksvr.loc
                  FDPort = 9102
                  Catalog = MyCatalog
                  Password = "FdPass"
                  File Retention = 30 days
                  Job Retention = 6 months
                  AutoPrune = yes
                }
                Storage {
                  Name = File
                  Address = bksvr.loc
                  SDPort = 9103
                  Password = "SdPass"
                  Device = FileStorage
                  Media Type = File
                }
                Catalog {
                  Name = MyCatalog
                  dbname = "bacula"; dbuser = "bacula"; dbpassword =
                  "DBPass"
                }
                ...
                --------------------------------------------


so, atm a bit stumped as to what - specifically - the problem is.

any ideas?

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