Hi. I checked it out many times and couldn't find where the problem was.
I have read many problems and weird behaviours from the debian version from repositories..... so... i decided to give up and move to the latest version on the official webpage and now the "select" works like a charm. I don't know if this is a bug or just that the debian version needs something in addittion to "normal" set up, but it just didn't work in my case. Thank you for all. En/na Jordi Moles ha escrit: > Hi, > > i'll check it out again and let you know something. > > Thank you. > > En/na Mark Martinec ha escrit: > >> Jordi, >> >> >> >>> i've got a debian etch server, with amavis 2.4.2-6.1 and postfix 2.3.8-2. >>> Reading throught different manual pages on the Internet i've managed to >>> set up all the configuration i wanted except one thing, the white-black >>> lists. >>> I want them to work on the mysql server, and i've been already trying >>> for 2 days with no luck at all. >>> >>> I create the following tables: >>> CREATE TABLE `wblist` (... >>> CREATE TABLE `mailaddr` (... >>> >>> >> >> >>> I put some values into each table. >>> >>> Then, i've tried so many "selects" into de amavis configuration, none of >>> them working. >>> >>> For example: >>> >>> $sql_select_white_black_list = >>> 'SELECT wb FROM wblist LEFT JOIN mailaddr ON wblist.sid=mailaddr.id'. >>> ' WHERE (wblist.rid=?)' >>> . ' AND (mailaddr.email IN (%k))'. >>> ' ORDER BY mailaddr.priority DESC'; >>> >>> >> are you supplying a correct user.id (to be matched with wblist.rid)? >> >> >> >>> or just... >>> >>> $sql_select_white_black_list = 'SELECT "B" FROM wblist'; >>> which to my undesrtanding that would mark anything as BLACKMAILED. >>> >>> >> ...if there are any records in the wblist table. >> >> >> >>> Jan 16 11:24:04 postfix01.glusterproves /usr/sbin/amavisd-new[4223]: >>> (04223-01) wbl: checking sender <[EMAIL PROTECTED]> >>> Jan 16 11:24:04 postfix01.glusterproves /usr/sbin/amavisd-new[4223]: >>> (04223-01) lookup_sql_field(id) (WARN: no such field in the SQL table), >>> >>> >> How is your table 'users' set up? It appears it is lacking the 'id' field. >> This table lists your recipients (individually or just their domain(s)). >> >> Mark >> >> ------------------------------------------------------------------------- >> This SF.net email is sponsored by: Microsoft >> Defy all challenges. Microsoft(R) Visual Studio 2008. >> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ >> _______________________________________________ >> AMaViS-user mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/amavis-user >> AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 >> AMaViS-HowTos:http://www.amavis.org/howto/ >> >> > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > AMaViS-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/amavis-user > AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 > AMaViS-HowTos:http://www.amavis.org/howto/ > ------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2008. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
