ispman mysql/postgres database module update

--===============0356779832==
Content-Type: multipart/alternative; 
	boundary="----=_Part_20323_19959643.1197336550835"

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

Hi all,

After taking some of your input and realizing that there was a very old
DBMan.pm already there, I have done the following.

1. I suffix the uidNumber of the domain to the created databases (to avoid
name clash)
2. Leave the database information under the ou=databases,
ispmanDomain=someDomain,.... branch.
3. Set both database name and user name to be the same and max 16 chars
long. (Mysql by default has user as 16 char in mysql.user table)

to test this out you have to update from cvs.
install-data/schema  (and rebuild the schema)
The cn attribute is now required for ispmanDatabaseData class

lib/ISPMan/DBMan.pm

ispman-web/cgi-bin/tmpl/menu.tmpl

ispman-web/cgi-bin/tmpl/databases (directory)

At the moment (during development) I have hard-coded (mysql, oracle, pgsql)
as database types in DBMan.pm. Eventually this will come from the
configuration.

To test, you will have to create a hostgroup called databasegroup and add
one or more hosts to it.

Please test and let me have your feedback, so I can then start on the
Agents.







-- 
best regards
Atif Ghaffar
http://atif.ghaffar.googlepages.com

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

Hi all,<br><br>After taking some of your input and realizing that there was a very old DBMan.pm already there, I have done the following.<br><br>1. I suffix the uidNumber of the domain to the created databases (to avoid name clash)
<br>2. Leave the database information under the ou=databases, ispmanDomain=someDomain,.... branch.<br>3. Set both database name and user name to be the same and max 16 chars long. (Mysql by default has user as 16 char in 
mysql.user table)<br><br>to test this out you have to update from cvs.<br>install-data/schema&nbsp; (and rebuild the schema)<br>The cn attribute is now required for ispmanDatabaseData class<br><br>lib/ISPMan/DBMan.pm<br><br>ispman-web/cgi-bin/tmpl/menu.tmpl
<br><br>ispman-web/cgi-bin/tmpl/databases (directory)<br><br>At the moment (during development) I have hard-coded (mysql, oracle, pgsql) as database types in DBMan.pm. Eventually this will come from the configuration.<br>
<br>To test, you will have to create a hostgroup called databasegroup and add one or more hosts to it.<br><br>Please test and let me have your feedback, so I can then start on the Agents.<br><br><br>
<br><br><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_20323_19959643.1197336550835--


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

--===============0356779832==--