Opensuse 13.1

Submitted by witoszek on Wed, 10/22/2014 - 16:28

Hello

I got difficulties with opensuse, and with mariadb (i've installed by mistake, i'm not usually use for me).

Anyway,if i put add user with server mysql with webmin and fill each box , i got these message:

Fail to sab user : SQL insert into user (Host,User,Password,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,ssl_type,ssl_cipher,x509_issuer,x509_subject) values ('localhost', 'elim', '', 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','','','','') falló: Field 'authentication_string' doesn't have a default value

Thanks

Daniel Witoszek Arias

Status: 
Active

Comments

Submitted by andreychek on Wed, 10/22/2014 - 16:35

Howdy -- while I may take a look at that at some point in the future, Suse/OpenSuse isn't actually one of the distributions supported by Virtualmin.

You can see the ones that are supported here:

https://www.virtualmin.com/os-support

We haven't had much demand for Suse though, and it may be some time before we're able to look into that to see if it's resolvable.

Submitted by JamieCameron on Thu, 10/23/2014 - 04:11

I'd be interested to see the structure of the mysql.user table on your system though. Can you login to MySQL and run desc mysql.user and post the output here?

Submitted by witoszek on Thu, 10/23/2014 - 10:52

Ok , i will send you the output here

Submitted by witoszek on Sat, 10/25/2014 - 13:28

I haven't a user with mariadb.All my website use mysql.

~/mysqlbackup> mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 126 Server version: 5.5.33-MariaDB openSUSE package

Copyright (c) 2000, 2013, Oracle, Monty Program Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> desc mysql.user -> mysql.user ->