Dear Thomas,
It's quite simple to resolve as all is in the log.
The default scripts and configs which reference the catalog database
look for a resource in config called MyCatalog
yours is call MySQL so you have two choice. Renaming your catalog resource or
adjust the different configuration
inside your bacula-dir.conf to point to MySQL name.
On 01/26/2010 04:44 PM, Thomas Schweikle wrote:
> Hi!
>
> I have set up bacula server on windows. But: there is an error reported
> constantly:
> ----
> 26-Jan 05:19 bacula-dir ERROR TERMINATION
> Please correct configuration file: C:\Bacula\bacula-dir.conf
> 26-Jan 05:31 bacula-dir JobId 0: Fatal error: Could not open Catalog
> "MyCatalog", database "baculabd".
> 26-Jan 05:31 bacula-dir JobId 0: Fatal error:
> /home/kern/bacula/k/bacula/src/cats/mysql.c:195 Unable to connect to
> MySQL
> server.
> Database=baculabd User=bacula
> MySQL connect failed either server not running or your authorization is
> incorrect.
> 26-Jan 05:31 bacula-dir ERROR TERMINATION
> Please correct configuration file: C:\Bacula\bacula-dir.conf
> ----
>
> in bacula-dir.conf I have:
> ----
> Catalog {
> Name = MySQL
> dbname = baculabd
> user = bacula
> password = "************"
> DB Address = localhost
> DB Port = 3306
> DB Socket = C:/MySQL/mysql.soc
> }
> ----
>
> MySQL is configured to allow connections on port 3306. It is no
> problem to
> access the bacula-db from a command line:
> ----
> C:\>mysql -u bacula -h localhost -P 3306 -p************ baculadb
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 2
> Server version: 5.1.41-community MySQL Community Server (GPL)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the current input
> statement.
>
> mysql> show tables;
> +--------------------+
> | Tables_in_baculadb |
> +--------------------+
> | basefiles |
> | cdimages |
> | client |
> | counters |
> | device |
> | file |
> | filename |
> | fileset |
> | job |
> | jobhisto |
> | jobmedia |
> | location |
> | locationlog |
> | log |
> | media |
> | mediatype |
> | path |
> | pool |
> | status |
> | storage |
> | unsavedfiles |
> | version |
> +--------------------+
> 22 rows in set (0.19 sec)
>
> mysql> show grants;
> +------------------------------------------------
> | Grants for bac...@localhost
> +------------------------------------------------
> | GRANT USAGE ON *.* TO 'bacula'@'localhost'\
> IDENTIFIED BY PASSWORD '***********************'
> | GRANT ALL PRIVILEGES ON `baculadb`.* TO 'bacula'@'localhost'
> +------------------------------------------------
> 2 rows in set (0.01 sec)
> ----
>
> bacula-dir immediately bails out after being started. Any idea what's
> going wrong here?
>
>
--
Bruno Friedmann
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
