Wow, Gerald, Aleksey, I really don't think this is a great idea.
The otrs.CheckDB.pl script just connects to your database, tries to do
a select statement on the OTRS table called 'valid' and if that works,
assumes there is a connection.
What happened in this case is that the authentication is no
On Tue, Mar 29, 2011 at 7:44 PM, Gerald Young wrote:
> Message: ERROR: permission denied for relation valid, SQL: 'SELECT *
> FROM valid'
>
>... you don't have select privileges on the table named "valid" so
> you should
> grant select on valid to public;
Thanks, Gerald, that did it!
Perhaps th
Message: ERROR: permission denied for relation valid, SQL: 'SELECT *
FROM valid'
You're heavily invested in postgresql ... your database admin should have
been able to resolve this in a heartbeat.
Short answer: you don't have select privileges on the table named "valid" so
you should
grant selec
otrs.CheckDB.pl fails, it says permission denied for table "valid" -
the table is there though.
# /opt/otrs/bin/otrs.CheckDB.pl
Trying to connect to database
DSN: DBI:Pg:dbname=otrs;host=localhost;
DatabaseUser: otrs
DBD::Pg::st execute failed: ERROR: permission denied for relation
valid at /op
