Re: [Bacula-users] DebianSqueeze Installation Issue
Rory, Thank you for the feedback and links. I will look into PostgreSQL when I get a moment. Regards Dene On 28/02/2011 16:27, Rory Campbell-Lange wrote: Hi Dene If you are already running MySQL on the server and you are familiar with administering it, that is probably the best RDMS to use. Choosing one over the other is the subject of many flamewars. There are some notes here: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL and http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html We use Postgresql for a number of large web applications and we have found it very robust and easily upgradeable over several versions. We also make extensive use of stored procedures. Regards Rory -- Ridgedale Communications Limited 2 School Road, West Hanney, Wantage, Oxfordshire, OX12 0LA, UK t 01235 868111m 07967 665758 registration details: name Ridgedale Communications Limited address Murray House, 58 High Street, Biddulph, Stoke-on-Trent, ST8 6AR, UK number England 3879827 CONFIDENTIALITY: This e-mail and it attachments are intended for the above named only and may be confidential. If they come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to the e-mail and highlight the error. SECURITY WARNING: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. VIRUSES: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] DebianSqueeze Installation Issue
Randy, A belated thanks for your feedback. I will check the settings you have suggested and see if I can get it to work with MySQL. Regards Dene On 28/02/2011 13:49, Randy Katz wrote: 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 -- Ridgedale Communications Limited 2 School Road, West Hanney, Wantage, Oxfordshire, OX12 0LA, UK t 01235 868111m 07967 665758 registration details: name Ridgedale Communications Limited address Murray House, 58 High Street, Biddulph, Stoke-on-Trent, ST8 6AR, UK number England 3879827 CONFIDENTIALITY: This e-mail and it attachments are intended for the above named only and may be confidential. If they come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to the e-mail and highlight the error. SECURITY WARNING: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. VIRUSES: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
[Bacula-users] DebianSqueeze Installation Issue
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. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] DebianSqueeze Installation Issue
On 28/02/11, Dene Stringfellow (supp...@ridgedale.co.uk) 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. If you run dpkg -l | grep bacula it will show you which bacula packages you have installed. My server has: bacula-common bacula-commong-pgsql bacula-console bacula-director-common bacula-director-pgsql bacula-fd bacula-sd bacula-sd-pgsql If you are intending to use mysql you will need to choose the packages with mysql instead of pgsql. The other errors you report have to do with Mysql configuration. If you haven't got a database configured yet, it may be worth moving to Postgresql in any event. -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] DebianSqueeze Installation Issue
Rory, Thank you for your feedback. I now have the following bacula modules on my server: ii bacula 5.0.2-2.2 ii bacula-client 5.0.2-2.2 ii bacula-common 5.0.2-2.2+b1 ii bacula-common-mysql 5.0.2-2.2+b1 rc bacula-common-sqlite3 5.0.2-2.2+b1 ii bacula-console 5.0.2-2.2+b1 ii bacula-director-common 5.0.2-2.2+b1 ii bacula-director-mysql 5.0.2-2.2+b1 rc bacula-director-sqlite3 5.0.2-2.2+b1 ii bacula-doc 5.0.2-1 ii bacula-fd 5.0.2-2.2+b1 ii bacula-sd 5.0.2-2.2+b1 ii bacula-sd-mysql 5.0.2-2.2+b1 ii bacula-server 5.0.2-2.2 ii bacula-traymonitor 5.0.2-2.2+b1 I already have other MySQL databases running so I really want to try to get Bacula working with MySQL. Can I ask, though, are there advantages in running Postgresql as opposed to MySQL? If so, what do you perceive them to be? Thanks again Dene On 28/02/2011 10:37, Rory Campbell-Lange wrote: If you run dpkg -l | grep bacula it will show you which bacula packages you have installed. My server has: bacula-common bacula-commong-pgsql bacula-console bacula-director-common bacula-director-pgsql bacula-fd bacula-sd bacula-sd-pgsql If you are intending to use mysql you will need to choose the packages with "mysql" instead of "pgsql". The other errors you report have to do with Mysql configuration. If you haven't got a database configured yet, it may be worth moving to Postgresql in any event. -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -- Ridgedale Communications Limited 2 School Road, West Hanney, Wantage, Oxfordshire, OX12 0LA, UK t 01235 868111m 07967 665758 registration details: name Ridgedale Communications Limited address Murray House, 58 High Street, Biddulph, Stoke-on-Trent, ST8 6AR, UK number England 3879827 CONFIDENTIALITY: This e-mail and it attachments are intended for the above named only and may be confidential. If they come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to the e-mail and highlight the error. SECURITY WARNING: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. We advise that you understand and observe this lack of security when e-mailing us. VIRUSES: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should ensure they are actually virus free. -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
Re: [Bacula-users] DebianSqueeze Installation Issue
On 28/02/11, Dene Stringfellow (supp...@ridgedale.co.uk) wrote: Thank you for your feedback. I now have the following bacula modules on my server: ii bacula 5.0.2-2.2 ii bacula-client 5.0.2-2.2 ii bacula-common 5.0.2-2.2+b1 ii bacula-common-mysql5.0.2-2.2+b1 rc bacula-common-sqlite3 5.0.2-2.2+b1 ii bacula-console 5.0.2-2.2+b1 ii bacula-director-common 5.0.2-2.2+b1 ii bacula-director-mysql 5.0.2-2.2+b1 rc bacula-director-sqlite35.0.2-2.2+b1 ii bacula-doc 5.0.2-1 ii bacula-fd 5.0.2-2.2+b1 ii bacula-sd 5.0.2-2.2+b1 ii bacula-sd-mysql5.0.2-2.2+b1 ii bacula-server 5.0.2-2.2 ii bacula-traymonitor 5.0.2-2.2+b1 I already have other MySQL databases running so I really want to try to get Bacula working with MySQL. Can I ask, though, are there advantages in running Postgresql as opposed to MySQL? If so, what do you perceive them to be? Hi Dene If you are already running MySQL on the server and you are familiar with administering it, that is probably the best RDMS to use. Choosing one over the other is the subject of many flamewars. There are some notes here: http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL and http://www.bacula.org/5.0.x-manuals/en/main/main/Installing_Configuring_Post.html We use Postgresql for a number of large web applications and we have found it very robust and easily upgradeable over several versions. We also make extensive use of stored procedures. Regards Rory -- Rory Campbell-Lange r...@campbell-lange.net Campbell-Lange Workshop www.campbell-lange.net 0207 6311 555 3 Tottenham Street London W1T 2AF Registered in England No. 04551928 -- 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users