problem accessing new vw7.8 Store repository with non-superuser user

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

problem accessing new vw7.8 Store repository with non-superuser user

Ken G. Brown
In vw7.8, following PostgreSQL Setup on page 3.5 of the SourceCodeMgmtGuide.pdf to create a new Store repository, when I try to connect to the repository with a normal user created via #> createuser -U postgres -D -A -P <username>, I keep getting the error:
'The Store database tables do not appear to be in the current database. Install Store database tables?'

The tables are clearly there when the new database is viewed with pgAdmin3, and the repository is usable if a user is a superuser.

I do not want to create all repository users as superusers.

The symptoms are the same from client images running on both Mac and Linux.
The server where the new repository is being created is running Ubuntu 12.04 LTS (GNU/Linux 3.2.0-27-generic x86_64), and PostgreSQL 9.1.

Does anyone know how to get around this issue?

Thx for any tips.
Ken G. Brown
_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: problem accessing new vw7.8 Store repository with non-superuser user

Niall Ross
Dear Ken,
    you apply the appropriate resolution (100490 IIRC).  I'll email you.

(This will be restored in 7.9.1.)

             Yours faithfully
                   Niall Ross

>In vw7.8, following PostgreSQL Setup on page 3.5 of the SourceCodeMgmtGuide.pdf to create a new Store repository, when I try to connect to the repository with a normal user created via #> createuser -U postgres -D -A -P <username>, I keep getting the error:
>'The Store database tables do not appear to be in the current database. Install Store database tables?'
>
>The tables are clearly there when the new database is viewed with pgAdmin3, and the repository is usable if a user is a superuser.
>
>I do not want to create all repository users as superusers.
>  
>
No indeed.

>The symptoms are the same from client images running on both Mac and Linux.
>The server where the new repository is being created is running Ubuntu 12.04 LTS (GNU/Linux 3.2.0-27-generic x86_64), and PostgreSQL 9.1.
>
>Does anyone know how to get around this issue?
>
>Thx for any tips.
>Ken G. Brown
>_______________________________________________
>vwnc mailing list
>[hidden email]
>http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
>
>
>  
>


_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
Reply | Threaded
Open this post in threaded view
|

Re: problem accessing new vw7.8 Store repository with non-superuser user

Ken G. Brown
Thank you very much for the quick response.
I had a quick look and it seems there was a lot to correct.
Thx,
   Ken

On 2012-07-27, at 4:40 PM, Niall Ross wrote:

> Dear Ken,
>   you apply the appropriate resolution (100490 IIRC).  I'll email you.
>
> (This will be restored in 7.9.1.)
>
>            Yours faithfully
>                  Niall Ross
>
>> In vw7.8, following PostgreSQL Setup on page 3.5 of the SourceCodeMgmtGuide.pdf to create a new Store repository, when I try to connect to the repository with a normal user created via #> createuser -U postgres -D -A -P <username>, I keep getting the error:
>> 'The Store database tables do not appear to be in the current database. Install Store database tables?'
>>
>> The tables are clearly there when the new database is viewed with pgAdmin3, and the repository is usable if a user is a superuser.
>>
>> I do not want to create all repository users as superusers.
>>
> No indeed.
>
>> The symptoms are the same from client images running on both Mac and Linux.
>> The server where the new repository is being created is running Ubuntu 12.04 LTS (GNU/Linux 3.2.0-27-generic x86_64), and PostgreSQL 9.1.
>>
>> Does anyone know how to get around this issue?
>>
>> Thx for any tips.
>> Ken G. Brown
>> _______________________________________________
>> vwnc mailing list
>> [hidden email]
>> http://lists.cs.uiuc.edu/mailman/listinfo/vwnc
>>
>>
>>
>
>

_______________________________________________
vwnc mailing list
[hidden email]
http://lists.cs.uiuc.edu/mailman/listinfo/vwnc