Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

ports/127104: OTRS/PostgreSQL 8.3.3 error: Syntax error in OTRS-CGI-10 root@localhost can't login due to possible syntax error in Perl module

7 views

Skip to first unread message

O. Hartmann

unread,

Sep 5, 2008, 3:58:12 AM9/5/08

to freebsd-gn...@freebsd.org

>Number: 127104
>Category: ports
>Synopsis: OTRS/PostgreSQL 8.3.3 error: Syntax error in OTRS-CGI-10 root@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@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@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:

RudiS...@gmail.com

unread,

Sep 11, 2008, 2:59:59 PM9/11/08

make the otrs user a superuser and try it again. It is not secure
doing this but otrs will work.

0 new messages