Bad SQL query from Squirrelmail

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Cisco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
-----
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@xxxxxxxxxxxxxxxxxxxxx
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users



[Index of Archives]     [Video For Linux]     [Yosemite News]     [Yosemite Photos]     [gtk]     [KDE]     [Cyrus SASL]     [Gimp on Windows]     [Steve's Art]     [Webcams]

  Powered by Linux