Hello everyone. It is ok now. Thanks Rick. I have some more questions to be get it clearer ...
I see, that with greylist more complex filtering can be done, like : mysql -h $MYSQLHOST -u $MYSQLUSER -p$MYSQLPASS $MYSQLDB -e \ "delete FROM relaytofrom WHERE mail_from = '' || rcpt_to = '';" so all mail to|from '' don't get to the mailboxes. or some whitelist can be done like this: mysql -h $MYSQLHOST -u $MYSQLUSER -p$MYSQLPASS $MYSQLDB -e \ "update relaytofrom SET passed_count = '1' WHERE mail_from like '%@ hitelistdomain.com' and passed_count = '0';" #every hour you can also make passed_count = '0' for domains you want to blacklist, and update database every hour. DO I understand it right ? Could you guys share your thought about this ? Thanks, Jaroslav On 03/10/2007, Rick Macdougall <[EMAIL PROTECTED]> wrote: > > Jaroslav wrote: > > Hello. > > I did like you said but got the error while doing make: > > > > ./compile local_scan.c > > local_scan.c:15:38: error: /usr/include/mysql/mysql.h: No such file or > > directory > > local_scan.c:34: error: expected Б─≤)Б─≥ before Б─≤*Б─≥ token > > local_scan.c:64: error: expected Б─≤)Б─≥ before Б─≤*Б─≥ token > > local_scan.c:103: error: expected Б─≤)Б─≥ before Б─≤*Б─≥ token > > local_scan.c:162: error: expected Б─≤)Б─≥ before Б─≤*Б─≥ token > > local_scan.c: In function Б─≤local_scanБ─≥: > > local_scan.c:258: error: Б─≤MYSQLБ─≥ undeclared (first use in this > function) > > local_scan.c:258: error: (Each undeclared identifier is reported only > once > > local_scan.c:258: error: for each function it appears in.) > > local_scan.c:258: error: Б─≤mysqlБ─≥ undeclared (first use in this > function) > > make: *** [local_scan.o] Error 1 > > > > seems I need mysql sources, right ? > > Distro is Ubuntu. > > > > Hi, > > Yes, you will need mysql-dev or what ever it is called under Ubuntu. > > Regards, > > Rick > >
