Submitted by ghost23 on Tue, 05/07/2019 - 04:44 Pro Licensee
I'm on a debian9 an use MariaDB 10.1.38 on a remote host. Infront of the db-hosts is a MaxScale Proxy 2.2.20 In VM I set Password storage mode = Only store hashed passwords.
Now when I create a new "Virtual Server" VM put the passwort in the "authentication_string" field. But in MariaDB the "password" field is still present unlike in MySQL > 5.7 (I guess). Now the MaxSale uses the "password" field to authenticate users.
Is it possible to force VM to use the "password" field instead of "authentication_string" or even set it in both?
Status:
Active
Comments
Submitted by andreychek on Tue, 05/07/2019 - 09:08 Comment #1
Howdy -- thanks for contacting us!
I'm unfortunately not sure about that, but I'm passing this along to Jamie for comment. He'll know whether that's possible, and how to go about that.
Submitted by JamieCameron on Wed, 05/08/2019 - 23:46 Comment #2
This could be happening because Virtualmin can't detect the real MySQL version properly.
If you connect to your MySQL server (via the proxy) as
rootand runselect version(), what does is output?Submitted by ghost23 on Thu, 05/09/2019 - 02:03 Pro Licensee Comment #3
root is deactivated but I've a equivalent this user virtualmin uses to connect lets say "virtualmin_sql" running with this user it shows:
MariaDB [(none)]> select version(); +--------------------------+ | version() | +--------------------------+ | 10.1.38-MariaDB-0+deb9u1 | +--------------------------+ 1 row in set (0.01 sec)
Submitted by JamieCameron on Sun, 05/12/2019 - 18:19 Comment #4
I think the issue here is that Virtualmin should be using the
alter usercommand to set the password, rather than writing toauthentication_stringdirectly, because it assumes that this is only possible in MariaDB 10.2 and above.Which Virtualmin version are you running there?
Submitted by ghost23 on Mon, 05/13/2019 - 01:55 Pro Licensee Comment #5
6.06-2 when the server go to production it will be a pro version.
Submitted by JamieCameron on Tue, 05/14/2019 - 01:18 Comment #6
Can you post the output from the SQL command
desc mysql.useron your system?Submitted by ghost23 on Tue, 05/14/2019 - 08:35 Pro Licensee Comment #7
this is from the user with witch vm connet to the mysql
+------------------------+-----------------------------------+------+-----+----------+-------+| Field | Type | Null | Key | Default | Extra |
+------------------------+-----------------------------------+------+-----+----------+-------+
| Host | char(60) | NO | PRI | | |
| User | char(80) | NO | PRI | | |
| Password | char(41) | NO | | | |
| Select_priv | enum('N','Y') | NO | | N | |
| Insert_priv | enum('N','Y') | NO | | N | |
| Update_priv | enum('N','Y') | NO | | N | |
| Delete_priv | enum('N','Y') | NO | | N | |
| Create_priv | enum('N','Y') | NO | | N | |
| Drop_priv | enum('N','Y') | NO | | N | |
| Reload_priv | enum('N','Y') | NO | | N | |
| Shutdown_priv | enum('N','Y') | NO | | N | |
| Process_priv | enum('N','Y') | NO | | N | |
| File_priv | enum('N','Y') | NO | | N | |
| Grant_priv | enum('N','Y') | NO | | N | |
| References_priv | enum('N','Y') | NO | | N | |
| Index_priv | enum('N','Y') | NO | | N | |
| Alter_priv | enum('N','Y') | NO | | N | |
| Show_db_priv | enum('N','Y') | NO | | N | |
| Super_priv | enum('N','Y') | NO | | N | |
| Create_tmp_table_priv | enum('N','Y') | NO | | N | |
| Lock_tables_priv | enum('N','Y') | NO | | N | |
| Execute_priv | enum('N','Y') | NO | | N | |
| Repl_slave_priv | enum('N','Y') | NO | | N | |
| Repl_client_priv | enum('N','Y') | NO | | N | |
| Create_view_priv | enum('N','Y') | NO | | N | |
| Show_view_priv | enum('N','Y') | NO | | N | |
| Create_routine_priv | enum('N','Y') | NO | | N | |
| Alter_routine_priv | enum('N','Y') | NO | | N | |
| Create_user_priv | enum('N','Y') | NO | | N | |
| Event_priv | enum('N','Y') | NO | | N | |
| Trigger_priv | enum('N','Y') | NO | | N | |
| Create_tablespace_priv | enum('N','Y') | NO | | N | |
| ssl_type | enum('','ANY','X509','SPECIFIED') | NO | | | |
| ssl_cipher | blob | NO | | NULL | |
| x509_issuer | blob | NO | | NULL | |
| x509_subject | blob | NO | | NULL | |
| max_questions | int(11) unsigned | NO | | 0 | |
| max_updates | int(11) unsigned | NO | | 0 | |
| max_connections | int(11) unsigned | NO | | 0 | |
| max_user_connections | int(11) | NO | | 0 | |
| plugin | char(64) | NO | | | |
| authentication_string | text | NO | | NULL | |
| password_expired | enum('N','Y') | NO | | N | |
| is_role | enum('N','Y') | NO | | N | |
| default_role | char(80) | NO | | | |
| max_statement_time | decimal(12,6) | NO | | 0.000000 | |
+------------------------+-----------------------------------+------+-----+----------+-------+
Submitted by ghost23 on Tue, 06/04/2019 - 05:14 Pro Licensee Comment #8
push