Re: Locked myself out of my root account? [SOLVED?]

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