The mailing list for listmasters using Sympa

[Olivier Salaün <address@concealed>]

Hi Bill,

At startup sympa.pl process checks the database structure and tries to 
upgrade it if needed. In older versions of Sympa, like yours, all sympa 
processes perform these checks.

It seems that your sympa processes try to create the DB tables and fail 
because the tables already exist. I suspect that this failure happens 
because sympa does not know the tables exist when running the 
$dbh->tables() function ; probably a permission problem.

I'd suggest that you remove all the tables in your sympa DB, since sympa 
is able to create them automatically, see 
http://www.sympa.org/manual/database#creating_a_sympa_database

Bill Best a écrit :
> I am running the following set-up:
>
> Fedora Core 9
> mysql  Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (i386)
>
> And I've tried to install sympa following the instructions at
> http://www.sympa.org/manual/installing-sympa and creating the
> databases using the MySQL script here
> http://www.sympa.org/manual/database#creating_a_sympa_database
>
> This is the description of the relevant table:
>
> mysql> describe admin_table;
> [...]
>
> However I am getting these errors on trying to start sympa:
>
> [root@machine ~]# /etc/init.d/sympa restart
> Restarting Sympa subsystem:
> Stopping Sympa subsystem:
> Module bounced.pl not running
> Module archived.pl not running
> Module sympa.pl not running
> Module sympa-distribute.pl not running
> Module task_manager.pl not running
> Starting Sympa subsystem:
> Starting module sympa.pl: DBD::mysql::db do failed: Table
> 'admin_table' already exists at /usr/lib/sympa/bin/List.pm line 9107.
> DBD::mysql::db do failed: Table 'user_table' already exists at
> /usr/lib/sympa/bin/List.pm line 9107.
> DBD::mysql::db do failed: Table 'subscriber_table' already exists at
> /usr/lib/sympa/bin/List.pm line 9107.
> DBD::mysql::st execute failed: 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 at
> /usr/lib/sympa/bin/List.pm line 9128.
> 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
>  [...]
>
> I've Googled around - can anybody help with this at all?
>
> Many thanks in advance.
>