[Pkg-zenoss-team] dbconfig-common: statements as db admin with info about the db user

[Stefano Zacchiroli]

Hi Sean,
  about dbconfig-common: is it possible to execute SQL statements as the
db administrator, but also having info about the configured db user?

My use case scenario is as follows. I need to execute "GRANT super on
*.* to <USER>@localhost". This statement is particular since it needs to
be executed as the db admin but it also needs to know the user name
chosen at postinst-time.

According to my reading of dbconfig-common documentation this is not
possible:
1) /usr/share/dbconfig-common/data/PACKAGE/install-dbadmin/DBTYPE is
   executed as the db admin but has no access to database connection
   information (since it's SQL it can't "source" external info, right?)
2) /usr/share/dbconfig-common/scripts/PACKAGE/install/DBTYPE has database
   connection information but does not know how to connect as the
   administrator to the db

Should I rely on (2) be executed as root and then discover how to
connect to the db as the db administrator?  Other ideas?

Thanks in advance, ... and many thanks for dbconfig-common!
Cheers.

-- 
Stefano Zacchiroli -*- PhD in Computer Science ............... now what?
zack@{cs.unibo.it,debian.org,bononia.it} -%- http://www.bononia.it/zack/
(15:56:48)  Zack: e la demo dema ?    /\    All one has to do is hit the
(15:57:15)  Bac: no, la demo scema    \/    right keys at the right time
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.alioth.debian.org/pipermail/pkg-zenoss-team/attachments/20070616/87fb751e/attachment.pgp