Re: warn: table-proc: pipe closed (Probably mySQL-hassle and a newbie-question)
Hello Fabian, not answering your question and not solving you problem, but after your introduction I feel compelled to say: f...@1lb.eu (Fabian Müller), 2020.08.16 (Sun) 02:15 (CEST): > 1. take e-mails on port 25, check via mysql if it's for a domain it is > responsible for and then forward via lmtp to dovecot which then takes > care of everything else (including rejecting unknown users). I'd recommend to deny delivery right at the front door, i.e. let OpenSMTPd do the rejection. That way the sender gets the Non-Delivery-Notification from her/his own mail server. Otherwise the sending server sees the "250 2.0.0 XXYYZZ Message accepted for delivery" and thinks all is well. Later, when dovecot rejects, your server has to send the NDN, possibly to a spammer, which might bounce and all of that. Marcus
Re: warn: table-proc: pipe closed (Probably mySQL-hassle and a newbie-question)
Hi Edgar, hi Reio, smptd -dv did the job: It turned out, that opensmtpd could not connect to the db because there was a Space after the db-name. So „host db.example.com “ instead of „host db.example.com“. Now it connects fine but I get illegal table-api version which prevents opensmtpd from starting up. I guess that‘s from a version mismatch between the debian buster packages of opensmtpd and opensmtpd-extras. According to the Debian bugtracker this is fixed in the latest backport packages. I‘ll give it a try. Thanks a lot for your help! Greetings Fabian Am 16.08.2020 um 11:00 schrieb Reio Remma : On 16.08.2020 03:15, Fabian Müller wrote: > 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. IIRC OpenSMTPD opens the connection to MySQL server at startup. Just like it opens all other tables at startup. Anything in MySQL logs? I'm fairly certain it is a connection issue. Like Edgar recommended, try running smtpd -dv possibly with trace enabled as well. Good luck, Reio
Re: warn: table-proc: pipe closed (Probably mySQL-hassle and a newbie-question)
On 16.08.2020 03:15, Fabian Müller wrote: 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. IIRC OpenSMTPD opens the connection to MySQL server at startup. Just like it opens all other tables at startup. Anything in MySQL logs? I'm fairly certain it is a connection issue. Like Edgar recommended, try running smtpd -dv possibly with trace enabled as well. Good luck, Reio
