+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Support Area (/forum-30.html)
+--- Forum: Update/Upgrade (/forum-44.html)
+--- Thread: "User not found" Problem after upgrade to 1.0.7 with dovecot mail (/thread-14887.html)
"User not found" Problem after upgrade to 1.0.7 with dovecot mail - patrick.geschke - 07-29-2011 06:29 PM
Hey,
i've (somewhat) successfully managed to upgrade my ispcp dovecot installation to 1.0.7.
But now some users can access their emails and the dovecot log gives the following error:
Quote:Jul 29 09:12:53 srv02 dovecot: auth-worker(default): sql(user@domain.tld:
SELECT CONCAT('/var/mail/virtual/', domain.domain_name, '/',mail_acc) AS home,
'1000' AS uid, '8' AS gid FROM mail_users INNER JOIN domain ON
mail_users.domain_id = domain.domain_id WHERE mail_a$
Jul 29 09:12:53 srv02 dovecot: auth-worker(default): sql(user@domain.tld):
User not found
I've checked the DB and the entries exist.
Does someone have an idea on how to fix this?
Thanks in advance!
RE: "User not found" Problem after upgrade to 1.0.7 with dovecot mail - kilburn - 08-02-2011 08:50 PM
The log is truncated to the width of your terminal window. Try to fetch the full sql query being executed and figure out why it is not returning the correct user...
RE: "User not found" Problem after upgrade to 1.0.7 with dovecot mail - joximu - 08-03-2011 12:17 AM
from which ispcp version did you upgrade?