Re: 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

_______________________________________________
Maia-users mailing list
[email protected]
http://www.renaissoft.com/cgi-bin/mailman/listinfo/maia-users