mysql edit user doesn't work in mariadb 10.4.7

3 posts / 0 new
Last post
#1 Sat, 09/07/2019 - 12:06
krustylicious

mysql edit user doesn't work in mariadb 10.4.7

Creating new virtual machines now works for me with the edits shown elsewhere. But creating a new mysql user in webmin in the mysql section fails with this error

"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"

the file I believe that is causing the issue is edit_user.cgi in the mysql folder.

Sat, 09/07/2019 - 13:21
andreychek

Howdy,

Yeah there's a number of fixes being worked on in order to get both Webmin and Virtualmin to properly work with newer MariaDB versions... Jamie is putting the finishing touches on that now.

-Eric

Sat, 09/07/2019 - 17:05 (Reply to #2)
krustylicious

I can live without creating mysql users for a bit .. And yay for Jamie ..