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

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
>

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