dovecot - Jan 2010 - virtual users with mysql

Hello List,

we use in our system cryptical Usernames for dovecot etc. and authenticate users
against shadow/passwd

User abcde is loging in and gets data from /var/spool/mail/abcde  and
/home/popuser/abcde

Now we want to make it possible that users can log in also with emailadresses.
I tried dovecot-mysql authentication which works fine but i do not find a way to
use 2 different login-formats in my queries.
login with abcde and also testname at example.com should return ok and lead to 
/var/spool/mail/abcde.
Is this possible or i have to make a decision which format to use?

Thanks,
Andre

We use mysql auth and support username or username at domain.com for logins.
Perhaps you just need to edit the auth_username_chars variable in the
dovecot config to allow @ symbol in usernames?


-----Original Message-----
From: dovecot-bounces+jkrejci=usinternet.com at dovecot.org
[mailto:dovecot-bounces+jkrejci=usinternet.com at dovecot.org] On Behalf Of
Andre H?bner
Sent: Thursday, January 28, 2010 4:11 AM
To: Dovecot Mailing List
Subject: [Dovecot] virtual users with mysql

Hello List,

we use in our system cryptical Usernames for dovecot etc. and authenticate
users against shadow/passwd

User abcde is loging in and gets data from /var/spool/mail/abcde  and
/home/popuser/abcde

Now we want to make it possible that users can log in also with
emailadresses.
I tried dovecot-mysql authentication which works fine but i do not find a
way to use 2 different login-formats in my queries.
login with abcde and also testname at example.com should return ok and lead to
/var/spool/mail/abcde.
Is this possible or i have to make a decision which format to use?

Thanks,
Andre

>>We use mysql auth and support username or username at domain.com for
logins.
>>Perhaps you just need to edit the auth_username_chars variable in the
>> dovecot config to allow @ symbol in usernames?
sorry, is already solved.
was just a question of the correct sql-query. to easy to see it ;)
i think i forgot to inform the list, problem can be ignored ;)

Thanks,
Andre