Spam notification

2010-06-18 Thread Antoine Nguyen
Hi all, I'm facing a stupid situation and I'm looking for advises. I'm using a postfix relay to filter viruses and spams. All is working well except with spam that use the same declared address for both sender and recipient. What happened in this particular situation is described as follow:

Re: Spam notification

2010-06-18 Thread Antoine Nguyen
Le 18/06/2010 11:15, Michael Weissenbacher a écrit : Conclusion: the spam is passed! I could stop sending notifications but I think my employer would not like it... Short answer: You should NEVER notify anyone about detected spam! This will effectively make yourself a spam source.

Re: Spam notification

2010-06-18 Thread Antoine Nguyen
Le 18/06/2010 11:28, Mark Goodge a écrit : On 18/06/2010 10:17, Antoine Nguyen wrote: Le 18/06/2010 11:15, Michael Weissenbacher a écrit : Conclusion: the spam is passed! I could stop sending notifications but I think my employer would not like it... Short answer: You should NEVER notify

Re: Spam notification

2010-06-18 Thread Antoine Nguyen
Le 18/06/2010 11:42, Erik Logtenberg a écrit : Michael Weissenbacher wrote: Conclusion: the spam is passed! I could stop sending notifications but I think my employer would not like it... Short answer: You should NEVER notify anyone about detected spam! This will effectiv

Re: Spam notification

2010-06-18 Thread Antoine Nguyen
Le 18/06/2010 11:51, Reko Turja a écrit : I'm not a great fan of quarantining, although it works fairly well for webmail systems where the quarantine can be accessed through the same interface as the inbox (eg, Gmail and Hotmail). It's less helpful where mail is delivered to a POP3 or IMAP box

MailNG: simple web solution to manage virtual domains

2009-06-19 Thread Antoine Nguyen
Hi all, I'm working on a web solution to manage virtual domains. It has been tested with Postfix and Dovecot. A MySQL backend is needed. You cand find the project here : http://projects.koalabs.org/trac/mailng/ The source code is distributed under the BSD license. Regards, Antoine N

Re: Maildir not automaticily added with virtual users

2011-07-20 Thread Antoine Nguyen
x for each virtual user you will hande: /etc/postfix/vmailbox: u...@example.comexample.com/user/Maildir/ -- Antoine Nguyen Modoboa developer http://modoboa.org

Re: Plesk or equivalent to manage Postfix ?

