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

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