On Sun, Aug 16, 2020 at 02:15:52AM +0200, Fabian M??ller wrote: > > is your user allowed to connect to the host above? > > ** Which host do you mean? mx01 is allowed to connect to db (ha-proxy) and > even db1, db2, db3 directly (which I also tried, but did not change > anything). And the internet is allowed to connect to mx1. Or did you mean the > mda1? mda1 is not yet set up. >
The user from mysql.conf needs to be able to connect to the mysql server found at host db.[removed for privacy]. > > > > username [removed for privacy] > > > password [removed for privacy] > > > database [removed for privacy] > > > > > > query_credentials SELECT email, password FROM virtual_users WHERE email=?; > > > query_domain SELECT name FROM virtual_domains WHERE name=?; > > > query_userinfo SELECT uid,gid,maildir FROM virtual_users WHERE email=?; > > > query_alias SELECT destination FROM virtual_aliases WHERE source=?; > > > > # Further explinations: What I've tried > > First I guess the error has something to do with the mysql-stuff. > > > > But I am really really confused about the whole mysql-tables thing and can't > find a place where actually somebody explained (or documented) how it works. > > > > Have you tried: > > > > man table-mysql > > > > Perhaps its missing if so you can find it on github. > > > > > > ** I found the source for a man that sheds light on what those config options > are for. > > > > But that actually doesn???t help me with the error which occurs or if they > are needed. > > > > By taking a look at table_proc.c from the opensmdpd source on github I guess > > > > > warn: table-proc: pipe closed > > > > means that opensmtpd got an emty response when trying to do something (?) > with a table. I am unsure what opensmtpd is trying to do with the table. > Strangely it isn???t even trying to connect to the db-server (tcpdump > unrevals that). > > > table-proc is a seperate process if I'm not mistaken that needs to talk to the table-mysql which is a seperate process. If the pipe is closed they can't talk to eachother. > So what we know: It has something to do with the mysql-tables. What I don???t > understand is, what opensmtpd is trying to do which leads to that error. To > my understanding opensmtpd should only try to connect to the database if it > needs to read from the tables, which ??? if just starting up ??? obviously is > not the case. > > If you try something like: # smtpd -dv You should get some useful messages from table-mysql if its not connecting or what have you. Edgar