[GH-ISSUE #263] OpenSMTPD ? #214

New issue

Closed

opened 2026-02-26 09:36:49 +03:00 by kerem · 2 comments

kerem commented

2026-02-26 09:36:49 +03:00

Owner

Originally created by @sachaz on GitHub (Jan 4, 2020).
Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/263

Is any plan or documentation to make it work with OpenSMTPD ?

Originally created by @sachaz on GitHub (Jan 4, 2020). Original GitHub issue: https://github.com/opensolutions/ViMbAdmin/issues/263 Is any plan or documentation to make it work with OpenSMTPD ?

kerem closed this issue

2026-02-26 09:36:49 +03:00

kerem commented

2026-02-26 09:36:50 +03:00

Author

Owner

@barryo commented on GitHub (May 16, 2020):

Hi @sachaz - no plans for this because I am not familiar with it. ViMbAdmin is a database frontend so if OpenSNMPD can be made work with the schema, there should be no problem. Happy to accept any documentation on this if you get it working.

@barryo commented on GitHub (May 16, 2020): Hi @sachaz - no plans for this because I am not familiar with it. ViMbAdmin is a database frontend so if OpenSNMPD can be made work with the schema, there should be no problem. Happy to accept any documentation on this if you get it working.

kerem commented

2026-02-26 09:36:50 +03:00

Author

Owner

@sachaz commented on GitHub (May 16, 2020):

Hi @barryo
as Postfix, OpenSMTPD can use Mysql, Redis, LDAP...
https://github.com/OpenSMTPD/OpenSMTPD-extras/tree/master/extras/tables/table-mysql

/etc/smtpd.conf

(...)
table vdomains mysql:/etc/smtpd-mysql.conf
table vusers mysql:/etc/smtpd-mysql.conf
table userinfo mysql:/etc/smtpd-mysql.conf
table credentials mysql:/etc/smtpd-mysql.conf

/etc/smtpd-mysql.conf

host localhost
username opensmtpd
password MY-SUPER-PASSWORD
database smtpd
query_credentials SELECT user,password FROM userinfo WHERE user=?;
query_domain SELECT domain FROM vdomains WHERE domain=? LIMIT 1;
query_userinfo SELECT uid,gid,maildir FROM userinfo where user=?;
query_alias SELECT alias FROM valias WHERE addr=?;

@sachaz commented on GitHub (May 16, 2020): Hi @barryo as Postfix, OpenSMTPD can use Mysql, Redis, LDAP... https://github.com/OpenSMTPD/OpenSMTPD-extras/tree/master/extras/tables/table-mysql - /etc/smtpd.conf ``` (...) table vdomains mysql:/etc/smtpd-mysql.conf table vusers mysql:/etc/smtpd-mysql.conf table userinfo mysql:/etc/smtpd-mysql.conf table credentials mysql:/etc/smtpd-mysql.conf ``` - /etc/smtpd-mysql.conf ``` host localhost username opensmtpd password MY-SUPER-PASSWORD database smtpd query_credentials SELECT user,password FROM userinfo WHERE user=?; query_domain SELECT domain FROM vdomains WHERE domain=? LIMIT 1; query_userinfo SELECT uid,gid,maildir FROM userinfo where user=?; query_alias SELECT alias FROM valias WHERE addr=?; ```

kerem referenced this issue

2026-02-26 10:30:43 +03:00

[PR #214] [MERGED] Fix alias listing #303