The mailing list for listmasters using Sympa

["Bill Best" <address@concealed>]

Hi

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;
+-----------------------+-------------------------------------+------+-----+---------+-------+
| Field                 | Type                                | Null |
Key | Default | Extra |
+-----------------------+-------------------------------------+------+-----+---------+-------+
| comment_admin         | varchar(150)                        | YES  |
    | NULL    |       |
| date_admin            | datetime                            | NO   |
    |         |       |
| include_sources_admin | varchar(50)                         | YES  |
    | NULL    |       |
| included_admin        | enum('0','1')                       | YES  |
    | NULL    |       |
| info_admin            | varchar(150)                        | YES  |
    | NULL    |       |
| list_admin            | varchar(50)                         | NO   |
PRI |         |       |
| profile_admin         | enum('privileged','normal')         | YES  |
    | NULL    |       |
| reception_admin       | varchar(20)                         | YES  |
    | NULL    |       |
| role_admin            | enum('listmaster','owner','editor') | NO   |
PRI |         |       |
| subscribed_admin      | enum('0','1')                       | YES  |
    | NULL    |       |
| update_admin          | datetime                            | YES  |
    | NULL    |       |
| user_admin            | varchar(100)                        | NO   |
PRI |         |       |
+-----------------------+-------------------------------------+------+-----+---------+-------+
12 rows in set (0.00 sec)

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
                                                           [FAILED]
Starting module archived.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
                                                           [FAILED]
Starting module bounced.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.
Sympa not setup to use DBI, unable to manage bounces
                                                           [FAILED]
Starting module task_manager.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
                                                           [FAILED]

I've Googled around - can anybody help with this at all?

Many thanks in advance.

Bill