empty

Virtualmin
1

empty

2

Howdy,

Virtualmin and Webmin can both help users and sysadmins to manage databases, and simply connect to the running MySQL daemon in order to interact with the database. Of course, depending on the user accessing it at the moment, Webmin or Virtualmin may restrict which databases are available.

That means a few things –

  • There isn’t a difference in the database location for Webmin and Virtualmin

  • The database location depends on the default for your distribution, but typically it is /var/lib/mysql (again, it doesn’t matter whether we’re dealing with Webmin or Virtualmin)

Is there something in particular you’re trying to do that we can assist with?

-Eric

3

I’ve imported my DB in var lib mysql, but it appears only under webmin.

Ah, that’s because by default, Webmin shows all databases on the server if you’re looking at it as root.

Virtualmin only shows databases it knows about, that are somehow associated with a Virtualmin user.

If the database was not created from within Virtualmin, it will not show up in Virtualmin.

Two ways to handle that are:

  1. You could always first create the database from within Virtualmin, then import the data into the database that Virtualmin created

  2. Using Virtualmin, you can import the database. To do that, go into Virtualmin, and click Edit Databases -> Import Database. That will tell Virtualmin to give control of that particular database to the current Virtual Server.

-Eric

4

Well, your issue isn’t likely one with filesystem permissions, it may very well be related to settings in MySQL for this particular database, or perhaps settings for the MySQL user you’re using and the permissions they have for that database.

As a test, what happens if you log into MySQL as the root user, and run the same SQL statement? Does that work?

-Eric

5

Ah, so to clarify, are you saying that you’re receiving that error in Virtualmin itself?

That is, this particular error:

“SQL delete from db where host = ‘’ and db = ‘glpi’ and user = ‘intra’ failed : Table ‘db’ is read only”

You get that when using Virtualmin in order to create or import a database?

-Eric

6

empty

7

empty

8

empty

9

empty

10

empty