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 Dunphy wrote:
> 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 including the lines where the bacula
>     is trying to connect to the database.
>     It might be helpful to see your last 25 lines of the output but note
>     that it will write out the database password so you might want to
>     replace it with something else.
>
>
>
> 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 root
> bacula   26664     1  0 00:21 ?        00:00:00 bacula-sd -c
> /etc/bacula/bacula-sd.conf -u bacula -g disk
>
> And this is what I get when I run that command:
>
> [root@ops:~] #bacula-dir -c /etc/bacula/bacula-dir.conf -d 200 -f
> bacula-dir: dird.c:194-0 Debug level = 200
> bacula-dir: address_conf.c:264-0 Initaddr 0.0.0.0:9101 <http://0.0.0.0:9101>
> bacula-dir: runscript.c:284-0 runscript: debug
> bacula-dir: runscript.c:285-0  --> RunScript
> bacula-dir: runscript.c:286-0   -->
> Command=/etc/bacula/make_catalog_backup.pl
> <http://make_catalog_backup.pl> JokefireCatalog
> bacula-dir: runscript.c:287-0   --> Target=
> bacula-dir: runscript.c:288-0   --> RunOnSuccess=1
> bacula-dir: runscript.c:289-0   --> RunOnFailure=0
> bacula-dir: runscript.c:290-0   --> FailJobOnError=1
> bacula-dir: runscript.c:291-0   --> RunWhen=2
> bacula-dir: runscript.c:284-0 runscript: debug
> bacula-dir: runscript.c:285-0  --> RunScript
> bacula-dir: runscript.c:286-0   -->
> Command=/etc/bacula/delete_catalog_backup
> bacula-dir: runscript.c:287-0   --> Target=
> bacula-dir: runscript.c:288-0   --> RunOnSuccess=1
> bacula-dir: runscript.c:289-0   --> RunOnFailure=0
> bacula-dir: runscript.c:290-0   --> FailJobOnError=1
> bacula-dir: runscript.c:291-0   --> RunWhen=1
> bacula-dir: jcr.c:128-0 read_last_jobs seek to 192
> bacula-dir: jcr.c:135-0 Read num_items=10
> bacula-dir: dir_plugins.c:148-0 Load dir plugins
> bacula-dir: dir_plugins.c:150-0 No dir plugin dir!
> bacula-dir: dird.c:972-0 Could not open Catalog "JokefireCatalog",
> database "bacula".
> bacula-dir: dird.c:977-0 Query failed: SELECT VersionId FROM Version:
> ERR=no such table: Version
> 27-Mar 12:04 bacula-dir ERROR TERMINATION
> Please correct configuration file: /etc/bacula/bacula-dir.conf
>
> It looks like it can't find a catalog by the name "JokefireCatalog". But
> it used to be there before some data got deleted.
>
> So is this a physical file on the file system that it's not finding?  Or
> is this an entry in the database that it's not finding? Any ideas how to
> correct this?
>
> Thanks!!
> Tim
>
>
>
> On Fri, Mar 27, 2015 at 11:47 AM, Josip Deanovic
> <djosip+news AT linuxpages DOT net <mailto:djosip+news AT linuxpages DOT 
> net>> wrote:
>
>     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
>     >
>     > Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights
>     > reserved.
>     >
>     > Oracle is a registered trademark of Oracle Corporation and/or its
>     > affiliates. Other names may be trademarks of their respective
>     > owners.
>     >
>     > Type 'help;' or '\h' for help. Type '\c' to clear the current input
>     > statement.
>     >
>     > mysql>
>     >
>     >
>     >
>     > Still need some ideas, unfortunately! :(
>
>     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 including the lines where the bacula
>     is trying to connect to the database.
>
>     It might be helpful to see your last 25 lines of the output but note
>     that it will write out the database password so you might want to
>     replace it with something else.
>
>     --
>     Josip Deanovic
>
>     
> ------------------------------------------------------------------------------
>     Dive into the World of Parallel Programming The Go Parallel Website,
>     sponsored
>     by Intel and developed in partnership with Slashdot Media, is your
>     hub for all
>     things parallel software development, from weekly thought leadership
>     blogs to
>     news, videos, case studies, tutorials and more. Take a look and join the
>     conversation now. http://goparallel.sourceforge.net/
>     _______________________________________________
>     Bacula-users mailing list
>     Bacula-users AT lists.sourceforge DOT net
>     <mailto:Bacula-users AT lists.sourceforge DOT net>
>     https://lists.sourceforge.net/lists/listinfo/bacula-users
>
>
>
>
> --
> GPG me!!
>
> gpg --keyserver pool.sks-keyservers.net <http://pool.sks-keyservers.net>
> --recv-keys F186197B
>
>
>
> ------------------------------------------------------------------------------
> Dive into the World of Parallel Programming The Go Parallel Website, sponsored
> by Intel and developed in partnership with Slashdot Media, is your hub for all
> things parallel software development, from weekly thought leadership blogs to
> news, videos, case studies, tutorials and more. Take a look and join the
> conversation now. http://goparallel.sourceforge.net/
>
>
>
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users
>

------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users