In the mail_users table there are 2 flags. pop3 and imap. I use the configuration supplied by froxlor and I can't find where dovecot/postfix checks to see if these flags are enabled.
In the dovecot sql configuration I use these sql statements:
password_query = SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mail_users WHERE username = '%u' OR email = '%u'
user_query = SELECT CONCAT(homedir, maildir) AS home, CONCAT('maildir:', homedir, maildir) AS mail, uid, gid, CONCAT('maildir:storage=', (quota*1024)) as quota FROM mail_users WHERE username = '%u' OR email = '%u'
Can anybody tell me how I can update the script so that if the pop3 or imap flag is set that only that service is available.
Question
Cybergen
In the mail_users table there are 2 flags. pop3 and imap. I use the configuration supplied by froxlor and I can't find where dovecot/postfix checks to see if these flags are enabled.
In the dovecot sql configuration I use these sql statements:
password_query = SELECT username AS user, password_enc AS password, CONCAT(homedir, maildir) AS userdb_home, uid AS userdb_uid, gid AS userdb_gid, CONCAT('maildir:', homedir, maildir) AS userdb_mail, CONCAT('maildir:storage=', (quota*1024)) as userdb_quota FROM mail_users WHERE username = '%u' OR email = '%u'
user_query = SELECT CONCAT(homedir, maildir) AS home, CONCAT('maildir:', homedir, maildir) AS mail, uid, gid, CONCAT('maildir:storage=', (quota*1024)) as quota FROM mail_users WHERE username = '%u' OR email = '%u'
Can anybody tell me how I can update the script so that if the pop3 or imap flag is set that only that service is available.
I am using Debian Lenny with froxlor 0.9.14.
Thanks in advance,
Martyn
Link to comment
Share on other sites
3 answers to this question
Recommended Posts
Archived
This topic is now archived and is closed to further replies.