#103: username field is case sensitive with authreg_mysql
-------------------+--------------------------------------------------------
Reporter: Teresa | Owner: smoku
Type: defect | Status: new
Priority: major | Component: c2s
Version: 2.1.7 | Resolution:
Keywords: | Blocking:
-------------------+--------------------------------------------------------
Comment (by Teresa):
Replying to [comment:4 smoku]:
> * compile c2s with {{{--enable-debug}}}, run c2s with {{{-D}}} switch
and show the SELECT statement that causes login failure for the user
Debug Output for bad case(used jid: '''[EMAIL PROTECTED]'''):
{{{
C2S : sx (sasl_cyrus.c:757) response from client (response:
username="Teresa",realm="kvitka.net",nonce="oZ+0pSJSKbvWUnBdfrjM8/WX
6p1Ln2qzIW//BoVeOjQ=",cnonce="c239834121838916283fcefaaf",nc=00000001,qop=auth
,digest-uri="xmpp/kvitka.net",response=7f5d6fc344d
ebf3aa8f8ddce3c6021b8,charset=utf-8)
C2S : Sun Jul 8 12:46:56 2007 authreg_mysql.c:60 prepared sql: SELECT
`password` FROM `authreg` WHERE `username` = 'Teresa' AND `realm` =
'kvitka.net'
C2S : sx (sasl_cyrus.c:801) sasl handshake failed: SASL(-13):
authentication failure: Requested identity not permitted for authorization
identity
}}}
Debug Output for working case (used jid: '''[EMAIL PROTECTED]'''):
{{{
C2S : Sun Jul 8 12:47:09 2007 [notice] [12] SASL authentication
succeeded: mechanism=DIGEST-MD5; [EMAIL PROTECTED]
}}}
--
Ticket URL: <http://jabberd2.xiaoka.com/ticket/103#comment:7>
jabberd2 <http://jabberd2.xiaoka.com/>
jabberd2 project
_______________________________________________
jabberd2 mailing list
[email protected]
http://lists.xiaoka.com/listinfo.cgi/jabberd2-xiaoka.com
