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: r...@cw8:~# /opt/bacula/scripts/grant_mysql_privileges [OK] r...@cw8:~# /opt/bacula/scripts/create_mysql_database Creation of bacula database succeeded. r...@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: r...@cw8:/opt/bacula/etc# cd r...@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 bac...@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: r...@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? Best Charles +---------------------------------------------------------------------- |This was sent by catki...@yahoo.co.uk via Backup Central. |Forward SPAM to ab...@backupcentral.com. +---------------------------------------------------------------------- ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
