Re: MySQL Support

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

Hans Martin wrote:
> Hi Pedro,
> 
> hopefully I didn't get it wrong but I thought MySQL-support means an 
> agent which creates/deletes databases for domains/vhosts so that your 
> customers can easily create their own databases. In fact this isn't a 
> very hard task as long as you don't care about quotas and backup.
> So you didn't meant to replace LDAP with MySQL?
> 
> Regards,
> 
> Hans
> 
> Pedro Algarvio schrieb:
>> Just to get some ideas together.
>>
>> Untill MySQL supports PAM which is beeing talked about
>> (http://forge.mysql.com/wiki/PluggableAuthenticationSupport) there
>> will be a major problem for this, usernames for MySQL are hardcoded to
>> a maximum lenght of 16 chars.
>> This introduces a major problem, all you can go is like:
>> [email protected]
>> test_tes_dom_com
>> [email protected]
>> testtest_dom_com
>>
>> As seen, most usernames plus domain will easely get more that 16 chars.
>>
>> Any ideas on how overcome this?
>>
>> Wendel, you seem to have made this work(we're still waiting for your  
>> patch :) ), what was your approach?
>>
>> Happy thoughts,
> 
> -------------------------------------------------------------------------
> 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 idea is *not* to replace LDAP for MySQL ;) no, not a chance!!!

The idea *is* for ISPMan to take care of DB creation/deletion/permissions

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.

And no, DB backup and quota was not on my mind :|


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

iD8DBQFFK2VAniPxVTX2hA4RAnjQAJ9NnGr/G5HRAt+Hj90EA4rZEQyY1ACggQma
2OFYFntcNmGfeppWGD2QJXw=
=Yiot
-----END PGP SIGNATURE-----

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