Re: User created with wrong case

That is correct that there are no messages stored under the 'robert' 
account, however it is not possible to link to the upper-case Robert 
account because that account is not listed on the admin screen, only the 
lower-case version exists.  As I mentioned, there is a mod in place that 
should convert ALL addresses to lowercase.  This has been working for 
more than a decade with the existing configuration, in fact for so long 
that I don't even remember where this change was made at, although it 
must be in a config file because I have obviously gone through multiple 
OS upgrades since using Maia and this feature has always continued to 
work.  And it DOES still continue to work with every other address on 
the server.  I just sent myself a test message from an outside mailbox 
to ShdwDrgn@, then checked in maia and it was correctly sorted under the 
lowercase version of my nick.  But for whatever reason, this one 
specific user is now getting sorted under an uppercase version of his name.

So I'm guessing this may have to be solved by going directly into the 
database (mine is on mysql).  Any suggestions on what table(s) I need to 
look under, and/or what queries I would need to perform to change all 
instances of this username to lowercase?


On 12/3/20 1:59 PM, Bubba Brown wrote:
> You said "robert" had no messages stored, right? So it shouldn't hurt 
> to recreate that account as an alias of the existing "Robert" account.
>
> Best,
>
> Bubba
>
>
> On 12/3/20 12:55 PM, Jeff Taylor wrote:
>> I had thought about that, but won't that drop the messages that are 
>> quarantined?
>>
>>
>> On 11/28/20 2:16 PM, Bubba Brown wrote:
>>> Just off the top of my head, you might be able to nuke the "robert" 
>>> account and create a new "robert" account as a link to the Robert 
>>> account.
>>>
>>> Bubba
>>>
>>>
>>> On 11/25/20 5:03 PM, Jeff Taylor wrote:
>>>> My setup has always used all lower-case user names, in fact I think 
>>>> there was a mod for this years ago to force all names to lowercase 
>>>> at all times.  Recently one of my users informed me that he is no 
>>>> longer seeing anything listed in the overview screen (no spam, ham, 
>>>> viruses, or anything). After much digging I discovered a new 
>>>> account had been created with the first letter capitalized.
>>>>
>>>> Let's say the user's name is Robert... so his actual account name 
>>>> is 'robert', which still exists in Maia, but a new account was 
>>>> created as Robert with the first letter capitalized.  Now if I look 
>>>> under the user screen there is no sign of Robert, only robert is 
>>>> shown, but if I do a search for *domain* I can then see both 
>>>> robert@ and Robert@, however Robert@ is showing thousands of spam 
>>>> and non-spam, while robert@ shows zeros in all columns.
>>>>
>>>> So, since Robert doesn't show up in the list for me to link 
>>>> accounts together, how do I properly get the user's emails back 
>>>> into a place where he can see and sort through the spams?  And how 
>>>> do I ensure that future emails don't keep going to the name with 
>>>> the upper-case letter?
>>>>
>>>> For reference, my server handles email from several different 
>>>> domains, and incoming email comes with a variety of upper and lower 
>>>> case permutations, but everything *should* be forced to lowercase 
>>>> for Maia.  I've dug through, and cannot find any other accounts 
>>>> where an upper-case variation got through, so this is the only 
>>>> mailbox where it has happened.  Any help sorting this out would be 
>>>> appreciated.
>>>> _______________________________________________
>>>> Maia-users mailing list
>>>> [email protected]
>>>> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
>>> _______________________________________________
>>> Maia-users mailing list
>>> [email protected]
>>> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
>>
>> _______________________________________________
>> Maia-users mailing list
>> [email protected]
>> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
> _______________________________________________
> Maia-users mailing list
> [email protected]
> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users