The mailing list for listmasters using Sympa

[Olivier Salaun - CRU <address@concealed>]

Hi Rene,

I looks like the tables() function run by Sympa does not list all 
tables. I you feel confortable with Perl you can try adding some traces 
in List::probe_db() to list the tables returned by tables() subroutine.

Did you upgrade your MySQL or DBI/DBD perl modules.

You can try reinstalling Sympa 3.3.3 for a try...

FYI here is our config :
   mysql-server    3.23.56
   DBI                 1.21
   DBD-mysql    2.0419

Rene Pfeiffer wrote:

> One of our SYMPA servers keeps missing its subscriber and user table. It
> ran version 3.3.3 and was upgraded to 3.4.4.1. A dump with the debug
> option shows the following output:
>
> root@sympa:~ $ /home/sympa/bin/sympa.pl -d
> Configuration file read, log level set using options : 2
> DBD::mysql::db do failed: Table 'user_table' already exists at 
> /home/sympa/bin/List.pm line 6507.
> Could not create table user_table in database sympa : Table 'user_table' 
> already exists
> DBD::mysql::db do failed: Table 'subscriber_table' already exists at 
> /home/sympa/bin/List.pm line 6507.
> Could not create table subscriber_table in database sympa : Table 
> 'subscriber_table' already exists
> Table user_table not found in database sympa
> 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
> root@sympa:~ $ 
>
> I checked the database connectivity, the login with the SYMPA user works
> and I can see all tables with the mysql client. I also checked the table
> structure before and after the upgrade and found no problems. Is there a
> better way to trace this problem? Is there a link to the new mySQL DBI
> module in CPAN? Does anyone use DBD-mysql-2.9002 together with SYMPA?
>
> Any insights welcome.
>  
--
Olivier Salaun
Comite Reseau des Universites