The mailing list for listmasters using Sympa

[Jerome Pouilloux <address@concealed>]

Hello,

If you change the name of the robot for testing, one method could be to do update requests :

UPDATE sympa.session_table SET robot_session='lists-tst.university.edu' WHERE  robot_session = 'lists.university.edu'

UPDATE sympa.one_time_ticket_table SET robot_one_time_ticket='lists-tst.university.edu' WHERE  robot_one_time_ticket = 'lists.university.edu'

UPDATE sympa.list_table SET robot_list='lists-tst.university.edu' WHERE  robot_list = 'lists.university.edu'

UPDATE sympa.exclusion_table SET robot_exclusion='lists-tst.university.edu' WHERE  robot_exclusion = 'lists.university.edu'

UPDATE sympa.admin_table SET robot_admin='lists-tst.university.edu' WHERE  robot_admin = 'lists.university.edu'

---

De : address@concealed <address@concealed> de la part de Michael Heller <address@concealed>
Envoyé : jeudi 8 septembre 2022 21:01:37
À : address@concealed
Objet : [en@sympa] migration & upgrade of Sympa -- missing lists in admin interface

 

Hello!  I'm a new Sympa admin and have found the Sympa Community to be invaluable — first-time post.

Our production Sympa v6.1.20 is being upgraded to 6.2.68 on new application and database hosts.  

The database was backed up from the production database server and imported to the new test database server.   The Sympa configuration from production app server was copied to the new Sympa app server prior to running the Sympa upgrade command.

I've spent a lot of time learning about Sympa while configuring sympa.conf and robot.conf, among other items, and have finally gotten the Sympa web interface to load, however I do not see any of the migrated lists.

The new test host is named lists-tst.university.edu and was named lists.university.edu     I created a new list in the new test environment and it was named address@concealed   I could see this in the web interface and also in the database.   That is, in the database I now have lists.university.edu and lists-tst.university.edu   

How do I have a new host lists-tst.university.edu (CName to FQDN) access the lists in database under lists.university.edu (without the -tst)?

Thank you in advance for any guidance for this n00bie!  ~Michael