webmin: MariaBD 10.4: The target table user of the INSERT is not insertable-into
For some time now creation of users in MariaDB is no longer possible. As soon as you create a user the following error gets presented by save_user.cgi
Failed to save user : SQL insert into user (host, user, Select_priv, Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, Index_priv, Alter_priv, Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv, Execute_priv, Repl_slave_priv, Repl_client_priv, Create_view_priv, Show_view_priv, Create_routine_priv, Alter_routine_priv, Create_user_priv, Event_priv, Trigger_priv, Create_tablespace_priv, Delete_history_priv, ssl_type, ssl_cipher, x509_issuer, x509_subject, authentication_string) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) failed : The target table user of the INSERT is not insertable-into
I looked at the workarounds for Virtualmin, but they don’t apply to Webmin without Virtualmin.
The setup: Webmin version: 1.941 Operating system: FreeBSD 12.1-RELEASE-p1 MariaDB version: 10.4.12
Any ideas how to get out of this?
About this issue
- Original URL
- State: closed
- Created 4 years ago
- Comments: 17
Commits related to this issue
- Fix to support devel updates on BSD systems as well https://github.com/webmin/webmin/issues/1232#issuecomment-615903971 — committed to webmin/webmin by iliajie 3 years ago
Support for MariaDB 10.4+ and MySQL 8+ has been implemented in Webmin 1.960 and Virtualmin 6.13. Let us know if it works for you.
Yeah, GNU date command is more complete than BSD variant. I’ll take a look when I have time.
Can confirm this is working beautifully again. Awesome job!
Correct. And looking at the virtualmin fixes there is some additional version checking being done. Which is not the case in save_user.cgi.