Installing RT with PostgreSQL yields "invalid privilege type USAGE for table" error

RT Users
1

Hi. I just downloaded rt-3.8.1 and am trying to install in on CentOS
5.2 with PostgreSQL 8.1.11

make initialize-database exists with error:

Working with:
Type: Pg
Host: localhost
Name: rt3
User: rt_user
DBA: postgres
Now creating a Pg database rt3 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs
Couldn’t finish ‘acl’ step.

ERROR: Couldn’t run SQL query:
GRANT USAGE, SELECT, UPDATE ON attachments_id_seq TO rt_user;

ERROR: ERROR: invalid privilege type USAGE for table

make: *** [initialize-database] Error 255
[root@hwd-ddc-app-prod01 rt-3.8.1]#

So I re-ran this command as:

rt3=# GRANT SELECT, UPDATE ON attachments_id_seq TO rt_user;
GRANT
rt3=#

MySQL.com docs say “USAGE” is synonym for “no privileges”.

Does anybody know the PostgreSQL equivalent for “no priveleges”, please?

Best,
Aleksey

Aleksey Tsalolikhin
UNIX System Administrator
“I get stuff done!”
http://www.lifesurvives.com/

2

I think I am OK… if anybody knows to the contrary, please let me know.

rt3=# \du
List of roles
Role name | Superuser | Create role | Create DB | Connections | Member of
…
rt_user | no | no | no | no limit |
(3 rows)

rt3=#

Best,
Aleksey

3

Hi. I just downloaded rt-3.8.1 and am trying to install in on CentOS
5.2 with PostgreSQL 8.1.11

make initialize-database exists with error:

Working with:
Type: Pg
Host: localhost
Name: rt3
User: rt_user
DBA: postgres
Now creating a Pg database rt3 for RT.
Done.
Now populating database schema.
Done.
Now inserting database ACLs
Couldn’t finish ‘acl’ step.

ERROR: Couldn’t run SQL query:
GRANT USAGE, SELECT, UPDATE ON attachments_id_seq TO rt_user;

USAGE for sequences has been added in Pg 8.2. Replace “GRANT USAGE,
SELECT, UPDATE” with “GRANT SELECT, UPDATE” in etc/acl.Pg.

ERROR: ERROR: invalid privilege type USAGE for table

make: *** [initialize-database] Error 255
[root@hwd-ddc-app-prod01 rt-3.8.1]#

So I re-ran this command as:

rt3=# GRANT SELECT, UPDATE ON attachments_id_seq TO rt_user;
GRANT
rt3=#

MySQL.com docs say “USAGE” is synonym for “no privileges”.

Does anybody know the PostgreSQL equivalent for “no priveleges”, please?

Best,
Aleksey

–
Aleksey Tsalolikhin
UNIX System Administrator
“I get stuff done!”
http://www.lifesurvives.com/

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

4

USAGE for sequences has been added in Pg 8.2. Replace “GRANT USAGE,
SELECT, UPDATE” with “GRANT SELECT, UPDATE” in etc/acl.Pg.

Thanks, Ruslan! that’s what I did. But now I get HTTP 500 internal
server error when I try to access my RT for the first time.

My httpd error log reads:

DBD::Pg::st execute failed: ERROR: permission denied for relation
users at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 505.
RT::Handle=HASH(0x2aea5f3f0590) couldn’t execute the query ‘SELECT *
FROM Users WHERE LOWER(Name) = LOWER(?)’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518

Please advise?

Thanks,
Aleksey

5

You did something wrong. Either start over with patched acl.Pg file or
in Pg client grant SELECT/CREATE/UPDATE/DELETE rights to rt_user on
all tables in RT DB.On Wed, Dec 3, 2008 at 1:52 AM, Aleksey Tsalolikhin atsaloli.tech@gmail.com wrote:

On Tue, Dec 2, 2008 at 2:36 PM, Ruslan Zakirov ruz@bestpractical.com wrote:

USAGE for sequences has been added in Pg 8.2. Replace “GRANT USAGE,
SELECT, UPDATE” with “GRANT SELECT, UPDATE” in etc/acl.Pg.

Thanks, Ruslan! that’s what I did. But now I get HTTP 500 internal
server error when I try to access my RT for the first time.

My httpd error log reads:

DBD::Pg::st execute failed: ERROR: permission denied for relation
users at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 505.
RT::Handle=HASH(0x2aea5f3f0590) couldn’t execute the query ‘SELECT *
FROM Users WHERE LOWER(Name) = LOWER(?)’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518

Please advise?

Thanks,
Aleksey

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

6

THANK YOU. I am up now!

Best,
AlekseyOn Tue, Dec 2, 2008 at 3:57 PM, Ruslan Zakirov ruz@bestpractical.com wrote:

You did something wrong. Either start over with patched acl.Pg file or
in Pg client grant SELECT/CREATE/UPDATE/DELETE rights to rt_user on
all tables in RT DB.

On Wed, Dec 3, 2008 at 1:52 AM, Aleksey Tsalolikhin atsaloli.tech@gmail.com wrote:

On Tue, Dec 2, 2008 at 2:36 PM, Ruslan Zakirov ruz@bestpractical.com wrote:

USAGE for sequences has been added in Pg 8.2. Replace “GRANT USAGE,
SELECT, UPDATE” with “GRANT SELECT, UPDATE” in etc/acl.Pg.

Thanks, Ruslan! that’s what I did. But now I get HTTP 500 internal
server error when I try to access my RT for the first time.

My httpd error log reads:

DBD::Pg::st execute failed: ERROR: permission denied for relation
users at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 505.
RT::Handle=HASH(0x2aea5f3f0590) couldn’t execute the query ‘SELECT *
FROM Users WHERE LOWER(Name) = LOWER(?)’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518

Please advise?

Thanks,
Aleksey

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

Aleksey Tsalolikhin
UNIX System Administrator
“I get stuff done!”
http://www.lifesurvives.com/

7

This has been fixed in the repository. RT 3.8.2 will have two acl.Pg
files: acl.Pg and acl.Pg-8.2 for different Pg versions.On Wed, Dec 3, 2008 at 3:27 AM, Aleksey Tsalolikhin atsaloli.tech@gmail.com wrote:

THANK YOU. I am up now!

Best,
Aleksey

On Tue, Dec 2, 2008 at 3:57 PM, Ruslan Zakirov ruz@bestpractical.com wrote:

You did something wrong. Either start over with patched acl.Pg file or
in Pg client grant SELECT/CREATE/UPDATE/DELETE rights to rt_user on
all tables in RT DB.

On Wed, Dec 3, 2008 at 1:52 AM, Aleksey Tsalolikhin atsaloli.tech@gmail.com wrote:

On Tue, Dec 2, 2008 at 2:36 PM, Ruslan Zakirov ruz@bestpractical.com wrote:

USAGE for sequences has been added in Pg 8.2. Replace “GRANT USAGE,
SELECT, UPDATE” with “GRANT SELECT, UPDATE” in etc/acl.Pg.

Thanks, Ruslan! that’s what I did. But now I get HTTP 500 internal
server error when I try to access my RT for the first time.

My httpd error log reads:

DBD::Pg::st execute failed: ERROR: permission denied for relation
users at /usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm
line 505.
RT::Handle=HASH(0x2aea5f3f0590) couldn’t execute the query ‘SELECT *
FROM Users WHERE LOWER(Name) = LOWER(?)’ at
/usr/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518

Please advise?

Thanks,
Aleksey

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

–
Aleksey Tsalolikhin
UNIX System Administrator
“I get stuff done!”
http://www.lifesurvives.com/

Best regards, Ruslan.