0337d704 |
1 | #!/usr/bin/env python |
2 | #*************************************************************************** |
9f5bd98e |
3 | #* Copyright (C) 2003-2010 Polytechnique.org * |
0337d704 |
4 | #* http://opensource.polytechnique.org/ * |
5 | #* * |
6 | #* This program is free software; you can redistribute it and/or modify * |
7 | #* it under the terms of the GNU General Public License as published by * |
8 | #* the Free Software Foundation; either version 2 of the License, or * |
9 | #* (at your option) any later version. * |
10 | #* * |
11 | #* This program is distributed in the hope that it will be useful, * |
12 | #* but WITHOUT ANY WARRANTY; without even the implied warranty of * |
13 | #* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * |
14 | #* GNU General Public License for more details. * |
15 | #* * |
16 | #* You should have received a copy of the GNU General Public License * |
17 | #* along with this program; if not, write to the Free Software * |
18 | #* Foundation, Inc., * |
19 | #* 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * |
20 | #*************************************************************************** |
21 | |
22 | import base64, MySQLdb, os, getopt, sys, MySQLdb.converters, sha |
23 | from pwd import getpwnam |
24 | from grp import getgrnam |
25 | |
26 | from SimpleXMLRPCServer import SimpleXMLRPCServer |
27 | from SimpleXMLRPCServer import SimpleXMLRPCRequestHandler |
28 | |
29 | import paths |
30 | from Mailman import MailList |
31 | from Mailman import Utils |
32 | from Mailman import Message |
33 | from Mailman import Errors |
34 | from Mailman import mm_cfg |
35 | from Mailman import i18n |
36 | from Mailman.UserDesc import UserDesc |
37 | from Mailman.ListAdmin import readMessage |
38 | |
39 | #------------------------------------------------------------------------------- |
40 | # helpers |
41 | # |
42 | |
43 | def connectDB(): |
44 | db = MySQLdb.connect( |
45 | db='x4dat', |
46 | user=mm_cfg.MYSQL_USER, |
47 | passwd=mm_cfg.MYSQL_PASS, |
48 | unix_socket='/var/run/mysqld/mysqld.sock') |
49 | db.ping() |
50 | return db.cursor() |
51 | |
52 | def set_options(vhost,listname,opts,vals): |
53 | try: |
54 | mlist = MailList.MailList(vhost+'-'+listname) |
55 | except: |
56 | return 0 |
57 | try: |
58 | for (k,v) in vals.iteritems(): |
59 | if k not in opts: |
60 | continue |
61 | if k == 'default_member_moderation': |
62 | for member in mlist.getMembers(): |
63 | mlist.setMemberOption(member, mm_cfg.Moderate, int(v)) |
64 | t = type(mlist.__dict__[k]) |
65 | if t is bool: mlist.__dict__[k] = bool(v) |
66 | elif t is int: mlist.__dict__[k] = int(v) |
67 | elif t is str: mlist.__dict__[k] = Utils.uncanonstr(v,'fr') |
68 | else: mlist.__dict__[k] = v |
69 | mlist.Save() |
70 | mlist.Unlock() |
71 | return 1 |
72 | except: |
73 | mlist.Unlock() |
74 | raise |
75 | return 0 |
76 | |
77 | def mass_subscribe(vhost,listname,users): |
78 | try: |
79 | mlist = MailList.MailList(vhost+'-'+listname) |
80 | except: |
81 | return 0 |
82 | try: |
83 | members = mlist.getRegularMemberKeys() |
84 | added = [] |
85 | for user in users: |
86 | name, forlife = user; |
87 | if forlife+'@polytechnique.org' in members: |
88 | continue |
89 | userd = UserDesc(forlife+'@polytechnique.org', name, None, 0) |
90 | mlist.ApprovedAddMember(userd, 0, 0) |
91 | added.append( (userd.fullname, userd.address) ) |
92 | mlist.Save() |
93 | finally: |
94 | mlist.Unlock() |
95 | return added |
96 | |
97 | def add_owner(vhost,listname,forlife): |
98 | try: |
99 | mlist = MailList.MailList(vhost+'-'+listname) |
100 | except: |
101 | return 0 |
102 | try: |
103 | if forlife+'@polytechnique.org' not in mlist.owner: |
104 | mlist.owner.append(forlife+'@polytechnique.org') |
105 | mlist.Save() |
106 | finally: |
107 | mlist.Unlock() |
108 | return True |
109 | |
110 | #------------------------------------------------------------------------------- |
111 | # admin procedures [ check.php ] |
112 | # |
113 | |
114 | check_opts = { |
115 | 'acceptable_aliases' : '', |
116 | 'admin_immed_notify' : True, |
117 | 'administrivia' : True, |
118 | 'anonymous_list' : False, |
119 | 'autorespond_admin' : False, |
120 | 'autorespond_postings' : False, |
121 | 'autorespond_requests' : False, |
122 | 'available_languages' : ['fr'], |
123 | 'ban_list' : [], |
124 | 'bounce_matching_headers' : '', |
125 | 'bounce_processing' : False, |
126 | 'convert_html_to_plaintext' : False, |
127 | 'digestable' : False, |
128 | 'digest_is_default' : False, |
129 | 'discard_these_nonmembers' : [], |
130 | 'emergency' : False, |
131 | 'encode_ascii_prefixes' : 2, |
132 | 'filter_content' : False, |
133 | 'first_strip_reply_to' : False, |
134 | 'forward_auto_discards' : True, |
135 | 'header_filter_rules' : [], |
136 | 'hold_these_nonmembers' : [], |
137 | 'include_list_post_header' : False, |
138 | 'include_rfc2369_headers' : False, |
139 | 'new_member_options' : 256, |
140 | 'nondigestable' : True, |
141 | 'obscure_addresses' : True, |
142 | 'preferred_language' : 'fr', |
143 | 'reject_these_nonmembers' : [], |
144 | 'reply_goes_to_list' : 0, |
145 | 'reply_to_address' : '', |
146 | 'require_explicit_destination' : False, |
147 | 'send_reminders' : 0, |
148 | 'send_welcome_msg' : True, |
149 | 'topics_enabled' : False, |
150 | 'umbrella_list' : False, |
151 | 'unsubscribe_policy' : 0, |
152 | } |
153 | |
154 | def check_options(vhost,listname,correct=False): |
155 | try: |
156 | mlist = MailList.MailList(vhost+'-'+listname) |
157 | except: |
158 | return 0 |
159 | try: |
160 | options = { } |
161 | for (k,v) in check_opts.iteritems(): |
162 | if mlist.__dict__[k] != v: |
163 | options[k] = v,mlist.__dict__[k] |
164 | if correct: mlist.__dict__[k] = v |
165 | if mlist.real_name != listname: |
166 | options['real_name'] = listname, mlist.real_name |
167 | if correct: mlist.real_name = listname |
168 | if mlist.host_name != vhost: |
169 | options['real_name'] = vhost, mlist.host_name |
170 | if correct: mlist.host_name = vhost |
171 | if correct: mlist.Save() |
172 | mlist.Unlock() |
173 | return (details,options) |
174 | except: |
175 | mlist.Unlock() |
176 | return 0 |
177 | |
178 | #------------------------------------------------------------------------------- |
179 | # admin procedures [ soptions.php ] |
180 | # |
181 | |
182 | def create_list(vhost,listname,desc,advertise,modlevel,inslevel,owners,members): |
183 | name = vhost+'-'+listname; |
184 | if Utils.list_exists(name): |
185 | return 0 |
186 | |
187 | mlist = MailList.MailList() |
188 | try: |
189 | oldmask = os.umask(002) |
190 | pw = sha.new('foobar').hexdigest() |
191 | try: |
192 | mlist.Create(name, owners[0], pw) |
193 | finally: |
194 | os.umask(oldmask) |
195 | |
196 | mlist.real_name = listname |
197 | mlist.host_name = vhost |
198 | mlist.description = desc |
199 | |
200 | mlist.advertised = int(advertise) > 0 |
201 | mlist.default_member_moderation = int(modlevel) is 2 |
202 | mlist.generic_nonmember_action = int(modlevel) > 0 |
203 | mlist.subscribe_policy = 2 * (int(inslevel) is 1) |
25112e7a |
204 | |
0337d704 |
205 | mlist.owner = owners |
25112e7a |
206 | |
0337d704 |
207 | mlist.subject_prefix = '['+listname+'] ' |
208 | mlist.max_message_size = 0 |
209 | |
210 | mlist.Save() |
211 | mlist.Unlock() |
212 | check_options(vhost,listname,True) |
213 | mass_subscribe(vhost,listname,members) |
214 | except: |
215 | raise |
216 | return 0 |
217 | return 1 |
218 | |
219 | uid = getpwnam(mm_cfg.MAILMAN_USER)[2] |
220 | gid = getgrnam(mm_cfg.MAILMAN_GROUP)[2] |
221 | |
222 | if not os.getuid(): |
223 | os.setregid(gid,gid) |
224 | os.setreuid(uid,uid) |
225 | |
226 | if ( os.getuid() is not uid ) or ( os.getgid() is not gid): |
227 | sys.exit(0) |
228 | |
229 | opts, args = getopt.getopt(sys.argv[1:], 'f') |
230 | for o, a in opts: |
231 | if o == '-f' and os.fork(): |
232 | sys.exit(0) |
233 | |
234 | mysql = connectDB() |
235 | |
236 | #-------------------- LOGIC --------------------- |
237 | |
238 | mysql.execute ("""SELECT a.id, a.alias, d.topic, d.bienvenue, |
239 | FIND_IN_SET('publique',d.type) AND NOT FIND_IN_SET('promo',d.type) AS advertised, |
240 | (1-FIND_IN_SET('freeins',d.type)) AS inslevel, |
241 | (1-FIND_IN_SET('libre',d.type))*2 AS modlevel |
242 | FROM aliases AS a |
243 | INNER JOIN listes_def AS d USING(id) |
244 | WHERE a.type='liste'""") |
245 | lists = mysql.fetchall() |
246 | i=0 |
247 | l=len(lists) |
248 | |
249 | for id,alias,desc,welcome,advertise,inslevel,modlevel in lists: |
250 | mysql.execute ( """SELECT a.alias |
251 | FROM auth_user_md5 AS u |
252 | INNER JOIN aliases AS a ON ( a.id=u.user_id AND a.type='a_vie' ) |
253 | INNER JOIN listes_mod AS m ON ( m.idu=u.user_id AND m.idl='%i' )""" %(id) ) |
254 | owners = map(lambda x: x[0]+'@polytechnique.org', mysql.fetchall()) |
255 | if owners == []: owners = ['listes@m4x.org'] |
256 | if desc.startswith('ADMIN/'): owners=[mm_cfg.ADMIN_ML_OWNER] |
257 | mysql.execute ( """SELECT CONCAT(u.prenom, ' ',u.nom),a.alias |
258 | FROM auth_user_md5 AS u |
259 | INNER JOIN aliases AS a ON ( a.id=u.user_id AND a.type='a_vie' ) |
260 | INNER JOIN listes_ins AS m ON ( m.idu=u.user_id AND m.idl='%i' )""" %(id) ) |
261 | members = mysql.fetchall() |
262 | create_list('polytechnique.org',alias,desc,advertise,modlevel,inslevel,owners,members) |
263 | set_options('polytechnique.org',alias,['welcome_msg'],{'welcome_msg':welcome}) |
264 | i = i+1 |
265 | print ("""[%3i/%i] '%s' created""" %(i,l,alias)) |
266 | |
267 | # vim:set et: |