On Tuesday, 24 November 2015 11:41:03 UTC, philipp.storz wrote: > If you are sure that postgresql is running, the access rights on postgres > seem to be your problem. > > check the settings in your pg_hba.conf > > Am 24.11.2015 um 12:13 schrieb [email protected]: > > Hey guys, > > > > I had a previous version of BareOS (Nov 2014) running on the machine that > > does backups, but after > > an update to the November 2015 client (which was apparently unintentional) > > backups for this > > install are now failing. > > > > I ran the update scripts to convert the DB from 2003 to 2004 which > > completed successfully but > > ever since it's not been too happy. > > > > > > > > 24-Nov 03:28 vm-backups1-dir JobId 0: Fatal error: sql_create.c:544 > > sql_create.c:544 query SELECT > > ClientId,Uname FROM Client WHERE Name='vm-backups1-fd' failed: no > > connection to the server > > > > 24-Nov 03:30 vm-backups1-dir JobId 0: Error: sql_create.c:587 Create DB > > Client record INSERT INTO > > Client (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES > > ('vm-backups1-fd','',0,2592000,15552000) failed. ERR=no connection to the > > server > > > > 24-Nov 03:31 vm-backups1-dir JobId 0: Fatal error: Could not create Client > > record. ERR=Query > > failed: INSERT INTO Log (JobId, Time, LogText) VALUES (0,'2015-11-24 > > 03:30:11','vm-backups1-dir > > JobId 0: Error: sql_create.c:587 Create DB Client record INSERT INTO Client > > (Name,Uname,AutoPrune,FileRetention,JobRetention) VALUES > > (''vm-backups1-fd'','''',0,2592000,15552000) failed. ERR=no connection to > > the server > > > > '): ERR=no connection to the server > > > > > > > > It's pretty clear that it's having trouble connecting, but I can't for the > > life of me figure out > > why. > > > > I've made sure Postgres (v8.4) is running, there is a bareos database. The > > config file for > > bareos-dir, bareos-fd, and bareos-sd haven't changed. I've changed file > > permissions, I've tried > > to connect to the database myself. > > > > Running the bareos-dir -t just results in... > > > > 23-Nov 16:47 bareos-dir JobId 0: Fatal error: Could not open Catalog > > "MyCatalog", database > > "bareos". 23-Nov 16:47 bareos-dir JobId 0: Fatal error: postgresql.c:246 > > Unable to connect to > > PostgreSQL server. Database=bareos User=bareos Possible causes: SQL server > > not running; password > > incorrect; max_connections exceeded. 23-Nov 16:47 bareos-dir ERROR > > TERMINATION > > > > > > Le help please? What additional info/configs would you guys like? > > > > Cheers, > > > > - Mark > > > > > -- > Mit freundlichen Grüßen > > Philipp Storz [email protected] > Bareos GmbH & Co. KG Phone: Phone: +49221630693-92 > http://www.bareos.com Fax: +49221630693-10 > > Sitz der Gesellschaft: Köln | Amtsgericht Köln: HRA 29646 > Geschäftsführer: Stephan Dühr, M. Außendorf, > J. Steffens, P. Storz, M. v. Wieringen
Hey Philipp, Thanks for taking some time to help. Pretty sure postgres is running. :) [root@vm-backups1]# /etc/init.d/postgresql status postmaster (pid 20615) is running... As for pg_hba.conf... # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident # IPv4 local connections: host all all 127.0.0.1/32 ident # IPv6 local connections: host all all ::1/128 ident -> I added these lines below in the process of troubleshooting, which hasn't really solved much just yet, but so I could log in and confirm databases, etc. Otherwise this file is unchanged. # Allow for root login local all root trust # BareOS local bareos bareos trust Log in to the shell was/has been disabled. I've enabled it to log onto the bareos user for testing again and since disabled it again. [root@vm-backups1]# cat /etc/passwd bareos:x:498:498:bareos:/var/lib/bareos:/bin/false Is my pg_hba.conf incorrect? I've looked for examples online and mine appears to be valid. Like I said, nothing in the config was changed prior/after the update until I got an alert that it wasn't completing backups. - Mark -- 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 [email protected]. To post to this group, send email to [email protected]. For more options, visit https://groups.google.com/d/optout.
