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 bacula@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 AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users