[Dbconfig-common-devel] RFC: Multiple users and databases support

[Daniel Dehennin]

Hello,

Looking around the dbconfig-common code, I'm thinking on an idea for
multiple users support.

dbconfig-common could register a list of users in debconf:
--8<---------------cut here---------------start------------->8---
$package/db/users <list of users>
--8<---------------cut here---------------end--------------->8---

Then, for each user we can have:

--8<---------------cut here---------------start------------->8---
$package/db/<user>/password
                  /grants <list of grants>
                  /remote/hosts <list of hosts>
[...]
--8<---------------cut here---------------end--------------->8---

Installing a package, debconf could ask:
- the database name
- the list of users
- for each user:
  * a password + confirmation
  * from where this user can connect
  * a list of grants

Using the same idea, dbconfig-common could support multiple databases:
--8<---------------cut here---------------start------------->8---
$package/db/dbnames <list of databases>
$package/db/<dbname>/users <list of users>
                    /remote/host <server host>
$package/db/<dbname>/<user>/password
                           /grants
                           /remote/hosts
[...]
--8<---------------cut here---------------end--------------->8---

What do you think about this?

Regards.
-- 
Daniel Dehennin
Récupérer ma clef GPG:
gpg --keyserver pgp.mit.edu --recv-keys 0x6A2540D1
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/dbconfig-common-devel/attachments/20090620/2fd483ee/attachment.pgp>