Re: Locked myself out of my root account? [SOLVED?]
"Derek Atkins" <[email protected]> Sun, 27 Nov 2022 19:49:57 -0500
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <[email protected]> |
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 _______________________________________________ Maia-users mailing list [email protected] http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users