Re: [Dovecot] How to disable imap of some user

2011-02-21 Thread 邓卫华
Hi,all i have resolved this problem, when i am modify password_query parameter. password_query = SELECT username AS user,password FROM (select username,password,disableimap as imap ,disablepop3 as pop3,disablesmtp as smtp,disablesieve as sieve FROM mailbox WHERE username = '%u' AND a

Re: [Dovecot] How to disable imap of some user

2011-02-21 Thread 邓卫华
Hi, Pascal thanks, that's great. it's work in our test environment. but i have a problem in mail server. i have a user manage program of mail server, runing on mysql. it had a disableIMAP disablePOP3, disablesmtp column in user table. that's easy if i can modify password_query. i had

Re: [Dovecot] How to disable imap of some user

2011-02-19 Thread Pascal Volk
On 02/19/2011 02:20 PM 邓卫华 wrote: > Dear Pascal, > > thanks for your reply ASAP. can i only add pop3 and > imap column in the password table, and not to add sieve and smtp column? > can password not verified if there have not existing smtp and sieve > column? > You don't need to add the colum

Re: [Dovecot] How to disable imap of some user

2011-02-19 Thread 邓卫华
Dear Pascal, thanks for your reply ASAP. can i only add pop3 and imap column in the password table, and not to add sieve and smtp column? can password not verified if there have not existing smtp and sieve column? Regards, Deng On Sat, 19 Feb 2011 09:17:16 +0100, Pascal Volk wrote: >

Re: [Dovecot] How to disable imap of some user

2011-02-19 Thread Pascal Volk
On 02/19/2011 08:55 AM 邓卫华 wrote: > > > Hi, > > in our company, i want to disable imap of some users, they > can access them mailbox by pop3 only, and another user can allow access > them mailbox by imap or pop3. > > how can i do ? > Its really simple - since you are using a SQL backend

[Dovecot] How to disable imap of some user

2011-02-18 Thread 邓卫华
Hi, in our company, i want to disable imap of some users, they can access them mailbox by pop3 only, and another user can allow access them mailbox by imap or pop3. how can i do ? -- Best Cheer (XiaMen) Stone Works CO.,LTP. Phone: 0592-7221600