Re: Locked myself out of my root account? [SOLVED?]
Lawrence Mulder <lmulder-iL7gtBVyNKCGUxFv0Br65wC/[email protected]> Sun, 27 Nov 2022 23:12:59 +0000
| Newsgroups | gmane.mail.virus.maiamailguard |
|---|---|
| Message-ID | <BYAPR05MB49345A876EBB8700310DC648AD109@BYAPR05MB4934.namprd05.prod.outlook.com> |
Derek, Did you try stopping amavisd / maiad and then from a command prompt run: # amavisd debug-sa This should give you a ton of output and perhaps give you some indication of why spamassassin is being "skipped". You can also check your amavisd.conf file to ensure it's configured correctly, and make sure your settings in the web interface are configured to filter spam. Thanks, -Larry -----Original Message----- From: Maia-users <[email protected]> On Behalf Of Derek Atkins Sent: Sunday, November 27, 2022 4:09 PM To: jjs - mainphrame <[email protected]> Cc: [email protected] Subject: Re: [Maia-users] Locked myself out of my root account? [SOLVED?] 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 _______________________________________________ Maia-users mailing list [email protected] http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users