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

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
participants (1)
-
Rudi Schmitz