| SYSTEM INFORMATION | |
|---|---|
| OS type and version | Ubuntu 24.04 |
| Webmin version | 2.202 |
| MariaDB version | 10.11.8 |
I know this is the Webmin forum, but I think my problem is related to the interaction of Webmin and Virtualmin.
When I did a Virtualmin installation on a stock Ubuntu 24.04 server, the MySQL broke. Actually MariaDB broke because as you know a stock installation of Ubunutu 24.04 installs MariaDB.
In Webmin the issue is evident in two places:
- When I looked at the Webmin screen, before refreshing Webmin modules, the UI said MySQL. After I refreshed modules, I saw MariaDB.
- I get this error:
**Fatal Error!**
SQL select table_schema,table_name from information_schema.views where table_schema = ? failed : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''' at line 1
I would like some advice. This is a new server with only two databases so I have an ideal opportunity to try and fix things. The problem is I don’t know where to start.
Is there perhaps a way to get Webmin modules to re-setup MariaDB?
Here is a screenshot of the problem:
I’ve documented further problems down the line with Virtualmin here:
I’m sorry if this is a cross post but I started off thinking it’s a Virtualmin problem but I have since concluded it’s the MariaDB integration in Webmin that’s failing.
Any advice will be appreciated.