What user are you logging into the database as? It looks as if the
user you are using does not have th correct database permissions.
Make sure the user that you are using to log into the database has
been granted the correct permissions
OTRS (3.0) docs for Database installation (scroll down to the section
"Installing the OTRS database manually")
http://doc.otrs.org/3.0/en/html/manual-installation-of-otrs.html#database-co...
Postgres grant statement
http://www.postgresql.org/docs/7.2/static/privileges.html
Kind regards,
Rory Clerkin
On 29 October 2011 15:22, Ekram
Hi,
When i am running the database check i found the following error. It is a fresh installation on debian6.
root@newotrs:/opt/otrs# perl -w /opt/otrs/bin/otrs.CheckDB.pl DBD::Pg::st execute failed: ERROR: permission denied for relation valid at /opt/otrs/Kernel/System/DB.pm line 553. ERROR: OTRS-otrs.CheckDB.pl-10 Perl: 5.10.1 OS: linux Time: Sat Oct 29 16:15:26 2011
Message: ERROR: permission denied for relation valid, SQL: 'SELECT * FROM valid'
Traceback (21481): Module: /opt/otrs/bin/otrs.CheckDB.pl (v1.3) Line: 64
DBD::Pg::st fetchrow_array failed: no statement executing at /opt/otrs/Kernel/System/DB.pm line 616. No initial inserts found!
Please help me.
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs