| 1 | #!/usr/bin/env python |
| 2 | #*************************************************************************** |
| 3 | #* Copyright (C) 2003-2014 Polytechnique.org * |
| 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) |
| 204 | |
| 205 | mlist.owner = owners |
| 206 | |
| 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: |