Re: ispman mysql/postgres database module

Hi Atif et al,

it might be usefull to introduce a hostgroup "database" or maybe 
"MySqlgroup", "Oracle", "Sybase".. just to follow the configuration for 
the other services.
Moreover I suggest just to store the username and password for the 
(user)db and store the root password of the databases in the ispman.conf 
on the database servers.
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.
As you stated a db is just a db - so it should be in an own tree. But 
looking on the customers side I guess many of the ispman-driven hosters 
provide something like "one database per vhost". Doesn't it make sense 
to just add an option to the vhost add/edit/delete for one db (depending 
on the hostgroup oracle/mysql/whatever)?

Kind Regards,

Hans



Atif Ghaffar schrieb:
> I am doing the following. (rough draft)
> Please let me know your thoughts.
> 
> Adding a "cn" attribute as required in ispmanDatabaseData class.
> 
> Getting rid of ispmanDBPrefix.
> Ignoring the ispmanDB*Priv attributes.
> 
> Making the name of the database match the name of the user. (so we dont 
> have to look in two different places for uniqueness).
> 
> A db is just that. A database.
> 
> It has just a username and a password from which it can be accessed.
> 
> It is not part of a domain.  (We can put some information in the record 
> to say which domain it belongs to so that we can purge it when the 
> domain is deleted)
> 
> 
> 
> The record we will have will be something like this.
> 
> # Database tree (outside of domain tree)
> dn: ou=databases,o=ispman
> objectClass: top
> objectClass: organizationalUnit
> ou: databases
> 
> dn: cn=db012345, ou=databases,o=ispman
> objectClass: top
> objectClass: ispmanDatabaseData
> cn: db012345
> ispmanDBUser: db012345
> ispmanDBPass: someclearpass
> ispmanDBHost: dbserver01
> ispmanDBType: mysql
> 
> dn: cn=db012346, ou=databases,o=ispman
> objectClass: top
> objectClass: ispmanDatabaseData
> cn: db012346
> ispmanDBUser: db012346
> ispmanDBPass: someclearpass
> ispmanDBHost: dbserver02
> ispmanDBType: postgres
> 
> dn: cn=db012347, ou=databases,o=ispman
> objectClass: top
> objectClass: ispmanDatabaseData
> cn: db012347
> ispmanDBUser: db012347
> ispmanDBPass: someclearpass
> ispmanDBHost: dbserver03
> ispmanDBType: oracle
> 
> 
> 
> 
> 
> On Dec 9, 2007 10:28 PM, Atif Ghaffar < [email protected] 
> <mailto:[email protected]>> wrote:
> 
>     Hello all,
> 
>     I see that there are still requests for this intergration.
>     If no one is already working on it, i will start.
> 
> 
> 
>     -- 
>     best regards
>     Atif Ghaffar
>     http://atif.ghaffar.googlepages.com 
> 
> 
> 
> 
> -- 
> best regards
> Atif Ghaffar
> http://atif.ghaffar.googlepages.com
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> 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
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Ispman-developers mailing list
> Ispman-developers-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/ispman-developers

-------------------------------------------------------------------------
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