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@lists.sourceforge.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@lists.sourceforge.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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
