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
  alaric AT caerllewys DOT net   alaric AT metrocast DOT net   phil AT 
co.ordinate DOT 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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users