[Pkg-sympa-devel] Bug#686845: sympa: install fails when using sympa with sqlite3

Andi Fink andis at global2000.at
Thu Sep 13 10:23:47 UTC 2012


Package: sympa
Version: 6.1.11~dfsg-4
Followup-For: Bug #686845

Dear Maintainer,

On a clean minimal Debian Wheezy install,
when I install sympa with `apt-get install sympa`
and select configure database with dbconfig
and choose sqlite3
then the install fails with:

-----8<------
Setting up sympa (6.1.11~dfsg-4) ...
Adding system user: sympa.
[ ok ] Stoping Sympa mailing list manager: sympa is 
already stopped.
/etc/sympa/sympa.conf file has been created
/etc/sympa/wwsympa.conf file has been created
dbconfig-common: writing config to 
/etc/dbconfig-common/sympa.conf

Creating config file /etc/dbconfig-common/sympa.conf 
with new version
creating database sympa: success.
verifying database sympa exists: success.
populating database via sql...  done.
Not configuring Web server.
info Configuration file read, default log level 0
info Upgrade::probe_db() Field 'robot_exclusion' (table 
'exclusion_table' ; database 
'/var/lib/dbconfig-common/sqlite3/sympa/sympa') was NOT 
found. Attempting to add it...
DBD::SQLite::db do failed: Cannot add a NOT NULL column 
with default value NULL at 
/usr/share/sympa/lib/Upgrade.pm line 1271.
err Upgrade::probe_db() Could not add field 
'robot_exclusion' to table'exclusion_table'.
err Upgrade::probe_db() Sympa's database structure may 
have change since last update ; please check RELEASE_NOTES
Database /var/lib/dbconfig-common/sqlite3/sympa/sympa 
defined in sympa.conf has not the right structure or is 
unreachable. verify db_xxx parameters in sympa.conf
dpkg: error processing sympa (--configure):
  subprocess installed post-installation script 
returned error exit status 1
----->8------

-- System Information:
Debian Release: wheezy/sid
   APT prefers testing
   APT policy: (500, 'testing')
Architecture: amd64 (x86_64)

Kernel: Linux 3.2.0-3-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 
(charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages sympa depends on:
ii  adduser                                    3.113+nmu3
ii  ca-certificates                            20120623
ii  dbconfig-common                            1.8.47+nmu1
ii  debconf [debconf-2.0]                      1.5.46
ii  dpkg                                       1.16.8
ii  exim4-daemon-light [mail-transport-agent]  4.80-4
ii  libarchive-zip-perl                        1.30-6
ii  libc6                                      2.13-35
ii  libcgi-fast-perl                           5.14.2-12
ii  libdbd-mysql-perl                          4.021-1+b1
ii  libdbd-pg-perl                             2.19.2-1
ii  libdbd-sqlite3-perl                        1.37-1
ii  libdbd-sybase-perl                         1.14-1
ii  libdbi-perl                                1.622-1
ii  libfcgi-perl                               0.74-1+b1
ii  libfile-copy-recursive-perl                0.38-1
ii  libhtml-format-perl                        2.10-1
ii  libhtml-stripscripts-parser-perl           1.03-1
ii  libhtml-tree-perl                          5.02-1
ii  libintl-perl                               1.20-1
ii  libio-stringy-perl                         2.110-5
ii  libmailtools-perl                          2.09-1
ii  libmime-charset-perl                       1.009.2-1
ii  libmime-encwords-perl                      1.012.4-1
ii  libmime-lite-html-perl                     1.23-1.1
ii  libmime-tools-perl                         5.503-1
ii  libmsgcat-perl                             1.03-5+b2
ii  libnet-ldap-perl                           1:0.4400-1
ii  libnet-netmask-perl                        1.9016-1
ii  libregexp-common-perl                      2011121001-1
ii  libtemplate-perl                           2.24-1
ii  libterm-progressbar-perl                   2.13-1
ii  libunicode-linebreak-perl                  
0.0.20120401-1
ii  libxml-libxml-perl                         
2.0001+dfsg-1
ii  lsb-base                                   4.1+Debian7
ii  mhonarc                                    2.6.18-2
ii  perl                                       5.14.2-12
ii  perl-modules [libcgi-pm-perl]              5.14.2-12
ii  rsyslog [system-log-daemon]                5.8.11-1+b1
ii  sqlite3                                    3.7.13-1

Versions of packages sympa recommends:
ii  apache2-suexec             2.2.22-11
ii  doc-base                   0.10.4
ii  libapache2-mod-fcgid       1:2.3.6-1.1
ii  libcrypt-ciphersaber-perl  0.61-4
ii  libfile-nfslock-perl       1.21-1
ii  libio-socket-ssl-perl      1.76-1
ii  libmail-dkim-perl          0.39-1
ii  libsoap-lite-perl          0.714-1
ii  locales                    2.13-35
ii  logrotate                  3.8.1-4
ii  mysql-server               5.5.24+dfsg-7

Versions of packages sympa suggests:
pn  apache2 | httpd-cgi  <none>
pn  libauthcas-perl      <none>
pn  libdbd-oracle-perl   <none>
pn  libtext-wrap-perl    <none>
ii  openssl              1.0.1c-4

-- debconf information:
   sympa/app-password-confirm: (password omitted)
   sympa/password-confirm: (password omitted)
   sympa/pgsql/app-pass: (password omitted)
   sympa/mysql/admin-pass: (password omitted)
   sympa/pgsql/admin-pass: (password omitted)
   sympa/mysql/app-pass: (password omitted)
* sympa/dbconfig-install: true
   sympa/remote/newhost:
   sympa/remove-error: abort
* wwsympa/webserver_type: Apache 2
   sympa/listmaster: listmaster at testmailserver.domain
   wwsympa/wwsympa_url: http://testmailserver.domain/wws
* wwsympa/webserver_restart: false
   sympa/pgsql/manualconf:
   sympa/remote/port:
   sympa/mysql/admin-user: root
   sympa/dbconfig-remove:
   sympa/upgrade-backup: true
   sympa/mysql/method: unix socket
   sympa/hostname: testmailserver.domain
   sympa/pgsql/changeconf: false
   sympa/pgsql/authmethod-user: password
   sympa/dbconfig-reinstall: false
   sympa/pgsql/admin-user: postgres
   sympa/upgrade-error: abort
   sympa/language: en_US
   sympa/pgsql/method: unix socket
   sympa/dbconfig-upgrade: true
   sympa/use_soap: false
* sympa/install-error: ignore
   sympa/db/dbname: sympa
   sympa/internal/skip-preseed: false
* sympa/database-type: sqlite3
   sympa/pgsql/no-empty-passwords:
   sympa/pgsql/authmethod-admin: ident
   wwsympa/remove_spool: false
   sympa/db/basepath: 
/var/lib/dbconfig-common/sqlite3/sympa
   sympa/remote/host:
   sympa/passwords-do-not-match:
   wwsympa/fastcgi: false
   sympa/internal/reconfiguring: false
   sympa/db/app-user:
   sympa/purge: false
   sympa/missing-db-package-error: abort
   sympa/remove_spool: false



More information about the Pkg-sympa-devel mailing list