Projects tigase _server server-core Issues #32
User ID character case in DB (#32)
Artur Hefczyc opened 1 decade ago
Due Date
2011-03-30

I have just fixed schema in MySQL so it allows for storing user accounts using any character case, like: TestCase@example.com but it does not allow to create multiple accounts which only differ in character cases. So if you try to create another account like: testcase@example.com you will get "duplicate entry" error.

(I am talking about stored procedures API only here).

We need to do the same modifications for other supported databases too: PostgreSQL and Derby.

Artur Hefczyc commented 1 decade ago

I think this is a correct behavior now.

Allowing to create different accounts which differ only in the character case could be very confusing and could lead to serious abuse and security issues. Moreover, according to RFC, BareJID is character case insensitive. So we really do not want to allow to create accounts with different character case.

issue 1 of 1
Type
Bug
Priority
Minor
Assignee
RedmineID
68
Version
tigase-server-5.1.0
Issue Votes (0)
Watchers (0)
Reference
tigase/_server/server-core#32
Please wait...
Page is in error, reload to recover