Re: [OpenSMTPD-5.9.1] Postgresql Backend

2016-07-11 Thread Mischa
b / > query_userinfo ? No > è Does query_userinfo fill a proc: ? No idea. > In parallel I used the syntax : > _ query_credentials select account, password from vusers where account=$1; > instead > _ query_credentials select account, password from vusers where account=?; > (from the Giovanni’s presentation : opensmtpd-linuxcon2015) > The syntax used is working fine on my side. > è Where can I find all last informations or correct syntax for it ? I think it depends on the backend you are using. Mischa -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org

Virtual domain setup sanity check

2016-07-02 Thread Mischa
..@virtualdomain1.tld The end goal is to move the files to either sqlite or MariaDB. Am I missing the bloody obvious or is it not possible, to have overlapping left hand side of the email addresses, without remapping in the aliases table? Thanx!! Mischa -- You received this mail because you are subscri

Re: Virtual domain setup sanity check

2016-07-02 Thread Mischa
o for a kick ass, albeit confusing at times :)), smtp server! With all the filtering in place it's time to move away from Postfix! Mischa > On 02 Jul 2016, at 13:39, Mischa <open...@high5.nl> wrote: > > Hi All, > > I have been wrecking my brain to figure out how to get Op

Re: plans for 2017

2017-02-09 Thread Mischa
Hi Gilles, Thank you for expressing your plans. Looking forward to the changes. Keep it coming, you are doing great things! Mischa > On 9 Feb 2017, at 10:44, Gilles Chehade <gil...@poolp.org> wrote: > > Hello misc@, > > It's been calm for a while due to "real-

Re: tool-stats

2016-09-06 Thread Mischa
Hi Giovanni, Nope... native. Only running this machine with a honeypot domain at the moment. # uname -a OpenBSD br1 6.0 GENERIC.MP#0 amd64 Mischa > On 06 Sep 2016, at 18:22, Giovanni Bechis <giova...@paclan.it> wrote: > > On 09/06/16 18:10, Mischa wrote: >> Hi All, >

tool-stats

2016-09-06 Thread Mischa
quot; /var/log/maillog 754 Mischa -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org

Re: Filter withdrawals

2016-09-12 Thread Mischa
provides a much more timely notification of > activity, but I haven't found the round tuits to do it and am unlikely > to do so. I am very interested in that script as well. Would be great to have a blacklist function in spamd based on RBLs. Mischa -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail to: misc+unsubscr...@opensmtpd.org

relayd l7 loadbalancing

2017-08-14 Thread Mischa
ent requests. With "match request quick url" this is to be expected as it checks everything up to /. For example: http://example.com/ -> wwwhost http://example.com/crm/ -> otherhost http://exmaple.com/folder/ -> otherhost Is this expected behaviour for "match reques

Re: Filter email where sender and rcpt-to are the same

2019-02-20 Thread Mischa
> On 6 Feb 2019, at 17:24, Mischa wrote: > >> On 6 Feb 2019, at 15:38, Gilles Chehade wrote: >> >> On Wed, Feb 06, 2019 at 11:42:19AM +0100, Mischa wrote: >>> Hi All, >>> >>> There has been a new scam going around for some time now wher

Filter email where sender and rcpt-to are the same

2019-02-06 Thread Mischa
this email from your own account. etc.. Is there a quick way to filter email where the sender and rcpt-to are the same? Has anybody created a filter already to easily do this? Thanx! Mischa -- You received this mail because you are subscribed to misc@opensmtpd.org To unsubscribe, send a mail

Re: match rule seems to be failing in -current

2019-01-29 Thread Mischa
> On 29 Jan 2019, at 16:20, Gilles Chehade wrote: > > On Tue, Jan 29, 2019 at 01:10:47PM +0100, Mischa wrote: >> Hi Gilles, >> >>> well, providing the full session log from connect to disconnect without >>> altering it would be a good start to troubl

match rule seems to be failing in -current

2019-01-25 Thread Mischa
mx1 smtpd[36743]: 00a1b263550db3c7 smtp disconnected reason=disconnect Jan 18 14:10:04 mx1 smtpd[36743]: 00a1b263550db3c7 smtp connected address=46.23.xx.xx host=www.domain2.nl Jan 18 14:10:04 mx1 smtpd[36743]: 00a1b263550db3c7 smtp failed-command command="RCPT TO:" result="550

Re: match rule seems to be failing in -current

2019-01-29 Thread Mischa
> On 29 Jan 2019, at 12:30, Gilles Chehade wrote: > > On Fri, Jan 25, 2019 at 02:08:41PM +0100, Mischa wrote: >> Hi All, >> > > Hi, > > >> ### smtpd.conf >> pki mx1.domain1.nl cert "/etc/ssl/mx1.domain1.nl.fullchain.pem" >>

Re: match rule seems to be failing in -current

2019-01-29 Thread Mischa
Hi Gilles, > On 29 Jan 2019, at 12:58, Gilles Chehade wrote: > > On Tue, Jan 29, 2019 at 12:41:17PM +0100, Mischa wrote: >> >> >>> On 29 Jan 2019, at 12:30, Gilles Chehade wrote: >>> >>> On Fri, Jan 25, 2019 at 02:08:41PM +01

Re: RBLs?

2019-06-20 Thread Mischa
:file=/etc/mail/dnsbl-2.uceprotect.net psbl:\ :black:\ :msg="Your address %A is listed on PSBL\n\ See https://psbl.org/":\ :method=file:\ :file=/etc/mail/psbl.txt dnsbl-white:\ :white:\ :method=file:\ :file=/etc/mail/ips.whitelisted.or

Re: Unable to remove mail from queue

2020-06-04 Thread Mischa
Hi Gilles, Ok. So course of action is indeed just to rm the files? Which works for me. ;) Mischa > On 4 Jun 2020, at 05:16, Gilles Chehade wrote: > > this is due to a short-coming with how inflight envelopes are handled: > > when a mail is passed from scheduler to mt

Re: Crashing once a day and not auto-starting back

2016-05-05 Thread Mischa Peters
Hi All, There was an awesome utility once, daedalus. Written in Ruby though. :) http://portsmon.freebsd.org/portoverview.py?category=sysutils=daedalus Mischa -- > On 05 May 2016, at 17:30, Edgar Pettijohn <ed...@pettijohn-web.com> wrote: > > You could have a cron job check th

Re: Greylisting

2016-09-10 Thread Mischa Peters
Hi Silvio, Have a look at spamd. https://www.openbsd.org/spamd/index.html Also runs on non-OpenBSD. Mischa > On 10 Sep 2016, at 19:10, Silvio Siefke <siefke_lis...@web.de> wrote: > > Hello, > > is greylisting available in opensmtpd? I have so much spam

Re: Greylisting

2016-09-11 Thread Mischa Peters
Hi Peter, That is indeed a great article. Thank you for writing it. It gave me a new appreciation for spamd again. :) Mischa > On 11 Sep 2016, at 12:17, Peter N. M. Hansteen <pe...@bsdly.net> wrote: > >> On 09/10/16 19:10, Silvio Siefke wrote: >> I search with go

Unable to remove mail from queue

2020-05-31 Thread Mischa Peters
to pinpoint what is going on, before I rm the files? Mischa