On 10/14/05, David Saez Padros david@ols.es wrote:
Hi !!
In that case you don't need to select the host on the login screen but enter your full e-mail address as user name.
the probem is that on Mac, specially Entourage, refuses to work with usernames that contain a @ character, so many of our users username is user.domain.com or another.user.domain.com. One good aproach will be:
I've used the % fix in previous installations: user%domain.com. Most IMAP servers can handle this on the fly.
only of first login:
a) if the username does not have a @, and if a external query has been configured, execute the query to get the real email b) if the username does not have a @, and if a default domain has been configured, append the configured domain to the user's username c) if the username does not have a @ the use the apache virtual hostname (striping the initial www. if present) and append the hostname domain to the user's username (note that this will not work in servers other than apache)
Once that user is resolved from the virtusertable, it'll be saved in the users table (alias) and don't has to be resolved from the file again on the next login.
that's perfect
1). Too expensive, past 1000 users the lookups take valuable time. If they're in MySQL, then its not so bad, but why waste another MySQL lookup that Courier-AUTHLIB will be doing anyways (or whatever your IMAP server's auth system does).
as the real email has been saved in Rounbdcube own's database this will not be exepensive (one only query for the firt login of each user)
What I'm saying is any access to MySQL is expensive. 1 extra query just at login is almost too much.
Queries: 164.2M qps: 1438 Slow: 90.0 Se/In/Up/De(%): 94/01/02/00 qps now: 467 Slow qps: 0.0 Threads: 88 ( 14/ 82) 59/10/07/03 Cache Hits: 154.7M Hits/s: 372.8 Hits now: 91.0 Ratio: 91.0% Ratio now: 57.4% Key Efficiency: 100.0% Bps in/out: 6.5k/ 2.7k Now in/out: 33.1k/600.6k
My customers would not like another query per login... with 2515 users logged into email at this moment that may only translate to another 3-5/second, but hey each one counts.
I'm fine with the option being there, it adds a ton of flexibility, however simpler ones must be made available so that large installs are not hamstringed (hamstrung?) with extraneous database usage.
-- Best regards ...
The dentist said my wisdom teeth were retarded.
David Saez Padros http://www.ols.es On-Line Services 2000 S.L. e-mail david@ols.es Pintor Vayreda 1 telf +34 902 50 29 75 08184 Palau-Solita i Plegamans movil +34 670 35 27 53
-- Christopher A. Watford christopher.watford@gmail.com