mysql server option works fine I can login.

If i put a postgresql server i get:

[root@help bin]# ./CheckDB.pl
DBD::Pg::st execute failed: ERROR:  permission denied for relation valid at /opt/otrs/Kernel/System/DB.pm line 561.
ERROR: OTRS-CheckDB-10 Perl: 5.8.8 OS: linux Time: Wed Sep  3 04:37:51 2008

 Message: ERROR:  permission denied for relation valid, SQL: 'SELECT * FROM valid'

 Traceback (25060):
   Module: ./CheckDB.pl (v1.20) Line: 62

DBD::Pg::st fetchrow_array failed: no statement executing at /opt/otrs/Kernel/System/DB.pm line 624.
No initial inserts found!
[root@help bin]#


syslog:
Sep  3 04:31:28 help OTRS-CheckDB-10[24796]: [Error][./CheckDB.pl][Line:62]: ERROR:  permission denied for relation valid, SQL: 'SELECT * FROM valid'


Config.pm:
  # ---------------------------------------------------- #
    # database settings                                    #
    # ---------------------------------------------------- #
    # DatabaseHost
    # (The database host.)
    $Self->{'DatabaseHost'} = 'localhost';
    # Database
    # (The database name.)
    $Self->{'Database'} = 'otrs';
    # DatabaseUser
    # (The database user.)
    $Self->{'DatabaseUser'} = 'otrs';
    # DatabasePw
    # (The password of database user. You also can use bin/CryptPassword.pl
    # for crypted passwords.)
    $Self->{'DatabasePw'} = 'kingjohn';
    # DatabaseDSN
    # (The database DSN for MySQL ==> more: "man DBD::mysql")
# $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

    # (The database DSN for PostgreSQL ==> more: "man DBD::Pg")
    # if you want to use a local socket connection
$Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};";
    # if you want to use a tcpip connection
# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};";

 


If i put an incorrect passwork in my Config.pm I get:

Message: FATAL:  password authentication failed for user "otrs"

So I see it is talking to the postgresql server fine. Any pointers?

Rudi Schmitz