Re: Locked myself out of my root account? [SOLVED?]
"Derek Atkins" <[email protected]> Sun, 27 Nov 2022 18:28:48 -0500
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <[email protected]> |
Well, right now nothing is even showing up in maia. Even this message that I am responding to is not listed. Maia is showing "0" messages in all categories. I wonder if I need to blow away the DB and just start over due to my user-linking brain-o earlier? -derek On Sun, November 27, 2022 6:18 pm, David Sims wrote: > Hi, > > If I remember correctly, spamAssassin requires to use the first 200 > spams (as marked in the UI) and the same number of hams to train its > Bayesian filter… So… Just start marking spams and hams in the UI and > after 200 of each it will start working…. > > Dave > > Sent from my iPhone > >> On Nov 27, 2022, at 4:09 PM, Derek Atkins <[email protected]> wrote: >> >> Hi Jake, >> >>> On Sun, November 27, 2022 4:43 pm, jjs - mainphrame wrote: >>> 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 >> >> Thanks. >> >> I have looked through all the configs and all look correct. Most of >> them >> are set to "undef", the default, to let the script find it. That's how >> the >> old system was set up, too. >> >> The load-sa-rules script gets run every night, and I do get notice that >> (sometimes) new rules get added to the database. >> >> However, even though it appears maia is running, I don't see anything in >> the UI -- no new messages are showing up in any category. For example, >> this came through: >> >> Nov 27 16:59:04 mail maiad[414614]: (414614-05) LMTP::10024 >> /var/lib/maia/tmp/maia-20221127T162033-414614: <[email protected]> -> >> <[email protected]> Received: SIZE=3896 BODY=7BIT from mail.ihtfp.org >> ([127.0.0.1]) by localhost (mail [127.0.0.1]) (maiad, port 10024) with >> LMTP id 414614-05 for <[email protected]>; Sun, 27 Nov 2022 16:59:04 -0500 >> (EST) >> Nov 27 16:59:04 mail maiad[414614]: (414614-05) Checking: >> [94.182.146.22] >> <[email protected]> -> <[email protected]> >> Nov 27 16:59:04 mail maiad[414614]: (414614-05) FWD via SMTP: >> [127.0.0.1]:10025 <[email protected]> -> <[email protected]> >> Nov 27 16:59:04 mail maiad[414614]: (414614-05) Passed CLEAN, >> [94.182.146.22] [197.184.178.212] <[email protected]> -> >> <[email protected]>, Message-ID: >> <[email protected]>, Hits: -, 187 ms >> Nov 27 16:59:04 mail maiad[414614]: (414614-05) Passed CLEAN, >> <[email protected]> -> <[email protected]>, Hits: -, tag=999, tag2=999, >> kill=999, L/0/0/0 >> >> But currently the main page shows '0' messages. >> >> Also, looking for "spamas" in the maillog, all I see are: >> >> Nov 27 14:22:08 mail maiad[413327]: Module Mail::SpamAssassin 3.004006 >> Nov 27 14:22:08 mail maiad[413327]: SpamControl: initializing >> Mail::SpamAssassin >> >> So it's loading it, but as far as I can tell, not actually doing >> anything. >> >> I'm at a loss. :( >> >> -derek >> >>> 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 >>>> >>>> >>> >> >> >> -- >> 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