ports/127104: OTRS/PostgreSQL 8.3.3 error: Syntax error in OTRS-CGI-10 root at localhost can't login due to possible syntax error in Perl module
O. Hartmann
ohartman at zedat.fu-berlin.de
Fri Sep 5 08:00:14 UTC 2008
>Number: 127104
>Category: ports
>Synopsis: OTRS/PostgreSQL 8.3.3 error: Syntax error in OTRS-CGI-10 root at localhost can't login due to possible syntax error in Perl module
>Confidential: no
>Severity: critical
>Priority: high
>Responsible: freebsd-ports-bugs
>State: open
>Quarter:
>Keywords:
>Date-Required:
>Class: sw-bug
>Submitter-Id: current-users
>Arrival-Date: Fri Sep 05 08:00:13 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator: O. Hartmann
>Release: FreeBSD 7.1-PRE
>Organization:
FU Berlin
>Environment:
OS: FreeBSD 7.1-PRE
DB: PostgreSQL 8.3.3
WWW: Lighttpd 1.4.19_1
>Description:
When trying logging in into OTRS as 'root at localhost' with password 'root' for the very first time as described in the documentation (after a successful installation) this error occurs on the host running OTRS:
--
Sep 5 07:47:35 munin kernel: Sep 5 07:47:35 munin OTRS-CGI-10[88359]: [Error][Kernel::System::Valid::ValidIDsGet][Line:120]: ERROR: permission denied for relation valid, SQL: 'SELECT id FROM valid WHERE name = 'valid''
Sep 5 07:47:35 munin kernel: Sep 5 07:47:35 munin OTRS-CGI-10[88359]: [Error][Kernel::System::Auth::DB::Auth][Line:93]: ERROR: syntax error at or near ")" LINE 1: SELECT pw, id FROM users WHERE valid_id IN ( ) AND log... ^, SQL: 'SELECT pw, id FROM users WHERE valid_id IN ( ) AND login = 'root at localhost''
--
Remark: the database already do have an administrative user/operator which is capable of logging in, so there should be no access vilation problem.
>How-To-Repeat:
Install lighttpd-1.4.19, postgresql-8.3.3 on a FreeBSD 7.1-PRE box, follow the instructions of the OTRS docu how to initiate first time schemata and then try to login via
https://host/otrs-web/
>Fix:
None known. Even recompiling/reinstalling every Perl-5 related modules (everything OTRS needs and further more, /var/db/pkg/p5-*) does not fix the problem.
>Release-Note:
>Audit-Trail:
>Unformatted:
More information about the freebsd-ports-bugs
mailing list