[Bacula-users] Upgrading bacula from version 5 to version 7

Hi all, I am currently using version 5 of bacula dir,sd and fd. Is there any documentation on upgrading to the latest release from this version. Will I have to first upgrade to 7.0 or can I upgrade directly to 7.0.5. I am also upgrading the base OS from Centos 6 to Centos 7. Which problems can

Re: [Bacula-users] director won't start

So, just to be thorough, I dropped the database again and ran these commands again! [root@ops:/etc/bacula] #./create_mysql_database Creation of bacula database succeeded. [root@ops:/etc/bacula] #./make_mysql_tables Creation of Bacula MySQL tables succeeded. [root@ops:/etc/bacula]

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi! Which Bacula´s 5 version do you have? I´ve upgraded from 5.2.13 to 7.0.5 with no problems (host XenServer). I´m affraid version 5.0.X has a prior database version than 5.2.13, so it will be nice to take a look at your actual database version (you can make a select to list contents from

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

The version I am running is 5 exactly: Version: 5.0.0 (26 January 2010) Selecting database version I get VersionID = 12 5.0.0 is in the base repo but I can’t see 5.2.13 in there. What’s the best way to get to 5.2.13 first? Where can I get update_bacula_tables from + documentation :P I

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi Ana, The version I am running is 5 exactly: Version: 5.0.0 (26 January 2010) Selecting database version I get VersionID = 12 5.0.0 is in the base repo but I can’t see 5.2.13 in there. What’s the best way to get to 5.2.13 first? Where can I get update_bacula_tables from +

Re: [Bacula-users] director won't start

Hi Heitor, Hey Tim: it seems that the make_mysql_tables scripts isn't creating the Version table for some reason. I would suggest you to download Bacula 5.2.13 code and run the database creation scripts from there. Ps.: I really like your posts at US Govmnt list. Regards, Thanks for your

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

CentOS 6.5 should be 5.2.13. Try yum update bacula-client Sent from my android device. -Original Message- From: Waqar Khan waqar.k...@hornbill.com To: Ana Emília M. Arruda emiliaarr...@gmail.com Cc: Bacula-users@lists.sourceforge.net bacula-users@lists.sourceforge.net Sent: Fri, 27 Mar

Re: [Bacula-users] director won't start

Hi Heitor, Hey Tim: it seems that the make_mysql_tables scripts isn't creating the Version table for some reason. I would suggest you to download Bacula 5.2.13 code and run the database creation scripts from there. Ps.: I really like your posts at US Govmnt list. Regards,

[Bacula-users] Upgrading bacula from version 5 to version 7

No Change in structure Database 5.2.5 to 7.x Adjust your conf file ( /var/run/bacula - /var/run for ex ), that's all :) I make this for Ubuntu 14/Bacula 5.2.5 to CentOs 7/bacula 7.0.5 Le 27/03/2015 14:14, bacula-users-requ...@lists.sourceforge.net a écrit : Send Bacula-users mailing list

Re: [Bacula-users] director won't start

Hello Heitor, I can see in your dir.conf that you are using an admin user to connect to your database. Did you try the bacula user? This is the one created by the grant_x_privileges script. I took a look at the grant_mysql_privileges script. And noticed that the password entry wasn't set. So

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi Wagar, On Fri, Mar 27, 2015 at 2:30 PM, Waqar Khan waqar.k...@hornbill.com wrote: Hi, I have done some reading on bacula 7 and the 5.2.13 version in centos base. I have decided to upgrade to centos7 and use the 5.2.13 version and not go to 7 just yet. (sorry for changing my mind L)

Re: [Bacula-users] director won't start

Hi Dmitri, That sounds familiar... do you need to do what the /usr/share/doc/bacula-.../quickstart_mysql.txt says? Yep! I ran the following commands from the mysql quickstart: [root@ops:~] #alternatives --set libbaccats.so /usr/lib64/libbaccats-mysql.so You have new mail in

Re: [Bacula-users] director won't start

On 03/27/2015 11:52 AM, Tim Dunphy wrote: Ok I think you're right about this! No mention of MySQL!!! That sounds familiar... do you need to do what the /usr/share/doc/bacula-.../quickstart_mysql.txt says? -- Dimitri Maziuk Programmer/sysadmin BioMagResBank, UW-Madison --

Re: [Bacula-users] director won't start

Hi Josip, I am pretty much sure that after the two lines that contain dir_plugins.c, you should see several lines mentioning mysql.c Are you sure that your bacula-dir has been compiled with mysql support? You could probably check that with the command such as: ldd /path/to/your/bacula-dir

Re: [Bacula-users] director won't start

Josip, I uninstalled bacula-director as you suggested. And went through the install again. It seems to only offer me the bacula-dir that does'nt directly support mysql, if I'm understanding everything correctly: [root@ops:~] #yum install bacula-director-mysql.x86_64 Loaded plugins:

Re: [Bacula-users] director won't start

Quoting message written on Friday 2015-03-27 11:34:29: Yep! that works! [root@ops:~] #mysql -ubacula -p -h localhost Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 32 Server version: 5.5.42 MySQL Community Server (GPL) by Remi

Re: [Bacula-users] director won't start

Quoting message written on Friday 2015-03-27 12:52:13: No mention of MySQL!!! If I do a yum search for references to mysql and bacula: [root@ops:~] #yum search bacula| grep mysql Repository base is listed more than once in the configuration Repository updates is listed more than once in

Re: [Bacula-users] director won't start

Hold on... You said the original bacula director box died, puppet restored the configs and you restored the db from the source skel files? Perhaps restoring a copy of your bacula database from before the crash will help with the missing catalog mystery :) --eddie On 03/27/2015 09:08 AM, Tim

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi Wagar, Is that clear for you? I saw the other posts. So you have two options: upgrade to 5.2.13 using yum or remove your actual version and build from source the 7.0.5 version. If you decide to build from source, remember to do a backup of your conf files (they shouldn´t be replaced, but...).

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi Wagar, On Fri, Mar 27, 2015 at 12:55 PM, Waqar Khan waqar.k...@hornbill.com wrote: Hi, Thanks all for the replies. My requirement is to move to a centos 7 OS with mysql as DB (current is 6). Here is what I’ve found from the instructions provided by everyone (and for the benefit of

Re: [Bacula-users] director won't start

Hi Josip, I wonder if your bacula director is reading the correct config file. Could you check that your bacula-dir is down and try to start the bacula-dir manually with the debug set? For example: bacula-dir -c /etc/bacula/bacula.dir.conf -d 200 -f That should show some debug output

Re: [Bacula-users] director won't start

Quoting message written on Friday 2015-03-27 11:01:52: Hello Heitor, I can see in your dir.conf that you are using an admin user to connect to your database. Did you try the bacula user? This is the one created by the grant_x_privileges script. I took a look at the

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi Waqar, On 27 March 2015 at 15:08, Waqar Khan waqar.k...@hornbill.com wrote: 5.0.0 is in the base repo but I can’t see 5.2.13 in there. What’s the best way to get to 5.2.13 first? Where can I get update_bacula_tables from + documentation :P I'm the Bacula Fedora maintainer, and the

Re: [Bacula-users] director won't start

Hi Josip, Are you able to connect to the mysql using the same credentials as bacula but using mysql client with -h localhost option, e.g. mysql -h localhost -u bacula -p bacula Yep! that works! [root@ops:~] #mysql -ubacula -p -h localhost Enter password: Welcome to the MySQL monitor.

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi, Thanks all for the replies. My requirement is to move to a centos 7 OS with mysql as DB (current is 6). Here is what I’ve found from the instructions provided by everyone (and for the benefit of someone in the future in my situation): Firstly, build a new centos 7 machine and do the

Re: [Bacula-users] director won't start

Quoting message written on Friday 2015-03-27 12:08:27: Ok, I've verified that director is down, only storage and file daemons are running: [root@ops:~] #ps -ef | grep bacula | grep -v grep root 12915 1 0 Mar26 ?00:00:00 bacula-fd -c /etc/bacula/bacula-fd.conf -u root -g

Re: [Bacula-users] director won't start

So I'd trace those !@#$ing alternatives symlinks and see which libbaccat your director is actually finding. Ah-HA!!! [root@ops:/etc/bacula] #ls -l /usr/lib64/libbaccats-7.0.5.so lrwxrwxrwx 1 root root 21 Mar 25 22:33 /usr/lib64/libbaccats-7.0.5.so - libbaccats-sqlite3.so OK so that

Re: [Bacula-users] director won't start

On 03/27/2015 01:22 PM, Tim Dunphy wrote: Hmmm...ok well if I do a ldd on that libcats file I see no mysql support is listed: Well, keeping in mind the different everything, here's what I got on a working 5.2.13/postgres 9.2: # ldd /usr/sbin/bacula-dir linux-vdso.so.1 =

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi Ana, I’ve now come to these steps after your suggestions: 1. Build a centos 7 server and install bacula from base i.e. 5.2.13 and mariadb 2. Stop all bacula services on old server 3. Take a mysql dump of the old server’s bacula database. Mysqldump –u root –p bacula

Re: [Bacula-users] director won't start

That's fine b/c it's in libbaccats-7.0.5.so = /usr/lib64/libbaccats-7.0.5.so (0x2aeee000) You could ldd libbaccats just to double-check. Hmm. I don't use mysql so about the only other thing I can think of is lower_case_table_names or whatever it's called in my.cnf

Re: [Bacula-users] director won't start

On 03/27/2015 03:16 PM, Tim Dunphy wrote: Ah-HA!!! [root@ops:/etc/bacula] #alternatives --set libbaccats-mysql-7.0.5.so /usr/lib64/libbaccats-mysql.so So I guess I'm still not doing this quite right, because it looks like the mysql libraries are still not linked to the bacula director:

Re: [Bacula-users] director won't start

Quoting message written on Friday 2015-03-27 16:16:53: I tried setting the alternatives this way: [root@ops:/etc/bacula] #alternatives --set libbaccats-mysql-7.0.5.so /usr/lib64/libbaccats-mysql.so So I guess I'm still not doing this quite right, because it looks like the mysql libraries

Re: [Bacula-users] director won't start

Quoting message written on Friday 2015-03-27 17:55:52: These are the binaries I have installed: [root@ops:/etc/yum.repos.d] #rpm -qa | grep bacula bacula-client-7.0.5-1.el5.x86_64 bacula-storage-7.0.5-1.el5.x86_64 bacula-director-7.0.5-1.el5.x86_64 bacula-libs-sql-7.0.5-1.el5.x86_64

Re: [Bacula-users] director won't start

What the fine manual sez, literally: alternatives --set libbaccats.so /usr/lib64/libbaccats-mysql.so You might want to --remove libbaccats-mysql-7.0.5.so while you're at it. The long story is /usr/lib[64]/libfoo.so is a symlink to /etc/alternatives/libfoo.so which is a symlink to

Re: [Bacula-users] director won't start

[root@ops:/etc/yum.repos.d] #rpm -qa | grep bacula bacula-client-7.0.5-1.el5.x86_64 bacula-storage-7.0.5-1.el5.x86_64 bacula-director-7.0.5-1.el5.x86_64 bacula-libs-sql-7.0.5-1.el5.x86_64 bacula-libs-7.0.5-1.el5.x86_64 bacula-console-7.0.5-1.el5.x86_64 bacula-common-7.0.5-1.el5.x86_64

Re: [Bacula-users] director won't start

On 03/27/2015 04:55 PM, Tim Dunphy wrote: OK! Well sarcasm perhaps deserved. But that is what I tried initially. The sarcasm was aimed at people (debian as I recall) who came up with the alternatives system: I could not for the life of me figure out the name and path bits myself the first

Re: [Bacula-users] director won't start

Hey Josip, FINALLY we have success! [root@ops:/etc/bacula] #service bacula-dir start Starting bacula-dir: [ OK ] [root@ops:/etc/bacula] #service bacula-dir status bacula-dir (pid 3547) is running... And the test results are good:

Re: [Bacula-users] Upgrading bacula from version 5 to version 7

Hi Wagar, On Fri, Mar 27, 2015 at 3:25 PM, Waqar Khan waqar.k...@hornbill.com wrote: Hi Ana, I’ve now come to these steps after your suggestions: 1. Build a centos 7 server and install bacula from base i.e. 5.2.13 and mariadb 2. Stop all bacula services on old server 3.