Thoughts about ispcp and other apps (mail)

[joximu]

Hi
We now have (as an example) two hostos with some long sql statements in it, because there is no field in the database with the full mail address (well, there is a field but it's empty...).

The dovecot howto uses the mysql interface of dovecot and the password change in webmail needs to update the right password...

It might be a good idea to use the already defined field in the datbase:
ispcp -> mail_users -> mail_addr.
This would simplify severall processes and shouldn't be a drawback...

Another thought:
courier uses an own user database (userdb) which is active also when mysql is down. Dovecot cannot authenticate when mysql is down.
Personally I like the separated userdb - I don't know which is faster but at least it spares some mysql connections...
I used to have a look at SysCP, they have all services (courier, postfix) with direct mysql connection: without mysql everything is down (except apache).
I know: mysql should not be stopped (many php apps need it) but I still like the idea that I cann stop mysql for some seconds without being phoned instantly :-)

I'm looking forward to ispcp 1.0!
/Joximu