def envrcpt(self, to, *str):
# <>
if self.mailfrom == "":
return Milter.CONTINUE
# de +ify
addr = Milter.utils.parse_addr(to.lower())
rcpt = addr[0] + "@" + addr[1]
userdata = lib.user.GWUser(email=rcpt)
# non exising user
if not userdata.check():
return Milter.CONTINUE
if userdata.cancharge == 0 or userdata.masterpubkey_btc == None or userdata.feeamount == 0:
return Milter.CONTINUE
h = hashlib.new('sha256')
h.update(self.mailfrom + "!" + rcpt)
digest = h.digest()
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
cur.execute("SELECT id, status FROM sendercharge WHERE hash = %s",
(digest))
result = False
for row in cur.fetchall():
result = row
if result and result['status'] == 1:
cur.close()
return Milter.CONTINUE
if result: # result['status'] == 0
cur.execute(
"SELECT address, amount FROM invoice WHERE sendercharge_id = %s",
(row['id']))
for row in cur.fetchall():
result = row
url = lib.payment.create_payment_url(result['address'], 'BTC',
result['amount'], rcpt,
'Sending emails')
else: # no record
btcaddress, amount = lib.payment.create_invoice_user(rcpt)
url = lib.payment.create_payment_url(btcaddress, 'BTC', amount,
rcpt, 'Sending emails')
cur.execute(
"INSERT INTO sendercharge (hash, status) values (%s, %s)",
(digest, 0))
sendercharge_id = cur.lastrowid
cur.execute(
"UPDATE invoice SET sendercharge_id = %s WHERE address = %s and coin = 'BTC'",
(sendercharge_id, btcaddress))
cur.close()
url = url.replace("%", "%%")
self.setreply("550", "5.7.0", "PAYMENT REQUIRED: %s" % url)
return Milter.REJECT
def create_invoice_domain (domain, payer):
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
filterwarnings('ignore', category = MySQLdb.Warning)
cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM domain WHERE name = %s AND active = 1", (domain))
result = False
for row in cur.fetchall():
result = row
while result:
if result['masterpubkey_btc'][0:4] == "xpub":
# BIP44
dpk1 = bitcoin.bip32_ckd(result['masterpubkey_btc'], 0)
dpk2 = bitcoin.bip32_ckd(dpk1, result['offset_btc'])
pubkey = bitcoin.bip32_extract_key(dpk2)
else:
# Electrum 1.x
pubkey = bitcoin.electrum_pubkey(result['masterpubkey_btc'], result['offset_btc'])
address = bitcoin.pubkey_to_address(pubkey)
bitcoind_importaddress(address)
cur.execute ("UPDATE domain SET offset_btc = offset_btc + 1 WHERE name = %s AND active = 1 AND masterpubkey_btc = %s", (domain, result['masterpubkey_btc']))
if result['feecurrency'] in ("USD", "GBP", "EUR"):
result['feeamount'] /= decimal.Decimal(get_bitcoin_price(result['feecurrency']))
cur.execute ("INSERT IGNORE INTO invoice (issuer, payer, address, coin, amount, type, paid) VALUES (%s, %s, %s, 'BTC', %s, 0, 0)", (result['bm'], payer, address, result['feeamount']))
# invoice already exists for that address, increment
if cur.rowcount == 0:
cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM domain WHERE name = %s AND active = 1", (domain))
result = False
for row in cur.fetchall():
result = row
continue
cur.close()
return address, result['feeamount'];
cur.close()
return False
def envrcpt (self, to, *str):
# <>
if self.mailfrom == "":
return Milter.CONTINUE
# de +ify
addr = Milter.utils.parse_addr(to.lower())
rcpt = addr[0] + "@" + addr[1]
BMMySQL().db.ping(True)
userdata = lib.user.GWUser(email = rcpt)
# non exising user
if not userdata.check():
return Milter.CONTINUE
if userdata.cancharge == 0 or userdata.masterpubkey_btc == None or userdata.feeamount == 0:
return Milter.CONTINUE
h = hashlib.new('sha256')
h.update (self.mailfrom + "!" + rcpt);
digest = h.digest()
cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor)
cur.execute("SELECT id, status FROM sendercharge WHERE hash = %s", (digest))
result = False
for row in cur.fetchall():
result = row
if result and result['status'] == 1:
cur.close()
return Milter.CONTINUE
if result: # result['status'] == 0
cur.execute("SELECT address, amount FROM invoice WHERE sendercharge_id = %s", (row['id']))
for row in cur.fetchall():
result = row
url = lib.payment.create_payment_url(result['address'], 'BTC', result['amount'], rcpt, 'Sending emails')
else: # no record
btcaddress, amount = lib.payment.create_invoice_user(rcpt)
url = lib.payment.create_payment_url(btcaddress, 'BTC', amount, rcpt, 'Sending emails')
cur.execute("INSERT INTO sendercharge (hash, status) values (%s, %s)", (digest, 0))
sendercharge_id = cur.lastrowid
cur.execute("UPDATE invoice SET sendercharge_id = %s WHERE address = %s and coin = 'BTC'", (sendercharge_id, btcaddress))
cur.close()
url = url.replace("%", "%%")
self.setreply("550", "5.7.0", "PAYMENT REQUIRED: %s" % url)
return Milter.REJECT
def key_from_mysql(key):
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
logging.info("Importing GPG keys from SQL for %s", key)
cur.execute("SELECT data FROM gpg WHERE email = %s", (key))
for row in cur.fetchall():
import_key(row['data'])
cur.close()
def create_invoice_user (email):
BMMySQL().db.ping(True)
cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor)
cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM user WHERE email = %s AND active = 1", (email))
result = False
for row in cur.fetchall():
result = row
if result:
if result['masterpubkey_btc'][0:4] == "xpub":
# BIP44
dpk1 = pybitcointools.bip32_ckd(result['masterpubkey_btc'], 0)
dpk2 = pybitcointools.bip32_ckd(dpk1, result['offset_btc'])
pubkey = pybitcointools.bip32_extract_key(dpk2)
else:
# Electrum 1.x
pubkey = pybitcointools.electrum_pubkey(result['masterpubkey_btc'], result['offset_btc'])
address = pybitcointools.pubkey_to_address(pubkey)
cur.execute ("UPDATE user SET offset_btc = offset_btc + 1 WHERE email = %s AND active = 1 AND masterpubkey_btc = %s", (email, result['masterpubkey_btc']))
if result['feecurrency'] in ("USD", "GBP", "EUR"):
result['feeamount'] /= decimal.Decimal(get_bitcoin_price(result['feecurrency']))
cur.execute ("INSERT INTO invoice (issuer, address, coin, amount, type, paid) VALUES (%s, %s, 'BTC', %s, 1, 0)", (result['bm'], address, result['feeamount']))
bitcoind_importaddress(address)
cur.close()
return address, result['feeamount'];
cur.close()
return False
def create_invoice_user (email):
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM user WHERE email = %s AND active = 1", (email))
result = False
for row in cur.fetchall():
result = row
if result:
if result['masterpubkey_btc'][0:4] == "xpub":
# BIP44
dpk1 = bitcoin.bip32_ckd(result['masterpubkey_btc'], 0)
dpk2 = bitcoin.bip32_ckd(dpk1, result['offset_btc'])
pubkey = bitcoin.bip32_extract_key(dpk2)
else:
# Electrum 1.x
pubkey = bitcoin.electrum_pubkey(result['masterpubkey_btc'], result['offset_btc'])
address = bitcoin.pubkey_to_address(pubkey)
bitcoind_importaddress(address)
cur.execute ("UPDATE user SET offset_btc = offset_btc + 1 WHERE email = %s AND active = 1 AND masterpubkey_btc = %s", (email, result['masterpubkey_btc']))
if result['feecurrency'] in ("USD", "GBP", "EUR"):
result['feeamount'] /= decimal.Decimal(get_bitcoin_price(result['feecurrency']))
cur.execute ("INSERT INTO invoice (issuer, address, coin, amount, type, paid) VALUES (%s, %s, 'BTC', %s, 1, 0)", (result['bm'], address, result['feeamount']))
cur.close()
return address, result['feeamount'];
cur.close()
return False
def load(self, bm=None, uid=None, email=None, unalias=False):
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
filterwarnings('ignore', category=MySQLdb.Warning)
multirow = False
self.uid = None
if bm != None:
cur.execute("SELECT * FROM user WHERE bm = %s", (bm))
elif uid != None:
cur.execute("SELECT * FROM user WHERE uid = %s", (uid))
elif email != None:
if unalias:
alias = GWAlias(email=email).target
if alias:
email = alias
cur.execute("SELECT * FROM user WHERE email = %s", (email))
else:
# if no arguments, return all
multirow = True
cur.execute("SELECT * FROM user ORDER BY email")
for row in cur.fetchall():
if multirow:
print "%1s %-40s %-39s " % ("*" if row['active'] else " ",
row['email'], row['bm'])
else:
for column in row:
setattr(self, column, row[column])
cur.close()
if hasattr(self, 'email'):
self.aliases = GWAlias(alias=self.email).aliases
def load(self, bm = None, uid = None, email = None, unalias = False):
BMMySQL().db.ping(True)
cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor)
filterwarnings('ignore', category = MySQLdb.Warning)
multirow = False
self.uid = None
if bm != None:
cur.execute ("SELECT * FROM user WHERE bm = %s", (bm))
elif uid != None:
cur.execute ("SELECT * FROM user WHERE uid = %s", (uid))
elif email != None:
if unalias:
alias = GWAlias(email).target
if alias:
email = alias
cur.execute ("SELECT * FROM user WHERE email = %s", (email))
else:
# if no arguments, return all
multirow = True
cur.execute ("SELECT * FROM user ORDER BY email")
for row in cur.fetchall():
if multirow:
print "%1s %-40s %-39s " % ("*" if row['active'] else " ", row['email'], row['bm'])
else:
for column in row:
setattr(self, column, row[column])
cur.close()
def getSchedule(key):
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
cur.execute("SELECT ts FROM schedules WHERE id = %s", (key))
ret = None
for row in cur.fetchall():
ret = row['ts']
cur.close()
return ret
def payment_exists_domain (domain, payer):
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
cur.execute ("SELECT address, amount FROM invoice WHERE type = 0 AND payer = %s AND paid = '0000-00-00 00:00:00'", (payer))
result = False
for row in cur.fetchall():
result = row
if result:
return result['address'], result['amount']
cur.close()
return False, False
def payment_exists_domain (domain, payer):
BMMySQL().db.ping(True)
cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor)
cur.execute ("SELECT address, amount FROM invoice WHERE type = 0 AND payer = %s AND paid = '0000-00-00 00:00:00'", (payer))
result = False
for row in cur.fetchall():
result = row
if result:
return result['address'], result['amount']
cur.close()
return False, False
def __init__(self, email=None, alias=None):
self.aliases = []
self.target = None
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
result = False
if email:
seen = {email: True}
src = email
while not result:
cur.execute("SELECT target FROM alias WHERE alias = %s", (src))
result = True
for row in cur.fetchall():
result = False
seen[row['target']] = True
src = row['target']
for column in row:
setattr(self, column, row[column])
elif alias:
cur.execute("SELECT alias FROM alias WHERE target = %s", (alias))
for row in cur.fetchall():
self.aliases.append(row['alias'])
cur.close()
def create_invoice_domain (domain, payer):
BMMySQL().db.ping(True)
cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor)
filterwarnings('ignore', category = MySQLdb.Warning)
cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM domain WHERE name = %s AND active = 1", (domain))
result = False
for row in cur.fetchall():
result = row
while result:
if result['masterpubkey_btc'][0:4] == "xpub":
# BIP44
dpk1 = pybitcointools.bip32_ckd(result['masterpubkey_btc'], 0)
dpk2 = pybitcointools.bip32_ckd(dpk1, result['offset_btc'])
pubkey = pybitcointools.bip32_extract_key(dpk2)
else:
# Electrum 1.x
pubkey = pybitcointools.electrum_pubkey(result['masterpubkey_btc'], result['offset_btc'])
address = pybitcointools.pubkey_to_address(pubkey)
cur.execute ("UPDATE domain SET offset_btc = offset_btc + 1 WHERE name = %s AND active = 1 AND masterpubkey_btc = %s", (domain, result['masterpubkey_btc']))
if result['feecurrency'] in ("USD", "GBP", "EUR"):
result['feeamount'] /= decimal.Decimal(get_bitcoin_price(result['feecurrency']))
cur.execute ("INSERT IGNORE INTO invoice (issuer, payer, address, coin, amount, type, paid) VALUES (%s, %s, %s, 'BTC', %s, 0, 0)", (result['bm'], payer, address, result['feeamount']))
# invoice already exists for that address, increment
if cur.rowcount == 0:
cur.execute ("SELECT bm, masterpubkey_btc, offset_btc, feeamount, feecurrency FROM domain WHERE name = %s AND active = 1", (domain))
result = False
for row in cur.fetchall():
result = row
continue
bitcoind_importaddress(address)
cur.close()
return address, result['feeamount'];
cur.close()
return False
def __init__(self, email):
self.alias = None
self.target = None
BMMySQL().db.ping(True)
cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor)
result = False
seen = {email: True}
src = email
while not result:
cur.execute ("SELECT target FROM alias WHERE alias = %s", (src))
result = True
for row in cur.fetchall():
result = False
seen[row['target']] = True
src = row['target']
for column in row:
setattr(self, column, row[column])
def __init__(self, domain = None):
self.name = None
self.active = None
BMMySQL().db.ping(True)
cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor)
filterwarnings('ignore', category = MySQLdb.Warning)
multirow = False
if domain != None:
cur.execute ("SELECT * FROM domain WHERE active = 1 AND name = %s", (domain))
else:
multirow = True
cur.execute ("SELECT * FROM domain WHERE active = 1")
for row in cur.fetchall():
if multirow:
print "%40s %1u" % (row['name'], row['active'])
else:
self.name = row['name']
self.active = row['active']
cur.close()
def __init__(self, domain=None):
self.name = None
self.active = None
cur = BMMySQL().conn().cursor(MySQLdb.cursors.DictCursor)
filterwarnings('ignore', category=MySQLdb.Warning)
multirow = False
if domain != None:
cur.execute("SELECT * FROM domain WHERE active = 1 AND name = %s",
(domain))
else:
multirow = True
cur.execute("SELECT * FROM domain WHERE active = 1")
for row in cur.fetchall():
if multirow:
print "%40s %1u" % (row['name'], row['active'])
else:
self.name = row['name']
self.active = row['active']
cur.close()
def key_from_mysql(key):
cur = BMMySQL().db.cursor(MySQLdb.cursors.DictCursor)
logger.info("Importing GPG keys from SQL for %s", key)
cur.execute ("SELECT data FROM gpg WHERE email = %s", (key))
for row in cur.fetchall():
import_key(row['data'])
filterwarnings('ignore', category=MySQLdb.Warning)
#amount = txinfo['amount']
for detail in txinfo['details']:
if detail['category'] == "receive":
print detail['address'] + " -> " + str(detail['amount'])
cur.execute(
"""INSERT IGNORE INTO payment (address, coin, txid, amount, confirmations) VALUES (%s, %s, %s, %s, %s)""",
(detail['address'], coin, txid, detail['amount'],
txinfo['confirmations']))
if txinfo['confirmations'] == 0:
# select from invoice
cur.execute(
"SELECT amount, paid, type, payer, sendercharge_id FROM invoice WHERE address = %s AND coin = %s",
(detail['address'], coin))
for row in cur.fetchall():
invoice = row
# fetch
totalpaid = 0
cur.execute(
"SELECT amount FROM payment WHERE address = %s AND coin = %s AND confirmations = 0",
(detail['address'], coin))
for row in cur.fetchall():
payment = row
totalpaid += payment[
'amount'] # fixme floating rounding problems?
# fetch
if invoice['paid'] == None or invoice['paid'] <= datetime.datetime(
1971, 1, 1) and totalpaid >= invoice['amount']:
cur.execute(
"UPDATE invoice SET paid = NOW() WHERE address = %s AND coin = %s ",
while BMAPI().conn() is False:
print "Failure connecting to API, sleeping..."
time.sleep(random.random()+0.5)
filterwarnings('ignore', category = MySQLdb.Warning)
#amount = txinfo['amount']
for detail in txinfo['details']:
if detail['category'] == "receive":
print detail['address'] + " -> " + str(detail['amount'])
cur.execute ( """INSERT IGNORE INTO payment (address, coin, txid, amount, confirmations) VALUES (%s, %s, %s, %s, %s)""",
(detail['address'], coin, txid, detail['amount'], txinfo['confirmations']))
if txinfo['confirmations'] == 0:
# select from invoice
cur.execute ("SELECT amount, paid, type, payer, sendercharge_id FROM invoice WHERE address = %s AND coin = %s", (detail['address'], coin))
for row in cur.fetchall():
invoice = row
# fetch
totalpaid = 0
cur.execute ("SELECT amount FROM payment WHERE address = %s AND coin = %s AND confirmations = 0", (detail['address'], coin))
for row in cur.fetchall():
payment = row
totalpaid += payment['amount'] # fixme floating rounding problems?
# fetch
if invoice['paid'] == None or invoice['paid'] <= datetime.datetime(1971, 1, 1) and totalpaid >= invoice['amount']:
cur.execute ("UPDATE invoice SET paid = NOW() WHERE address = %s AND coin = %s ", (detail['address'], coin))
if invoice['type'] == 0:
incomingamount = decimal.Decimal(str(detail['amount']))
if incomingamount < invoice['amount']:
months = 0
else:
