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

I'm a little rusty myself, but I remember solving a similar problem a few
years ago, I would double check all the settings in the web interface, and
those in maia.conf and maiad.conf

Jake

On Sun, Nov 27, 2022 at 1:36 PM Derek Atkins <[email protected]> wrote:

> 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