Skip to Content.
Sympa Menu

en - SYMPA can't find subscriber and user table

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Rene Pfeiffer <address@concealed>
  • To: Sympa Users <address@concealed>
  • Subject: SYMPA can't find subscriber and user table
  • Date: Wed, 2 Jul 2003 19:55:48 +0200

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello!

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.

Cheers,
René.

- --
GNU/Linux Manages! - Linux Solution Provider
RP551296-NICAT - Free Software for Open Minds

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)

iD8DBQE/AxyjeMu5lRpXJ7kRAlQeAJ0fgEbQ1UQ2ujcK+71vsQsn486OcACgxend
P1hTuh5kvl1s6k5TYoAi4Uo=
=Wl1Z
-----END PGP SIGNATURE-----



Archive powered by MHonArc 2.6.19+.

Top of Page