I am new to both bacula and mysql and I need some suggestions about
how to further diagnose this problem. I cannot get the bacula
director daemon to start. The mqsqld is running and the database
generation scripts are able to connect as user root (with a password)
as well as user bacula (with no password). However, I get an error
when starting the director stating that it cannot connect to the MYSQL
server. See below for details.
My bacula-dir.conf file has this section:
# Generic catalog service
Catalog {
Name = MyCatalog
dbname = bacula; user = bacula; password = ""
}
I can post more of the config file(s) if it would help. I am installing
bacula 2.0.3 fresh from the bacula-2.0.3.tar.gz source file with the
2.0.3 patches from SourceForge applied. The target system is
Slackware 11.0 with MYSQL 5.0.24a installed from the distribution
disk. The mysql database files appear to be in /var/lib/mysql which
has a subdirectory named bacula which looks like it contains the
bacula database files.
Here is what I did:
added users bacdir and bacsd to /etc/passwd
added groups bacdir and bacsd to /etc/group
In the bacula-2.0.3 top level directory from the tar file:
# make distclean
# ./configure --prefix=/usr --sbindir=/usr/sbin --sysconfdir=/etc/bacula
--with-scriptdir=/etc/bacula --enable-smartalloc --enable-wx-console
--with-mysql --with-working-dir=/var/bacula --with-pid-dir=/var/run
--with-subsys-dir=/var/lock/subsys --enable-conio --disable-ipv6 --with-openssl
--with-dir-user=bacdir --with-dir-group=bacdir --with-sd-user=bacsd
--with-sd-group=bacsd
# make
# make install
started mysqld with 'mysqld_safe'
(in /etc/bacula)
# ./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.
--
[EMAIL PROTECTED] John Stimson
http://www.idsfa.net/~john/ HMC Physics '94
-------------------------------------------------------------------------
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
