Package: otrs2
Version: 2.4.7-5
Severity: important
Hi,
we are migrating from OTRS 2.2.4-1 (Debian Etch) to OTRS 2.4.7-5 (Lenny + OTRS
from Testing). OTRS is working fine so far, we added our custom settings from
Config.pm to the new System. Imported the mysql DB, ran the migration
scripts...
But we have one major problem: when we edit /etc/otrs/Kernel/Config.pm and save
the file OTRS breaks. Even if we don't change the file content - just open it
and save it. I've to restart apache to get OTRS up again. If a someone opens a
ticket in otrs and was filling out the field on the webpage, all his work would
be wiped by just editing this file.
I get the following error message in my browser:
#####
Fehler: Access denied for user 'otrs'@'localhost' (using password: NO)
Kommentar: Please contact your admin
Fehler berichten:
Traceback: ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Thu Jul 1
09:34:07 2010
Message: Access denied for user 'otrs'@'localhost' (using password: NO)
Traceback (19657):
Module: Kernel::System::DB::new (v1.105.2.1) Line: 188
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 143
Module:
ModPerl::ROOT::ModPerl::Registry::usr_share_otrs_bin_cgi_2dbin_index_2epl::handler
(unknown version) Line: 48
Module: (eval) (v1.88) Line: 204
Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
####
Note: DB access is working fine before saving Config.pm and after restarting
apache.
I could track down the problem to the Apache2::Reload module which is activated
in /etc/apache2/conf.d/otrs2.
# Apache::Reload - Reload Perl Modules when Changed on Disk
PerlModule Apache2::Reload
PerlInitHandler Apache2::Reload
PerlModule Apache2::RequestRec
If I disable Apache2::Reload I don't get the error after editing Config.pm.
Next I've enabled debugging for apache and Apache2::Reload with...
LogLevel debug
PerlSetVar ReloadDebug On
....and get this in the log file:
####
[...]
[Thu Jul 1 09:34:06 2010] -e: Apache2::Reload: Checking mtime of Carp/Heavy.pm
[Thu Jul 1 09:34:06 2010] -e: Apache2::Reload: Checking mtime of Config.pm
[Thu Jul 1 09:34:06 2010] -e: Apache2::Reload: Checking mtime of
Convert/ASN1.pm
[...]
[Thu Jul 1 09:34:07 2010] -e: Apache2::Reload: Checking mtime of warnings.pm
[Thu Jul 1 09:34:07 2010] -e: Apache2::Reload: Checking mtime of
warnings/register.pm
[Thu Jul 1 09:34:07 2010] Config.pm: Apache2::Reload: process 19657 reloading
Kernel::Config from Kernel/Config.pm
ERROR: DatabasePw not defined!
[Thu Jul 1 09:34:07 2010] -e: Use of uninitialized value in pattern match
(m//) at /usr/share/otrs//Kernel/System/DB.pm line 111.
[Thu Jul 1 09:34:07 2010] -e: DBI
connect('database=otrs;host=localhost;port=3306;','otrs',...) failed: Access
denied for user 'otrs'@'localhost' (using password: NO) at
/usr/share/otrs//Kernel/System/DB.pm line 214
ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: linux Time: Thu Jul 1 09:34:07 2010
Message: Access denied for user 'otrs'@'localhost' (using password: NO)
Traceback (19657):
Module: Kernel::System::DB::new (v1.105.2.1) Line: 188
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 143
Module:
ModPerl::ROOT::ModPerl::Registry::usr_share_otrs_bin_cgi_2dbin_index_2epl::handler
(unknown version) Line: 48
Module: (eval) (v1.88) Line: 204
Module: ModPerl::RegistryCooker::run (v1.88) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.88) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
[Thu Jul 01 09:34:07 2010] [debug] mod_deflate.c(615): [client xx.60.20.67]
Zlib: Compressed 5356 to 1535 : URL /otrs/index.pl, referer:
http://vumea008/otrs/index.pl?Session=1074f2b456ff43d100898ecb7ec0874a0e
[Thu Jul 1 09:34:07 2010] -e: Apache2::Reload: Checking mtime of
/etc/otrs/database.pm
[...]
####
On the old server with OTRS 2.2.4 we didn't have this problem because
libapache2-reload-perl was not installed there.
Is this a problem with the otrs2 package or libapache2-reload-perl? What would
be the downside of disableing Apache2::Reload?
Thanks, Ralf
-- System Information:
Debian Release: 5.0.4
APT prefers stable
APT policy: (990, 'stable'), (50, 'testing')
Architecture: i386 (i686)
Kernel: Linux 2.6.26-2-686 (SMP w/1 CPU core)
Locale: LANG=de_DE.utf8, LC_CTYPE=de_DE.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/bash
Versions of packages otrs2 depends on:
ii adduser 3.110 add and remove users and groups
ii apache2-mpm-prefork [htt 2.2.9-10+lenny7 Apache HTTP Server - traditional n
ii dbconfig-common 1.8.39 common framework for packaging dat
ii debconf [debconf-2.0] 1.5.24 Debian configuration management sy
ii libapache2-reload-perl 0.10-2 Reload Perl modules when changed o
ii libauthen-sasl-perl 2.12-1 Authen::SASL - SASL Authentication
ii libcrypt-passwdmd5-perl 1.3-9 interoperable MD5-based crypt() fo
ii libdate-pcalc-perl 1.2-3 Perl module for Gregorian calendar
ii libdbi-perl 1.605-1 Perl5 database interface by Tim Bu
ii libemail-valid-perl 0.179-2 Check validity of Internet email a
ii libio-stringy-perl 2.110-4 Perl modules for IO from scalars a
ii libjs-prototype 1.6.0.2-4 JavaScript Framework for dynamic w
ii libmail-pop3client-perl 2.17-1 POP3 client module for perl
ii libmailtools-perl 2.03-1 Manipulate email in perl programs
ii libmime-tools-perl 5.427-1 Perl5 modules for MIME-compliant m
ii libnet-imap-simple-perl 1.17-3 Perl extension for simple IMAP acc
ii libnet-imap-simple-ssl-p 1.3-3 Subclass of Net::IMAP::Simple with
ii libnet-smtp-ssl-perl 1.01-2 SSL support for Net::SMTP
ii libpdf-api2-perl 0.69-2 create or modify PDF documents in
ii libsoap-lite-perl 0.710.08-1 Client and server side SOAP implem
ii libtext-csv-perl 1.06-1 comma-separated values manipulator
ii libtext-diff-perl 0.35-3 Perform diffs on files and record
ii libxml-feedpp-perl 0.34-1 Parse/write/merge/edit RSS/RDF/Ato
ii libxml-parser-perl 2.36-1.1+b1 Perl module for parsing XML files
ii perl 5.10.0-19lenny2 Larry Wall's Practical Extraction
ii ucf 3.0016 Update Configuration File: preserv
Versions of packages otrs2 recommends:
ii ispell 3.1.20.0-4.4 International Ispell (an interacti
ii libdbd-mysql-perl 4.007-1+lenny1 A Perl5 database interface to the
ii libgd-graph-perl 1.44-3 Graph Plotting Module for Perl 5
ii libgd-text-perl 0.86-5 Text utilities for use with GD
ii mysql-server 5.1.47-1~bpo50+1 MySQL database server (metapackage
ii mysql-server-5.1 [mysql 5.1.47-1~bpo50+1 MySQL database server binaries and
ii procmail 3.22-16 Versatile e-mail processor
Versions of packages otrs2 suggests:
ii libnet-ldap-perl 1:0.36-1 A Client interface to LDAP servers
pn otrs2-doc-en | otrs2-doc-de <none> (no description available)
-- debconf information:
otrs2/pgsql/app-pass: (password omitted)
otrs2/mysql/app-pass: (password omitted)
otrs2/app-password-confirm: (password omitted)
otrs2/password-confirm: (password omitted)
otrs2/mysql/admin-pass: (password omitted)
otrs2/pgsql/admin-pass: (password omitted)
otrs2/install-error: abort
otrs2/remove-error: abort
otrs2/pgsql/authmethod-admin: ident
otrs2/pgsql/method: unix socket
otrs2/db/app-user: otrs
otrs2/resetdbuser: true
otrs2/pgsql/changeconf: false
otrs2/pgsql/authmethod-user: ident
otrs2/internal/skip-preseed: false
otrs2/remote/port:
otrs2/upgrade-backup: true
otrs2/db/dbname: otrs2
otrs2/pgsql/admin-user: postgres
otrs2/dbconfig-reinstall: false
otrs2/db/basepath:
* otrs2/dbconfig-install: true
otrs2/pgsql/manualconf:
otrs2/mysql/method: unix socket
otrs2/dbconfig-remove:
otrs2/upgrade-error: abort
otrs2/remote/newhost:
otrs2/internal/reconfiguring: false
otrs2/purge: false
* otrs2/database-type: mysql
otrs2/pgsql/no-empty-passwords:
otrs2/dbconfig-upgrade: true
otrs2/passwords-do-not-match:
otrs2/remote/host:
otrs2/missing-db-package-error: abort
otrs2/mysql/admin-user: root
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
