The mailing list for listmasters using Sympa

[Etienne MELEARD <address@concealed>]

Hi,

Did you not forget to also copy the lists/robot config files ?

Regards,

Etienne


Le 02/04/12 20:14, Ruud Baart a écrit :
> Hello,
>
> Any help or hints would be nice.
>
> I have a problem with the upgrade from debian lenny sympa 5.3.4 to 
> squeeze sympa 6.1.4. The old system is running sympa 5.3.4 and the new 
> server is running sympa 6.1.4. Database backend was postgres 8.4, the 
> new server is using postgres 9.1
>
> First I migrated all data and configured the new server. The server is 
> running fine: postfix, amavis, dspam etc. The final step was migrating 
> the listserver. After some experimenting I decided to upgrade the old 
> server from Lenny->Squeeze. I created the missing tables and:
>
>     sympa --upgrade --from=5.3.4 --to=6.1.4
>
>     sympa --md5_encode_password
>
> I made a postgres dump (pg_dump) and copied it to the new server. I 
> created the database and imported the data. Not everything went 
> smoothly but I managed to fill the database and started sympa. I can 
> login in the the web frontend. But all listing are missing and no 
> users are available.
>
>
> I have no idea where to look for errors. Below some information 
> concerning the database.
>
> # grep db sympa.conf
>
> db_type Pg
>
> db_name sympa
>
> db_host localhost
>
> db_port5432
>
> db_user sympa
>
> db_passwd******
>
> # psql --user=sympa --password --host=localhost --port=5432 sympa
>
> Password for user sympa: *****
>
> psql (9.1.3)
>
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
>
> Type "help" for help.
>
> sympa=> \ds+
>
> ...
> public     | admin_table                     | table | sympa    | 16 
> kB      |
>  public     | bulkmailer_table                | table | sympa    | 16 
> kB      |
>  public     | bulkspool_table                 | table | sympa    | 16 
> kB      |
>  public     | conf_table                      | table | sympa    | 0 
> bytes    |
>  public     | exclusion_table                 | table | sympa    | 0 
> bytes    |
>  public     | logs_table                      | table | sympa    | 16 
> kB      |
>  public     | netidmap_table                  | table | sympa    | 0 
> bytes    |
>  public     | one_time_ticket_table           | table | sympa    | 16 
> kB      |
>  public     | session_table                   | table | sympa    | 40 
> kB      |
>  public     | subscriber_table                | table | sympa    | 848 
> kB     |
>  public     | user_table                      | table | sympa    | 552 
> kB     |
>
> Select * from admin_tables and other tables givethe expected results:
>
> sympa=> SELECT * from admin_table ;
>     list_admin     |          user_admin           |     
> robot_admin      | role_admin |       date_admin       |      
> update_admin      | reception_admin | visibility_admin |         
> comment_admin         | subscribed_admin | included_admin | 
> include_sources_admin | info_admin | profile_admin
> -------------------+-------------------------------+----------------------+------------+------------------------+------------------------+-----------------+------------------+-------------------------------+------------------+----------------+-----------------------+------------+---------------
>  2313              | xxxxxxxxxxxx       | listserver.prompt.nl | 
> owner      | 2012-04-02 17:15:46+02 | 2012-04-02 17:15:46+02 | 
> mail            | noconceal        | ******t               
> |                1 |              0 |                       
> |            | privileged
>
> ..
>
> --
>
> Regards,
>
> Ruud Baart