login case sensitivity and user home issue

[Stratop0w]

Hi,

I'm preparing to switch to NC 29 and the external user extention I previously used is not supported anymore, so I tried user_backend_sql_raw as a replacement.

It sounds very good, except that an issue with login sensitivity: if I log with a name like 'foo' or 'Foo', login will succeed, like this should, but then, the two logins will then have different homes, which is the issue.

With internal Nextcloud user login or other external authentication apps I experimented, case sensitivity never caused this issue.

Best regards,
Strato

[bob4os]

I set my SQL statements like this:

'get_password_hash_for_user' => 'SELECT password FROM users WHERE LOWER(username) = LOWER(:username)',
'set_password_hash_for_user' => 'UPDATE users SET password = :new_password_hash WHERE LOWER(username) = LOWER(:username)',
'user_exists' => 'SELECT EXISTS(SELECT 1 FROM users WHERE LOWER(username) = LOWER(:username))',
'get_users' => 'SELECT username FROM users WHERE (LOWER(username) LIKE LOWER(:search)) OR (LOWER(displayname) LIKE LOWER(:search))',
'get_display_name' => 'SELECT displayname FROM users WHERE LOWER(username) = LOWER(:username)',
'set_display_name' => 'UPDATE users SET displayname = :new_display_name WHERE LOWER(username) = LOWER(:username))',
'count_users' => 'SELECT COUNT(*) FROM users',
'delete_user' => 'SELECT EXISTS(SELECT 1 FROM users WHERE LOWER(username) = LOWER(:username))',
'create_user' => 'INSERT INTO users (username, password) VALUES (:username, :password_hash)',

and created a fork to solve this issue for me.
Nextcloud uses the IGetRealUIDBackend for this.

However, I no longer use this app in production.