MariaDB and the MySQL module, which stable version is compatible with the user permission feature?

Virtualmin
1

It seems that we’re hitting a bug with MariaDB 10.4 with regards to adding/editing users using the MySQL module. Supported here: https://www.virtualmin.com/node/67870

I might experiment with a few different versions later with a VM, but it might be easier if I ask you guys here. What stable version of MariaDB you have that has a working user editing feature?

Thanks.

2

Okay, I had a few minutes to play with this. The module’s user permission section would work until MariaDB 10.3.

The cause was due to 10.4 changing the user table to global_priv: “All user accounts, passwords, and global privileges are now stored in the mysql.global_priv table. The mysql.user table still exists and has exactly the same set of columns as before, but it’s now a view that references the mysql.global_priv table. Tools that analyze the mysql.user table should continue to workas before.”

Just some notes for future updates to the module.

Reference: https://mariadb.com/kb/en/authentication-from-mariadb-104/

Submitted an issue for bug tracking.

3

Hi, I have just come across an issue where I cannot create mysql users through the webmin/virtualmin interface

Error being reported is:
“failed : The target table user of the INSERT is not insertable-into”

I presume this error is due to the changes MariaDB has made to the user authentication etc.

Do you have any expected resolution timeframe yet?

MariaDB 10.4.12 and
Webmin 1.941
Virtualmin 6.08
Usermin 1.791

Many thanks for all your work.
Simon

4

Yeah, this is still ongoing https://www.virtualmin.com/node/68371

If you don’t mind the new features in 10.4, 10.3 still fully works with Virtualmin’s MySQL module. Otherwise, you may use phpMyAdmin to manage your DBs as an alternative to the official MySQL module. Or simply use command line.