Project InfoSponsor & PartnerInstalling ispCPFAQDocumentationDevelopment
Current time: 11-14-2024, 07:31 AM Hello There, Guest! (Login — Register)

ispCP - Board - Support / ispCP Omega Support Area / Usage v / [SOLVED] courier replaced with dovecot one mail users can't auth unknown user

Post Reply 
[SOLVED] courier replaced with dovecot one mail users can't auth unknown user
Author Message
gilbert Offline
Junior Member
*

Posts: 45
Joined: May 2007
Reputation: 0
Post: #1
[SOLVED] courier replaced with dovecot one mail users can't auth unknown user
Hi,

We have recently upgraded to RC7 and mostly all is well.
All mail seems to be ok.
we have replaced dovecot with courier
we have pysieved installed to allow users to have vacation message access from webmail.

The problems occurs with 1 user.
I have tried to delete the user and re-add the user
reset the password with no success.

This user can't auth for mail.

Any suggestions would be welcome


Code:
Mar  3 07:04:55 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): execute: /var/www/ispcp/engine/ispcp-pysieved-mngr /usr/lib/dovecot/checkpassword-reply
Mar  3 07:04:55 joe dovecot: ispcp-pysieved-mngr[17017]: got data: the_fishers@dido.ca
Mar  3 07:04:55 joe dovecot: Bad username "the_fishers@dido.ca" from 24.103.180.6 to POP3 server
Mar  3 07:04:55 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): Received no input
Mar  3 07:04:55 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): exit_status=1
Mar  3 07:04:55 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): Login failed (status=1)
Mar  3 07:04:55 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): query: SELECT md5(mail_pass) as password FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='the_fishers' and concat(subdomain.subdomain_name,".",domain.domain_name)='dido.ca';
Mar  3 07:04:55 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): unknown user
Mar  3 07:04:55 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): query: SELECT md5(mail_pass) as password FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='the_fishers' and concat(subdomain.subdomain_name,".",domain.domain_name)='dido.ca';
Mar  3 07:04:55 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): unknown user
Mar  3 07:04:57 joe dovecot: auth(pysieved): client out: FAIL^I1^Iuser=the_fishers@dido.ca
Mar  3 07:04:58 joe dovecot: auth(default): checkpassword(the_fishers@dido.ca,24.103.180.6): execute: /var/www/ispcp/engine/ispcp-dovecot-mngr /usr/lib/dovecot/checkpassword-reply
Mar  3 07:04:58 joe dovecot: Bad username "the_fishers@dido.ca" from 24.103.180.6 to POP3 server
Mar  3 07:04:58 joe dovecot: auth(default): checkpassword(the_fishers@dido.ca,24.103.180.6): Received no input
Mar  3 07:04:58 joe dovecot: auth(default): checkpassword(the_fishers@dido.ca,24.103.180.6): exit_status=1
Mar  3 07:04:58 joe dovecot: auth(default): checkpassword(the_fishers@dido.ca,24.103.180.6): Login failed (status=1)
Mar  3 07:05:00 joe dovecot: auth(default): client out: FAIL^I2^Iuser=the_fishers@dido.ca
Mar  3 07:05:01 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): execute: /var/www/ispcp/engine/ispcp-pysieved-mngr /usr/lib/dovecot/checkpassword-reply
Mar  3 07:05:01 joe dovecot: ispcp-pysieved-mngr[17022]: got data: the_fishers@dido.ca
Mar  3 07:05:01 joe dovecot: Bad username "the_fishers@dido.ca" from 24.103.180.6 to POP3 server
Mar  3 07:05:01 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): Received no input
Mar  3 07:05:01 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): exit_status=1
Mar  3 07:05:01 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): Login failed (status=1)
Mar  3 07:05:01 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): query: SELECT md5(mail_pass) as password FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='the_fishers' and concat(subdomain.subdomain_name,".",domain.domain_name)='dido.ca';
Mar  3 07:05:01 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): unknown user
Mar  3 07:05:01 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): query: SELECT md5(mail_pass) as password FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='the_fishers' and concat(subdomain.subdomain_name,".",domain.domain_name)='dido.ca';
Mar  3 07:05:01 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): unknown user
Mar  3 07:05:01 joe dovecot: auth(pysieved): client out: FAIL^I3^Iuser=the_fishers@dido.ca
Mar  3 07:05:04 joe dovecot: pop3-login: Disconnected: user=<the_fishers@dido.ca>, method=PLAIN, rip=24.103.180.6, lip=64.86.63.150
(This post was last modified: 03-04-2009 05:02 AM by sci2tech.)
03-03-2009 10:09 PM
Find all posts by this user Quote this message in a reply
sci2tech Away
Senior Member
****

