John J. Stimson-III wrote:
>
> My bacula-dir.conf file has this section:
>
> # Generic catalog service
> Catalog {
> Name = MyCatalog
> dbname = bacula; user = bacula; password = ""
> }
>
> ...
>
> # ./grant_mysql_privileges -p
> (big permissions table prints)
> Privileges for bacula granted.
> # ./create_mysql_database -u bacula
> Creation of bacula database succeeded.
> # ./make_mysql_tables -u bacula
> Creation of Bacula MySQL tables succeeded.
>
> # ./bacula start
> Starting the Bacula Storage daemon
> Starting the Bacula File daemon
> Starting the Bacula Director daemon
> 25-Apr 10:15 bacula-dir: Fatal error: Could not open Catalog "MyCatalog",
> database "bacula".
> 25-Apr 10:15 bacula-dir: Fatal error: mysql.c:188 Unable to connect to
> MySQL server.
> Database=bacula User=bacula
> It is probably not running or your password is incorrect.
> 25-Apr 10:15 bacula-dir ERROR TERMINATION
> Please correct configuration file: /etc/bacula/bacula-dir.conf
>
> # dbcheck -c /etc/bacula/bacula-dir.conf
> 25-Apr 11:05 dbcheck: Fatal Error at dbcheck.c:253 because:
> mysql.c:188 Unable to connect to MySQL server.
> Database=bacula User=bacula
> It is probably not running or your password is incorrect.
>
>
The problem is most likely incorrect permissions on the tables or database.
I got the same error message (using postgresql) and after running
$ ./grant_postgresql_privileges bacula -U root
as root in /etc/bacula the problem was gone.
BR Håkon Løvdal
--
View this message in context:
http://www.nabble.com/V2.0.3-director-can%27t-connect-to-mysql-tf3647350.html#a10330827
Sent from the Bacula - Users mailing list archive at Nabble.com.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
