I installed everything new! And it is the same problem as before. I created the database through plesk and flushed the privileges. Everything exactly like you described. I’m really going mad right now.
But I discovered something! bmeshier posted once a sample of his greylist_dbg.txt and there where three sql commands:
1. SELECT id, block_expires > NOW(), block_expires < NOW() FROM relaytofrom WHERE record_expires > NOW() AND mail_from IS NULL AND rcpt_to IS NULL AND (relay_ip = '69.64.46.29' OR relay_ip = '69.64.46' OR relay_ip = '69.64' OR relay_ip = '69') ORDER BY length(relay_ip)
2. SELECT id, block_expires > NOW(), block_expires < NOW() FROM relaytofrom WHERE record_expires > NOW() AND mail_from IS NULL AND relay_ip IS NULL AND rcpt_to = 'meshier.com'
3. SELECT id, NOW() > block_expires FROM relaytofrom WHERE record_expires > NOW() AND mail_from = '
[email protected]' AND rcpt_to = '
[email protected]' AND relay_ip like '69.64.46%' order by block_expires desc
and 4.
update relaytofrom set record_expires = NOW() + INTERVAL 36 DAY, passed_count = passed_count + 1 where id ='259503'
I get always this as result:
MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)
Is this right? Seems mysql is doing nothing at all, or is it a complete different command that qmail uses instead of the one in the .txt file?
My local_scan.c file looks like this:
#define MYSQLHOST "localhost"
#define MYSQLUSER "greylisting"
#define MYSQLPASS "greylistqmail"
#define MYSQLDB "qmail"
#define BLOCK_EXPIRE 5 /* minutes until email is accepted */
#define RECORD_EXPIRE 600 /* minutes until record expires */
#define RECORD_EXPIRE_GOOD 36 /* days until record expires after accepting email */
Any suggestions?