Page MenuHomeDevCentral

Deploy Sympa to serve lists.nasqueron.org
Open, NormalPublic

Description

We want to get mailing lists through Sympa.

This will allow to:

  • evaluate sympa, as required in T228
  • host our own mailing lists pending Murasil project deployed in production

Initial plan was to deploy a standalone mail server. Meanwhile, we decided to deploy a Postfix server to host mailboxes. We so move to integrate Sympa to this mail server.

Revisions and Commits

D849

Event Timeline

dereckson claimed this task.
dereckson raised the priority of this task from to Normal.
dereckson updated the task description. (Show Details)
dereckson added a subscriber: dereckson.
dereckson renamed this task from Deploy a Sympa Docker container on Dwellers to serve lists.nasqueron.org to Deploy Sympa to serve lists.nasqueron.org.Jan 18 2017, 08:27
dereckson updated the task description. (Show Details)

Plan

  1. Install sympa on the mailserver lxc container
  2. Define two virtual maps in Postfix with virtual_alias_maps, one for our users domains (managed by vma.nasqueron.org), one for our mailing lists domains (managed by Sympa)
  3. Follow https://tribut.de/blog/sympa-and-postfix/ per T232#6384
  4. Configure a test@lists.nasqueron.org list
  5. Configure a second test@lists.ook.space list to determine multidomain works

Sympa software in installed in /var/lib/sympa.

Steps 2 and 3 have been done this Thursday.

I started the server, it then populate database and reported sending a mail to listmaster with this content:

