[one-users] Use External MySQL database for user authentication

[Shi Jin]

Hi there,

Opennebula-2 has the capability of using an external Authentication/Authorization module instead of the internal username/password.
However, when I took a look at it, the one_auth_mad module only uses external database for the quotas while still use the internal user_pool if the simple authentication is chosen (instead of ssh).

What I want to have is the same kind of simple username/password authentication (not ssh type) but the database is stored outside of OpenNebula's own database (sqlite or mysql). This way, I could have extra user information stored in the same database and do all kinds of database actions such as remote replication to it without affecting OpenNebula at all.
To get started, I am wondering what is needed if I want to have a simple table just as user_pool but stored somewhere else other than   the one already used by OpenNebula. Basically, I want the new user_pool table to be in the same database as quotas, not with the vm_pool, history etc.

BTW, it is fairly straightforward to change the database from sqlite to mysql since all we need is the URL supplied to sequel. This is awesome. Thanks.

I appreciate your help.
Thanks.

Shi
--
Shi Jin, PhD