Bug: da_sso_<ID> user does not belong to you when deleting a database

k1l0b1t

Verified User
Joined
May 10, 2020
Messages
526
Location
Belgium
When deleting a database, I get the following error:

Error deleting database(s)​

The user da_sso_3uiuKotcj does not belong to you

Database is deleted (at least, as far as I can see).
SSO user does not get deleted.

To reproduce: create database, log in to sso (just that db's sso user), close phpmyadmin and delete the database.

DA version 1.62.4, Cent7, MariaDB 10.5

@smtalk
 
still happening...

I did notice the entries get deleted eventualy though. the mysql.user table is not filling up with random sso users, they seem to clear up at night though.
 
Same here:
  1. Created a DB
  2. Login to phpmyadmin with SSO
  3. Return to DA and delete the DB
1628261116260.png
 

FYI, should be fixed in the "alpha" binaries now.
It will be in the next release (after 1.63.5), as 1.63.5 is already locked in the release candidate phase.

Also, after testing, it does look like the DB and all normal Users are correctly being deleted.
The da_sso_* users are all listed in a file, so should in theory be cleaned up by the dataskq after they expired.

John
 
Back
Top