Re: [Bacula-users] DebianSqueeze Installation Issue

On 2/28/2011 12:17 AM, Dene Stringfellow wrote:

I am wondering if anyone could provide some assistance. I have just upgraded Debian Lenny to Squeeze on my server and decided to try Bacula to set up a disk-to-disk (initial full backup) daily incremental backup using two (NTFS formatted) external drives rotated on a weekly basis, so one disk is held off-site while the other is in use. I'm not trying to back up clients at this point.

I ran the following command to install Bacula:

apt-get install bacula

The installation appeared to be successful although I did notice during the installation process that SQLite appeared to be being installed - surprising since I have an active MySQL server installation.

When I then went into the Webmin Bacula module in an attempt to start configuring a backup I was presented with the following error:

Failed to connect to the Bacula database : Failed to load the database DBI driver SQLite at ./bacula-backup-lib.pl line 44. Maybe it is not set up, or the module configuration is incorrect.

... so I checked Module Config and tried changing the path to the database to:

/var/lib/bacula/bacula.db

... but that didn't work either.

I checked online to see if anyone else had had a similar problem and came across a post that recommended checking to see that the (DBI or DBD) perl driver for mysql was installed. I checked and have the following related perl modules installed:

libdb-file-lock-perl 0.05-3
libdbd-mysql-perl 4.016-1
libdbi-perl 1.612-1

Next I tried changing the database server to MySQL under Module Config but that didn't work either as I get the following error:

Failed to connect to the Bacula database : Failed to login to the database /var/lib/bacula/bacula.db : Access denied for user 'root'@'localhost' (using password: NO). Maybe it is not set up, or the module configuration is incorrect.

I realise that the path to the database may now be incorrect as it is the path to the SQLite database file.

I then tried changing the path to the database to:

/var/lib/mysql

but got a similar error:

Failed to connect to the Bacula database : Failed to login to the database /var/lib/mysql : Access denied for user 'root'@'localhost' (using password: NO). Maybe it is not set up, or the module configuration is incorrect.

I then checked the Users and can see that a user called bacula has been created (primary group = bacula; secondary groups = tape).

Then I checked MySQL Database Server (via Webmin) and can see that there is no bacula database present and there is no bacula user listed under User Permissions.

Any pointers as to what to do to try and get bacula configured and started so I can get a backup up and running would be appreciated.

I understand your issue and had a similar one, what you should do is:

Make sure MySQL server daemon is up and running (if you will use MySQL, if not use postgresql).
mysqladmin create bacula (of course you will need privileges to do this)
then /etc/bacula/make_bacula_tables
in /etc/bacula/bacula-dir.conf
make sure your line (search for dbname) is correct:

dbname = "bacula"; dbuser = "root"; dbpassword = "correct pass for root"

if you want to use the dbuser bacula make sure you have created it in MySQL and used
the GRANT statement to give it permissions and updated the password for the bacula database.

That should do it for you.

Regards,
Randy

------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev

_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users