Re: [Bacula-users] upgrading bacula problem with mysql
Re: [Bacula-users] upgrading bacula problem with mysql From: Phil Stracchino alaric@me... - 2011-03-01 00:58 On 02/28/11 17:39, Maria Mckinley wrote: Hi there, I am upgrading bacula, but am having problems with my database. When I upgraded from Debian Lenny to Debian Squeeze, I ran into the version error bug, and I used 'update_mysql_tables_10_to_11' from Jim Padel posted in the bug report here: https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/579924 to upgrade to 11, and then update_mysql_tables with the advice from Johan Vervloet on the same page for updating to 12. When I try to start bconsole, bacula-dir dies, and I get this in the logs: 28-Feb 13:57 bacula-dir JobId 0: Fatal error: Could not open Catalog MyCatalog, database bacula. 28-Feb 13:57 bacula-dir JobId 0: Fatal error: mysql.c:194 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorrect. 28-Feb 13:57 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf If I log into mysql, I find that the username/password are just fine, but my database is not as I expect: mysql show grants for 'bacula'; ++ | Grants for bacula@%| ++ | GRANT USAGE ON *.* TO 'bacula'@'%' | | GRANT ALL PRIVILEGES ON `bacula`.* TO 'bacula'@'%' | ++ 2 rows in set (0.00 sec) mysql select * from MyCatalog; ERROR 1146 (42S02): Table 'bacula.MyCatalog' doesn't exist mysql SHOW TABLES; +--+ | Tables_in_bacula | +--+ | BaseFiles| | CDImages | | Client | | Counters | | Device | | File | | FileSet | | Filename | | Job | | JobHisto | | JobMedia | | Location | | LocationLog | | Log | | Media| | MediaType| | Path | | PathHierarchy| | PathVisibility | | Pool | | Status | | Storage | | UnsavedFiles | | Version | +--+ 24 rows in set (0.00 sec) So, what happened to MyCatalog in the upgrade? Nothing. There is no MyCatalog table. 'MyCatalog', or whatever you replace it with, is a name for Bacula to use to identify that specific catalog database. Your DB is present. MySQL is running. You can connect to it, yet Bacula can't. Did Debian helpfully change your Bacula passwords in your config files for you, or perhaps replace your Bacula config files altogether...? Hi Phil, Thanks for your help. Debian did replace my config files, and I put them back. The password/username is the same in my config as the ones I entered into MySQL. I think it is connecting, but looking for a table that doesn't exist? Is it possible it would give me the connection error if it connected but didn't find the database it was looking for? Unfortunately my MySQL skills are pretty low, but it seems that somehow the bacula database name changed? What name do I put in to the config file to see if it can connect if it has a table to connect to? Iow, is one of those tables above something that bacula could connect to and understand? It almost seems to be that what was once called bacula.MyCatalog is now just called bacula? 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] upgrading bacula problem with mysql
On 03/01/11 14:56, Maria Mckinley wrote:
Thanks for your help. Debian did replace my config files, and I put them
back. The password/username is the same in my config as the ones I
entered into MySQL. I think it is connecting, but looking for a table
that doesn't exist? Is it possible it would give me the connection error
if it connected but didn't find the database it was looking for?
No, that would result in a different error message.
Unfortunately my MySQL skills are pretty low, but it seems that somehow
the bacula database name changed?
You've proved that you can connect to your DB server and that the Bacula
DB is present. There was never any such table as 'bacula.MyCatalog'.
It never existed. 'MyCatalog' is a shorthand name user in your Bacula
configuration, and ONLY there, to identify the catalog DB resource that
Bacula is to use. You could perfectly easily name the Catalog resource
'BigCollectionOfBaculaData', or even 'Fred', and it would not change
anything in the DB. The Bacula catalog db will always be created as
'bacula' and containing the tables you see.
What name do I put in to the config
file to see if it can connect if it has a table to connect to? Iow, is
one of those tables above something that bacula could connect to and
understand? It almost seems to be that what was once called
bacula.MyCatalog is now just called bacula?
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.
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.
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
--
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] upgrading bacula problem with mysql
On 3/1/11 11:56 AM, Maria Mckinley wrote: Re: [Bacula-users] upgrading bacula problem with mysql From: Phil Stracchino alaric@me... - 2011-03-01 00:58 On 02/28/11 17:39, Maria Mckinley wrote: Hi there, I am upgrading bacula, but am having problems with my database. When I upgraded from Debian Lenny to Debian Squeeze, I ran into the version error bug, and I used 'update_mysql_tables_10_to_11' from Jim Padel posted in the bug report here: https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/579924 to upgrade to 11, and then update_mysql_tables with the advice from Johan Vervloet on the same page for updating to 12. When I try to start bconsole, bacula-dir dies, and I get this in the logs: 28-Feb 13:57 bacula-dir JobId 0: Fatal error: Could not open Catalog MyCatalog, database bacula. 28-Feb 13:57 bacula-dir JobId 0: Fatal error: mysql.c:194 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorrect. 28-Feb 13:57 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf If I log into mysql, I find that the username/password are just fine, but my database is not as I expect: mysql show grants for 'bacula'; ++ | Grants for bacula@% | ++ | GRANT USAGE ON *.* TO 'bacula'@'%' | | GRANT ALL PRIVILEGES ON `bacula`.* TO 'bacula'@'%' | ++ 2 rows in set (0.00 sec) mysql select * from MyCatalog; ERROR 1146 (42S02): Table 'bacula.MyCatalog' doesn't exist mysql SHOW TABLES; +--+ | Tables_in_bacula | +--+ | BaseFiles | | CDImages | | Client | | Counters | | Device | | File | | FileSet | | Filename | | Job | | JobHisto | | JobMedia | | Location | | LocationLog | | Log | | Media | | MediaType | | Path | | PathHierarchy | | PathVisibility | | Pool | | Status | | Storage | | UnsavedFiles | | Version | +--+ 24 rows in set (0.00 sec) So, what happened to MyCatalog in the upgrade? Nothing. There is no MyCatalog table. 'MyCatalog', or whatever you replace it with, is a name for Bacula to use to identify that specific catalog database. Your DB is present. MySQL is running. You can connect to it, yet Bacula can't. Did Debian helpfully change your Bacula passwords in your config files for you, or perhaps replace your Bacula config files altogether...? Hi Phil, Thanks for your help. Debian did replace my config files, and I put them back. The password/username is the same in my config as the ones I entered into MySQL. I think it is connecting, but looking for a table that doesn't exist? Is it possible it would give me the connection error if it connected but didn't find the database it was looking for? Unfortunately my MySQL skills are pretty low, but it seems that somehow the bacula database name changed? What name do I put in to the config file to see if it can connect if it has a table to connect to? Iow, is one of those tables above something that bacula could connect to and understand? It almost seems to be that what was once called bacula.MyCatalog is now just called bacula? thanks, maria Hi there, Okay, I was confused about the Catalog directive. MyCatalog is just the name used internally by bacula to know which Catalog directive to use for backup. The name of the database is bacula, which has not changed. For some reason, the director no longer crashes when I try to log in to bconsole. But, bacula can still not log in to mySQL, even though I can log in at the command line with the exact same name and password. What else does bacula need besides the correct username/password to log into the MySQL database? 28-Feb 01:05 billie-dir JobId 0: Fatal error: Could not open database bacula. 28-Feb 01:05 billie-dir JobId 0: Fatal error: mysql.c:194 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorrect. 28-Feb 01:05 billie-dir: Fatal Error at mysql.c:350 because: rwl_writelock failure. stat=22: ERR=Invalid argument 28-Feb 01:05 billie-dir: Fatal Error because: Bacula interrupted by signal 11: Segmentation violation 28-Feb 11:44 billie-dir: ERROR in authenticate.c:418 Unable to authenticate console *UserAgent* at client:127.0.0.1:36131. 28-Feb 13:25 billie-dir: ERROR in authenticate.c:418 Unable to authenticate console *UserAgent* at client:127.0.0.1:36131. What is this UserAgent thing. and where does it come from? thanks, maria -- Free Software Download: Index, Search Analyze Logs and other IT data
Re: [Bacula-users] upgrading bacula problem with mysql
On 03/02/11 16:13, Maria Mckinley wrote: For some reason, the director no longer crashes when I try to log in to bconsole. But, bacula can still not log in to mySQL, even though I can log in at the command line with the exact same name and password. What else does bacula need besides the correct username/password to log into the MySQL database? That's a very good question. Does the MySQL error log (assuming logging is enabled) tell you anything? Are you logging in from the same host on which bacula runs? What does the following SQL statement return? SHOW GRANTS FOR `bacula`@`address`; where address is either 'localhost' or the IP of your Bacula server? This is really sounding as though you have an authentication problem. Try changing the Bacula catalog password, both in MySQl and in bacula, to something braindead-simple like 'TEST', then flush privileges in MySQL and restart bacula, and see if it'll connect. -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] upgrading bacula problem with mysql
Message: 20
Date: Wed, 02 Mar 2011 10:23:14 -0500
From: Phil Stracchino ala...@metrocast.net
Subject: Re: [Bacula-users] upgrading bacula problem with mysql
To: bacula-users@lists.sourceforge.net
Message-ID: 4d6e60e2.8020...@metrocast.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] upgrading bacula problem with mysql - Solved
On 3/2/11 2:06 PM, Maria Mckinley wrote:
Message: 20
Date: Wed, 02 Mar 2011 10:23:14 -0500
From: Phil Stracchino ala...@metrocast.net
Subject: Re: [Bacula-users] upgrading bacula problem with mysql
To: bacula-users@lists.sourceforge.net
Message-ID: 4d6e60e2.8020...@metrocast.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
Not sure exactly what happened, but the password in MySQL was definitely
the problem. I logged into MySQL as root, and looked at the password
table, and noticed that the password for the user bacula was not
encrypted, but all of the other user passwords were. I looked up the
command in the MySQL manual, and it appears you need parentheses around
the password:
mysql UPDATE mysql.user SET Password = PASSWORD('')
- WHERE User = 'bacula';
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
When I looked at the password table after flushing this, the password
for bacula was encrypted, and I was again able to login as bacula. And,
I was able to start bconsole and my backup seems to be back up and
running! Yay!
Thanks Phil, for pointing me in the right direction.
cheers,
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] upgrading bacula problem with mysql - Solved
On 03/02/11 17:52, Maria Mckinley wrote:
On 3/2/11 2:06 PM, Maria Mckinley wrote:
Message: 20
From: Phil Stracchino ala...@metrocast.net
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;
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.
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)
Not sure exactly what happened, but the password in MySQL was definitely
the problem. I logged into MySQL as root, and looked at the password
table, and noticed that the password for the user bacula was not
encrypted, but all of the other user passwords were.
Yes, that's because you set the password field to the literal password,
instead of calling password() to generate a password hash.
I looked up the
command in the MySQL manual, and it appears you need parentheses around
the password:
More to the point, you need to call the password() function with your
new password as the argument.
mysql UPDATE mysql.user SET Password = PASSWORD('')
- WHERE User = 'bacula';
Query OK, 1 row affected (0.02 sec)
Rows matched: 1 Changed: 1 Warnings: 0
...Yup, just like that.
When I looked at the password table after flushing this, the password
for bacula was encrypted, and I was again able to login as bacula. And,
I was able to start bconsole and my backup seems to be back up and
running! Yay!
So it looks as though the original problem was indeed that the upgrade
left you with mismatched passwords. Glad to hear that everything's
working now that they're consistently set again.
For future reference, always remember that no MySQL password changes or
grants take effect until you either execute 'flush privileges' or
restart MySQL. So any time you're changing the MySQL password for root,
use two sessions; change the password in one, flush privileges, *then*
try to log in a second session *with the new password*, so that you can
verify it's working *while you still have a logged-in session*, just in
case you get it wrong and need to reset it.
(Losing your MySQL admin password is fixable. It can be reset without
loss of any data, but you need to know what you're doing. Best to avoid
the situation in the first place.)
--
Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355
ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org
Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater
It's not the years, it's the mileage.
--
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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] upgrading bacula problem with mysql
Hi there, I am upgrading bacula, but am having problems with my database. When I upgraded from Debian Lenny to Debian Squeeze, I ran into the version error bug, and I used 'update_mysql_tables_10_to_11' from Jim Padel posted in the bug report here: https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/579924 to upgrade to 11, and then update_mysql_tables with the advice from Johan Vervloet on the same page for updating to 12. When I try to start bconsole, bacula-dir dies, and I get this in the logs: 28-Feb 13:57 bacula-dir JobId 0: Fatal error: Could not open Catalog MyCatalog, database bacula. 28-Feb 13:57 bacula-dir JobId 0: Fatal error: mysql.c:194 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorrect. 28-Feb 13:57 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf If I log into mysql, I find that the username/password are just fine, but my database is not as I expect: mysql show grants for 'bacula'; ++ | Grants for bacula@%| ++ | GRANT USAGE ON *.* TO 'bacula'@'%' | | GRANT ALL PRIVILEGES ON `bacula`.* TO 'bacula'@'%' | ++ 2 rows in set (0.00 sec) mysql select * from MyCatalog; ERROR 1146 (42S02): Table 'bacula.MyCatalog' doesn't exist mysql SHOW TABLES; +--+ | Tables_in_bacula | +--+ | BaseFiles| | CDImages | | Client | | Counters | | Device | | File | | FileSet | | Filename | | Job | | JobHisto | | JobMedia | | Location | | LocationLog | | Log | | Media| | MediaType| | Path | | PathHierarchy| | PathVisibility | | Pool | | Status | | Storage | | UnsavedFiles | | Version | +--+ 24 rows in set (0.00 sec) So, what happened to MyCatalog in the upgrade? 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] upgrading bacula problem with mysql
On 02/28/11 17:39, Maria Mckinley wrote: Hi there, I am upgrading bacula, but am having problems with my database. When I upgraded from Debian Lenny to Debian Squeeze, I ran into the version error bug, and I used 'update_mysql_tables_10_to_11' from Jim Padel posted in the bug report here: https://bugs.launchpad.net/ubuntu/+source/bacula/+bug/579924 to upgrade to 11, and then update_mysql_tables with the advice from Johan Vervloet on the same page for updating to 12. When I try to start bconsole, bacula-dir dies, and I get this in the logs: 28-Feb 13:57 bacula-dir JobId 0: Fatal error: Could not open Catalog MyCatalog, database bacula. 28-Feb 13:57 bacula-dir JobId 0: Fatal error: mysql.c:194 Unable to connect to MySQL server. Database=bacula User=bacula MySQL connect failed either server not running or your authorization is incorrect. 28-Feb 13:57 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf If I log into mysql, I find that the username/password are just fine, but my database is not as I expect: mysql show grants for 'bacula'; ++ | Grants for bacula@%| ++ | GRANT USAGE ON *.* TO 'bacula'@'%' | | GRANT ALL PRIVILEGES ON `bacula`.* TO 'bacula'@'%' | ++ 2 rows in set (0.00 sec) mysql select * from MyCatalog; ERROR 1146 (42S02): Table 'bacula.MyCatalog' doesn't exist mysql SHOW TABLES; +--+ | Tables_in_bacula | +--+ | BaseFiles| | CDImages | | Client | | Counters | | Device | | File | | FileSet | | Filename | | Job | | JobHisto | | JobMedia | | Location | | LocationLog | | Log | | Media| | MediaType| | Path | | PathHierarchy| | PathVisibility | | Pool | | Status | | Storage | | UnsavedFiles | | Version | +--+ 24 rows in set (0.00 sec) So, what happened to MyCatalog in the upgrade? Nothing. There is no MyCatalog table. 'MyCatalog', or whatever you replace it with, is a name for Bacula to use to identify that specific catalog database. Your DB is present. MySQL is running. You can connect to it, yet Bacula can't. Did Debian helpfully change your Bacula passwords in your config files for you, or perhaps replace your Bacula config files altogether...? -- Phil Stracchino, CDK#2 DoD#299792458 ICBM: 43.5607, -71.355 ala...@caerllewys.net ala...@metrocast.net p...@co.ordinate.org Renaissance Man, Unix ronin, Perl hacker, SQL wrangler, Free Stater It's not the years, it's the mileage. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
