These two commands apparently went through as root, they fail as postgres. And yes, it was "postgres" reported by the "psql -l" command, the "postres" was a typo.

[EMAIL PROTECTED] bacula]# ./make_postgresql_tables -U postgres
psql: FATAL:  Ident authentication failed for user "postgres"
Creation of Bacula PostgreSQL tables failed.

[EMAIL PROTECTED] bacula]# ./grant_postgresql_privileges -U postgres
psql: FATAL:  Ident authentication failed for user "postgres"
Error creating privileges.

I reran both commands as root, the first fails because it's already been done, the second says "role "bacula" alread exists" and then grants all the privs again.

But the director still won't start:

[EMAIL PROTECTED] bacula]# ./bacula-ctl-dir start
Starting the Bacula Director daemon
03-Nov 09:28 bacula-dir:  Fatal error: Could not open Catalog "MyCatalog", database "bacula".
03-Nov 09:28 bacula-dir:  Fatal error: postgresql.c:168 Unable to connect to PostgreSQL server.
Database=bacula User=bacula
It is probably not running or your password is incorrect.
03-Nov 09:28 bacula-dir ERROR TERMINATION
Please correct configuration file: /etc/bacula/bacula-dir.conf

I have not made any changes to the bacula-dir.conf, it's exactly what the RPM installed. The same applies to to the other .conf files:
[EMAIL PROTECTED] bacula]# ls -l *.conf
-rw-r----- 1 root bacula 7890 Nov  1 01:28 bacula-dir.conf
-rw-r----- 1 root bacula 1000 Nov  1 01:28 bacula-fd.conf
-rw-r----- 1 root disk   5272 Nov  1 01:28 bacula-sd.conf
-rw-r----- 1 root bacula  192 Nov  1 01:28 bconsole.conf

Van



John Drescher wrote:


---------- Forwarded message ----------
From: John Drescher <[EMAIL PROTECTED]>
Date: Nov 3, 2006 8:41 AM
Subject: Re: [Bacula-users] Getting started
To: "G. Armour Van Horn" <[EMAIL PROTECTED]>



On 11/3/06, G. Armour Van Horn <[EMAIL PROTECTED]> wrote:
The list of databases includes four, the significant one says:
bacula   postgres   UTF8

Does the fact that the bacula database shows "postres" as the owner
suggest a solution?


Run

make_postgresql_tables -U postres
grant_postgresql_privileges -U postres

John



--
John M. Drescher

------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642

_______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users

-- 
----------------------------------------------------------
Sign up now for Quotes of the Day, a handful of quotations
on a theme delivered every morning.
Enlightenment! Daily, for free! 
mailto:[EMAIL PROTECTED]

For photography, web design, hosting, and maintenance, 
visit Van's home page: http://www.domainvanhorn.com/van/
-----------------------------------------------------------
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users

Reply via email to