def check_connect_token(self, token):
return (self.connect_token
and constant_time_compare(self.connect_token, token)
and self.connect_expires > utcnow())
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 authenticate_user_if_possible(csrf_token, request, response, state, user,
_):
"""This signs the user in.
"""
if state.get('etag'):
return
db = state['website'].db
if not db:
return
# Try to authenticate the user
# We want to try cookie auth first, but we want password and email auth to
# supersede it.
session_p = None
if SESSION in request.headers.cookie:
creds = request.headers.cookie[SESSION].value.split(':', 2)
if len(creds) == 2:
creds = [creds[0], 1, creds[1]]
if len(creds) == 3:
session_p, state[
'session_status'] = Participant.authenticate_with_session(
*creds,
allow_downgrade=True,
cookies=response.headers.cookie)
if session_p:
user = state['user'] = session_p
p = None
session_suffix = ''
redirect = False
redirect_url = None
if request.method == 'POST':
# Form auth
body = _get_body(request)
if body:
redirect = body.get('form.repost', None) != 'true'
redirect_url = body.get('sign-in.back-to')
# Remove email address from blacklist if requested
email_address = body.pop('email.unblacklist', None)
if email_address:
remove_email_address_from_blacklist(email_address, user,
request)
# Proceed with form auth
carry_on = body.pop('log-in.carry-on', None)
if carry_on:
can_carry_on = (session_p is not None
and session_p.session_type != 'ro'
and session_p.get_email_address() == carry_on)
if not can_carry_on:
state['log-in.carry-on'] = carry_on
raise LoginRequired
else:
p = sign_in_with_form_data(body, state)
if p:
if not p.session:
session_suffix = '.pw' # stands for "password"
else:
redirect = False
elif request.method == 'GET':
if request.qs.get('log-in.id') or request.qs.get('email.id'):
# Prevent email software from messing up an email log-in or confirmation
# with a single GET request. Also, show a proper warning to someone trying
# to log in while cookies are disabled.
require_cookie(state)
if request.qs.get('log-in.id'):
# Email auth
id = request.qs.get_int('log-in.id')
session_id = request.qs.get('log-in.key')
if not session_id or session_id < '1001' or session_id > '1010':
raise response.render('simplates/log-in-link-is-invalid.spt',
state)
token = request.qs.get('log-in.token')
if not (token and token.endswith('.em')):
raise response.render('simplates/log-in-link-is-invalid.spt',
state)
required = request.qs.parse_boolean('log-in.required',
default=True)
p = Participant.authenticate_with_session(
id,
session_id,
token,
allow_downgrade=not required,
cookies=response.headers.cookie,
)[0]
if p:
if p.id != user.id:
submitted_confirmation_token = request.qs.get(
'log-in.confirmation')
if submitted_confirmation_token:
expected_confirmation_token = b64encode_s(
blake2b(
token.encode('ascii'),
key=csrf_token.token.encode('ascii'),
digest_size=48,
).digest())
confirmation_tokens_match = constant_time_compare(
expected_confirmation_token,
submitted_confirmation_token)
if not confirmation_tokens_match:
raise response.invalid_input(
submitted_confirmation_token,
'log-in.confirmation', 'querystring')
del request.qs['log-in.confirmation']
else:
raise response.render(
'simplates/log-in-link-is-valid.spt', state)
redirect = True
db.run(
"""
DELETE FROM user_secrets
WHERE participant = %s
AND id = %s
AND mtime = %s
""", (p.id, p.session.id, p.session.mtime))
p.session = None
session_suffix = '.em'
elif required:
raise response.render('simplates/log-in-link-is-invalid.spt',
state)
del request.qs['log-in.id'], request.qs['log-in.key'], request.qs[
'log-in.token']
request.qs.pop('log-in.required', None)
# Handle email verification
email_id = request.qs.get_int('email.id', default=None)
email_nonce = request.qs.get('email.nonce', '')
if email_id and not request.path.raw.endswith('/disavow'):
email_participant, email_is_already_verified = db.one(
"""
SELECT p, e.verified
FROM emails e
JOIN participants p On p.id = e.participant
WHERE e.id = %s
""", (email_id, ),
default=(None, None))
if email_participant:
result = email_participant.verify_email(
email_id, email_nonce, p or user, request)
state['email.verification-result'] = result
request.qs.pop('email.id', None)
request.qs.pop('email.nonce', None)
if result == EmailVerificationResult.SUCCEEDED:
request.qs.add(
'success',
b64encode_s(_("Your email address is now verified.")))
del email_participant
# Set up the new session
if p:
if p.status == 'closed':
p.update_status('active')
if session_p:
p.regenerate_session(session_p.session,
response.headers.cookie,
suffix=session_suffix)
if not p.session:
p.sign_in(response.headers.cookie, suffix=session_suffix)
state['user'] = p
# Redirect if appropriate
if redirect:
if not redirect_url:
# Build the redirect URL with the querystring as it is now (we've
# probably removed items from it at this point).
redirect_url = request.path.raw + request.qs.serialize()
response.redirect(redirect_url, trusted_url=False)
def check_connect_token(self, token):
return (
self.connect_token and
constant_time_compare(self.connect_token, token) and
self.connect_expires > utcnow()
)
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
