M0rF3uS
23rd April 2008, 22:24
Hi all,
i've followed this: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV)
under debian etch, seems all gone ok, but the imap/pop login with or without tls.
in my logfile i got this:
Apr 23 21:23:10 logubuntu authdaemond: SQL query: SELECT email, password, "", 5000, 5000, /home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", "", "" FROM users WHERE email = "mailbox"
Apr 23 21:23:10 logubuntu authdaemond: mysql_query failed, reconnecting: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',' at line 1
Apr 23 21:23:10 logubuntu authdaemond: mysql_query failed second time, giving up: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',' at line 1
how i can fix this? thank you a lot
p.s. if you need some conf files, just say and i'll paste it
i've followed this: Virtual Users And Domains With Postfix, Courier And MySQL (+ SMTP-AUTH, Quota, SpamAssassin, ClamAV)
under debian etch, seems all gone ok, but the imap/pop login with or without tls.
in my logfile i got this:
Apr 23 21:23:10 logubuntu authdaemond: SQL query: SELECT email, password, "", 5000, 5000, /home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',1),'/'), "", "", "" FROM users WHERE email = "mailbox"
Apr 23 21:23:10 logubuntu authdaemond: mysql_query failed, reconnecting: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',' at line 1
Apr 23 21:23:10 logubuntu authdaemond: mysql_query failed second time, giving up: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/home/vmail, CONCAT(SUBSTRING_INDEX(email,'@',-1),'/',SUBSTRING_INDEX(email,'@',' at line 1
how i can fix this? thank you a lot
p.s. if you need some conf files, just say and i'll paste it