[otrs] problem using OTRS 2.3.2 with Postgresql 8.3.3 on centos 5.2 64 bit.

9 Sep 2008

      I figured this out the Postgresql SQL account that is in Config.pm has to
have superuser rights for some reason. If I give the otrsdb user account
superuser in PGAdmin3 it works fine now.

This doesn't make sense but it is working. I figured it was permissions
related but not SQL permissions related.

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