Could not open Catalog "MyCatalog", database "bareos

[Doknik]

Hello,
I am new to this forum and bareos, I am trying to set up bareos 18.2 on Rhel (Redhat Enterprise Linux) 7.4 using postgres 9.6

However my bareos-dir (Bareos birector) service keeps failing with errors as below i run command bareos-dir -t

Jun 19 16:54:57 MYSERVER systemd[1]: Starting Bareos Director Daemon service...
Jun 19 16:55:27 MYSERVER bareos-dir[41667]: bareos-dir: dird/dird.cc:927-0 Could not open Catalog "MyCatalog", database "bareos".
Jun 19 16:55:27 MYSERVER bareos-dir[41667]: bareos-dir: dird/dird.cc:932-0 cats/postgresql.cc:254 Unable to connect to PostgreSQL server. Database=bareos User=postgres
Jun 19 16:55:27 MYSERVER systemd[1]: PID file /var/lib/bareos/bareos-dir.9101.pid not readable (yet?) after start.

My Postgres user is the default postgres (Linux OS user account) seems to be created by default and i have a bareos user that also seem to be created with the installation of bareos

I am sure most of you have seen this many times but there seems to be no clear solution to this problem .

Any help would be greatly appreciated

Rgds
Doknik

[Frank Ueberschar]

Did you see the documentation:
https://docs.bareos.org/IntroductionAndTutorial/InstallingBareos.html?highlight=postgres#section-createdatabase
?

Am 19.06.19 um 23:46 schrieb Doknik:

--
Mit freundlichen Grüßen

Frank Ueberschar frank.ue...@bareos.com
Bareos GmbH & Co. KG Phone: +49 221 63 06 93-88
http://www.bareos.com Fax: +49 221 63 06 93-10

Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646
Geschäftsführer: Stephan Dühr, M. Außendorf, J. Steffens, P. Storz

[Doknik]

On Friday, 21 June 2019 09:22:21 UTC+1, Frank Ueberschar wrote:
> Did you see the documentation:
> https://docs.bareos.org/IntroductionAndTutorial/InstallingBareos.html?highlight=postgres#section-createdatabase
> ?
>
> Am 19.06.19 um 23:46 schrieb Doknik:
> > Hello,
> > I am new to this forum and bareos, I am trying to set up bareos 18.2 on Rhel (Redhat Enterprise Linux) 7.4 using postgres 9.6
> >
> > However my bareos-dir (Bareos birector) service keeps failing with errors as below i run command bareos-dir -t
> >
> > Jun 19 16:54:57 MYSERVER systemd[1]: Starting Bareos Director Daemon service...
> > Jun 19 16:55:27 MYSERVER bareos-dir[41667]: bareos-dir: dird/dird.cc:927-0 Could not open Catalog "MyCatalog", database "bareos".
> > Jun 19 16:55:27 MYSERVER bareos-dir[41667]: bareos-dir: dird/dird.cc:932-0 cats/postgresql.cc:254 Unable to connect to PostgreSQL server. Database=bareos User=postgres
> > Jun 19 16:55:27 MYSERVER systemd[1]: PID file /var/lib/bareos/bareos-dir.9101.pid not readable (yet?) after start.
> >
> > My Postgres user is the default postgres (Linux OS user account) seems to be created by default and i have a bareos user that also seem to be created with the installation of bareos
> >
> > I am sure most of you have seen this many times but there seems to be no clear solution to this problem .
> >
> > Any help would be greatly appreciated
> >
> > Rgds
> > Doknik
> >

> >Yes i have read it dilligently and thoroughly yet foun d nothing suggesting i misconfigured anything

[Dominic S S]

Some more information   

I am trying to set up bareos 18.2 on Rhel (Redhat Enterprise Linux) 7.4 using postgres 9.6

However my bareos-dir (Bareos birector) service keeps failing with errors as below as soon as i run it


[root@MYSERVER ~]# systemctl status bareos-dir.service
● bareos-dir.service - Bareos Director Daemon service
   Loaded: loaded (/usr/lib/systemd/system/bareos-dir.service; enabled; vendor preset: disabled)
   Active: inactive (dead) since Sun 2019-06-23 22:04:22 UTC; 10h ago
     Docs: man:bareos-dir(8)
  Process: 8138 ExecStart=/usr/sbin/bareos-dir (code=exited, status=0/SUCCESS)
  Process: 8135 ExecStartPre=/usr/sbin/bareos-dir -t -f (code=exited, status=0/SUCCESS)
 Main PID: 8140 (code=exited, status=1/FAILURE)

Jun 23 22:04:22 MYSERVER systemd[1]: Starting Bareos Director Daemon service...
Jun 23 22:04:22 MYSERVER systemd[1]: PID file /var/lib/bareos/bareos-dir.9101.pid not readable (yet?) after start.
Jun 23 22:04:22 MYSERVER systemd[1]: Started Bareos Director Daemon service.

 I have tried different things but still failing i also found that for some reason my port 9101 is blocked


The main problem i am trying to resolve is the bareos-dir (director) keeps failing a few minutes after starting
the other bareos services are all running fine no issues.

[root@MYSERVER bareos]# netstat -plunt |grep 910[123]
tcp 0 0 0.0.0.0:9102 0.0.0.0:* LISTEN 970/bareos-fd
tcp 0 0 0.0.0.0:9103 0.0.0.0:* LISTEN 965/bareos-sd

 all listening except bareos-dir which is failing and shutting a few seconds after starting

[root@MYSERVER ]# ps -ef |grep bareos
bareos 965 1 0 Jun21 ? 00:00:00 /usr/sbin/bareos-sd
root 970 1 0 Jun21 ? 00:00:00 /usr/sbin/bareos-fd

My guess is that bareos-dir needs ports 9101 open but something has blocked it , i tried to open it manually but get errors below

[root@MYSERVER ~]# nc -l 9101
Ncat: bind to 0.0.0.0:9101: Address already in use. QUITTING.
[root@MYSERVER ~]# nc localhost 9101


[root@MYSERVER bareos]# ls -ltr /var/lib/bareos/
total 20
drwxrwxr-x. 2 bareos bareos 6 Feb 1 10:42 storage
-rw-------. 1 root root 0 Jun 20 14:57 bareos-dir.conmsg
-rw-r-----. 1 root bareos 196 Jun 21 22:48 bareos-fd.9102.state
-rw-r-----. 1 bareos bareos 196 Jun 21 22:48 bareos-sd.9103.state
-rw-r-----. 1 bareos bareos 4 Jun 21 22:50 bareos-sd.9103.pid
-rw-r-----. 1 root bareos 4 Jun 21 22:50 bareos-fd.9102.pid
-rw-r-----. 1 root root 6 Jun 23 09:01 bareos-dir.9101.pid

Please help i am am not sure how to fix this as i mentioned earlier i am running

bareos 18.2 on Rhel (Redhat Enterprise Linux) 7.4 using postgres 9.6

Thanks

My Postgres user is the default postgres (Linux OS user account) seems to be created by default and i have a bareos user that also seem to be created with the installation of bareos

I am sure most of you have seen this many times but there seems to be no clear solution to this problem .

--
You received this message because you are subscribed to the Google Groups "bareos-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to bareos-users...@googlegroups.com.
To post to this group, send email to bareos...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/bareos-users/8c1c6aa6-6251-4d74-bb1c-010e1d04b332%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.