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
