The mailing list for listmasters using Sympa

[Ruud Baart <address@concealed>]

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_port  5432

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