This is not _excactly_ a dbmail problem but it's kinda close so... I have one server which is using postgre as the backend and one on mysql. Now both of them are perfectly fine but there's a small problem with the relay lookup on postgre backend server.
Now I use imap_before_smtp to save the IP addresses of the clients to enable on-the-road smtp server for them. On postgresql side this unfortunately started failing recently pretty nastily (upgraded postfix & postgre) when before it was just giving an error. DBMail saves the host's IP address as is in the database, but postfix wants to query by the fqdn. That will produce the following: -- clip -- Jul 21 15:39:50 vanessa postfix/smtpd[87307]: connect from catfish.tfproject.org[209.50.251.11] Jul 21 15:39:50 vanessa postfix/smtpd[87307]: match_hostname: catfish.tfproject.org ~? 127.0.0.0/8 Jul 21 15:39:50 vanessa postfix/smtpd[87307]: match_hostaddr: 209.50.251.11 ~? 127.0.0.0/8 Jul 21 15:39:50 vanessa postfix/smtpd[87307]: match_hostname: catfish.tfproject.org ~? 134.160.174.10 Jul 21 15:39:50 vanessa postfix/smtpd[87307]: match_hostaddr: 209.50.251.11 ~? 134.160.174.10 Jul 21 15:39:50 vanessa postfix/smtpd[87307]: match_hostname: catfish.tfproject.org ~? pgsql:/usr/local/etc/postfix/relay.pgsql(0,lock|fold_fix) Jul 21 15:39:50 vanessa postgres[87308]: [1-1] ERROR: invalid input syntax for type inet: "catfish.tfproject.org" Jul 21 15:39:50 vanessa postfix/smtpd[87307]: dict_pgsql_get_active: attempting to connect to host /tmp/ Jul 21 15:39:50 vanessa postfix/smtpd[87307]: dict_pgsql: successful connection to host /tmp/ Jul 21 15:39:50 vanessa postfix/smtpd[87307]: warning: pgsql query failed: fatal error from host /tmp/: ERROR: invalid input syntax for type inet: "catfish.tfproject.org"? Jul 21 15:39:50 vanessa postfix/smtpd[87307]: match_hostname: lookup pgsql:/usr/local/etc/postfix/relay.pgsql catfish.tfproject.org: notfound Jul 21 15:39:50 vanessa postfix/smtpd[87307]: fatal: pgsql:/usr/local/etc/postfix/relay.pgsql(0,lock|fold_fix): table lookup problem Jul 21 15:39:50 vanessa kernel: Jul 21 15:39:50 vanessa postfix/smtpd[87307]: fatal: pgsql:/usr/local/etc/postfix/relay.pgsql(0,lock|fold_fix): table lookup problem -- clip -- Before this just produced an error, life went on and somehow it still worked (postfix tried with IP after failing with fqdn?). Now I end up with fatal and delivery stops there... Any ideas? I tried to disable dns lookups from postfix -> doesn't help. It still tries to execute the query with the fqdn, failing... I was thinking about doing some nasty wrangling with proxymap or possibly dumping the contents of the table every minute to a file... -- br, Tommi _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
