mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Public bug reported:

Currently in the auth/user.php [around line 187] there is  a query that
is matching lower(username) against username

At the very least it should be lower(u.username) against us.username

however the whole sql query could be tidied up to function better.

Normally, usernames are email addresses and are stored as lowecase
strings - but sometimes you need a username that is not lowercase and so
this check fails.

** Affects: mahara
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: In Progress

** Affects: mahara/1.7
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: New

** Affects: mahara/1.8
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: New

** Affects: mahara/1.9
     Importance: High
     Assignee: Robert Lyon (robertl-9)
         Status: New


** Tags: auth

** Also affects: mahara/1.7
   Importance: Undecided
       Status: New

** Also affects: mahara/1.8
   Importance: Undecided
       Status: New

** Also affects: mahara/1.9
   Importance: Undecided
       Status: New

** Changed in: mahara/1.7
   Importance: Undecided => High

** Changed in: mahara/1.9
   Importance: Undecided => High

** Changed in: mahara/1.8
   Importance: Undecided => High

** Changed in: mahara/1.7
     Assignee: (unassigned) => Robert Lyon (robertl-9)

** Changed in: mahara/1.7
    Milestone: None => 1.7.8

** Changed in: mahara/1.8
     Assignee: (unassigned) => Robert Lyon (robertl-9)

** Changed in: mahara/1.8
    Milestone: None => 1.8.5

** Changed in: mahara/1.9
    Milestone: None => 1.9.3

** Changed in: mahara/1.9
     Assignee: (unassigned) => Robert Lyon (robertl-9)

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it!
https://bugs.launchpad.net/bugs/1364170

Title:
  Parent auth fails due to mixed case checking

Status in Mahara ePortfolio:
  In Progress
Status in Mahara 1.7 series:
  New
Status in Mahara 1.8 series:
  New
Status in Mahara 1.9 series:
  New

Bug description:
  Currently in the auth/user.php [around line 187] there is  a query
  that is matching lower(username) against username

  At the very least it should be lower(u.username) against us.username

  however the whole sql query could be tidied up to function better.

  Normally, usernames are email addresses and are stored as lowecase
  strings - but sometimes you need a username that is not lowercase and
  so this check fails.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1364170/+subscriptions