Re: Locked myself out of my root account? [SOLVED?]
"Derek Atkins" <[email protected]> Sun, 27 Nov 2022 19:54:50 -0500
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <[email protected]> |
That was it. Now it appears to be filtering and scoring properly. Thank you for humoring me. And thank you all for your help! -derek On Sun, November 27, 2022 7:49 pm, Derek Atkins wrote: > Aha, I found the little button next to the email in the Settings -> > Addresses page. > Let's see if those changes make a difference.. > > -derek > > On Sun, November 27, 2022 7:45 pm, Derek Atkins wrote: >> Hi, >> >> On Sun, November 27, 2022 7:32 pm, Lawrence Mulder wrote: >>> Also, if spam filtering is disabled for your user in the web interface, >>> messages will not be scored or stored either. Also, IIRC there is a >>> setting in the admin section of the web internet to cache non-spam >>> items >>> or not. You may need to double check that as well. >> >> I am not sure how to enable/disable it for my user in the web >> interface... >> I've gone through every page I could find and don't see anything. >> >> However, I did put an 'N' in the "spamtrap" setting in the DB for my >> user >> when I recreated it. I noticed it from this log entry, where >> "bypass_spam_checks" is set to "Y". Not sure why "bypass_header_checks" >> is also set to "Y"? >> >> Nov 27 19:32:45 mail maiad[416978]: (416978-01) lookup_sql (cached): >> "[email protected]" matches, result=(bad_header_lover=>"Y", >> banned_files_lover=>"Y", bypass_banned_checks=>"Y", >> bypass_header_checks=>"Y", bypass_spam_checks=>"Y", >> bypass_virus_checks=>"Y", discard_bad_headers=>"N", >> discard_banned_files=>"N", discard_spam=>"N", discard_viruses=>"N", >> email=>"@ihtfp.com", id=>"4", maia_domain_id=>"3", maia_user_id=>"4", >> policy_id=>"4", policy_name=>"@ihtfp.com", priority=>"2", >> spam_kill_level=>"999", spam_lover=>"Y", spam_modifies_subj=>"N", >> spam_quarantine_to=>-, spam_tag2_level=>"999", spam_tag_level=>"999", >> virus_lover=>"Y") >> >> not sure if "spamtrap" is the right setting? >> >> -derek >> >>> >>> Thanks, >>> -Larry >>> >>> -----Original Message----- >>> From: Derek Atkins <[email protected]> >>> Sent: Sunday, November 27, 2022 6:31 PM >>> To: Lawrence Mulder <[email protected]> >>> Cc: David Sims <[email protected]>; [email protected] >>> Subject: RE: [Maia-users] Locked myself out of my root account? >>> [SOLVED?] >>> >>> Hi, >>> >>> On Sun, November 27, 2022 7:22 pm, Lawrence Mulder wrote: >>>> Granted, but if you start over with a fresh DB and it still doesn't >>>> work, >>>> it is for naught. In any case, it would be nice to know what the >>>> issue >>>> is. Have you increased the verbosity of your logging? It sounds like >>>> maia thinks all your messages are whitelisted which won't get stored >>>> in >>>> the DB. >>> >>> Not sure why it would think that. There are some entries in the W/B >>> list, >>> but not sure why "everything" would be whitelisted. >>> >>> Good point on the logging -- I increased from level 1 to 5 in maiad and >>> restarted, so.. We'll see what it says on the next message >>> >>>> >>>> Thanks, >>>> -Larry >>> >>> -derek >>> >>>> >>>> -----Original Message----- >>>> From: Derek Atkins <[email protected]> >>>> Sent: Sunday, November 27, 2022 6:19 PM >>>> To: Lawrence Mulder <[email protected]> >>>> Cc: David Sims <[email protected]>; [email protected] >>>> Subject: RE: [Maia-users] Locked myself out of my root account? >>>> [SOLVED?] >>>> >>>> HI, >>>> >>>> On Sun, November 27, 2022 7:10 pm, Lawrence Mulder wrote: >>>>> I wouldn't do that. It sounds like a configuration issue and not a >>>>> DB >>>>> issue. >>>> >>>> Well, this is a fresh install of maia, for all intents and purposes, >>>> so >>>> if >>>> I need to "start over" I might as well. >>>> >>>> The fact that no new mail is showing up in the UI is worrisome, >>>> considering there is nothing in the logs to indicate that maia is NOT >>>> processing them. The fact that 'select count(*) from maia_mail;' does >>>> not >>>> appear to be increasing is also worrisome. >>>> >>>> Sure, this COULD be a config issue. Or it could have been broken when >>>> I >>>> accidentally linked my (root) user to another 'account' and tried to >>>> fix >>>> it by the DB. I could easily have missed something when "fixing" it. >>>> So >>>> restarting it would be the simplest thing as it has no data right now. >>>> >>>>> >>>>> Thanks, >>>>> -Larry >>>> >>>> -derek >>>> >>>>> >>>>> -----Original Message----- >>>>> From: Maia-users <[email protected]> On Behalf Of >>>>> Derek >>>>> Atkins >>>>> Sent: Sunday, November 27, 2022 5:29 PM >>>>> To: David Sims <[email protected]> >>>>> Cc: [email protected] >>>>> Subject: Re: [Maia-users] Locked myself out of my root account? >>>>> [SOLVED?] >>>>> >>>>> 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 >>>>> >>>> >>>> >>>> -- >>>> 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 >>> >>> >> >> >> -- >> 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