Having now updated from .0.8.4 to 0.9.0, I thought I'd do an audit of the users in the database and am quite surprised by the number of rows with the same username.
I cannot see how these have come about. The last_logins in some cases are very close together and in others they are years apart.
Any clues ? I am guessing there are not supposed to be duplicates.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Glen Eustace, GodZone Internet Services, a division of AGRE Enterprises Ltd., P.O. Box 8020, Palmerston North, New Zealand 4446 Ph: +64 6 357 8168, Fax: +64 6 357 8165, Mob: +64 27 542 4015
"A Ministry specialising in providing low-cost professional Internet Services to NZ Christian Churches, Ministries and Organisations"
On Fri, Apr 19, 2013 at 6:28 AM, Glen Eustace geustace@godzone.net.nz wrote:
Having now updated from .0.8.4 to 0.9.0, I thought I'd do an audit of the users in the database and am quite surprised by the number of rows with the same username.
I cannot see how these have come about. The last_logins in some cases are very close together and in others they are years apart.
Any clues ? I am guessing there are not supposed to be duplicates.
No, there shouldn't be any duplicates of username + mail_host values. But please look closely if there are differences in upper/lower case within these two columns. Depending on your IMAP server's capabilities and settings, you should consider to adjust the $rcmail_config['login_lc'] option which influences this.
Regards, Thomas
On 04/19/2013 11:17 PM, Thomas Bruederli wrote:
No, there shouldn't be any duplicates of username + mail_host values. But please look closely if there are differences in upper/lower case within these two columns. Depending on your IMAP server's capabilities and settings, you should consider to adjust the $rcmail_config['login_lc'] option which influences this.
The duplicates were true duplicates. Many of them had a created and last_login that were identical as well. I have deleted all of these ones if there was another record with a more recent last_login.
I then looked at each of the duplicates and deleted in most cases all but the one with the most recent activity. In a couple of cases there were preferences on an older one so I kept that instead. Whole exercise took a while but we don't have a lot of webmail users.
I am not sure but I think they may have come about using the squirrelmail_usercopy plugin when people have got their password wrong. We haven't supported squirrelmail for quite sometime so I have removed that plugin and will keep an eye on things.
-
Glen Eustace -
Thomas Bruederli