View Single Post
  #10  
Old 16th October 2010, 06:37
evok evok is offline
Junior Member
 
Join Date: Oct 2010
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Please help

Hi, I am still totally lost here.. Please help.. I uninstalled and reinstalled dovecot and postfix.. and I still am getting the same error.. It is not authenticating the password for some reason.. I have no idea where in the process it is going wrong, but I am really frustrated at this point.. Any help would be greatly appreciate..

Here are my maillogs - you have all my config files for dovecot and postfix above..

Code:
Oct 15 22:30:02 tcfmail dovecot: pop3-login: Disconnected (no auth attempts): rip=127.0.0.1, lip=127.0.0.1, secured
Oct 15 22:30:02 tcfmail dovecot: imap-login: Disconnected (no auth attempts): rip=127.0.0.1, lip=127.0.0.1, secured
Oct 15 22:30:02 tcfmail postfix/smtpd[3640]: connect from localhost.localdomain[127.0.0.1]
Oct 15 22:30:02 tcfmail postfix/smtpd[3640]: lost connection after CONNECT from localhost.localdomain[127.0.0.1]
Oct 15 22:30:02 tcfmail postfix/smtpd[3640]: disconnect from localhost.localdomain[127.0.0.1]
Oct 15 22:30:37 tcfmail clamd[1699]: SelfCheck: Database status OK.
Oct 15 22:31:31 tcfmail dovecot: imap-login: Aborted login (auth failed, 1 attempts): user=<user@tcfcares.net>, method=PLAIN, rip=127.0.0.1, lip=127.0.0.1, secured
Here is the dovecot-sql.conf file..

Code:
driver = mysql
connect = host=localhost dbname=dbispconfig user=<dbusername> password=<long encrypted password string>
default_pass_scheme = CRYPT

password_query = SELECT password FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
user_query = SELECT email as user, maildir as home, CONCAT(maildir, '/Maildir') as mail, uid, gid, CONCAT('maildir:storage=', quota) AS quota, CONCAT(maildir, '/.sieve') as sieve FROM mail_user WHERE email = '%u' AND disable%Ls = 'n'
I checked the MySQL DB and it definately has an encrypted password in it.. So could it be somehow that the system is trying to read the password from somewhere else?

Also in ispconfig3 under - Server config > mail - I noticed that Mailfilter Syntax is set to sieve, is that correct? there is also an option for Maildrop..

Last edited by evok; 16th October 2010 at 07:39. Reason: add dovecot-sql info
Reply With Quote