Re: [Bacula-users] Could not open Catalog "MyCatalog", database "bacula"
2010-11-01 11:30:14
On Mon, Nov 1, 2010 at 11:07 AM, catkins <bacula-forum AT backupcentral DOT
com> wrote:
> Hello :)
>
> On a new installation of 5.0.3 with .conf files copied from a working 5.0.1
> installation. MySQL 5.1.46. Slackware64 13.1.
>
> >From the log
> 24-Oct 18:45 bacula-dir JobId 0: Fatal error: Could not open
> Catalog "MyCatalog", database "bacula".
> 24-Oct 18:45 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.
> 24-Oct 18:45 bacula-dir ERROR TERMINATION
> Please correct configuration file: /opt/bacula/etc/bacula-dir.conf
>
> MySQL is running and was previously initialised with:
> root@CW8:~# /opt/bacula/scripts/grant_mysql_privileges
> [OK]
> root@CW8:~# /opt/bacula/scripts/create_mysql_database
> Creation of bacula database succeeded.
> root@CW8:~# /opt/bacula/scripts/make_mysql_tables
> Creation of Bacula MySQL tables succeeded.
>
> Excerpt from bacula-dir.conf:
> Catalog {
> Name = MyCatalog
> # Uncomment the following line if you want the dbi driver
> # dbdriver = "dbi:mysql"; dbaddress = 127.0.0.1; dbport =
> dbname = "bacula"; dbuser = "bacula"; dbpassword = ""
> }
>
> Can log on to database using above username and password:
> root@CW8:/opt/bacula/etc# cd
> root@CW8:~# mysql --user=bacula --password= bacula
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 13
> Server version: 5.1.46-log Source distribution
>
> 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> show grants;
> +------------------------------------------------------------+
> | Grants for bacula@localhost
> |
> +------------------------------------------------------------+
> | GRANT USAGE ON *.* TO 'bacula'@'localhost'
> |
> | GRANT ALL PRIVILEGES ON `bacula`.* TO 'bacula'@'localhost' |
> +------------------------------------------------------------+
> 2 rows in set (0.00 sec)
>
> mysql> quit
> Bye
> Running with debug enabled:
> root@CW8:~# /opt/bacula/bin/bacula-dir -d 300 -f
> [snip]
> bacula-dir: mysql.c:100-0 db_open first time
> bacula-dir: mysql.c:129-0 initdb ref=1 connected=0 db=0
> bacula-dir: mysql.c:165-0 mysql_init done
> bacula-dir: mysql.c:186-0 mysql_real_connect done
> bacula-dir: mysql.c:188-0 db_user=bacula db_name=bacula db_password=
> bacula-dir: mysql.c:214-0 opendb ref=1 connected=1 db=6e6980
> bacula-dir: sql_create.c:342-0 In create mediatype
> bacula-dir: sql_create.c:345-0 selectmediatype: SELECT
> MediaTypeId,MediaType FROM MediaType WHERE MediaType='File'
> bacula-dir: mysql.c:235-0 closedb ref=0 connected=1 db=6e6980
> bacula-dir: mysql.c:239-0 close db=6e6980
> [snip]
>
> What to do?
>
Although this is very hard to read on the mailing list your problem
may be that mysql is not listening on the network interface.
John
------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users
|
|
|