Janco van der Merwe wrote:
> Sorry I just read the rest of your mail......it has been one of those
> days.
>
> Bacula version: 2.2.5
> OS: CentOS5
>
> The output requested:
>
> bacula=# \dp
> Access privileges for database "bacula"
> Schema | Name | Type |
> Access privileges
> --------+----------------------------------+----------+-----------------------------------------
> public | basefiles | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | basefiles_baseid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | cdimages | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | client | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | client_clientid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | client_group | table |
As you can see, many tables have no permissions for bacula.
In fact, I don't recognize many of these tables...It appears that tables
have been added to this database which are not part of a usual Bacula
database.
> public | client_group_client_group_id_seq | sequence |
> public | client_group_member | table |
> public | counters | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | device | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | device_deviceid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | file | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | file_fileid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | filename | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | filename_filenameid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | fileset | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | fileset_filesetid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | job | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | job_jobid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | jobmedia | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | jobmedia_jobmediaid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | location | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | location_locationid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | locationlog | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | locationlog_loclogid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | log | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | log_logid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | media | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | media_mediaid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | mediatype | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | mediatype_mediatypeid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | path | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | path_pathid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | pool | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | pool_poolid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | status | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | storage | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | storage_storageid_seq | sequence |
> {root=arwdRxt/root,bacula=rw/root}
> public | unsavedfiles | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> public | version | table |
> {root=arwdRxt/root,bacula=arwdRxt/root}
> (40 rows)
>
>
>
> -----Original Message-----
> From: Dan Langille <[EMAIL PROTECTED]>
> To: Janco van der Merwe <[EMAIL PROTECTED]>
> Cc: bacula-users@lists.sourceforge.net
> Subject: Re: [Bacula-users] Postgres Dump command fails
> Date: Thu, 13 Dec 2007 07:57:34 -0500
>
> Janco van der Merwe wrote:
>> Hi,
>>
>> Can someone please help me with the below? I'm not a BD expert so I
>> don't have the faintest idea how to fix this.
>>
>> The permissions in the pg_hba.conf has been working for over 6 months
>> and I suddenly received these errors after a Zabbix database was
>> removed.
>>
>> -------- Forwarded Message --------
>>
>> Subject: Bacula: Backup Error of carssrv4-fd Full
>> Date: Thu, 13 Dec 2007 01:31:01 +0200 (SAST)
>>
>> 13-Dec 01:31 carssrv4-dir JobId 185: BeforeJob: run command
>> "/usr/local/etc/bacula/make_catalog_backup bacula bacula xxxxxxx "
>
> If you issue that command from the command line, does it succeed?
>
> By the way, if non-trusted users are on this system, and even if they
> aren't, you can avoid having the password in this email by using .pgpass
> in Bacula's home dir:
>
> http://www.postgresql.org/docs/8.2/static/libpq-pgpass.html
>
>> 13-Dec 01:31 carssrv4-dir JobId 185: BeforeJob: pg_dump: SQL command failed
>> 13-Dec 01:31 carssrv4-dir JobId 185: BeforeJob: pg_dump: Error message from
>> server: ERROR: permission denied for relation client_group
>
> What are the table permissions?
> $ psql bacula
> Welcome to psql 8.2.5, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> bacula=# \dp
>
> They should all be simliar permissions for the bacula user.
>
> BTW, you didn't tell us what version of Bacula, or the OS you are using.
>
>> 13-Dec 01:31 carssrv4-dir JobId 185: BeforeJob: pg_dump: The command was:
>> LOCK TABLE public.client_group IN ACCESS SHARE MODE
>
> How odd, but let's check the permissions first.
>
>> 13-Dec 01:31 carssrv4-dir JobId 185: Error: Runscript: BeforeJob returned
>> non-zero status=1. ERR=Child exited with code 1
>
--
Dan Langille - http://www.langille.org/
BSDCan - The Technical BSD Conference: http://www.bsdcan.org/
-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services
for just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
