The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

VUser::Email::Postfix::SQL - vuser extension for managing postfix users and domain in SQL

DESCRIPTION

SAMPLE CONFIGURATION

 [Extension Email::Postfix::SQL]
 dsn = dbi:mysql:database=email
 user = email
 password = secret

 # The various *_query settings here need to be defined to tell vuser how to
 # add, delete, etc accounts in the database. Any option passed on the commandline
 # can be inserted into the query with %-option_name.
 # Several macros are defined by VUser::Email::Postfix::SQL to make things easier.
 #  %a = account name (user@domain)
 #  %p = password
 #  %n = name
 #  %q = quota
 #  %h = home
 #  %d = domain (option, i.e. --domain)
 # These options are calculated from other options, hence the '$' in the macro
 #  %$u = user part of the account (user)
 #  %$d = domain part of the account (domain)
 
 # Add a user
 useradd_query = insert into Emails set username=%a, password=%p
 
 # Delete a user
 userdel_query = delete from Email where username=%a
 
 # Modify the user
 # The usermod_*_query's are used to change various portions of the users'
 # account information.
 usermod_account_query  = update Email set username=%-newaccount where username = %a
 usermod_password_query = update Email set password=%p where username = %a
 usermod_name_query     = update Email set name=%n where username = %a
 usermod_quota_query    = update Email set quota = %q where username = %a
 usermod_home_query     = update Email set home = %h where username = %a
 
 # Get user information. This query must return the following values in order
 #  account, password, name, home directory, quota
 userinfo_query = select ... from Email where username = %a
 userlist_query = select ... from Email
 
 # The domain*_query allow %d and %$d to be the same.
 # Add a domain 
 domainadd_query = insert into Domains set domain = %d, transport = 'virtual:' 
 
 # Delete a domain
 domaindel_query = delete from Domain where domain = %d
 
 # Modify a domain
 domainmod_domain_query = update Domain set domain = %-newdomain where domain = %d
 
 # Get domain info. The query must return the following fields in order
 #  domain
 domaininfo_query = select domain from Domain where domain = %d
 
 # Get domain list. The query must return the following fields in order
 #  domain
 domainlist_query = select domain from Domain

AUTHOR

Randy Smith <perlstalker@vuser.org>

LICENSE

 This file is part of VUser-Email-Postfix-SQL.
 
 VUser-Email-Postfix-SQL is free software; you can redistribute it and/or modify
 it under the terms of the GNU General Public License as published by
 the Free Software Foundation; either version 2 of the License, or
 (at your option) any later version.
 
 VUser-Email-Postfix-SQL is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 GNU General Public License for more details.
 
 You should have received a copy of the GNU General Public License
 along with VUser-Email-Postfix-SQL; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA