forked from matrix-org/synapse-email-account-validity
-
Notifications
You must be signed in to change notification settings - Fork 0
Home
mcalinghee edited this page Oct 17, 2024
·
1 revision
Welcome to the synapse-email-account-validity wiki!
If the configuration changes in particular period and send_renewal_email_at:
- we need to reset the module by apply the following statement :
TRUNCATE TABLE email_account_validity;
TRUNCATE TABLE email_status_account_validity;- restart the module
-- Display expiration date and configured period
SELECT email_account_validity.user_id, to_char(to_timestamp(email_account_validity.expiration_ts_ms/1000),'YYYY-MM-DD HH24:MI:SS'), to_char(to_timestamp(email_status_account_validity.renewal_period_in_ts/1000),'YYYY-MM-DD HH24:MI:SS'), email_status_account_validity.email_sent FROM email_account_validity LEFT JOIN email_status_account_validity ON email_status_account_validity.user_id = email_account_validity.user_id where email_account_validity.user_id LIKE '%john%';