Bug#548076: otrs2: can't configure database with dbconfig-common when using non-standard MySQL port
Package: otrs2
Version: 2.2.7-2lenny1
Severity: normal
dbconfig-common should ask for hostname and port (not only username and
password) of MySQL database, where otrs2 will be installed. For this
reason installation fails.
Installation process ask the following question:
An error occurred while installing the database:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
and I answer "ignore", but installation process fails.
Here is log from installation process:
$ apt-get install otrs2
...
dbconfig-common: otrs2 configure: ignoring errors from here forwards
populating database via sql... done.
dbconfig-common: flushing administrative password
Creating config file /etc/otrs/Kernel/Config.pm with new version
Creating config file /etc/otrs/Kernel/Config/GenericAgent.pm with new version
Creating config file /etc/otrs/maintainance.html with new version
Creating config file /etc/otrs/cron with new version
Creating config file /etc/otrs/fetchmailrc with new version
Creating config file /etc/apache2/conf.d/otrs2 with new version
Module perl already enabled
Enabling module rewrite.
Run '/etc/init.d/apache2 restart' to activate new configuration!
Reloading web server config: apache2.
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAAuto.pm
ERROR: No such file or directory: /usr/share/otrs/Kernel/Config/Files/ZZZAuto.pm
DBI connect('database=otrs2;host=localhost;port=3306;','otrs',...) failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) at /usr/share/otrs/Kernel/System/DB.pm line 216
ERROR: OTRS-otrs.RebuildConfig.pl-10 Perl: 5.10.0 OS: linux Time: Wed Sep 23 17:15:08 2009
Message: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
Traceback (21097):
Module: Kernel::System::DB::new (v1.95) Line: 190
Module: /usr/share/otrs/bin/otrs.RebuildConfig.pl (v1.8) Line: 53
Got no DBObject! at /usr/share/otrs/Kernel/System/Config.pm line 84.
dpkg: error processing otrs2 (--configure):
subprocess installed post-installation script returned error exit status 255
Setting up libbsd-resource-perl (1.2903-1) ...
Setting up libgd-text-perl (0.86-5) ...
Setting up libgd-graph-perl (1.44-3) ...
Errors were encountered while processing:
otrs2
E: Sub-process /usr/bin/dpkg returned an error code (1)
-- System Information:
Debian Release: 5.0.3
APT prefers stable
APT policy: (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.24-1-amd64 (SMP w/8 CPU cores)
Locale: LANG=C, LC_CTYPE=sk_SK.UTF-8 (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 2.2.9-10+lenny2 Apache HTTP Server metapackage
ii apache2-mpm-prefork [htt 2.2.9-10+lenny2 Apache HTTP Server - traditional n
ii dbconfig-common 1.8.39 common framework for packaging dat
ii debconf 1.5.24 Debian configuration management sy
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 libmailtools-perl 2.03-1 Manipulate email in perl programs
ii libmime-perl 5.427-1 transitional dummy package
ii libmime-tools-perl [libm 5.427-1 Perl5 modules for MIME-compliant m
ii libtext-diff-perl 0.35-3 Perform diffs on files and record
ii libxml-parser-perl 2.36-1.1+b1 Perl module for parsing XML files
ii lighttpd [httpd-cgi] 1.4.19-5 A fast webserver with minimal memo
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 aspell 0.60.6-1 GNU Aspell spell-checker
ii ispell 3.1.20.0-4.4 International Ispell (an interacti
ii libapache2-mod-perl2 2.0.4-5 Integration of perl with the Apach
ii libdbd-mysql-perl 4.007-1 A Perl5 database interface to the
ii libdbd-pg-perl 2.8.7-1 Perl DBI driver for the PostgreSQL
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.0.51a-24+lenny2 MySQL database server (metapackage
ii mysql-server-5.0 [mysq 5.0.51a-24+lenny2 MySQL database server binaries
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/remove-error: abort
otrs2/pgsql/method: unix socket
otrs2/pgsql/authmethod-admin: ident
otrs2/pgsql/changeconf: false
otrs2/pgsql/authmethod-user: ident
otrs2/internal/skip-preseed: false
* otrs2/db/dbname: <protected_for_security_reason>
otrs2/upgrade-error: abort
* otrs2/remote/newhost: 127.0.0.1
otrs2/internal/reconfiguring: false
otrs2/purge: false
otrs2/database-type: mysql
* otrs2/remote/host: 127.0.0.1
otrs2/missing-db-package-error: abort
* otrs2/mysql/admin-user: root
otrs2/install-error: retry
* otrs2/db/app-user: <protected_for_security_reason>
* otrs2/resetdbuser: false
* otrs2/remote/port: 3307
otrs2/upgrade-backup: true
otrs2/pgsql/admin-user: postgres
otrs2/dbconfig-reinstall: false
otrs2/db/basepath:
* otrs2/dbconfig-install: true
otrs2/pgsql/manualconf:
* otrs2/mysql/method: tcp/ip
otrs2/dbconfig-remove:
otrs2/pgsql/no-empty-passwords:
otrs2/dbconfig-upgrade: true
otrs2/passwords-do-not-match:
Reply to: