Bacula-users

Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"

2012-12-27 10:36:00
Subject: Re: [Bacula-users] PostgreSQL - Could not open Catalog "MyCatalog", database "bacula"
From: Simone Caronni <negativo17 AT gmail DOT com>
To: Wolfgang Denk <wd AT denx DOT de>
Date: Thu, 27 Dec 2012 16:33:21 +0100
Hello,

that's related to Fedora packaging and should not be addressed to this list.

Please take a look at your installed file:

/usr/share/doc/bacula-common-5.2.12/README.Fedora

What's missing is only your choice in the alternatives system for the
database backend:


# alternatives --config libbaccats.so

There are 3 programs which provide 'libbaccats.so'.

  Selection    Command
-----------------------------------------------
   1           /usr/lib64/libbaccats-mysql.so
 + 2           /usr/lib64/libbaccats-sqlite3.so
*  3           /usr/lib64/libbaccats-postgresql.so

Enter to keep the current selection[+], or type selection number:

Regards,
--Simone



On 27 December 2012 16:12, Wolfgang Denk <wd AT denx DOT de> wrote:
> Hi,
>
> I would like to apologize in advance for re-asking a FAQ:  I am well
> aware that here have been a ton of similar reports before, and I did
> read these and try out suggested solutions, with no avail.
>
> After running bacula for a long, long time with MySQL, I decided to
> try it out with PostgreSQL instead.
>
> This is a from-scratch installation based on Fedora 17 and the Bacula
> packages that come with this release, i. e.
>
>         bacula-client-5.2.12-3.fc17.x86_64
>         bacula-common-5.2.12-3.fc17.x86_64
>         bacula-console-5.2.12-3.fc17.x86_64
>         bacula-console-bat-5.2.12-3.fc17.x86_64
>         bacula-director-5.2.12-3.fc17.x86_64
>         bacula-docs-5.2.12-1.fc17.noarch
>         bacula-libs-5.2.12-3.fc17.x86_64
>         bacula-libs-sql-5.2.12-3.fc17.x86_64
>         bacula-storage-5.2.12-3.fc17.x86_64
>
> The problem:  I get (like so many others before) these error messages:
>
> ...
> bacula-dir: dir_plugins.c:160-0 Load dir plugins
> bacula-dir: dir_plugins.c:162-0 No dir plugin dir!
> bacula-dir: lockmgr.c:583-0 Exit check_deadlock.
> bacula-dir: postgresql.c:1126-0 db_init_database first time
> bacula-dir: postgresql.c:241-0 pg_real_connect done
> bacula-dir: postgresql.c:243-0 db_user=bacula db_name=bacula 
> db_password=XXXXXX
> bacula-dir: dird.c:1006 Could not open Catalog "MyCatalog", database "bacula".
> bacula-dir: dird.c:1011 postgresql.c:248 Unable to connect to PostgreSQL 
> server. Databas
> Possible causes: SQL server not running; password incorrect; max_connections 
> exceeded.
> 27-Dec 15:56 bacula-dir ERROR TERMINATION
> Please correct configuration file: /etc/bacula/bacula-dir.conf
> ...
>
> I used this command to set the db_password :
>
>         # su - -s /bin/bash bacula
>         -bash-4.2$ psql -Ubacula bacula
>         psql (9.1.7)
>         Type "help" for help.
>
>         bacula=> alter user bacula with password 'XXXXXX';
>         ALTER ROLE
>         bacula=> \q
>         -bash-4.2$
>
> I appears this worked fine. I can also access the batabase manually,
> like running the commands described in step "13. Resequence your
> tables with the following commands" in the "Installing and
> Configuring PostgreSQL" section of the manual:
>
>         # su - -s /bin/bash bacula
>         -bash-4.2$ psql -Ubacula bacula
>         psql (9.1.7)
>         Type "help" for help.
>
>         bacula=> SELECT SETVAL('client_clientid_seq', (SELECT
>         bacula(> MAX(clientid) FROM client));
>          setval
>         --------
>
>         (1 row)
>
>         bacula=> \q
>         -bash-4.2$
>
> So it appears that the PostgreSQL server is up and running, the DB is
> there and can be accessed.
>
> Note: none of the commands above did request me to enter any
> password. [But then, when changing bacula-dir.conf back to the
> default setting (empty db_password), I get the same results]
>
>
> I tried with misc settings of pg_hba.conf as recommended in some of
> the previous postings, with no avail either.
>
> Is there any way to debug which actual operation is failing?  Or
> otherwise find out which exact setting might be wrong?
>
>
> Thanks in advance...
>
> Best regards,
>
> Wolfgang Denk
>
> --
> DENX Software Engineering GmbH,     MD: Wolfgang Denk & Detlev Zundel
> HRB 165235 Munich, Office: Kirchenstr.5, D-82194 Groebenzell, Germany
> Phone: (+49)-8142-66989-10 Fax: (+49)-8142-66989-80 Email: wd AT denx DOT de
> "You're just jealous." "What, of an overgrown puppy  with  a  single-
> figure IQ?"                      - Terry Pratchett, _Moving Pictures_
>
> ------------------------------------------------------------------------------
> Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
> MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
> with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
> MVPs and experts. ON SALE this month only -- learn more at:
> http://p.sf.net/sfu/learnmore_122712
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users



-- 
You cannot discover new oceans unless you have the courage to lose
sight of the shore (R. W. Emerson).

------------------------------------------------------------------------------
Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS,
MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current
with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft
MVPs and experts. ON SALE this month only -- learn more at:
http://p.sf.net/sfu/learnmore_122712
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users