[Pkg-sympa-devel] Bug#769074: sympa: After wheezy-backports sympa does not work at all

[Ruud Baart]

Package: sympa
Version: 6.1.23~dfsg-1~bpo70+1
Severity: normal
Tags: d-i

Dear Maintainer,

My sympa installation is with a postgres database on an other server. After this (and previous) upgrades
of sympa nothing worked. The postgres database is not updated, webinterface did not work, configuration
files were incorrectly adjusted, files ownership incorrect. 

I do not know the reasons but I assume the post install or upgrade script made a mess.

I can't exactly remember the previous important backports upgrade but in that case:
- the configuration files were incorrectly updated. I remember that the database
  configuration entries in sympa.conf were overwritten. 
- It was impossible to install  without mysql (I use postgres)
With a lot of patience I managed to get sympa running again. 

Last upgrade to 6.1.23:
- Postgres database was not updated. I had to to this by hand: compare the source of 
  6.1.23 with the existing postgres database and alter the tables by hand. Time 
  consuming and I'm not sure everything is now correct.
- for unknown reason my webinterface did not work. A new configuration solved this 
  problem
- I presume files in /usr/lib/sympa/lib/sympa have an incorrect permission and ownership.
  After 
    chown sympa /usr/lib/sympa/lib/sympa/*
    chmod u+s /usr/lib/sympa/lib/sympa/*
  it works again
- Probably some other issues. If things are working again I tend to forget pretty quickly
  all the actions.

I understand that thing can go wrong, but the sympa upgrades are complicated. I think the 
main reasons are: I use postgres as database and the database server is not localhost.

For the moment sympa is running again but I still get apt errors:

  Setting up sympa (6.1.23~dfsg-1~bpo70+1) ...
  dpkg: error processing sympa (--configure):
   subprocess installed post-installation script returned error exit status 10
  Errors were encountered while processing:
   sympa
  E: Sub-process /usr/bin/dpkg returned an error code (1)

 

-- System Information:
Debian Release: 7.7
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 3.16-0.bpo.3-686-pae (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash

Versions of packages sympa depends on:
ii  adduser                           3.113+nmu3
ii  ca-certificates                   20130119+deb7u1
ii  dbconfig-common                   1.8.47+nmu1
ii  debconf [debconf-2.0]             1.5.49
ii  libarchive-zip-perl               1.30-6
ii  libc6                             2.13-38+deb7u6
ii  libcgi-fast-perl                  5.14.2-21+deb7u2
ii  libdbd-mysql-perl                 4.021-1+b1
ii  libdbd-pg-perl                    2.19.2-2
ii  libdbd-sqlite3-perl               1.37-1
ii  libdbd-sybase-perl                1.14-1
ii  libdbi-perl                       1.622-1+deb7u1
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.12-1~bpo70+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.505-1~bpo70+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  libsoap-lite-perl                 0.714-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+Debian8+deb7u1
ii  mhonarc                           2.6.18-2
ii  perl                              5.14.2-21+deb7u2
ii  perl-modules [libcgi-pm-perl]     5.14.2-21+deb7u2
ii  postfix [mail-transport-agent]    2.11.2-1~bpo70+1
ii  rsyslog [system-log-daemon]       7.6.3-2~bpo70+1
ii  sqlite3                           3.7.13-1+deb7u1

Versions of packages sympa recommends:
ii  apache2-suexec             2.2.22-13+deb7u3
ii  doc-base                   0.10.4
ii  libapache2-mod-fcgid       1:2.3.6-1.2+deb7u1
ii  libcrypt-ciphersaber-perl  0.61-4
ii  libfile-nfslock-perl       1.21-1
ii  libio-socket-ssl-perl      1.76-2
ii  libmail-dkim-perl          0.39-1
ii  locales                    2.13-38+deb7u6
ii  logrotate                  3.8.1-4
pn  mysql-server | postgresql  <none>

Versions of packages sympa suggests:
ii  apache2                          2.2.22-13+deb7u3
ii  apache2-mpm-prefork [httpd-cgi]  2.2.22-13+deb7u3
pn  libauthcas-perl                  <none>
pn  libdbd-oracle-perl               <none>
pn  libtext-wrap-perl                <none>
ii  openssl                          1.0.1e-2+deb7u13

-- Configuration Files:
/etc/sympa/facility changed [not included]
/etc/sympa/sympa.conf-smime.in [Errno 13] Permission denied: u'/etc/sympa/sympa.conf-smime.in'

-- debconf information excluded