[SOLVED] courier replaced with dovecot one mail users can't auth unknown user

[SOLVED] courier replaced with dovecot one mail users can't auth unknown user - Printable Version

+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Usage (/forum-34.html)
+--- Thread: [SOLVED] courier replaced with dovecot one mail users can't auth unknown user (/thread-5909.html)

[SOLVED] courier replaced with dovecot one mail users can't auth unknown user - gilbert - 03-03-2009 10:09 PM

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

RE: courier replaced with dovecot one mail users can't auth unknown user - sci2tech - 03-04-2009 02:31 AM

There is a BIG how to obout dovecot. Mail password are now encrypted on database.

RE: courier replaced with dovecot one mail users can't auth unknown user - gilbert - 03-04-2009 03:48 AM

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

RE: courier replaced with dovecot one mail users can't auth unknown user - BeNe - 03-04-2009 04:06 AM

Is this an Aliasdomain ?

Greez BeNe

RE: courier replaced with dovecot one mail users can't auth unknown user - gilbert - 03-04-2009 04:09 AM

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

RE: courier replaced with dovecot one mail users can't auth unknown user - sci2tech - 03-04-2009 04:22 AM

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.

RE: courier replaced with dovecot one mail users can't auth unknown user - gilbert - 03-04-2009 04:40 AM

(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

RE: courier replaced with dovecot one mail users can't auth unknown user - sci2tech - 03-04-2009 04:52 AM

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

RE: courier replaced with dovecot one mail users can't auth unknown user - gilbert - 03-04-2009 04:55 AM

(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

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

Thanks for your excellent help.

RE: courier replaced with dovecot one mail users can't auth unknown user - sci2tech - 03-04-2009 05:01 AM

Glad to help Wink

And I`ll modify for you.