|
From: SourceForge.net <no...@so...> - 2009-05-28 16:35:30
|
Feature Requests item #2686461, was opened at 2009-03-13 21:49 Message generated for change (Comment added) made by lexxai You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=2686461&group_id=191583 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: GingerDog (gingerdog) Assigned to: Nobody/Anonymous (nobody) Summary: Custom Fields support for mailbox table Initial Comment: See https://sourceforge.net/forum/message.php?msg_id=6779222 In brief: Add support for a number of fields to the mailbox table which will allow sysadmins to customise postfixadmin to their needs - e.g. to enable webmail or remote pop3/imap access access on a per user basis etc etc. ---------------------------------------------------------------------- Comment By: Oleksiy (lexxai) Date: 2009-05-28 19:35 Message: I use custom fileld before upgrdage... ------------------------------------------------- 'ext' - Enable/disable external access by local/external IP, thanks new version of POSTFIX that now will send IP to DOVECOT auth. dovecot-sql.conf password_query = SELECT username as user, password, IF ext,NULL,'172.16.1.0/24,10.0.0.0/8,127.0.0.0/8') AS allow_nets FROM mailbox WHERE username = '%u' AND active="1" ------------------------------------------------- 'expire' - date of end time for temporary email accounts. by crone will change 'active' state. #!/bin/sh export HOME=/root echo "UPDATE mailbox SET active=0,modified=now() WHERE active=1 AND expire > 'now()';" | /usr/local/bin/mysql --defaults-file=~/.my.cnf mailusers ------------------------------------------------- 'glob-maillist' - 0/1 - enable users recieve mail for one global email "so...@my..." mysql-virtual_globalmaillist_alias_maps.cf query = SELECT username FROM mailbox WHERE '%s'='someone\@mydomain.com' AND domain='mydomain.com' AND active='1' AND ` glob-maillist`='1' main.cf virtual_alias_maps = mysql:$pfbase/sql/mysql-virtual_alias_maps.cf,mysql:$pfbase/sql/mysql-virtual_globalmaillist_alias_maps.cf For this case need custom field type too (bolean, data or numbering), depend of it web form (add/edit user) will changed. ---------------------------------------------------------------------- Comment By: Christian Boltz (christian_boltz) Date: 2009-04-25 00:20 Message: @rlaban: Your usecase is probably already covered - see $CONF['transport'] and $CONF['transport_options'] in config.inc.php. (Nevertheless I agree that custom fields should be available.) ---------------------------------------------------------------------- Comment By: Ruben Laban (rlaban) Date: 2009-04-24 11:14 Message: In addition to custom fields for mailboxes, I'd like to see custom fields for domains as well. Example use case: Store the backend server in a field which can be used by the frontend servers to use as a transport. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=937967&aid=2686461&group_id=191583 |
