Re: Locked myself out of my root account? [SOLVED?]

Thanks.

It's been like a decade since I set up the previous version, so some of
these details are rusty.

The other issue I am facing right now is that it does not appear that any
Spamassassin rules are being run.  Every message appears to come through
with a score of 0.

-derek

On Sun, November 27, 2022 4:33 pm, jjs - mainphrame wrote:
> I set my custom levels by editing maia/config.php starting after around
> line 150:
>
>  $protection = array(...
>
> Jake
>
>
> On Sun, Nov 27, 2022 at 10:57 AM Derek Atkins <[email protected]> wrote:
>
>> For the record, I seem to have recovered.  Looking in the DB I found my
>> email address in the 'users' table with id=2 but "tied" to the linked
>> account (which had id=12).  I also noticed there was no entry in the
>> maia_users table for my original primary account, and it was missing
>> id=2.
>> So I ran the following two queries:
>>
>> update users set maia_user_id=2 where id=2;
>>
>> insert into maia_users
>>
>> (id,user_name,user_level,reminders,charts,primary_email_id,language,charset,spamtrap,password,auto_whitelist,items_per_page,spam_quarantine_sort,virus_quarantine_sort,header_quarantine_sort,attachment_quarantine_sort,ham_cache_sort,discard_ham,theme_id,quarantine_digest_interval,last_digest_sent,truncate_subject,truncate_email)
>> values (2, '<my_email_address> 'S', 'N', 'N', 2, 'en', 'ISO-8859-1',
>> 'N',
>> NULL,'Y', 50, 'XA', 'DA', 'DA', 'DA', 'XD', 'Y', 2, 0, NULL, 20, 20);
>>
>> Once I did this, I was able to login again and get the to admin page!
>> And
>> then I was able to link the account and email in the correct direction.
>>
>> Hopefully this won't cause other issues down the road.
>>
>> The next thing I'm trying to figure out is where/how I set my "custom
>> levels".
>>
>> -derek
>>
>> On Sun, November 27, 2022 12:41 pm, Derek Atkins wrote:
>> > Hi,
>> >
>> > I am in the process of migrating my mail server to a new server, and
>> > migrating maia along the way.  I had had it all set up, but then I
>> started
>> > to try (re)linking addresses to my account, and apparently I did it in
>> the
>> > "wrong way" and now I locked myself out of my account.  My account
>> *was*
>> > the root account, but now it's linked to a "new user", somehow.
>> >
>> > I have access to the mysql DB but I'm at a loss to figure out how to
>> undo
>> > this mistake.
>> >
>> > When I try to login to my standard user account I get "Attempted login
>> by
>> > linked account rejected.  Please use the primary account"  But if I
>> try
>> to
>> > use the account I linked to (or what I think I linked to), using the
>> > password I got, I get "no login for user".
>> >
>> > If I cannot log in as the root user (which means I do not have access
>> to
>> > the admin page) how can I undo this mistake?
>> >
>> > Help!
>> >
>> > -derek
>> >
>> > --
>> >        Derek Atkins                 617-623-3745
>> >        [email protected]             www.ihtfp.com
>> >        Computer and Internet Security Consultant
>> >
>> > _______________________________________________
>> > Maia-users mailing list
>> > [email protected]
>> > http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
>> >
>>
>>
>> --
>>        Derek Atkins                 617-623-3745
>>        [email protected]             www.ihtfp.com
>>        Computer and Internet Security Consultant
>>
>> _______________________________________________
>> Maia-users mailing list
>> [email protected]
>> http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users
>>
>


-- 
       Derek Atkins                 617-623-3745
       [email protected]             www.ihtfp.com
       Computer and Internet Security Consultant

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