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

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.

Thanks,
-Larry

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

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