Bug #1342

Usernames are case sensitive/insensitive depending on the DB backend

Added by Daniel Molina almost 9 years ago. Updated about 8 years ago.

Status:NewStart date:07/09/2012
Priority:LowDue date:
Assignee:-% Done:

0%

Category:Core & System
Target version:-
Resolution: Pull request:
Affected Versions:OpenNebula 3.6

Description

When using a MYSQL backend, user names are case-insensitive.
When using a SQLite backend, user names are case-sensitive.

The OpenNebula core should handle this difference

History

#1 Updated by Ruben S. Montero almost 9 years ago

  • Category set to Core & System
  • Target version changed from Release 3.8 to Release 4.0

As noted by Christopher Barry

If you want a column always to be treated in case-sensitive fashion,
declare it with a case sensitive or binary collation. See Section
13.1.10, “CREATE TABLE Syntax”.
http://dev.mysql.com/doc/refman/5.0/en/create-table.html

We are postponing this, as it may cause some incompatibility issues with current verions

Thanks for the head up

#2 Updated by Ruben S. Montero over 8 years ago

  • Target version changed from Release 4.0 to Release 4.2

#3 Updated by Ruben S. Montero about 8 years ago

  • Priority changed from Normal to Low

#4 Updated by Ruben S. Montero about 8 years ago

  • Target version deleted (Release 4.2)

Also available in: Atom PDF