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/
