From owner-freebsd-ports-bugs@FreeBSD.ORG Fri Sep 5 08:00:14 2008 Return-Path: Delivered-To: freebsd-ports-bugs@hub.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 45AA0106569F for ; Fri, 5 Sep 2008 08:00:14 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (freefall.freebsd.org [IPv6:2001:4f8:fff6::28]) by mx1.freebsd.org (Postfix) with ESMTP id 1F8788FC35 for ; Fri, 5 Sep 2008 08:00:14 +0000 (UTC) (envelope-from gnats@FreeBSD.org) Received: from freefall.freebsd.org (gnats@localhost [127.0.0.1]) by freefall.freebsd.org (8.14.2/8.14.2) with ESMTP id m8580DBh043499 for ; Fri, 5 Sep 2008 08:00:14 GMT (envelope-from gnats@freefall.freebsd.org) Received: (from gnats@localhost) by freefall.freebsd.org (8.14.2/8.14.1/Submit) id m8580DUZ043497; Fri, 5 Sep 2008 08:00:13 GMT (envelope-from gnats) Resent-Date: Fri, 5 Sep 2008 08:00:13 GMT Resent-Message-Id: <200809050800.m8580DUZ043497@freefall.freebsd.org> Resent-From: FreeBSD-gnats-submit@FreeBSD.org (GNATS Filer) Resent-To: freebsd-ports-bugs@FreeBSD.org Resent-Reply-To: FreeBSD-gnats-submit@FreeBSD.org, "O. Hartmann" Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id 95C2D1065683 for ; Fri, 5 Sep 2008 07:58:12 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (www.freebsd.org [IPv6:2001:4f8:fff6::21]) by mx1.freebsd.org (Postfix) with ESMTP id 83D9D8FC1D for ; Fri, 5 Sep 2008 07:58:12 +0000 (UTC) (envelope-from nobody@FreeBSD.org) Received: from www.freebsd.org (localhost [127.0.0.1]) by www.freebsd.org (8.14.2/8.14.2) with ESMTP id m857wCSf066977 for ; Fri, 5 Sep 2008 07:58:12 GMT (envelope-from nobody@www.freebsd.org) Received: (from nobody@localhost) by www.freebsd.org (8.14.2/8.14.1/Submit) id m857wCaG066974; Fri, 5 Sep 2008 07:58:12 GMT (envelope-from nobody) Message-Id: <200809050758.m857wCaG066974@www.freebsd.org> Date: Fri, 5 Sep 2008 07:58:12 GMT From: "O. Hartmann" To: freebsd-gnats-submit@FreeBSD.org X-Send-Pr-Version: www-3.1 Cc: 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 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 05 Sep 2008 08:00:14 -0000 >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: