[BlueOnyx:26303] BlueOnyx 5210R/5211R: Ability to assign unassigned SQL DBs to Vsites added

[Michael Stauber]

Hi all,

A feature that has been often asked for has just been added to BlueOnyx 
5210R and BlueOnyx 5211R. This was sponsored by Chris Wallace. Many thanks!

Here is how it works:
----------------------

Say you have an SQL database which is currently not assigned to any 
Vsite. But you would like to have it under GUI management of a specific 
Vsite.

Login to the GUI as "admin" (or any other user with server-administrator 
privileges) and go to the Vsite to which you want to assign that DB.

Make sure the Vsite has MariaDB enabled and has more "Allowed Databases" 
set than it already has under its management.

Once that is true you'll see the "+ Add" button below "MariaDB databases 
of this virtual site".

Click on it.

If your server has currently unassigned DBs, then you will see a 
pulldown named "Unassigned Databases" which by default shows 
'___Empty___' as value. But if you select it, it'll show the names of 
all currently unassigned DBs.

Choose the DB you want to put under the management of this Vsite and it 
will be added. The existing MySQL user of this Vsite will get the 
specified SQL rights to manage this DB and can then manage the DB via 
the BlueOnyx GUI.

If you leave the "Unassigned Databases" pulldown on '___Empty___', 
nothing will be done - unless you choose to enter something under 
"Database Name", which will then create a new DB - provided the chosen 
name is not yet in use.

If there are no unassigned DBs or if you aren't logged in as "admin" (or 
similar), then the field "Unassigned Databases" will not be visible.

-- 
With best regards

Michael Stauber
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Add_unassigned_DB.png
Type: image/png
Size: 192181 bytes
Desc: not available
URL: <http://mail.blueonyx.it/pipermail/blueonyx/attachments/20230618/6b91a6f1/attachment.png>