The mailing list for listmasters using Sympa

[Ruud Baart <address@concealed>]

Found it: I should have moved the list definitions to /var/lib/sympa/ on my debian squeeze server. As far as I can see I have all information available.

Op 2-4-2012 22:17, Christian Dahlhausen schreef: You have to copy the directories from your old Sympa installation (below the /home/sympa/expl directory) the new Sympa 6 (into /home/sympa/list_data directory)

On Mon, Apr 2, 2012 at 4:14 PM, Ruud Baart <address@concealed> wrote:

Thanks, I think that is the answer: if I run the script no lists are mentioned. But where are the configuration folders?

Op 2-4-2012 21:36, Christian Dahlhausen schreef:

Did you copy the list configuration folders as well? Make sure that they have the right permission, maybe run a sympa.pl --reload_list_config

On Mon, Apr 2, 2012 at 2:14 PM, Ruud Baart <address@concealed> wrote:

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

--
-----------------------------------------------------------
Christian Dahlhausen, Infrastructure Applications Engineer
University of Virginia - ITS Infrastructure Applications
PO Box 400324, 2015 Ivy Road, Charlottesville, VA 22904

*** Please note that our group name and address has changed to: address@concealed - Please use this contact address for infrastructure applications such as Network Registration (netreg), Address Management System (AMS), messaging, MyGroups (LDAP)***

-- 

Met vriendelijke groet/Regards,
R.J. Baart Automatisering B.V.

Ruud Baart

Tel: +31 6 51318104

--
-----------------------------------------------------------
Christian Dahlhausen, Infrastructure Applications Engineer
University of Virginia - ITS Infrastructure Applications
PO Box 400324, 2015 Ivy Road, Charlottesville, VA 22904

*** Please note that our group name and address has changed to: address@concealed - Please use this contact address for infrastructure applications such as Network Registration (netreg), Address Management System (AMS), messaging, MyGroups (LDAP)***

-- 

Met vriendelijke groet/Regards,
R.J. Baart Automatisering B.V.

Ruud Baart

Tel: +31 6 51318104