I cannot create a database user for Mariadb

Virtualmin
1
SYSTEM INFORMATION
OS type and version Ubuntu Linux 22.04.1
Webmin version 2.001
Virtualmin version 7.3-1
Related packages SUGGESTED

I just installed Webmin & Virtualmin on this server.
For some reasons,

  1. The configuration entered on “MariaDB Server Configuration” information page are not been saved.
  2. When I’m trying to create a database’s user, I’m getting the error below:
    " Failed to save user : SQL create user ‘cell_user’@‘localhost’ identified by ‘hoN1NNA3TGrw1Rp’ failed : Operation CREATE USER failed for ‘cell_user’@‘localhost’"

Also, this is the log report:
[Sat Dec 17 05:30:22.128092 2022] [ssl:warn] [pid 53587:tid 139630112294784] AH01906: deseua.com:443:0 server certificate is a CA certificate (BasicConstraints: CA == TRUE !?)
[Sat Dec 17 05:31:03.859939 2022] [authz_core:error] [pid 61083:tid 139629680338496] [client 185.3.94.183:35850] AH01630: client denied by server configuration: /home/deseua/public_html/server-status
[Sat Dec 17 05:31:08.712840 2022] [authz_core:error] [pid 61082:tid 139629713909312] [client 185.3.94.183:43754] AH01630: client denied by server configuration: /home/deseua/public_html/server-status

Any hint on how to fix this please?

2

Screen Shot 2022-12-17 at 6.21.03 PM
Also, why is MySQL still showing in Webmin?
May be this is creating conflicts with Mariadb?
How could I please disable MySQL?

4

Did you use the latest Install script? I thought this issue was fixed.

5

I used this script below, that I saved on my cheatsheet.
$ wget http://software.virtualmin.com/gpl/scripts/install.sh

6

Er, nevermind my previous comment. I mixed up this issue with another database issue.

7

Could this issue be related to Ubuntu 22.04 or Webmin?
When Mysql is completely removed and purged from the server, its still showing up in Webmin of the server running Ubuntu 22.04 (see attached with_ubuntu_22 screenshot). However, when Mysql is removed from a server running Ubuntu 20.04, Mariadb instead shows up in Webmin (see with_ubuntu_20 screenshot attached).
Both servers have Mariadb installed and only the server running Ubuntu 22.04 is showing an error when trying to create a database user.
with_ubuntu_20
with_ubuntu_22

8

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.