The mailing list for listmasters using Sympa

[Fil <address@concealed>]

My main problem now is that wwwsympa fails
[Tue Feb 11 22:43:45 2003] [warn] FastCGI: server 
"/home/sympa/bin/wwsympa.fcgi" restarted (pid 20326) Can't do setuid
[Tue Feb 11 22:43:45 2003] [warn] FastCGI: server 
"/home/sympa/bin/wwsympa.fcgi" (pid 20326) terminated by calling exit with 
status '2'

What is this "can't do setuid" ?

> The first command fails :
> ERROR 1064: You have an error in your SQL syntax near 'with time zone NOT 
> NULL' at line 1
> What should I do?

I've had many other errors while upgrading, but I think I should have read
the list in reverse order, from bottom to top...

Here are the changes I have made with successes and failures :

*****   ALTER TABLE subscriber_table CHANGE date_subscriber timestamp with
time zone NOT NULL; 

bug

*****   ALTER TABLE subscriber_table CHANGE update_subscriber timestamp with
time zone;

bug

*****           ALTER TABLE subscriber_table ADD subscribed_subscriber enum
('0','1');

ERROR 1060: Duplicate column name 'subscribed_subscriber'

*****           ALTER TABLE subscriber_table ADD included_subscriber enum
('0','1');

OK

*****           ALTER TABLE subscriber_table ADD include_sources_subscriber
varchar(50);

OK

*****   ALTER TABLE subscriber_table ADD INDEX
(user_subscriber,list_subscriber);

OK

 ./sympa.pl --lowercase
load: Unable to open /home/sympa/bin/etc/auth.conf: 

Unknown parameter lang in /etc/wwsympa.conf
Configuration file read, default log level  0
Field 'bounce_subscriber'  (table 'subscriber_table' ; database 'sympadb')
does NOT have awaited type (varchar(35)). Attempting to change it...
Database structure updated
Loading locale file fr.cat version 3.3a
Loading locale file us.cat version 3.3a
Loading locale file es.cat version 3.3.3
Loading locale file de.cat version 3.3a
Loading locale file it.cat version 2.5.4
Loading locale file cn.cat version 2.8.1
Loading locale file tw.cat version 2.5
Loading locale file fi.cat version 3.3a
Loading locale file pl.cat version 2.8.1
Loading locale file cz.cat version 3.1b.12
Loading locale file hu.cat version 3.3a
Loading locale file ro.cat version 3.3a
Loading locale file et.cat version 3.3a
Loading locale file nl.cat version 3.3a
Sympa 3.4.3.1 started
Sympa 3.4.3.1 started
Working on user_table...
Working on subscriber_table...
Total lowercased rows: 8


*****    ALTER TABLE user_table CHANGE password_user password_user varchar
(40);

OK
*****   ALTER TABLE subscriber_table ADD comment_subscriber varchar (150);

ERROR 1060: Duplicate column name 'comment_subscriber'

****    Daemons(sympa.pl, archived.pl, bounced.pl) now set their UID 
themselves.
****    You can thereby run them with root privileges (a script is provided
****    in script/ directory for starting/stoping Sympa)
*****   Requires MIME::Parser >= 5.209
*****   for wwsympa is now the same as sympa (you may update your
*****   httpd.conf)

pas compris

****** ALTER TABLE subscriber_table ADD bounce_subscriber varchar (30);

ERROR 1060: Duplicate column name 'bounce_subscriber'

****** ALTER TABLE subscriber_table ADD update_subscriber datetime;

ERROR 1060: Duplicate column name 'update_subscriber'

****** ALTER TABLE user_table CHANGE lang_user lang_user varchar (10);

OK

******    ALTER TABLE user RENAME user_table;
******    ALTER TABLE subscriber RENAME subscriber_table;
****** ALTER TABLE user ADD cookie_delay_user  int,
******                  ADD lang_user     char (5);

pas la peine...


-- Fil