Posts: 1,285
Joined: Jan 2007
Reputation: 23
Post: #2
RE: courier replaced with dovecot one mail users can't auth unknown user
There is a BIG how to obout dovecot. Mail password are now encrypted on database.
03-04-2009 02:31 AM
Visit this user's website Find all posts by this user Quote this message in a reply
gilbert Offline
Junior Member
*

Posts: 45
Joined: May 2007
Reputation: 0
Post: #3
RE: courier replaced with dovecot one mail users can't auth unknown user
(03-04-2009 02:31 AM)sci2tech Wrote:  There is a BIG how to obout dovecot. Mail password are now encrypted on database.

Right, I and we did the whole thing.
All email accounts work fine.
It's only this one email out of over 1000 that has any problems.

Any suggestions.

Gilbert.
03-04-2009 03:48 AM
Find all posts by this user Quote this message in a reply
BeNe Offline
Moderator
*****
Moderators

Posts: 5,899
Joined: Jan 2007
Reputation: 68
Post: #4
RE: courier replaced with dovecot one mail users can't auth unknown user
Is this an Aliasdomain ?

Greez BeNe
03-04-2009 04:06 AM
Visit this user's website Find all posts by this user Quote this message in a reply
gilbert Offline
Junior Member
*

Posts: 45
Joined: May 2007
Reputation: 0
Post: #5
RE: courier replaced with dovecot one mail users can't auth unknown user
(03-04-2009 04:06 AM)BeNe Wrote:  Is this an Aliasdomain ?

Greez BeNe

It should not be.

What can I post from the database to make sure.

Other users from the same domain work very well.
03-04-2009 04:09 AM
Find all posts by this user Quote this message in a reply
sci2tech Away
Senior Member
****

Posts: 1,285
Joined: Jan 2007
Reputation: 23
Post: #6
RE: courier replaced with dovecot one mail users can't auth unknown user
I did not read carefully. Sorry. If something is wrong with dovecot auth script, output will go to syslog. See if anything useful can be found there.
03-04-2009 04:22 AM
Visit this user's website Find all posts by this user Quote this message in a reply
gilbert Offline
Junior Member
*

Posts: 45
Joined: May 2007
Reputation: 0
Post: #7
RE: courier replaced with dovecot one mail users can't auth unknown user
(03-04-2009 04:22 AM)sci2tech Wrote:  I did not read carefully. Sorry. If something is wrong with dovecot auth script, output will go to syslog. See if anything useful can be found there.

This is what is in syslog

