Jan Scholten wrote:
> Hi!
>
> Is there a possibility to edit the status bit for the domains?
Quick workaround:
Exec attachment. It adds column 'status' to table 'domain'.
In file which is checked by mydestination or relay_domains put
select_field = domain_name
where_field = domain_name
additional_conditions = and status > '0'
Change status to 0 for your domain by hand.
This is nice feature, so I add this to CVS.
> So if i could disable the domain (and enable it via web-cyradm) this would be
> great.. same thing
> would be nice for /temporaray) disableing Emailaddresses.
Look at 0.5.5 version. This is called 'Services'.
To get it working you should:
In file which is checked by virtual_maps your mysql query should look
like this:
select_field = dest
where_field = alias
additional_conditions = and status > '0'
also in cyrus-imap config files and in smtpd.conf you should add proper
condition.
I use auxprop plugin (but the same is possible for pam).
In cyrus.conf i have:
SERVICES {
imap cmd="imapd" listen="10.0.0.241:imap" prefork=0
imaplocal cmd="imapd -C /etc/imapd-local.conf"
listen="127.0.0.1:imap" prefork=0
imaps cmd="imapd -s" listen="10.0.0.241:imaps" prefork=0
imapslocal cmd="imapd -C /etc/imapd-local.conf"
listen="127.0.0.1:imaps" prefork=0
pop3 cmd="pop3d -C /etc/pop3d.conf" listen="pop3" prefork=0
pop3s cmd="pop3d -s -C /etc/pop3d.conf" listen="pop3s" prefork=0
In imapd.conf and imapd-local.conf:
sasl_pwcheck_method: auxprop
sasl_mech_list: plain login cram-md5 digest-md5
sasl_auxprop_plugin: sql
sasl_sql_engine: mysql
sasl_sql_user: mysql_user
sasl_sql_passwd: mysql_passwd
sasl_sql_hostnames: localhost
sasl_sql_database: maildb
sasl_sql_statement: select password from accountuser where username =
'%u' and imap = 1
In pop3d.conf:
sasl_sql_statement: select password from accountuser where username =
'%u' and pop = 1
In smtpd.conf:
pwcheck_method: auxprop
mech_list: plain login cram-md5 digest-md5
auxprop_plugin: sql
sql_engine: mysql
sql_user: mysql_user
sql_passwd: mysql_passwd
sql_hostnames: localhost
sql_database: maildb
sql_statement: select password from accountuser where username = '%u'
and smtpauth = 1
Rgds,
Lukasz
ALTER TABLE `domain` ADD `status` int(10) DEFAULT '1' NOT NULL AFTER
`freeaddress`;
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
