[Dbconfig-common-devel] A few questions about dbconfig-common

[sean finney]

hi jes,

hope you don't mind but i'm cc'ing this to the dbconfig-common-devel
list for posterity.

On Mon, Mar 23, 2009 at 02:51:55PM +0100, Jes Andersen wrote:
> How is dbconfig-common supposed to behave with package names
> containing hyphens and/or underscores?
> As far as I can tell a hyphen makes _dbc_sanity_check dbuser return
> false, indicating that it isn't a valid username, even tho
> w2b-SCADA_Data is a valid mysql username.

i believe that by default it should create a name that removes such
any characters deemed "special".

> If I change it to hyphens ("w2b_UserManagement") on the other hand
> creates a really strange behavior the user and database are created
> like before, but now
> /usr/share/dbconfig-common/data/w2bUserManagement/install/mysql is
> never executed but instead
> /usr/share/dbconfig-common/data/w2b/install/mysql is.

i think you're mixing up the package name and the database name.  try
keeping the package name when calling dbc_go, but before you call dbc_go
set the database user name to what you'd like (i.e. dbc_dbuser, check
the docs for which maintainer scripts need the variable set for this
to work).  the admin will still have the oppurtunity to override the
database user/db name, but you can using this technique set what you want
to be the default, modulo any special character removal.

> I know hyphens aren't allowed in the package name, which is one of the
> reasons I tried that one since it wouldn't conflict with other
> packages.

hyphens are allowed in package names, it's underscores that aren't...

> Besides is there an official way of creating multiple databases?

not in active use.  some time back i implemented a "multi instance support"
which is not advertised nor documented... if you could describe what you
need it for i could perhaps try to remember how it was implemented and whether
or not it might be feasible to use it.



	sean

-- 
-------------- 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/dbconfig-common-devel/attachments/20090323/c8972b4c/attachment.pgp