"Username for mysql" is incorrect

OS type and version: Ubuntu 18.04.6 LTS
Webmin version: 1.981
Virtualmin version: 6.17-3

I have transferred a Virtual Server from one Virtualmin host to another using the ’ Transfer Virtual Server’ tool in Virtualmin. The process works fine

On the target server I have a php script that queries the Virtualmin CLI API and looks to obtain the ‘Username for MYSQL’

The username retuned is a name with underscores ( like the db ) however this is incorrect as the actual username in mysql has period characters rather than underscores (same as the virtualmin username)
*** snip ***
Plan: Default Plan
Username: redacteddomain.com.au
User ID: 1086
Group name: redacteddomain.com.au
Group ID: 1086
Mailbox username prefix: redacteddomain.com.au
Password storage: Plain text
Password: hdtsgebfiq
Username for mysql: redacteddomain_com_au

Interestingly the Virtualmin GUI reports
Administration username redacteddomain.com.au (For MySQL database : redacteddomain.co)
which is correct

I have a ton of maintenance scripts that are failing due to this error

Is this a bug? It seems like it.


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