Developers of Sympa

[Straub Herbert <address@concealed>]

Title: AW: [sympa-dev] comment_subscriber database structure

I found the description in the CVS

*****   src/tools.pl: Add reversible encryption for password (rc4)
*****   &crypt_passwd ; &decrypt_passwd ; &ciphersaber_installed
*****   You need to change your database structure :
*****   ALTER TABLE user_table CHANGE password_user password_user varchar (40);
*****
*****   crypt_passwd.pl: Script for password encryption in database
Specific feature for postgresql:

ALTER TABLE user_table CHANGE password_user password_user varchar (40);

is in postgresql:

1. select * from user_table in user_table_save;
2. drop table user_table;
3. CREATE TABLE user_table (
        email_user                  varchar (100) NOT NULL,
        gecos_user                  varchar (150),
        cookie_delay_user       int4,
        password_user           varchar (40),
        lang_user               varchar (10),
        CONSTRAINT ind_user PRIMARY KEY (email_user)
);
4. insert into user_table select * from user_table_save
5. grant all on user_table to public;
   grant all on user_table to sympa;

edit and perl crypt_passwd.pl

*****   New field in table subscriber_table : comment_subscriber
*****   You **MUST** change your database sctructure:
*****   ALTER TABLE subscriber_table ADD comment_subscriber varchar (150);
*****
*****   src/etc/script/init_comment.pl: Script to initialize newly
*****   introduced comment_subscriber data row

no problems with postgresql.

Herbert Straub

-----Ursprüngliche Nachricht-----
Von: Olivier Salaun [mailto:address@concealed]
Gesendet: Mittwoch, 23. Mai 2001 12:03
An: Straub Herbert
Cc: address@concealed
Betreff: Re: [sympa-dev] comment_subscriber database structure

> Straub Herbert wrote:
> [...]
> With postgresql i get in sympa.log the error:
>
> May 23 09:50:48 koala postgres[10359]: [3] ERROR:  Attribute 'comment_subscriber' not found
> May 23 09:50:48 koala sympa[10353]: Unable to execute SQL statement "SELECT user_subscriber
> AS email, comment_subscriber AS gecos, reception_subscriber AS reception, visibility_subscriber
> AS visibility, bounce_subscriber AS bounce, date_part('epoch',date_subscriber) AS date FROM
> subscriber_table WHERE (list_subscriber = 'alpha-l' ) ORDER BY email"
> : ERROR:
>
> In which way i can do the upgrade with postgresql?

As told in the RELEASE_NOTES :
*****   New field in table subscriber_table : comment_subscriber
*****   You **MUST** change your database sctructure:
*****   ALTER TABLE subscriber_table ADD comment_subscriber varchar (150);

I don't know if this query works with Pg.
Please tell us, or provide corrections.

Regards

--
Olivier Salaün
Comité Réseau des Universités