Dennis Putnam via Mailman-users writes:
From database mailmanweb:
mysql> show tables;
I'm sorry for the typo for account_emailaddress, but I don't need this. I know what tables mailmanweb creates, and what tables mailman creates.
The table account_emailaddress has 3 entries:
mysql> select * from account_emailaddress; +----+-----------------------+----------+---------+---------+ | id | email� � � � � � � � �| verified | primary | user_id | +----+-----------------------+----------+---------+---------+ |� 1 | uuuu@ddddddddd.net� � |� � � � 1 |� � � �1 |� � � �2 | |� 2 | uuuu@ddddddddd.net� � |� � � � 0 |� � � �0 |� � � �3 | |� 3 | xxxxxxxx@gmail.com |� � � � 1 |� � � �1 |� � � �4 | +----+-----------------------+----------+---------+---------+ 3 rows in set (0.00 sec)
Yes, id 1 and 2 are the same email address.
I asked for the superuser ONLY. I assume "xxxxxxxx" is irrelevant and "uuuu" is the superuser, and I guess the duplicate is probably why you have the verification loop, as Mark did. Please check the logs for a backtrace indicating that the address uuuu@ddddddddd.net was found twice. I'm not sure it will be there, but if it is, I'd like to see it (the whole thing including the specific exception).
I'm not sure what you want to see in this address table.
I want to see the address of the superuser (if it's there, it might not be). That's why I specified a WHERE clause.
There is a lot of unexpected email addresses that I have no idea where they came from.
Why "unexpected"? I seem to recall you tried a migration of your list from Mailman 2 at some point. Deleting your Mailman 3 installation will not delete the MySQL databases. You need to do explicit DROPs on them from an SQL application. Mailman 3 does not do that for you.
In any case the user_id in this table does not correspond to the user_id in the table from the previous mailmanweb table.
I still want to see the query results (with the WHERE clause, please). The user_ids need not be equal. Addresses in mailmanweb are many-to- one with users, and addresses in mailman are many-to-one with users, so addresses are used to identify users in both databases.
-- GNU Mailman consultant (installation, migration, customization) Sirius Open Source https://www.siriusopensource.com/ Software systems consulting in Europe, North America, and Japan