def sign_in_with_form_data(body, state):
p = None
_, website = state['_'], state['website']
if body.get('log-in.id'):
request = state['request']
src_addr, src_country = request.source, request.country
website.db.hit_rate_limit('log-in.ip-addr', str(src_addr), TooManyLogInAttempts)
website.db.hit_rate_limit('log-in.country', src_country, TooManyLogInAttempts)
id = body['log-in.id'].strip()
password = body.pop('log-in.password', None)
k = 'email' if '@' in id else 'username'
if password:
id = Participant.get_id_for(k, id)
p = Participant.authenticate(id, 0, password)
if not p:
state['log-in.error'] = _("Bad username or password.")
else:
try:
p.check_password(password, context='login')
except Exception as e:
website.tell_sentry(e, state)
elif k == 'username':
state['log-in.error'] = _("\"{0}\" is not a valid email address.", id)
return
else:
email = id
p = Participant.from_email(email)
if p and p.kind == 'group':
state['log-in.error'] = _(
"{0} is linked to a team account. It's not possible to log in as a team.",
email
)
elif p:
if not p.get_email(email).verified:
website.db.hit_rate_limit('log-in.email.not-verified', email, TooManyLoginEmails)
website.db.hit_rate_limit('log-in.email', p.id, TooManyLoginEmails)
email_row = p.get_email(email)
p.send_email('login_link', email_row, link_validity=SESSION_TIMEOUT)
state['log-in.email-sent-to'] = email
raise LoginRequired
else:
state['log-in.error'] = _(
"We didn't find any account whose primary email address is {0}.",
email
)
p = None
elif 'sign-in.email' in body:
response = state['response']
# Check the submitted data
kind = body.pop('sign-in.kind', 'individual')
if kind not in ('individual', 'organization'):
raise response.invalid_input(kind, 'sign-in.kind', 'body')
email = body['sign-in.email']
if not email:
raise response.error(400, 'email is required')
email = normalize_and_check_email_address(email, state)
currency = body.get('sign-in.currency', 'EUR')
if currency not in CURRENCIES:
raise response.invalid_input(currency, 'sign-in.currency', 'body')
password = body.get('sign-in.password')
if password:
l = len(password)
if l < PASSWORD_MIN_SIZE or l > PASSWORD_MAX_SIZE:
raise BadPasswordSize
username = body.get('sign-in.username')
if username:
username = username.strip()
Participant.check_username(username)
session_token = body.get('sign-in.token', '')
if session_token:
Participant.check_session_token(session_token)
# Check for an existing account
is_duplicate_request = website.db.hit_rate_limit('sign-up.email', email) is None
for i in range(5):
existing_account = website.db.one("""
SELECT p
FROM emails e
JOIN participants p ON p.id = e.participant
WHERE lower(e.address) = lower(%s)
AND ( e.verified IS TRUE OR
e.added_time > (current_timestamp - interval '1 day') OR
p.email IS NULL )
ORDER BY p.join_time DESC
LIMIT 1
""", (email,))
if is_duplicate_request and not existing_account:
# The other thread hasn't created the account yet.
sleep(1)
else:
break
if existing_account:
session = website.db.one("""
SELECT id, secret, mtime
FROM user_secrets
WHERE participant = %s
AND id = 1
AND mtime < (%s + interval '6 hours')
AND mtime > (current_timestamp - interval '6 hours')
""", (existing_account.id, existing_account.join_time))
if session and constant_time_compare(session_token, session.secret):
p = existing_account
p.authenticated = True
p.sign_in(response.headers.cookie, session=session)
return p
else:
raise EmailAlreadyTaken(email)
username_taken = website.db.one("""
SELECT count(*)
FROM participants p
WHERE p.username = %s
""", (username,))
if username_taken:
raise UsernameAlreadyTaken(username)
# Rate limit
request = state['request']
src_addr, src_country = request.source, request.country
website.db.hit_rate_limit('sign-up.ip-addr', str(src_addr), TooManySignUps)
website.db.hit_rate_limit('sign-up.ip-net', get_ip_net(src_addr), TooManySignUps)
website.db.hit_rate_limit('sign-up.country', src_country, TooManySignUps)
website.db.hit_rate_limit('sign-up.ip-version', src_addr.version, TooManySignUps)
# Okay, create the account
with website.db.get_cursor() as c:
p = Participant.make_active(kind, currency, username, cursor=c)
p.set_email_lang(state['locale'].language, cursor=c)
p.add_email(email, cursor=c)
if password:
p.update_password(password)
p.check_password(password, context='login')
p.authenticated = True
p.sign_in(response.headers.cookie, token=session_token)
# We're done, we can clean up the body now
body.pop('sign-in.email')
body.pop('sign-in.currency', None)
body.pop('sign-in.password', None)
body.pop('sign-in.username', None)
body.pop('sign-in.token', None)
return p
def sign_in_with_form_data(body, state):
p = None
_, website = state['_'], state['website']
if body.get('log-in.id'):
request = state['request']
src_addr, src_country = request.source, request.country
input_id = body['log-in.id'].strip()
password = body.pop('log-in.password', None)
id_type = None
if input_id.find('@') > 0:
id_type = 'email'
elif input_id.startswith('~'):
id_type = 'immutable'
elif set(input_id).issubset(ASCII_ALLOWED_IN_USERNAME):
id_type = 'username'
if password and id_type:
website.db.hit_rate_limit('log-in.password.ip-addr', str(src_addr),
TooManyLogInAttempts)
if id_type == 'immutable':
p_id = Participant.check_id(input_id[1:])
else:
p_id = Participant.get_id_for(id_type, input_id)
try:
p = Participant.authenticate_with_password(p_id, password)
except AccountIsPasswordless:
if id_type == 'email':
state['log-in.email'] = input_id
else:
state['log-in.error'] = _(
"The submitted password is incorrect.")
return
if not p:
state['log-in.error'] = (_(
"The submitted password is incorrect."
) if p_id is not None else _(
"“{0}” is not a valid account ID.", input_id
) if id_type == 'immutable' else _(
"No account has the username “{username}”.",
username=input_id
) if id_type == 'username' else _(
"No account has “{email_address}” as its primary email address.",
email_address=input_id))
else:
website.db.decrement_rate_limit('log-in.password.ip-addr',
str(src_addr))
try:
p.check_password(password, context='login')
except Exception as e:
website.tell_sentry(e)
elif id_type == 'email':
website.db.hit_rate_limit('log-in.email.ip-addr', str(src_addr),
TooManyLogInAttempts)
website.db.hit_rate_limit('log-in.email.ip-net',
get_ip_net(src_addr),
TooManyLogInAttempts)
website.db.hit_rate_limit('log-in.email.country', src_country,
TooManyLogInAttempts)
email = input_id
p = Participant.from_email(email)
if p and p.kind == 'group':
state['log-in.error'] = _(
"{0} is linked to a team account. It's not possible to log in as a team.",
email)
elif p:
if not p.get_email(email).verified:
website.db.hit_rate_limit('log-in.email.not-verified',
email, TooManyLoginEmails)
website.db.hit_rate_limit('log-in.email', p.id,
TooManyLoginEmails)
email_row = p.get_email(email)
p.send_email('login_link',
email_row,
link_validity=SESSION_TIMEOUT)
state['log-in.email-sent-to'] = email
raise LoginRequired
else:
state['log-in.error'] = _(
"No account has “{email_address}” as its primary email address.",
email_address=email)
p = None
else:
state['log-in.error'] = _("\"{0}\" is not a valid email address.",
input_id)
return
elif 'sign-in.email' in body:
response = state['response']
# Check the submitted data
kind = body.pop('sign-in.kind', 'individual')
if kind not in ('individual', 'organization'):
raise response.invalid_input(kind, 'sign-in.kind', 'body')
email = body['sign-in.email']
if not email:
raise response.error(400, 'email is required')
email = normalize_and_check_email_address(email)
currency = (body.get('sign-in.currency') or body.get('currency')
or state.get('currency') or 'EUR')
if currency not in CURRENCIES:
raise response.invalid_input(currency, 'sign-in.currency', 'body')
password = body.get('sign-in.password')
if password:
l = len(password)
if l < PASSWORD_MIN_SIZE or l > PASSWORD_MAX_SIZE:
raise BadPasswordSize
username = body.get('sign-in.username')
if username:
username = username.strip()
Participant.check_username(username)
session_token = body.get('sign-in.token', '')
if session_token:
Participant.check_session_token(session_token)
# Check for an existing account
is_duplicate_request = website.db.hit_rate_limit(
'sign-up.email', email) is None
for i in range(5):
existing_account = website.db.one(
"""
SELECT p
FROM emails e
JOIN participants p ON p.id = e.participant
WHERE lower(e.address) = lower(%s)
AND ( e.verified IS TRUE OR
e.added_time > (current_timestamp - interval '1 day') OR
p.email IS NULL )
ORDER BY p.join_time DESC
LIMIT 1
""", (email, ))
if is_duplicate_request and not existing_account:
# The other thread hasn't created the account yet.
sleep(1)
else:
break
if existing_account:
session = website.db.one(
"""
SELECT id, secret, mtime
FROM user_secrets
WHERE participant = %s
AND id = 1
AND mtime < (%s + interval '6 hours')
AND mtime > (current_timestamp - interval '6 hours')
""", (existing_account.id, existing_account.join_time))
if session and constant_time_compare(session_token,
session.secret.split('.')[0]):
p = existing_account
p.authenticated = True
p.sign_in(response.headers.cookie, session=session)
return p
else:
raise EmailAlreadyTaken(email)
username_taken = website.db.one(
"""
SELECT count(*)
FROM participants p
WHERE p.username = %s
""", (username, ))
if username_taken:
raise UsernameAlreadyTaken(username)
# Rate limit
request = state['request']
src_addr, src_country = request.source, request.country
website.db.hit_rate_limit('sign-up.ip-addr', str(src_addr),
TooManySignUps)
website.db.hit_rate_limit('sign-up.ip-net', get_ip_net(src_addr),
TooManySignUps)
website.db.hit_rate_limit('sign-up.country', src_country,
TooManySignUps)
website.db.hit_rate_limit('sign-up.ip-version', src_addr.version,
TooManySignUps)
# Okay, create the account
with website.db.get_cursor() as c:
request_data = {
'url': request.line.uri.decoded,
'headers': get_recordable_headers(request),
}
p = Participant.make_active(kind,
currency,
username,
cursor=c,
request_data=request_data)
p.set_email_lang(state['locale'].language, cursor=c)
p.add_email(email, cursor=c)
if password:
p.update_password(password)
p.check_password(password, context='login')
p.authenticated = True
p.sign_in(response.headers.cookie, token=session_token, suffix='.in')
website.logger.info(f"a new participant has joined: ~{p.id}")
# We're done, we can clean up the body now
body.pop('sign-in.email')
body.pop('sign-in.currency', None)
body.pop('sign-in.password', None)
body.pop('sign-in.username', None)
body.pop('sign-in.token', None)
return p
def sign_in_with_form_data(body, state):
p = None
_, website = state['_'], state['website']
if body.get('log-in.id'):
request = state['request']
src_addr, src_country = request.source, request.country
website.db.hit_rate_limit('log-in.ip-addr', str(src_addr),
TooManyLogInAttempts)
website.db.hit_rate_limit('log-in.country', src_country,
TooManyLogInAttempts)
id = body.pop('log-in.id').strip()
password = body.pop('log-in.password', None)
k = 'email' if '@' in id else 'username'
if password:
id = Participant.get_id_for(k, id)
p = Participant.authenticate(id, 0, password)
if not p:
state['log-in.error'] = _("Bad username or password.")
else:
try:
p.check_password(password, context='login')
except Exception as e:
website.tell_sentry(e, state)
elif k == 'username':
state['log-in.error'] = _("\"{0}\" is not a valid email address.",
id)
return
else:
email = id
p = Participant.from_email(email)
if p and p.kind == 'group':
state['log-in.error'] = _(
"{0} is linked to a team account. It's not possible to log in as a team.",
email)
elif p:
if not p.get_email(email).verified:
website.db.hit_rate_limit('log-in.email.not-verified',
email, TooManyLoginEmails)
website.db.hit_rate_limit('log-in.email', p.id,
TooManyLoginEmails)
p.start_session()
qs = [('log-in.id', p.id), ('log-in.key', p.session.id),
('log-in.token', p.session.secret)]
p.send_email(
'login_link',
email,
link=p.url('settings/', qs),
link_validity=SESSION_TIMEOUT,
)
state['log-in.email-sent-to'] = email
raise LoginRequired
else:
state['log-in.error'] = _(
"We didn't find any account whose primary email address is {0}.",
email)
p = None
elif 'sign-in.email' in body:
response = state['response']
kind = body.pop('sign-in.kind', 'individual')
if kind not in ('individual', 'organization'):
raise response.error(400, 'bad kind')
email = body.pop('sign-in.email')
if not email:
raise response.error(400, 'email is required')
currency = body.pop('sign-in.currency', 'EUR')
if currency not in CURRENCIES:
raise response.error(
400,
"`currency` value '%s' is invalid of non-supported" % currency)
password = body.pop('sign-in.password', None)
if password:
l = len(password)
if l < PASSWORD_MIN_SIZE or l > PASSWORD_MAX_SIZE:
raise BadPasswordSize
request = state['request']
src_addr, src_country = request.source, request.country
website.db.hit_rate_limit('sign-up.ip-addr', str(src_addr),
TooManySignUps)
website.db.hit_rate_limit('sign-up.ip-net', get_ip_net(src_addr),
TooManySignUps)
website.db.hit_rate_limit('sign-up.country', src_country,
TooManySignUps)
website.db.hit_rate_limit('sign-up.ip-version', src_addr.version,
TooManySignUps)
with website.db.get_cursor() as c:
p = Participant.make_active(
kind,
currency,
body.pop('sign-in.username', None),
cursor=c,
)
p.set_email_lang(state['locale'].language, cursor=c)
p.add_email(email, cursor=c)
if password:
p.update_password(password)
p.check_password(password, context='login')
p.authenticated = True
return p
def sign_in_with_form_data(body, state):
p = None
_, website = state['_'], state['website']
if body.get('log-in.id'):
request = state['request']
src_addr, src_country = request.source, request.country
website.db.hit_rate_limit('log-in.ip-addr', str(src_addr), TooManyLogInAttempts)
website.db.hit_rate_limit('log-in.country', src_country, TooManyLogInAttempts)
id = body.pop('log-in.id').strip()
password = body.pop('log-in.password', None)
k = 'email' if '@' in id else 'username'
if password:
id = Participant.get_id_for(k, id)
p = Participant.authenticate(id, 0, password)
if not p:
state['log-in.error'] = _("Bad username or password.")
else:
try:
p.check_password(password, context='login')
except Exception as e:
website.tell_sentry(e, state)
elif k == 'username':
state['log-in.error'] = _("\"{0}\" is not a valid email address.", id)
return
else:
email = id
p = Participant.from_email(email)
if p and p.kind == 'group':
state['log-in.error'] = _(
"{0} is linked to a team account. It's not possible to log in as a team.",
email
)
elif p:
if not p.get_email(email).verified:
website.db.hit_rate_limit('log-in.email.not-verified', email, TooManyLoginEmails)
website.db.hit_rate_limit('log-in.email', p.id, TooManyLoginEmails)
p.start_session()
qs = [
('log-in.id', p.id),
('log-in.key', p.session.id),
('log-in.token', p.session.secret)
]
p.send_email(
'login_link',
email,
link=p.url('settings/', qs),
link_validity=SESSION_TIMEOUT,
)
state['log-in.email-sent-to'] = email
raise LoginRequired
else:
state['log-in.error'] = _(
"We didn't find any account whose primary email address is {0}.",
email
)
p = None
elif 'sign-in.email' in body:
response = state['response']
# Check the submitted data
kind = body.pop('sign-in.kind', 'individual')
if kind not in ('individual', 'organization'):
raise response.invalid_input(kind, 'sign-in.kind', 'body')
email = body.pop('sign-in.email')
if not email:
raise response.error(400, 'email is required')
email = normalize_email_address(email)
check_email_blacklist(email)
currency = body.pop('sign-in.currency', 'EUR')
if currency not in CURRENCIES:
raise response.invalid_input(currency, 'sign-in.currency', 'body')
password = body.pop('sign-in.password', None)
if password:
l = len(password)
if l < PASSWORD_MIN_SIZE or l > PASSWORD_MAX_SIZE:
raise BadPasswordSize
username = body.pop('sign-in.username', None)
if username:
username = username.strip()
Participant.check_username(username)
session_token = body.pop('sign-in.token', '')
if session_token:
Participant.check_session_token(session_token)
# Check for an existing account
existing_account = website.db.one("""
SELECT p, s.secret
FROM emails e
JOIN participants p ON p.id = e.participant
LEFT JOIN user_secrets s ON s.participant = p.id
AND s.id = 1
AND s.mtime < (p.join_time + interval '6 hours')
AND s.mtime > (current_timestamp - interval '6 hours')
WHERE lower(e.address) = lower(%s)
AND ( e.verified IS TRUE OR
e.added_time > (current_timestamp - interval '1 day') OR
s.secret IS NOT NULL OR
p.email IS NULL )
ORDER BY p.join_time DESC
LIMIT 1
""", (email,))
if existing_account:
p, secret = existing_account
if secret and constant_time_compare(session_token, secret):
p.authenticated = True
p.sign_in(response.headers.cookie, token=session_token)
return p
else:
raise EmailAlreadyTaken(email)
username_taken = website.db.one("""
SELECT count(*)
FROM participants p
WHERE p.username = %s
""", (username,))
if username_taken:
raise UsernameAlreadyTaken(username)
# Rate limit
request = state['request']
src_addr, src_country = request.source, request.country
website.db.hit_rate_limit('sign-up.ip-addr', str(src_addr), TooManySignUps)
website.db.hit_rate_limit('sign-up.ip-net', get_ip_net(src_addr), TooManySignUps)
website.db.hit_rate_limit('sign-up.country', src_country, TooManySignUps)
website.db.hit_rate_limit('sign-up.ip-version', src_addr.version, TooManySignUps)
# Okay, create the account
with website.db.get_cursor() as c:
p = Participant.make_active(kind, currency, username, cursor=c)
p.set_email_lang(state['locale'].language, cursor=c)
p.add_email(email, cursor=c)
if password:
p.update_password(password)
p.check_password(password, context='login')
p.authenticated = True
p.sign_in(response.headers.cookie, token=session_token)
return p