2011-11-04 Thread Antoine Nguyen
interface that avoid mistakes ( I don't want to let them modify something by hands !!!) For domains and mailboxes management, you can take a look at http://modoboa.org/. -- Antoine Nguyen Modoboa developer http://modoboa.org

Re: Graphical stats by domain

2013-04-04 Thread Antoine Nguyen
Muzaffer Tolga Özses wrote: >Good morning everyone :) > >Do you guys know of a tool that will act like pflogsumm, only based on >domain and graphical? > >Regards, > Hi, take a look at modoboa (http://modoboa.org/). It supports per-domain graphical stats using RRDtool. Antoine

Re: Autoresponder

2016-04-16 Thread Antoine Nguyen
t Modoboa (http://modoboa.org/), it provides an autoresponder. Antoine Nguyen

mysql lookup table and utf8

2016-09-12 Thread Antoine Nguyen
Dear list, I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 domains. The setup is almost ready but when I make some tests, utf8 domains are not found (I see "relay access denied" errors in the logs) and I get the same result using postmap: > postmap -q raté.com mysql:/etc/

mysql lookup table and utf8

2016-09-12 Thread Antoine Nguyen
me result using postmap: postmap -q raté.com mysql:/etc/postfix/sql-domains.cf If I try with a domain containing ascii characters only, it works just fine. What am I doing wrong ? Thanks for your help, Antoine Nguyen

Re: mysql lookup table and utf8

2016-09-12 Thread Antoine Nguyen
On 12/09/2016 12:42, Wietse Venema wrote: Antoine Nguyen: Dear list, sorry for my previous incomplete message. I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 domains. The setup is almost ready but when I make some tests, utf8 domains are not found (I see "re

Re: mysql lookup table and utf8

2016-09-12 Thread Antoine Nguyen
On 12/09/2016 17:04, Wietse Venema wrote: Antoine Nguyen: On 12/09/2016 12:42, Wietse Venema wrote: Antoine Nguyen: Dear list, sorry for my previous incomplete message. I'm trying to setup a postfix 3.0 with a mysql backend to host utf8 domains. The setup is almost ready but when I

Re: mysql lookup table and utf8

2016-09-13 Thread Antoine Nguyen
mysql:/etc/postfix/sql-domains.cf Just a stupid question but am I right to think the use case I'm trying to implement using Postfix 3+ and a SQL backend should work ? Thanks in advance, Antoine Nguyen

Re: mysql lookup table and utf8

2016-09-13 Thread Antoine Nguyen
On 13/09/2016 12:43, Wietse Venema wrote: Antoine Nguyen: On 12/09/2016 17:04, Wietse Venema wrote: Just for test, what happens when you do: (this is what Postfix daemons use by default) LC_ALL=C postmap -q rat?.com mysql:/etc/postfix/sql-domains.cf (this is to test what happens with

Re: mysql lookup table and utf8

2016-09-13 Thread Antoine Nguyen
On 13/09/2016 16:10, Admin Beckspaced wrote: hello ;) not sure if this will help? but had a similar issue with mysql queries a while back. it actually had nothing to do with postfix and sql lookup tables ... but ran into trouble with different mysql character sets ... causing queries to also

Re: mysql lookup table and utf8

2016-09-13 Thread Antoine Nguyen
On 13/09/2016 18:08, Viktor Dukhovni wrote: Make sure your shell or terminal emulator is not mangling utf-8 input or command-line arguments. * Post your map.cf file content, perhaps that map file restricts which lookup keys are passed on to the underlying database. * Place the lookup key

Re: mysql lookup table and utf8

2016-09-14 Thread Antoine Nguyen
On 14/09/2016 04:01, Viktor Dukhovni wrote: On Tue, Sep 13, 2016 at 09:52:16PM +0200, Antoine Nguyen wrote: query = SELECT name FROM admin_domain WHERE name='%s' AND type='domain' AND enabled=1 What is not clear is how MySQL's quoting behaves given the inpu

Re: mysql lookup table and utf8

2016-09-14 Thread Antoine Nguyen
On 14/09/2016 10:27, Antoine Nguyen wrote: The first query was executed using mysql shell and it returns 1 row. The second query was executed by postmap and returns nothing whereas we can see they are the same... I've just tried with postgresql and the result is the same... Antoine

Re: mysql lookup table and utf8

2016-09-14 Thread Antoine Nguyen
On 14/09/2016 12:53, Wietse Venema wrote: Antoine Nguyen: [ Charset windows-1252 converted... ] On 14/09/2016 10:27, Antoine Nguyen wrote: The first query was executed using mysql shell and it returns 1 row. The second query was executed by postmap and returns nothing whereas we can see they

Re: mysql lookup table and utf8

2016-09-14 Thread Antoine Nguyen
On 14/09/2016 14:17, Viktor Dukhovni wrote: On Wed, Sep 14, 2016 at 10:27:32AM +0200, Antoine Nguyen wrote: Do make sure that your tests with the sql CLI really make the same query against the same database: SELECT name FROM admin_domain WHERE name='' AND type='domain

Re: mysql lookup table and utf8

2016-09-14 Thread Antoine Nguyen
On 14/09/2016 14:53, Viktor Dukhovni wrote: Please post a single message with two complete traces in which: * The Unix login users executing "postmap -q" and using the MySQL shell are the same. (That is the same unix shell spawns both "postmap -q" and the MySQL interactive sess

Re: mysql lookup table and utf8

2016-09-14 Thread Antoine Nguyen
On 14/09/2016 16:09, Antoine Nguyen wrote: As I said, I made some tests with postgres and I think I found an interesting hint inside logs: LOG: statement: set client_encoding to 'LATIN1' LOG: statement: SELECT name FROM admin_domain WHERE name='raté.com' AND type=

Re: mysql lookup table and utf8

2016-09-14 Thread Antoine Nguyen
On 14/09/2016 17:06, Viktor Dukhovni wrote: On Wed, Sep 14, 2016 at 04:14:32PM +0200, Antoine Nguyen wrote: I haven't found how to change default client encoding yet... Does postfix set it ? Sorry to reply to myself but looks like the answer is here: https://github.com/vdukhovni/postfix

Re: mysql lookup table and utf8

2016-09-14 Thread Antoine Nguyen
On 14/09/2016 14:53, Viktor Dukhovni wrote: Please look for any client-side configuration files that might be loaded by the MySQL interactive shell that may affect connection settings, such as perhaps the client character set. Looks like I've found the issue. Actually, the mysql connector doe

Re: mysql lookup table and utf8

2016-09-16 Thread Antoine Nguyen
On 15/09/2016 16:47, Viktor Dukhovni wrote: On Thu, Sep 15, 2016 at 09:51:11AM -0400, Wietse Venema wrote: Stephan Seitz: On Thu, Sep 15, 2016 at 06:49:08AM -0400, Wietse Venema wrote: FYI, Postfix uses libmysqlclient. So what's up with not reading the default config file? Can it be the usua