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-configuration

Postgres grant statement
http://www.postgresql.org/docs/7.2/static/privileges.html

Kind regards,
Rory Clerkin

On 29 October 2011 15:22, Ekram <[email protected]> wrote:
> 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
>
---------------------------------------------------------------------
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

Reply via email to