Re: MySQL Support

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hans Martin wrote:
>> Still there's no way arround for the 16 chars max username length, we
>> would have to create a unique identifier for each domain admin so he
>> could create the databases, yet another user id he'd have to keep in mind.
> 
> Hi Pedro,
> 
> as of today we create one database per domain with a random username and 
> pw. It might be useful to have the ability to create one database per 
> vhost, but this should be enough. I guess there might be also only some 
> very rare cases in which a customer needs more then one user per db.
> So storing the username (id) in LDAP would be the way to go.
> 
> As soon as we have an agent for creating, deleting, modifying the 
> database it might also be easy for one to extend this agent to dump (of 
> course with nice) a database to the domain/vhost directory for backups.
> Moreover if we can find a place in the schema to store information about 
> the database size it might also be easy to let the agent provide this 
> information. But these should both be steps we can take if we have the 
> mysql installer already. ;-)
> 
> 
> Kind Regards,
> 
> Hans
> 
> 
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Ispman-developers mailing list
> Ispman-developers-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/ispman-developers
> 

The interesting part, would be if you implemented it in a .lib way
leaving the the agent part as general as possible. Why, well, why only
support MySQL, why not PostgreSQL aswell :)

See where I'm getting?

- --
Pedro Algarvio
   __ ___  ___ _______        ___ __
|   Y   .'  _|   _   .-----.'  _|  |_   .-----.----.-----.
|.  |   |   _|   1___|  _  |   _|   _|__|  _  |   _|  _  |
|.  |   |__| |____   |_____|__| |____|__|_____|__| |___  |
|:  1   |    |:  1   |                             |_____|
|::.. . |    |::.. . |  ufs [AT] ufsoft [DOT] org
`-------'    `-------'    ufs [AT] sapo [DOT] pt
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQFFLh+/niPxVTX2hA4RAtfOAJ0UG9D8MSf/8kx4hYsbL6QpkmkbsQCePZwg
9lt37Y5OP+DvbD9HFv0W6Nw=
=KCtO
-----END PGP SIGNATURE-----

-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642