Allow login without domain

[Christopher A. Watford]

On 10/14/05, David Saez Padros <david at 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 at 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 at gmail.com