1The database structure has been updated, Check the log file for further
2details:
3
4Table conf_table created in database sympa
5Table netidmap_table created in database sympa
6Table session_table created in database sympa
7Table inclusion_table created in database sympa
8Table logs_table created in database sympa
9Table exclusion_table created in database sympa
10Table list_table created in database sympa
11Table stat_counter_table created in database sympa
12Table admin_table created in database sympa
13Table user_table created in database sympa
14Table subscriber_table created in database sympa
15Table one_time_ticket_table created in database sympa
16Table stat_table created in database sympa
17Table notification_table created in database sympa
18Field 'label_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
19Field label_conf added to table conf_table (options : )
20Field 'robot_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
21Field robot_conf added to table conf_table (options : )
22Field 'value_conf' (table 'conf_table' ; database 'sympa') was NOT found. Attempting to add it...
23Field value_conf added to table conf_table (options : )
24Table conf_table, PRIMARY KEY set on label_conf,robot_conf
25Field 'email_netidmap' (table 'netidmap_table' ; database 'sympa') was NOT found. Attempting to add it...
26Field email_netidmap added to table netidmap_table (options : )
27Field 'netid_netidmap' (table 'netidmap_table' ; database 'sympa') was NOT found. Attempting to add it...
28Field netid_netidmap added to table netidmap_table (options : )
29Field 'robot_netidmap' (table 'netidmap_table' ; database 'sympa') was NOT found. Attempting to add it...
30Field robot_netidmap added to table netidmap_table (options : )
31Field 'serviceid_netidmap' (table 'netidmap_table' ; database 'sympa') was NOT found. Attempting to add it...
32Field serviceid_netidmap added to table netidmap_table (options : )
33Table netidmap_table, PRIMARY KEY set on netid_netidmap,robot_netidmap,serviceid_netidmap
34Field 'data_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
35Field data_session added to table session_table (options : )
36Field 'date_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
37Field date_session added to table session_table (options : )
38Field 'email_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
39Field email_session added to table session_table (options : )
40Field 'hit_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
41Field hit_session added to table session_table (options : )
42Field 'id_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
43Field id_session added to table session_table (options : PRIMARY KEY )
44Field 'prev_id_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
45Field prev_id_session added to table session_table (options : )
46Field 'refresh_date_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
47Field refresh_date_session added to table session_table (options : )
48Field 'remote_addr_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
49Field remote_addr_session added to table session_table (options : )
50Field 'robot_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
51Field robot_session added to table session_table (options : )
52Field 'start_date_session' (table 'session_table' ; database 'sympa') was NOT found. Attempting to add it...
53Field start_date_session added to table session_table (options : )
54Field 'role_inclusion' (table 'inclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
55Field role_inclusion added to table inclusion_table (options : )
56Field 'source_inclusion' (table 'inclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
57Field source_inclusion added to table inclusion_table (options : )
58Field 'target_inclusion' (table 'inclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
59Field target_inclusion added to table inclusion_table (options : )
60Field 'update_epoch_inclusion' (table 'inclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
61Field update_epoch_inclusion added to table inclusion_table (options : )
62Table inclusion_table, PRIMARY KEY set on target_inclusion,source_inclusion,role_inclusion
63Field 'action_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
64Field action_logs added to table logs_table (options : )
65Field 'client_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
66Field client_logs added to table logs_table (options : )
67Field 'daemon_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
68Field daemon_logs added to table logs_table (options : )
69Field 'date_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
70Field date_logs added to table logs_table (options : )
71Field 'error_type_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
72Field error_type_logs added to table logs_table (options : )
73Field 'list_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
74Field list_logs added to table logs_table (options : )
75Field 'msg_id_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
76Field msg_id_logs added to table logs_table (options : )
77Field 'parameters_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
78Field parameters_logs added to table logs_table (options : )
79Field 'robot_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
80Field robot_logs added to table logs_table (options : )
81Field 'status_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
82Field status_logs added to table logs_table (options : )
83Field 'target_email_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
84Field target_email_logs added to table logs_table (options : )
85Field 'usec_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
86Field usec_logs added to table logs_table (options : )
87Field 'user_email_logs' (table 'logs_table' ; database 'sympa') was NOT found. Attempting to add it...
88Field user_email_logs added to table logs_table (options : )
89Field 'date_exclusion' (table 'exclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
90Field date_exclusion added to table exclusion_table (options : )
91Field 'family_exclusion' (table 'exclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
92Field family_exclusion added to table exclusion_table (options : )
93Field 'list_exclusion' (table 'exclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
94Field list_exclusion added to table exclusion_table (options : )
95Field 'robot_exclusion' (table 'exclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
96Field robot_exclusion added to table exclusion_table (options : )
97Field 'user_exclusion' (table 'exclusion_table' ; database 'sympa') was NOT found. Attempting to add it...
98Field user_exclusion added to table exclusion_table (options : )
99Table exclusion_table, PRIMARY KEY set on family_exclusion,user_exclusion,robot_exclusion,list_exclusion
100Field 'creation_email_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
101Field creation_email_list added to table list_table (options : )
102Field 'creation_epoch_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
103Field creation_epoch_list added to table list_table (options : )
104Field 'family_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
105Field family_list added to table list_table (options : )
106Field 'name_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
107Field name_list added to table list_table (options : )
108Field 'robot_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
109Field robot_list added to table list_table (options : )
110Field 'searchkey_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
111Field searchkey_list added to table list_table (options : )
112Field 'status_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
113Field status_list added to table list_table (options : )
114Field 'topics_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
115Field topics_list added to table list_table (options : )
116Field 'total_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
117Field total_list added to table list_table (options : )
118Field 'update_email_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
119Field update_email_list added to table list_table (options : )
120Field 'update_epoch_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
121Field update_epoch_list added to table list_table (options : )
122Field 'web_archive_list' (table 'list_table' ; database 'sympa') was NOT found. Attempting to add it...
123Field web_archive_list added to table list_table (options : )
124Table list_table, PRIMARY KEY set on robot_list,name_list
125Field 'beginning_date_counter' (table 'stat_counter_table' ; database 'sympa') was NOT found. Attempting to add it...
126Field beginning_date_counter added to table stat_counter_table (options : )
127Field 'count_counter' (table 'stat_counter_table' ; database 'sympa') was NOT found. Attempting to add it...
128Field count_counter added to table stat_counter_table (options : )
129Field 'data_counter' (table 'stat_counter_table' ; database 'sympa') was NOT found. Attempting to add it...
130Field data_counter added to table stat_counter_table (options : )
131Field 'end_date_counter' (table 'stat_counter_table' ; database 'sympa') was NOT found. Attempting to add it...
132Field end_date_counter added to table stat_counter_table (options : )
133Field 'list_counter' (table 'stat_counter_table' ; database 'sympa') was NOT found. Attempting to add it...
134Field list_counter added to table stat_counter_table (options : )
135Field 'robot_counter' (table 'stat_counter_table' ; database 'sympa') was NOT found. Attempting to add it...
136Field robot_counter added to table stat_counter_table (options : )
137Field 'comment_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
138Field comment_admin added to table admin_table (options : )
139Field 'date_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
140Field date_admin added to table admin_table (options : )
141Field 'include_sources_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
142Field include_sources_admin added to table admin_table (options : )
143Field 'included_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
144Field included_admin added to table admin_table (options : )
145Field 'info_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
146Field info_admin added to table admin_table (options : )
147Field 'list_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
148Field list_admin added to table admin_table (options : )
149Field 'profile_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
150Field profile_admin added to table admin_table (options : )
151Field 'reception_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
152Field reception_admin added to table admin_table (options : )
153Field 'robot_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
154Field robot_admin added to table admin_table (options : )
155Field 'role_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
156Field role_admin added to table admin_table (options : )
157Field 'subscribed_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
158Field subscribed_admin added to table admin_table (options : )
159Field 'update_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
160Field update_admin added to table admin_table (options : )
161Field 'user_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
162Field user_admin added to table admin_table (options : )
163Field 'visibility_admin' (table 'admin_table' ; database 'sympa') was NOT found. Attempting to add it...
164Field visibility_admin added to table admin_table (options : )
165Table admin_table, PRIMARY KEY set on list_admin,user_admin,role_admin,robot_admin
166Table admin_table, index %s set using user_admin
167Field 'attributes_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
168Field attributes_user added to table user_table (options : )
169Field 'cookie_delay_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
170Field cookie_delay_user added to table user_table (options : )
171Field 'data_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
172Field data_user added to table user_table (options : )
173Field 'email_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
174Field email_user added to table user_table (options : PRIMARY KEY )
175Field 'gecos_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
176Field gecos_user added to table user_table (options : )
177Field 'lang_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
178Field lang_user added to table user_table (options : )
179Field 'last_active_date_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
180Field last_active_date_user added to table user_table (options : )
181Field 'last_login_date_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
182Field last_login_date_user added to table user_table (options : )
183Field 'last_login_host_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
184Field last_login_host_user added to table user_table (options : )
185Field 'password_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
186Field password_user added to table user_table (options : )
187Field 'wrong_login_count_user' (table 'user_table' ; database 'sympa') was NOT found. Attempting to add it...
188Field wrong_login_count_user added to table user_table (options : )
189Field 'bounce_address_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
190Field bounce_address_subscriber added to table subscriber_table (options : )
191Field 'bounce_score_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
192Field bounce_score_subscriber added to table subscriber_table (options : )
193Field 'bounce_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
194Field bounce_subscriber added to table subscriber_table (options : )
195Field 'comment_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
196Field comment_subscriber added to table subscriber_table (options : )
197Field 'custom_attribute_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
198Field custom_attribute_subscriber added to table subscriber_table (options : )
199Field 'date_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
200Field date_subscriber added to table subscriber_table (options : )
201Field 'include_sources_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
202Field include_sources_subscriber added to table subscriber_table (options : )
203Field 'included_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
204Field included_subscriber added to table subscriber_table (options : )
205Field 'list_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
206Field list_subscriber added to table subscriber_table (options : )
207Field 'number_messages_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
208Field number_messages_subscriber added to table subscriber_table (options : )
209Field 'reception_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
210Field reception_subscriber added to table subscriber_table (options : )
211Field 'robot_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
212Field robot_subscriber added to table subscriber_table (options : )
213Field 'subscribed_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
214Field subscribed_subscriber added to table subscriber_table (options : )
215Field 'suspend_end_date_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
216Field suspend_end_date_subscriber added to table subscriber_table (options : )
217Field 'suspend_start_date_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
218Field suspend_start_date_subscriber added to table subscriber_table (options : )
219Field 'suspend_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
220Field suspend_subscriber added to table subscriber_table (options : )
221Field 'topics_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
222Field topics_subscriber added to table subscriber_table (options : )
223Field 'update_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
224Field update_subscriber added to table subscriber_table (options : )
225Field 'user_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
226Field user_subscriber added to table subscriber_table (options : )
227Field 'visibility_subscriber' (table 'subscriber_table' ; database 'sympa') was NOT found. Attempting to add it...
228Field visibility_subscriber added to table subscriber_table (options : )
229Table subscriber_table, PRIMARY KEY set on robot_subscriber,list_subscriber,user_subscriber
230Table subscriber_table, index %s set using user_subscriber
231Field 'data_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...
232Field data_one_time_ticket added to table one_time_ticket_table (options : )
233Field 'date_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...
234Field date_one_time_ticket added to table one_time_ticket_table (options : )
235Field 'email_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...
236Field email_one_time_ticket added to table one_time_ticket_table (options : )
237Field 'remote_addr_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...
238Field remote_addr_one_time_ticket added to table one_time_ticket_table (options : )
239Field 'robot_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...
240Field robot_one_time_ticket added to table one_time_ticket_table (options : )
241Field 'status_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...
242Field status_one_time_ticket added to table one_time_ticket_table (options : )
243Field 'ticket_one_time_ticket' (table 'one_time_ticket_table' ; database 'sympa') was NOT found. Attempting to add it...
244Field ticket_one_time_ticket added to table one_time_ticket_table (options : PRIMARY KEY )
245Field 'daemon_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
246Field daemon_stat added to table stat_table (options : )
247Field 'date_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
248Field date_stat added to table stat_table (options : )
249Field 'email_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
250Field email_stat added to table stat_table (options : )
251Field 'list_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
252Field list_stat added to table stat_table (options : )
253Field 'operation_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
254Field operation_stat added to table stat_table (options : )
255Field 'parameter_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
256Field parameter_stat added to table stat_table (options : )
257Field 'read_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
258Field read_stat added to table stat_table (options : )
259Field 'robot_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
260Field robot_stat added to table stat_table (options : )
261Field 'user_ip_stat' (table 'stat_table' ; database 'sympa') was NOT found. Attempting to add it...
262Field user_ip_stat added to table stat_table (options : )
263Table stat_table, index %s set using email_stat
264Field 'arrival_date_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
265Field arrival_date_notification added to table notification_table (options : )
266Field 'arrival_epoch_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
267Field arrival_epoch_notification added to table notification_table (options : )
268Field 'date_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
269Field date_notification added to table notification_table (options : )
270Field 'list_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
271Field list_notification added to table notification_table (options : )
272Field 'message_id_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
273Field message_id_notification added to table notification_table (options : )
274Field 'pk_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
275Field pk_notification added to table notification_table (options : AUTO_INCREMENT PRIMARY KEY )
276Field 'reception_option_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
277Field reception_option_notification added to table notification_table (options : )
278Field 'recipient_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
279Field recipient_notification added to table notification_table (options : )
280Field 'robot_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
281Field robot_notification added to table notification_table (options : )
282Field 'status_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
283Field status_notification added to table notification_table (options : )
284Field 'type_notification' (table 'notification_table' ; database 'sympa') was NOT found. Attempting to add it...
285Field type_notification added to table notification_table (options : )

Next configure nginx and run wwsympa-wrapper.fcgi at user 116 (sympa)

dereckson added a commit: Restricted Diffusion Commit.Jan 22 2017, 16:05
dereckson removed dereckson as the assignee of this task.Mar 8 2018, 21:07