Re: [Bacula-users] Database insert error in bacula-5.2.5.

On Wed, Feb 8, 2012 at 12:43 PM, John Drescher <drescherjm AT gmail DOT com> 
wrote:
> On Wed, Feb 8, 2012 at 8:19 AM, John Drescher <drescherjm AT gmail DOT com> 
> wrote:
>> On Wed, Feb 8, 2012 at 3:07 AM, Geert Stappers
>> <Geert.Stappers AT vanadgroup DOT com> wrote:
>>> Op 20120202 om 18:12 schreef John Drescher:
>>>> Op 20120202 om 17:40 schreef Marty Frasier:
>>>> > I GRANTed rights to user bacula for that table and in addition usage
>>>> > must be granted for the related sequence (postgresql).
>>>> >
>>>> > This is what I have now:
>>>> > bacula=# \dp restoreobject*
>>>> >                                            Access privileges
>>>> >  Schema |               Name                |   Type   |   Access 
>>>> > privileges   | Column access privileges
>>>> > --------+-----------------------------------+----------+-----------------------+--------------------------
>>>> >  public | restoreobject                     | table    | 
>>>> > bacula=arwdDxt/bacula
>>>> >  public | restoreobject_restoreobjectid_seq | sequence | 
>>>> > bacula=rwU/bacula     |
>>>> >
>>>>
>>>> Sounds good to me. I will check this out later.
>>>
>>> Is no news, good news?
>>>
>>
> Working on now. The permissions were definitely wrong:
> bacula=# \dp restoreobject*
>                                          Access privileges
>  Schema |               Name                |   Type   | Access
> privileges | Column access privileges
> --------+-----------------------------------+----------+-------------------+--------------------------
>  public | restoreobject                     | table    |                   |
>  public | restoreobject_restoreobjectid_seq | sequence |                   |
> (2 rows)
>
>

It seems I needed to re run the grant_postgresql_privileges script:

fileserver1 bacula # sh grant_postgresql_privileges -h 192.168.1.33 -U hbroker
Password for user hbroker:
psql:-:2: ERROR:  role "bacula" already exists
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
GRANT
Privileges for user bacula granted on database bacula.
fileserver1 bacula # psql -U hbroker -d bacula -h 192.168.1.33
Password for user hbroker:
psql (9.1.2)
Type "help" for help.

bacula=# \dp restoreobject*
                                             Access privileges
 Schema |               Name                |   Type   |    Access
privileges    | Column access privileges
--------+-----------------------------------+----------+-------------------------+--------------------------
 public | restoreobject                     | table    |
hbroker=arwdDxt/hbroker+|
        |                                   |          |
bacula=arwdDxt/hbroker  |
 public | restoreobject_restoreobjectid_seq | sequence |
hbroker=rwU/hbroker    +|
        |                                   |          |
bacula=rw/hbroker       |
(2 rows)

bacula=#

John

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Bacula-users mailing list
Bacula-users AT lists.sourceforge DOT net
https://lists.sourceforge.net/lists/listinfo/bacula-users