Dear all, I get a message from root as follows;
09-Feb 11:26 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula". 09-Feb 11:26 bacula-dir JobId 0: Fatal error: postgresql.c:227 Unable to connect to PostgreSQL server. Database=bacula User=bacula Possible causes: SQL server not running; password incorrect; max_connections exceeded. 09-Feb 11:26 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf
Does anyone know how to check if the database for bacula exists and how to start it?
I would like to know how to view tape archives?
Thank you if anyone can help.
John.
On 02/15/11 3:27 PM, Johnny H wrote:
Does anyone know how to check if the database for bacula exists and how to start it?
# su - postgres $ psql -l
that should list a bacula database. if it says postgres isn't running, then...
$ ^D # service postgresql start
then try the above steps again.
if postgresql won't start, find the postgres data directory, typically /var/lib/pgsql/data on centos system unless you built or installed a custom postgres, and look in pg_log/* for the latest logfile, and see what it says.
on some older versions, its 'server.log' in the data dir, instead of pg_log/*.log
On Tue, 2011-02-15 at 23:27 +0000, Johnny H wrote:
Dear all, I get a message from root as follows;
09-Feb 11:26 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula". 09-Feb 11:26 bacula-dir JobId 0: Fatal error: postgresql.c:227 Unable to connect to PostgreSQL server. Database=bacula User=bacula Possible causes: SQL server not running; password incorrect; max_connections exceeded. 09-Feb 11:26 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf
Does anyone know how to check if the database for bacula exists and how to start it?
I would like to know how to view tape archives?
Thank you if anyone can help.
---- bacula will create the database if there is a user with password and permissions suitable for the task. There is ample documentation at http://www.bacula.org
Craig
Thank you your advice.
Usefully I don't have password to # su - postgres and I am assuming it is impossible to get this. Normal su (root) pass does not work.
On Wed, Feb 16, 2011 at 12:07 AM, Craig White craigwhite@azapple.com wrote:
On Tue, 2011-02-15 at 23:27 +0000, Johnny H wrote:
Dear all, I get a message from root as follows;
09-Feb 11:26 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula". 09-Feb 11:26 bacula-dir JobId 0: Fatal error: postgresql.c:227 Unable to connect to PostgreSQL server. Database=bacula User=bacula Possible causes: SQL server not running; password incorrect; max_connections exceeded. 09-Feb 11:26 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf
Does anyone know how to check if the database for bacula exists and how to start it?
I would like to know how to view tape archives?
Thank you if anyone can help.
bacula will create the database if there is a user with password and permissions suitable for the task. There is ample documentation at http://www.bacula.org
Craig
-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On 2/15/11 6:30 PM, Johnny H wrote:
Thank you your advice.
Usefully I don't have password to # su - postgres and I am assuming it is impossible to get this. Normal su (root) pass does not work.
If you are already root when you execute that command it should not ask for another password.
talk to the system & database administrator for the machine, assuming they are interested in getting it backed up. I think by default, user 'postgres' doesn't need a password but then again, I wouldn't use that user on active database. I would create a user for that purpose...it's rather trivial.
Craig
On Wed, 2011-02-16 at 00:30 +0000, Johnny H wrote:
Thank you your advice.
Usefully I don't have password to # su - postgres and I am assuming it is impossible to get this. Normal su (root) pass does not work.
On Wed, Feb 16, 2011 at 12:07 AM, Craig White craigwhite@azapple.com wrote:
On Tue, 2011-02-15 at 23:27 +0000, Johnny H wrote:
Dear all, I get a message from root as follows;
09-Feb 11:26 bacula-dir JobId 0: Fatal error: Could not open Catalog "MyCatalog", database "bacula". 09-Feb 11:26 bacula-dir JobId 0: Fatal error: postgresql.c:227 Unable to connect to PostgreSQL server. Database=bacula User=bacula Possible causes: SQL server not running; password incorrect; max_connections exceeded. 09-Feb 11:26 bacula-dir ERROR TERMINATION Please correct configuration file: /etc/bacula/bacula-dir.conf
Does anyone know how to check if the database for bacula exists and how to start it?
I would like to know how to view tape archives?
Thank you if anyone can help.
bacula will create the database if there is a user with password and permissions suitable for the task. There is ample documentation at http://www.bacula.org
Craig
-- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
On 02/15/11 5:22 PM, Craig White wrote:
talk to the system& database administrator for the machine, assuming they are interested in getting it backed up. I think by default, user 'postgres' doesn't need a password but then again, I wouldn't use that user on active database. I would create a user for that purpose...it's rather trivial.
indeed, my examples were purely for diagnostic purposes. the postgres unix account should ONLY be used for database administration.
it typically has no password on a clean install, I showed the # prompt to indicate those commands would be issued by root.
if you're doing an initial install of bacula (I was assuming this was a previously working system that somehow stopped working), then something like..
# su - postgres postgres$ psql .... postgres=> create user bacula with password 'xxxyyy'; CREATE USER postgres=> create database bacula with owner bacula; CREATE DATABASE; postgres=> \q
postgres$ exit
...
would create a bacula SQL user and a empty bacula database owned by this user, which you could use for bacula.
Thank you all for your sound advice. Just to fill you in on why I am such a spoon at sys admin, this system cost £50K+ and there is no sys admin and it comes with really poor service support. So I am learning on the job.
I now have a list of databases and there is not one called Bacula. I will go away and mull/read and make a plan.
Again, thanks a lot, the simplest of tasks for your guys is the unknown for me, so your help appreciated.
Kind regards,
John.
On Wed, Feb 16, 2011 at 5:18 AM, John R Pierce pierce@hogranch.com wrote:
On 02/15/11 5:22 PM, Craig White wrote:
talk to the system& database administrator for the machine, assuming they are interested in getting it backed up. I think by default, user 'postgres' doesn't need a password but then again, I wouldn't use that user on active database. I would create a user for that purpose...it's rather trivial.
indeed, my examples were purely for diagnostic purposes. the postgres unix account should ONLY be used for database administration.
it typically has no password on a clean install, I showed the # prompt to indicate those commands would be issued by root.
if you're doing an initial install of bacula (I was assuming this was a previously working system that somehow stopped working), then something like..
# su - postgres postgres$ psql .... postgres=> create user bacula with password 'xxxyyy'; CREATE USER postgres=> create database bacula with owner bacula; CREATE DATABASE; postgres=> \q
postgres$ exit
...
would create a bacula SQL user and a empty bacula database owned by this user, which you could use for bacula.
CentOS mailing list CentOS@centos.org http://lists.centos.org/mailman/listinfo/centos
-
Craig White -
John R Pierce -
Johnny H -
Les Mikesell