On 12/23/11 5:27 PM, Thomas Lohman wrote:
> The update postgres script for 5.2.x is missing these two lines which 
> you can run manually from within psql (connect to the bacula db as your 
> Postgres admin db user):
> 
> grant all on RestoreObject to ${bacula_db_user};
> grant select, update on restoreobject_restoreobjectid_seq to 
> ${bacula_db_user};
> 
> That should solve your problem, I think.

Bingo! Thanks.

dn


> 
> 
> --tom
> 
>>>
>>> At this point I'm unclear where the permissions problem exists.
>>
>> Within PostgreSQL.  The PostgreSQL user does not have permissions on that 
>> table…
>>
>> This is not a Unix permissions issue.
>>
>>>
>>> Thanks in advance for further clues.
>>>
>>> dn
>>>
>>>
>>>
>>>>
>>>> I am not using 5.2.2, so I did the version table as an example of what it 
>>>> should look like.
>>>>
>>>>>
>>>>> bacula-# \l
>>>>>       List of databases
>>>>>   Name    | Owner  | Encoding
>>>>> -----------+--------+-----------
>>>>> bacula    | bacula | SQL_ASCII
>>>>> postgres  | pgsql  | UTF8
>>>>> template0 | pgsql  | UTF8
>>>>> template1 | pgsql  | UTF8
>>>>> (4 rows)
>>>>>
>>>>> User bacula's shell is defined as /sbin/nologin, so I think it's user
>>>>> pgsql that's doing the work (at least it was prior to the upgrade). User
>>>>> bacula cannot launch psql nor can I su to that user because of the
>>>>> nologin setting.
>>>>>
>>>>> What permissions do I need to change to get this dump working?
>>>>>
>>>>> Thanks again!
>>>>>
>>>>> dn
>>>>>
>>>>>>
>>>>>>>
>>>>>>> I have restarted all bacula and postgresql daemons since the upgrade. I
>>>>>>> have not changed any permissions in the /home/bacula directory.
>>>>>>>
>>>>>>> Thanks in advance for troubleshooting clues.
>>>>>>>
>>>>>>> dn
>>>>>>>
>>>>>>>
>>>>>>> ------------------------------------------------------------------------------
>>>>>>> Write once. Port to many.
>>>>>>> Get the SDK and tools to simplify cross-platform app development. Create
>>>>>>> new or port existing apps to sell to consumers worldwide. Explore the
>>>>>>> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
>>>>>>> http://p.sf.net/sfu/intel-appdev
>>>>>>> _______________________________________________
>>>>>>> Bacula-users mailing list
>>>>>>> Bacula-users AT lists.sourceforge DOT net
>>>>>>> https://lists.sourceforge.net/lists/listinfo/bacula-users
>>>>>>
>>>>>
>>>>
>>>
>>
> 
> 
> ------------------------------------------------------------------------------
> Write once. Port to many.
> Get the SDK and tools to simplify cross-platform app development. Create 
> new or port existing apps to sell to consumers worldwide. Explore the 
> Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
> http://p.sf.net/sfu/intel-appdev
> _______________________________________________
> Bacula-users mailing list
> Bacula-users AT lists.sourceforge DOT net
> https://lists.sourceforge.net/lists/listinfo/bacula-users


------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create 
new or port existing apps to sell to consumers worldwide. Explore the 
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users