[SM-USERS] Bad SQL query from Squirrelmail

[Dotan C. <dot...@gm...>]

Hi all, new Squirrelmail admin here.

Running the latest Squirrelmail on CentOS 6, my valid users get the
message "Unknown user or password incorrect." when logging in. I see
this in the maillog:

Oct 24 13:36:18 sharingcenterservers dovecot: auth: Error: mysql:
Query failed, retrying: 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 '��someUser’' at line 1
Oct 24 13:36:18 sharingcenterservers dovecot: auth: Error:
sql(beer,127.0.0.1): Password query failed: 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 '��someUser’' at line 1
Oct 24 13:36:20 sharingcenterservers dovecot: imap-login: Aborted
login (auth failed, 1 attempts): user=<beer>, method=PLAIN,
rip=127.0.0.1, lip=127.0.0.1, mpid=0, secured
Oct 24 13:36:30 sharingcenterservers dovecot: auth: Error: mysql:
Query failed, retrying: 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 '��anotherUser’' at line 1
Oct 24 13:36:30 sharingcenterservers dovecot: auth: Error:
sql(gadi,127.0.0.1): Password query failed: 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 '��anotherUser’' at line 1
Oct 24 13:36:32 sharingcenterservers dovecot: imap-login: Aborted
login (auth failed, 1 attempts): user=<gadi>, method=PLAIN,
rip=127.0.0.1, lip=127.0.0.1, mpid=0, secured


Note that someUser and anotherUser are both valid usernames on the
system. The username and the password are identical (someUser:someUser
and anotherUser:anotherUser). I can successfully log into ssh with
these usernames.

What could be the issue? Thanks!



-- 
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com