Re: Problem using senders table in listen directive

2019-10-14 Thread y38h5z 
Thanks for your remark. I gave it a try on postgresql 11.5. Running different 
versions of my query against it gives the same result for my case:

SELECT CONCAT(username, '@', domain) FROM users WHERE ?1 LIKE mailbox;
SELECT CONCAT(username, '@', domain) FROM users WHERE mailbox LIKE ?1;

I'm still stuck concerning my actual problem. As far as I understand the 
senders table should return a list of all addresses the user may send mail from.

Greetings,
  Michael



‐‐‐ Original Message ‐‐‐
Am Montag, Oktober 14, 2019 3:13 PM schrieb Ian Darwin :

> There are several reasons that sqlite is called 'lite'. One is that it is 
> extremely light on SQL standards conformance.
> It allows (I assume deliberately) many lax interpretations, in aid of getting 
> the job done.
>
> If you try this on a real SQL database like postgresql in ports, the inverted 
> form fails:
>
> website=# select * from product where 'http%' like url;
> (0 rows)
>
> website=# select * from product where url like 'http%';
> (100 rows)
>
> Clearly that doesn't matter in the case where sqlite is the only possible 
> database, but since people may read
> your post by doing a web search on 'sql like' and be deceived into thinking 
> you were talking about sql databases,
> I wanted to not leave readers of the list with an incorrect impression.
>
> > Hello Giovanni,
> > I just gave it a try. The order of the operands of the LIKE operator 
> > doesn't make any difference. I just tested it manually against my sqlite 
> > database. The returned results are identical.
> >
> > > On 10/12/19 4:46 PM, y38...@protonmail.com wrote:
> > >
> > > > SELECT (username||'@'||domain) FROM users WHERE ? LIKE mailbox
> > >
> > > I think it should read
> > > SELECT (username||'@'||domain) FROM users WHERE mailbox LIKE ?
> > > typo or error ?
> > > Giovanni

sympa mailing lists

2019-10-14 Thread Tony Boston 
Hi misc@

I have an issue finding the correct syntax in smtp.conf.

Sympa Docs say the following

table sympa db:$SYSCONFIDR/sympa_domain_aliases.db
accept from any for any recipient  virtual 
 
table lists db:$SENDMAIL_ALIASES.db
accept from any for any recipient  virtual 
 
#
# Here may be the rules for addresses excluded from mailing list service.
#
 
table sympa_domains { "mail.example.org" }
reject from any for domain 

I just don’t know how to write those rules in respect to the new syntax in 
OpenSMTPd.
Could someone give any advise?

Cheers
--
Tony

GPG-FP: 49CC8250 CDCF2183 6209C1AE 625677C1 F7783D5F
Threema: DN8PJX4Z

Re: Problem using senders table in listen directive

2019-10-14 Thread Reio Remma 

I just tested with MySQL and the result is the same.

smtpd -dv -T lookup yielded:

de334c3363d95880 smtp authentication user=u...@host.com result=ok
debug: smtp: SIZE in MAIL FROM command
debug: lka: mailaddrmap senderalias:u...@host.com
lookup: lookup "u...@host.com" as MAILADDRMAP in table proc:senderalias 
-> error: No such file or directory

warn: failure during mailaddrmap lookup senderalias:u...@host.com

Preceeded by:

senderalias[36753]: debug: (re)connecting
senderalias[36753]: debug: connected

So the table is loaded but it tries to look up from a file maybe?

Good luck,
Reio

On 14/10/2019 13:32, y38...@protonmail.com wrote:

Hello Giovanni,

I just gave it a try. The order of the operands of the LIKE operator doesn't 
make any difference. I just tested it manually against my sqlite database. The 
returned results are identical.

Greetings,
   Michael

‐‐‐ Original Message ‐‐‐
Am Montag, Oktober 14, 2019 9:15 AM schrieb Giovanni Bechis 
:


On 10/12/19 4:46 PM, y38...@protonmail.com wrote:


SELECT (username||'@'||domain) FROM users WHERE ? LIKE mailbox

I think it should read
SELECT (username||'@'||domain) FROM users WHERE mailbox LIKE ?
typo or error ?

Giovanni

Re: Problem using senders table in listen directive

2019-10-14 Thread y38h5z 
Hello Giovanni,

I just gave it a try. The order of the operands of the LIKE operator doesn't 
make any difference. I just tested it manually against my sqlite database. The 
returned results are identical.

Greetings,
  Michael

‐‐‐ Original Message ‐‐‐
Am Montag, Oktober 14, 2019 9:15 AM schrieb Giovanni Bechis 
:

> On 10/12/19 4:46 PM, y38...@protonmail.com wrote:
>
> > SELECT (username||'@'||domain) FROM users WHERE ? LIKE mailbox
>
> I think it should read
> SELECT (username||'@'||domain) FROM users WHERE mailbox LIKE ?
> typo or error ?
>
> Giovanni

Re: Problem using senders table in listen directive

2019-10-14 Thread Giovanni Bechis 
On 10/12/19 4:46 PM, y38...@protonmail.com wrote:
> SELECT (username||'@'||domain) FROM users WHERE ? LIKE mailbox
I think it should read
SELECT (username||'@'||domain) FROM users WHERE mailbox LIKE ?
typo or error ?
 
 Giovanni