Re: ispman mysql/postgres database module

Hans Martin <[email protected]> Mon, 10 Dec 2007 14:31:25 +0100
Newsgroups gmane.comp.isp.ispman.devel
Organization e-netconsulting KG
Message-ID <[email protected]>
Hi Atif,
> 
> 
>     I really like the idea of using the username for the database name, but
>     as this can be very long, I suggest to use just the uid of the user
>     (e.g. prefixed with db_), so we wont get into trouble with naming
>     conventions. 
> 
> 
> I mentioned that the name of the db and name of the user will be the 
> same. This
> does not mean that it will point to some existing user's name.
ok, I missed that point. Sorry.
However it might be a good idea to just add the uid of the 
(domain/vhost)-user to the db-name (e.g. randomname_uid). Doing it this 
way, it is possible to run e.g. a backup script, which dumps all db's in 
   the correspondending directories. With this naming convention, the 
script can get the homedir of the user without connecting to the ldap 
directly (which saves some loc).

[..]
> 
> *You may need more than one database within one vhost.
> *
ok, agreed :-)
Thanks for your work!

Kind Regards,

Hans

-------------------------------------------------------------------------
SF.Net email is sponsored by:
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://sourceforge.net/services/buy/index.php