The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Hi,

Troy Davis a écrit :
> [*crop*]
>
> # /etc/init.d/sympa start
> Starting Sympa subsystem:
> Starting module sympa.pl: DBD::mysql::db do failed: Can't DROP 
> 'PRIMARY'; check that column/key exists at 
> /usr/local/sympa-stable/bin/Upgrade.pm line 1000.
> DBD::mysql::db do failed: Can't DROP 'list_admin'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'robot_admin'; check that 
> column/key exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'user_admin'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'role_admin'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1000.
> DBD::mysql::db do failed: Can't DROP 'id_logs'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1000.
> DBD::mysql::db do failed: Can't DROP 'email_user'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1000.
> DBD::mysql::db do failed: Can't DROP 'list_subscriber'; check that 
> column/key exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'robot_subscriber'; check that 
> column/key exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'user_subscriber'; check that 
> column/key exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key 
> exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1000.
> DBD::mysql::db do failed: Can't DROP 'netid_netidmap'; check that 
> column/key exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'serviceid_netidmap'; check that 
> column/key exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.
> DBD::mysql::db do failed: Can't DROP 'robot_netidmap'; check that 
> column/key exists at /usr/local/sympa-stable/bin/Upgrade.pm line 1019.

These are warnings due to missing tests in the course of the upgrade 
process. They are completely harmless and will not appear in the next 
release.

>                                                            [  OK  ]
> Starting module archived.pl: Creating missing 
> /usr/local/sympa-stable/arc directory
>                                                            [  OK  ]
> Starting module bounced.pl:                                [  OK  ]
> Starting module task_manager.pl: Missing files. Aborting.
>                                                            [FAILED]
> -------
> [crop again]
> [...]
> So I stop sympa, then try again:
>
> -------
> # /etc/init.d/sympa start
> Starting Sympa subsystem:
> Starting module sympa.pl: DBD::mysql::db do failed: Table 'admin_table' 
> already exists at /usr/local/sympa-stable/bin/Upgrade.pm line 783.
> DBD::mysql::db do failed: Table 'logs_table' already exists at 
> /usr/local/sympa-stable/bin/Upgrade.pm line 783.
> DBD::mysql::db do failed: Table 'user_table' already exists at 
> /usr/local/sympa-stable/bin/Upgrade.pm line 783.
> DBD::mysql::db do failed: Table 'subscriber_table' already exists at 
> /usr/local/sympa-stable/bin/Upgrade.pm line 783.
> DBD::mysql::db do failed: Table 'netidmap_table' already exists at 
> /usr/local/sympa-stable/bin/Upgrade.pm line 783.

Same remark about the warnings.

> 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/local/sympa-stable/bin/Upgrade.pm line 806.
> 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

Other people ran into this problem recently, although for now we can't 
define what caused it.

Anyway, we came up with a patch which seems to be fixing the problem.

You can find it here :

Version 5.3b.4 :
http://sourcesup.cru.fr/viewvc/viewvc/branches/sympa-5.2-branch/src/List.pm?root=sympa&r1=4244&r2=4377

Version 5.2 :
http://sourcesup.cru.fr/viewvc/viewvc/trunk/src/Upgrade.pm?root=sympa&r1=4235&r2=4376

>                                                            [FAILED]
> Starting module archived.pl:                               [  OK  ]
> Starting module bounced.pl:                                [  OK  ]
> Starting module task_manager.pl: Missing files. Aborting.
>                                                            [FAILED]
> -------
About the missing file, now. We need Sympa logs to find exactly what 
file is missing. Could you send me them?

Regards,

--
David Verdin
Comité réseau des universités