On 1/14/2026 1:41 AM, Stephen J. Turnbull wrote:
Dennis Putnam via Mailman-users writes:> I can't seem to confirm the superuser's email address. Find the address in both the account_emailaddresses table and the addresses table. I'm interested to see the full record for both (you can obscure the email and display_name for this purpose). This is in the interest of figuring out why you are inflooping in the confirmation process.
From database mailmanweb: mysql> show tables; +-----------------------------------+ | Tables_in_mailmanweb | +-----------------------------------+ | account_emailaddress | | account_emailconfirmation | | auth_group | | auth_group_permissions | | auth_permission | | auth_user | | auth_user_groups | | auth_user_user_permissions | | django_admin_log | | django_content_type | | django_mailman3_maildomain | | django_mailman3_profile | | django_migrations | | django_q_ormq | | django_q_schedule | | django_q_task | | django_session | | django_site | | hyperkitty_attachment | | hyperkitty_email | | hyperkitty_favorite | | hyperkitty_lastview | | hyperkitty_mailinglist | | hyperkitty_mailinglist_moderators | | hyperkitty_mailinglist_owners | | hyperkitty_profile | | hyperkitty_sender | | hyperkitty_tag | | hyperkitty_tagging | | hyperkitty_thread | | hyperkitty_threadcategory | | hyperkitty_vote | | postorius_emailtemplate | | socialaccount_socialaccount | | socialaccount_socialapp | | socialaccount_socialapp_sites | | socialaccount_socialtoken | +-----------------------------------+ 37 rows in set (0.00 sec) The table account_emailaddress has 3 entries: mysql> select * from account_emailaddress; +----+-----------------------+----------+---------+---------+ | id | email | verified | primary | user_id | +----+-----------------------+----------+---------+---------+ | 1 | [email protected] | 1 | 1 | 2 | | 2 | [email protected] | 0 | 0 | 3 | | 3 | [email protected] | 1 | 1 | 4 | +----+-----------------------+----------+---------+---------+ 3 rows in set (0.00 sec) Yes, id 1 and 2 are the same email address. From database mailman: mysql> show tables; +--------------------+ | Tables_in_mailman | +--------------------+ | _request | | acceptablealias | | address | | alembic_version | | autoresponserecord | | ban | | bounceevent | | contentfilter | | domain | | domain_owner | | file_cache | | headermatch | | listarchiver | | mailinglist | | member | | message | | onelastdigest | | pended | | pendedkeyvalue | | preferences | | template | | uid | | user | | workflowstate | +--------------------+ 24 rows in set (0.00 sec)I'm not sure what you want to see in this address table. There is a lot of unexpected email addresses that I have no idea where they came from. In any case the user_id in this table does not correspond to the user_id in the table from the previous mailmanweb table. Here are the columns:
+----+---------------------------------------------------+-----------+------------------------+---------------------+---------------------+---------+----------------+| id | email | _original | display_name | verified_on | registered_on | user_id | preferences_id |
+----+---------------------------------------------------+-----------+------------------------+---------------------+---------------------+---------+----------------+
Confirmation you can do with a single SQL update. Find the address in the account_emailaddresses table and update the verified attribute to t. I think that's enough to allow you to log in. If not you should do the same for that address in the addresses table. However, in the addresses table you need to fill the verified field with a timestamp. Not sure how that works in SQL, try copying the value of the registered field. I don't know why you're inflooping though. It's possible that you're verified in one table but not the other, confusing Postorius.
OpenPGP_signature.asc
Description: OpenPGP digital signature
_______________________________________________ Mailman-users mailing list -- [email protected] To unsubscribe send an email to [email protected] https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at: https://lists.mailman3.org/archives/list/[email protected]/message/6FYUGVBUIAU5UFKW536QRLDNBLEPN4VD/ This message sent to [email protected]