Code:
Mar  3 13:39:23 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): execute: /var/www/ispcp/engine/ispcp-pysieved-mngr /usr/lib/dovecot/checkpassword-reply
Mar  3 13:39:23 joe dovecot: ispcp-pysieved-mngr[23481]: got data: the_fishers@dido.ca
Mar  3 13:39:23 joe dovecot: Bad username "the_fishers@dido.ca" from 24.103.180.6 to POP3 server
Mar  3 13:39:23 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): Received no input
Mar  3 13:39:23 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): exit_status=1
Mar  3 13:39:23 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): Login failed (status=1)
Mar  3 13:39:23 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): query: SELECT md5(mail_pass) as password FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='the_fishers' and concat(subdomain.subdomain_name,".",domain.domain_name)='dido.ca';
Mar  3 13:39:23 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): unknown user
Mar  3 13:39:23 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): query: SELECT md5(mail_pass) as password FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='the_fishers' and concat(subdomain.subdomain_name,".",domain.domain_name)='dido.ca';
Mar  3 13:39:23 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): unknown user
Mar  3 13:39:25 joe dovecot: auth(pysieved): client out: FAIL^I1^Iuser=the_fishers@dido.ca
Mar  3 13:39:26 joe dovecot: auth(default): checkpassword(the_fishers@dido.ca,24.103.180.6): execute: /var/www/ispcp/engine/ispcp-dovecot-mngr /usr/lib/dovecot/checkpassword-reply
Mar  3 13:39:26 joe dovecot: Bad username "the_fishers@dido.ca" from 24.103.180.6 to POP3 server
Mar  3 13:39:26 joe dovecot: auth(default): checkpassword(the_fishers@dido.ca,24.103.180.6): Received no input
Mar  3 13:39:26 joe dovecot: auth(default): checkpassword(the_fishers@dido.ca,24.103.180.6): exit_status=1
Mar  3 13:39:26 joe dovecot: auth(default): checkpassword(the_fishers@dido.ca,24.103.180.6): Login failed (status=1)
Mar  3 13:39:27 joe dovecot: auth(default): client out: FAIL^I2^Iuser=the_fishers@dido.ca
Mar  3 13:39:28 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): execute: /var/www/ispcp/engine/ispcp-pysieved-mngr /usr/lib/dovecot/checkpassword-reply
Mar  3 13:39:28 joe dovecot: ispcp-pysieved-mngr[23499]: got data: the_fishers@dido.ca
Mar  3 13:39:28 joe dovecot: Bad username "the_fishers@dido.ca" from 24.103.180.6 to POP3 server
Mar  3 13:39:28 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): Received no input
Mar  3 13:39:28 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): exit_status=1
Mar  3 13:39:28 joe dovecot: auth(pysieved): checkpassword(the_fishers@dido.ca,24.103.180.6): Login failed (status=1)
Mar  3 13:39:28 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): query: SELECT md5(mail_pass) as password FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='the_fishers' and concat(subdomain.subdomain_name,".",domain.domain_name)='dido.ca';
Mar  3 13:39:28 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): unknown user
Mar  3 13:39:28 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): query: SELECT md5(mail_pass) as password FROM (mail_users INNER JOIN subdomain ON mail_users.sub_id = subdomain.subdomain_id) INNER JOIN domain ON mail_users.domain_id = domain.domain_id WHERE mail_acc='the_fishers' and concat(subdomain.subdomain_name,".",domain.domain_name)='dido.ca';
Mar  3 13:39:28 joe dovecot: auth-worker(pysieved): sql(the_fishers@dido.ca,24.103.180.6): unknown user
Mar  3 13:39:29 joe dovecot: auth(pysieved): client out: FAIL^I3^Iuser=the_fishers@dido.ca
Mar  3 13:39:31 joe dovecot: pop3-login: Disconnected: user=<the_fishers@dido.ca>, method=PLAIN, rip=24.103.180.6, lip=64.86.63.150
(This post was last modified: 03-04-2009 04:52 AM by BeNe.)
03-04-2009 04:40 AM
Find all posts by this user Quote this message in a reply
sci2tech Away
Senior Member
****

Posts: 1,285
Joined: Jan 2007
Reputation: 23
Post: #8
RE: courier replaced with dovecot one mail users can't auth unknown user
Find this line
Code:
if ($username =~ /^(([a-z0-9\-]+\.?)+)@(([a-z0-9\-]+\.?)+)$/) {
and replace with
Code:
if ($username =~ /^(([a-z0-9_\-]+\.?)+)@(([a-z0-9\-]+\.?)+)$/) {
in ispcp-dovecot-mngr. It seems that I must work this regexp a little more Wink
(This post was last modified: 03-04-2009 04:52 AM by sci2tech.)
03-04-2009 04:52 AM
Visit this user's website Find all posts by this user Quote this message in a reply
gilbert Offline
Junior Member
*

Posts: 45
Joined: May 2007
Reputation: 0
Post: #9
RE: courier replaced with dovecot one mail users can't auth unknown user
(03-04-2009 04:52 AM)sci2tech Wrote:  Find this line
Code:
if ($username =~ /^(([a-z0-9\-]+\.?)+)@(([a-z0-9\-]+\.?)+)$/) {
and replace with
Code:
if ($username =~ /^(([a-z0-9_\-]+\.?)+)@(([a-z0-9\-]+\.?)+)$/) {
in ispcp-dovecot-mngr. It seems that I must work this regexp a little more Wink


Don't know how to mark this as solved but it has fixed the problem.

Thanks for your excellent help.
03-04-2009 04:55 AM
Find all posts by this user Quote this message in a reply
sci2tech Away
Senior Member
****

Posts: 1,285
Joined: Jan 2007
Reputation: 23
Post: #10
RE: courier replaced with dovecot one mail users can't auth unknown user
Glad to help Wink And I`ll modify for you.
03-04-2009 05:01 AM
Visit this user's website Find all posts by this user Quote this message in a reply
Post Reply 


Forum Jump:


User(s) browsing this thread: 1 Guest(s)

Contact Us | isp Control Panel ( ispCP ) | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication