Message: 20
Date: Wed, 02 Mar 2011 10:23:14 -0500
From: Phil Stracchino <alaric AT metrocast DOT net>
Subject: Re: [Bacula-users] upgrading bacula problem with mysql
To: bacula-users AT lists.sourceforge DOT net
Message-ID: <4D6E60E2.8020800 AT metrocast DOT net>
Content-Type: text/plain; charset=ISO-8859-1

Phil wrote:

 > There is not, and never was, any 'bacula.MyCatalog' table.  That is a
 > mistaken idea; stop letting it distract you.  You do not have a
 > missing table.  You have a connection/authentication problem.

Yes, sorry, complete brain fart there.

 > Try this:

 > Connect to your Bacula DB as your administrative user (probably root)
 > and change the password for Bacula, as follows:

 > UPDATE mysql.user SET password=PASSWORD('your new password here')
 > WHERE user='bacula';
 > FLUSH PRIVILEGES;

 > Then update your Bacula director config file and put the exact same
 > new catalog password in there, then restart Bacula and see if that
 > solves the problem.  It should.

Now I am very confused. Once I changed the password for user bacula, I 
can no longer log in at the command line as bacula, and of course, 
bacula cannot log in.

billie:~# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3003
Server version: 5.1.49-3 (Debian)

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input 
statement.
mysql> UPDATE mysql.user SET password='xxx' WHERE user='bacula';
Query OK, 2 rows affected (0.00 sec)
Rows matched: 2  Changed: 2  Warnings: 0

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye
billie:~# mysql -u bacula -p
Enter password:
ERROR 1045 (28000): Access denied for user 'bacula'@'localhost' (using 
password: YES)

No idea what is going on...

thanks,
maria

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users