Re: ispman mysql/postgres database module

--===============0213401004==
Content-Type: multipart/alternative; 
	boundary="----=_Part_15409_7328403.1197237039518"

------=_Part_15409_7328403.1197237039518
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_15409_7328403.1197237039518
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I am doing the following. (rough draft)<br>Please let me know your thoughts.<br><br>Adding a &quot;cn&quot; attribute as required in ispmanDatabaseData class.<br><br>Getting rid of ispmanDBPrefix.<br>Ignoring the ispmanDB*Priv attributes.
<br><br>Making the name of the database match the name of the user. (so we dont have to look in two different places for uniqueness).<br><br>A db is just that. A database. <br><br>It has just a username and a password from which it can be accessed.
<br>
<br>It is not part of a domain.&nbsp; (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)<br><br><br><br>The record we will have will be something like this.
<br><br># Database tree (outside of domain tree)<br>dn: ou=databases,o=ispman<br>objectClass: top<br>objectClass: organizationalUnit<br>ou: databases<br><br>dn: cn=db012345, ou=databases,o=ispman<br>objectClass: top<br>objectClass: ispmanDatabaseData
<br>cn: db012345<br>ispmanDBUser: db012345<br>ispmanDBPass: someclearpass<br>ispmanDBHost: dbserver01<br>ispmanDBType: mysql<br><br>dn: cn=db012346, ou=databases,o=ispman<br>objectClass: top<br>objectClass: ispmanDatabaseData
<br>cn: db012346<br>ispmanDBUser: db012346<br>ispmanDBPass: someclearpass<br>ispmanDBHost: dbserver02<br>ispmanDBType: postgres<br><br>dn: cn=db012347, ou=databases,o=ispman<br>objectClass: top<br>objectClass: ispmanDatabaseData
<br>cn: db012347<br>ispmanDBUser: db012347<br>ispmanDBPass: someclearpass<br>ispmanDBHost: dbserver03<br>ispmanDBType: oracle<br><br><br><br><br><br><div class="gmail_quote">On Dec 9, 2007 10:28 PM, Atif Ghaffar &lt;<a href="mailto:[email protected]">
[email protected]</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello all,<br><br>I see that there are still requests for this intergration.
<br>If no one is already working on it, i will start.<br><font color="#888888"><br><br clear="all"><br>-- <br>best regards<br>Atif Ghaffar<br><a href="http://atif.ghaffar.googlepages.com" target="_blank">
http://atif.ghaffar.googlepages.com</a>
</font></blockquote></div><br><br clear="all"><br>-- <br>best regards<br>Atif Ghaffar<br><a href="http://atif.ghaffar.googlepages.com">http://atif.ghaffar.googlepages.com</a>

------=_Part_15409_7328403.1197237039518--


--===============0213401004==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

-------------------------------------------------------------------------
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
--===============0213401004==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Ispman-developers mailing list
Ispman-developers-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
https://lists.sourceforge.net/lists/listinfo/ispman-developers

--===============0213401004==--