The mailing list for listmasters using Sympa

[Jean-Marc Liotier <address@concealed>]

Copy of
http://serendipity.ruwenzori.net/index.php/2007/04/25/solved-mysql-database-interface-problem-with-sympa-debian-upgrade-to-532

I upgraded the Sympa mailing list manager to 5.2.3-2 using the Debian
package from the "Testing" repository. The database part of the upgrade
procedure was a bit fussy so instead of solving its problems I simply
backed up the tables, dropped them, ran the upgrade procedure and
restored them. That workaround worked fine for making the Debian
packaging system happy.

But Sympa itself was definitely not happy. On starting Sympa I got the
following logs in /var/log/sympa.log :

Apr 25 17:02:39 kivu sympa[657]: Could not create table admin_table in
database sympa : Table 'admin_table' already exists
Apr 25 17:02:39 kivu sympa[657]: Could not create table user_table in
database sympa : Table 'user_table' already exists
Apr 25 17:02:39 kivu sympa[657]: Could not create table subscriber_table
in database sympa : Table 'subscriber_table' already exists
Apr 25 17:02:39 kivu sympa[657]: Could not create table netidmap_table
in database sympa : Table 'netidmap_table' already exists
Apr 25 17:02:39 kivu sympa[657]: Unable to execute SQL query : You have
an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '.`admin_table' at
line 1
Apr 25 17:02:39 kivu sympa[657]: Database sympa defined in sympa.conf
has not the right structure or is unreachable. If you don't use any
database, comment db_xxx parameters in sympa.conf
Apr 25 17:02:39 kivu sympa[657]: Exiting.
Apr 25 17:02:39 kivu sympa[657]: Sympa not setup to use DBI

With no database access, Sympa was not operational. Double plus ungood !

The very strange thing is that the database is fine : the right tables
with the right fields and the right records are all present. It even
worked with the preceding version of Sympa. It looked like Sympa itself
was unable to recognize that my database setup was correct, subsequently
reported those errors and thereafter refused to run with it at all.

With a little rummaging inside the Sympa-users mailing list I quickly
found a report of something looking suspiciously like my problem. It is
probably a bug and Olivier Berger proposed a patch that looked to me
like a workable solution : according to Olivier, a faulty regex was the
cause of Sympa's failure to recognize it's own.

After making a backup copy of /usr/lib/sympa/bin/List.pm I promptly
applied his patch :

    17:04 root@kivu /usr/lib/sympa/bin# diff List.pm.dist List.pm
    10750a10751
    > $t =~ s/^([^.]+\.)?(.+)$/\2/;
    zsh: exit 1 diff List.pm.dist List.pm

I restarted Sympa and it worked fine ever after. Thank you Olivier !

The only problem is that while Sympa was down, people wondered why the
messages did not go through and resent some of their messages. None of
those messages were lost - they were just piling up in a queue. So when
Sympa restarted many duplicates were sent.

But at least now it's working. So for now I'm going to use dselect to
freeze the Sympa Debian package at its current version so that it is
kept back next time I upgrade my system.