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