Quoting message written on Friday 2015-03-27 19:42:55:
One thing I neglected to mention was that my backup tapes were at all
points fine and not affected by the incident that had wrecked my bacula
system. So it looks like I'm good to go!
The bacula community is absolutely phenomenal and a
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]
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
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,
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
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
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 --
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
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:
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
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
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
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
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
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.
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
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
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 =
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
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:
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
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
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
[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
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
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:
Hey Alan,
Just on the offchance, try service bacula-dir stop and then start it.
Nah, sorry. That didn't work. The bacula director definitely is not
running...
[root@ops:~] #lsof -i :9101
[root@ops:~] #
[root@ops:~] #netstat -tulpn | grep -i listen | grep bacula
tcp0 0
Hi Josip,
Your config file seems ok to me except that you have omitted the
first line of the config file which probably looks like Director {
I accidentally sent this to only Josip. Now including the list. Sorry
dudes!
Hmm.. ok. Well that may have been a copy/paste error on my part. Here is
Hey all,
Ok, well I had an unfortunate incident where I had to rebuild my bacula
server. Fortunately I have the entire bacula config puppeted. So I was able
to restore config files that I was using when the server was running fine.
However, even tho that's the case, I am not able to get the
Hi Tim,
Are you sure about your Catalog´s name? I´m not sure, but I think it was
MyCatalog.
Best regards,
Ana
On Thu, Mar 26, 2015 at 5:30 PM, Josip Deanovic djosip+n...@linuxpages.net
wrote:
Quoting message written on Thursday 2015-03-26 16:07:27:
Here, it's complaining that it can't do a
Quoting message written on Thursday 2015-03-26 16:07:27:
Here, it's complaining that it can't do a select from the database. But
when I go into the DB myself, I can see it works just fine:
mysql use bacula
Reading table information for completion of table and column names
You can turn off
Quoting message written on Thursday 2015-03-26 17:37:18:
I actually copied the password from the config file, and pasted it into
the command prompt for the password when connecting to mysql.
Your config file seems ok to me except that you have omitted the
first line of the config file which
Running Bacular 3.0.3 on FreeNAS on FreeBSD 7.2-RELEASE-p4
When I try to start the Director, it will not remain in memory. Is there any
way to determine what the problem is?
Thanks Lars
/usr/local/etc/rc.d/bacula-dir start
Starting bacula_dir.
ps auwx | grep bacula
bacula 7 0.0 0.2
On Mon, Nov 30, 2009 at 3:34 PM, Larry Marshall l...@marshap.com wrote:
Running Bacular 3.0.3 on FreeNAS on FreeBSD 7.2-RELEASE-p4
When I try to start the Director, it will not remain in memory. Is there any
way to determine what the problem is?
Run the director directly from the shell. Add
34 matches
Mail list logo