On Wed, Oct 22, 2014 at 11:41:07AM +0000, Theron ZORBAS wrote: > Hi @list, > > I've installed OpenBSD 5.6-current from the 19/10/2014 snapshot: > > # uname -a > OpenBSD mail.mydom.local 5.6 GENERIC.MP#448 amd64 > > # pkg_info > gettext-0.19.2 GNU gettext > libiconv-1.14p1 character set conversion library > libidn-1.29 internationalized string handling > mariadb-client-10.0.14v0 multithreaded SQL database (client) > opensmtpd-extras-20140909 extra tools for OpenSMTPD > opensmtpd-extras-mysql-20140909 OpenSMTPD authentication support for MySQL > pcre-8.35 perl-compatible regular expression library > vim-7.4.430-no_x11 vi clone, many additional features > wget-1.15 retrieve files from the web via HTTP, HTTPS and FTP > > My aim is to replace our university's postfix servers with OpenSMTPD. > > After that searched about OpenSMTPD + Virtual Users(Mysql) > But got no result. Can anyone please supply to me minimal config and sql > schema please? > This is, more or less, what I am using, mysql.conf has been stripped down but you can create a simple database starting from that. Cheers Giovanni
# $OpenBSD: smtpd.conf,v 1.7 2014/03/12 18:21:34 tedu Exp $
# This is the smtpd server system-wide configuration file. # See smtpd.conf(5) for more information. # To accept external mail, replace with: listen on all # pki XXX certificate "/etc/ssl/XXX.crt" pki XXX key "/etc/ssl/private/XXX.key" table aliases db:/etc/mail/aliases.db table vusers mysql:/etc/mail/mysql.conf table vdomains mysql:/etc/mail/mysql.conf table valiases mysql:/etc/mail/mysql.conf table credentials mysql:/etc/mail/mysql.conf listen on egress secure auth-optional <credentials> pki XXX listen on egress port submission tls auth <credentials> pki XXX listen on lo0 port 10025 tag Filtered accept tagged Filtered for domain <vdomains> userbase <vusers> virtual <valiases> deliver to maildir accept from any for domain <vdomains> relay via "smtp://127.0.0.1:10024" # Local emails accept tagged Filtered for local alias <aliases> deliver to mbox accept from local for local relay via "smtp://127.0.0.1:10024" accept for any relay pki XXX
host localhost username usr password pass database db # Alias lookup query # # rows >= 0 # fields == 1 (user varchar) # query_alias select destination from mail_valias where source=? # Domain lookup query # # rows == 1 # fields == 1 (domain varchar) # query_domain select domain from mail_domain where domain=?; # User lookup query # # rows == 1 # fields == 3 (uid int, gid int, directory varchar) # query_userinfo select uid,gid,maildir AS maildir from mail_user where login=?; # Credentials lookup query # # rows == 1 # fields == 2 (username varchar, password varchar) # query_credentials select login, password from mail_user where login=?; # Netaddr lookup query # # rows == 1 # fields == 1 (netaddr varchar) # #query_netaddr select value from netaddr where value=$1;
