Re: mysql reintegration project...
wendelmaques <wendel-e5LGQ1J1bCxwFqzsTH5u/[email protected]> Mon, 21 Mar 2005 03:05:27 -0300
| Newsgroups | gmane.comp.isp.ispman.user |
|---|---|
| Message-ID | <1FF46F2F7B807670B53CADCE@[192.168.200.198]> |
> Thanks, it seems good, if you don't mind me to ask, please add two
thanks
> feature: 1. DB/account quota (you don't want your client to brust your
> mysql server :)
I search in Google about "mysql quota" I don't found any usable information,
if you some one know hot to add quota support to mysql, please, tell-me.
Maybe is possible to add via file system quota.
> 2. optional field box for auto-create db during domain name added
good.
> 3. according to the screenshot, it seems that user/password isn't sync
> with mysql DB, possible to make them sync ? Thanks..
all information are stored in the LDAP, I created a new OID tree in
OID 1.3.6.1.4.8833.2.2.13** and
1.3.6.1.4.8833.2.1.2*** , (I hope that ISpMan developers
don't kill me :) ) to store all information about the database and user.
Maybe we need a button to "LOAD PRIVILEGES FROM MYSQL".
At this moment the password is stored in clear text, to encrypt I need
to use POSIX account and mysql can't use this, because mysql have they
own database with encrypted password's, let's see:
LDAP PASSWORD: {crypt}KLPfxeoYLhtEU
MYSQL PASSWORD: *5935238C4C2F2A0678B5E16622E9B3DD5B437B90
Any chance to mysql use PAM? LDAP to auth users? :|
The module have CREATE/EDIT and DROP database. If the prefix of database
has changed during edition the agent create a new database, copy all tables
and drop the old database. In the future is possible to copy database from
a server to another.
O EDIT or DROP, the old user information are cleanup and added new info,
this avoid unused users account on the mysql.
The module follow ispman model, all task are stored in the LDAP, and the
agent do all the work on the host.
Tomorrow I'll prepare all files and
documentation about the module to be download.
--
wendelmaques
http://www.dotpix.com.br/~wendel/site/
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click