Date: Fri, 5 Sep 2008 07:58:12 GMT From: "O. Hartmann" <ohartman@zedat.fu-berlin.de> To: freebsd-gnats-submit@FreeBSD.org Subject: 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 Message-ID: <200809050758.m857wCaG066974@www.freebsd.org> Resent-Message-ID: <200809050800.m8580DUZ043497@freefall.freebsd.org>
next in thread | raw e-mail | index | archive | help
>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:
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200809050758.m857wCaG066974>