check_host yes/no
  • if set to no, the username-query will look like:
    select home, uid,... from passwd where (virtual_host = '' or virtual_host is null);
  • else it will look like:
    select home,uid,... from passwd where virtual_host='<passed from other qmail-programs>';
connectionstring All options passed to the database-server by qmail-sql: user, password, dbname, host ... This options are in the format required by postgresql (PQconnectdb). For compatibility-reasons, qmail-sql parses this field to get the parameters for connecting with a mysql-server. Connectionstring might look like:
user=userconsult password=readonly dbname=userdb host=localhost
Other mysql-options (eg portnumber) aren't recognized. Mail me if you want these options too.
Repeat this line for each database in your cluster.
connection_timeout How long (seconds) should qmail-sql try to connect with a database before returning an error (or trying the next database in your pool). Default: 0 (wait forever or until the client database-library returns itself).
query_timeout How long (seconds) should qmail-sql wait for an answer from the database before returning an error (or trying the next database in your pool). Default: 0 (wait forever or until the client database-library returns itself).
popconnectionstring All options passed to the database-server by checkpassword (pop3): user, password, dbname, host ...
dbtable Name of the table containing your passwd-fields
autohomedir Location of your sqlcreatehomedir-binary
localtable A table contaning the servernames, you want to treat as local. All users within these domains will be extracted from the passwd-file. If this line is missing, there won't be local deliveries. For more information, click here.
virt_host_field Name of the column containing the servernames of your virtual hosts in both localtable and dbtable
login_field Name of the column containing the logins of your virtual users
passwd_field Name of the column containing the passwords of your virtual users
home_field Name of the column containing the homedirectories of your virtual users
uid_field Name of the column containing the user-ids of your virtual users
gid_field Name of the column containing the group-ids of your virtual users
quota_field Name of the column containing the hardquota's of your virtual users
enabled_field Name of the column containing the "enabled"-flag of your virtual user
startdate_field Name of the column containing the date frow which your virtual user has a valid login
stopdate_field Name of the column containg the expiry-date of your virtual user
localpop This field is only used by pop3: users should login with user@servername, but if they forget the servername, checkpassword will try this one
domain_separators This field is only used by pop3: users should login with user@servername, but this may cause troubles with some mailclients. Therefore you can specify your own separator characters (eg: @:#).
lastlogin_field This field is only used by pop3: if specified, checkpassword will update the field every time a user logs in. Note that Alex his imap-server offers the same functionality. If this field isn't specified, checkpassword won't try to update. Read the notes about performance before enabling this option.
global_domain Should the system try to find a user within the global_domain if it didn't find the user within the requested domain ?
use_dotqmail_field Name of the column indicating whether the system should try to find a dotqmail for this user. Note that you'll need to specify dotqmailtable, dotqmail_field and extension_field too. Else qmail-sql will ignore this field.
dotqmailtable Table containing the contents of the dotqmails
dotqmail_field Name of the column containg the contents of the dotqmail (in dotqmailtable)
extension_field Name of the column containg the extension-part of an email-address (the part after the dash)
rcpthosts_from_db Qmail-smtpd can read the rcpthosts from the database if the controlfile rcpthosts is missing. Turn this option on if you want this behaviour. If the option is turned off, your mailserver will act as a open relay-server if the control file is missing.
allowed_recipients_from_db Qmail-smtpd can read the existings users from the database and eventually bounce mail for non-existant users. Turn this option on if you want the mailbouncing.