Re: Locked myself out of my root account? [SOLVED?]
"Derek Atkins" <[email protected]> Sun, 27 Nov 2022 20:02:06 -0500
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <[email protected]> |
indeed. Luckily I did not lose any sleep over this. Literally only been working on this for about 10 hours, though :) -derek On Sun, November 27, 2022 7:56 pm, Lawrence Mulder wrote: > Awesome! Amazing sometimes it’s a simple checkbox that causes us to chase > rabbits down holes all over the place. Ah, the joys. > > Glad to help! > Cheers, > -Larry > > -----Original Message----- > From: Derek Atkins <[email protected]> > Sent: Sunday, November 27, 2022 6:55 PM > To: Derek Atkins <[email protected]> > Cc: Lawrence Mulder <[email protected]>; David Sims > <[email protected]>; [email protected] > Subject: Re: [Maia-users] Locked myself out of my root account? [SOLVED?] > > 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 > > -- 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