HI, I have been trying to get sqlgrey working with my postfix, but although indicates that it is installed correctly with no errors, I don't get any indication on the incoming emails in my maillog that it is indeed causing then to wait before being resent.

main.cf:
smtpd_recipient_restrictions = reject_unauth_pipelining,
reject_unknown_recipient_domain,
permit_mynetworks,
permit_mx_backup,
permit_sasl_authenticated
reject_unauth_destination,
check_policy_service inet:127.0.0.1:2501

maillog
Mar 21 09:32:42 mercury2 sqlgrey: Process Backgrounded
Mar 21 09:32:42 mercury2 sqlgrey: 2008/03/21-09:32:42 sqlgrey (type Net::Server::Multiplex) starting! pid(7241)
Mar 21 09:32:42 mercury2 sqlgrey: Binding to TCP port 2501 on host localhost#012
Mar 21 09:32:42 mercury2 sqlgrey: Setting gid to "491 491"
Mar 21 09:32:42 mercury2 sqlgrey: Setting uid to "495"

Paul

check the section on non-delivery. Try seeing if you are getting any log entries into those directories.

http://sqlgrey.sourceforge.net/

Hi jimbo1708
not sure what you are asking but I have read the page you suggested, But find nothing new there that would help.
My maillog file is thus:
Mar 21 16:21:48 mercury2 postfix/smtpd[8510]: NOQUEUE: reject: RCPT from unknown[118.68.4.208]: 550 5.1.1 <aida@grantsbookshop.com.au>: Recipient address rejected: User unknown in virtual alias table; from=<htvx@bohse.com> to=<aida@grantsbookshop.com.au> proto=ESMTP helo=<[118.68.4.208]>
Mar 21 16:21:49 mercury2 postfix/smtpd[8510]:last message repeated 2 times
Mar 21 16:21:49 mercury2 postfix/smtpd[8510]: disconnect from unknown[118.68.4.208]
Mar 21 16:21:50 mercury2 postfix/smtpd[8620]: NOQUEUE: reject: RCPT from unknown[91.144.137.207]: 550 5.1.1

And I have seen that I should have a message in the maillog with every new connection indicating that the email should be resent, This is not there. Also I have checked the email server with dnsstuff and get an immediate connection where I should get a reply 451 or similar to indicate try again later.

I also tried postgrey on this server and had the same problem, everything installed and setup according to the information supplied, but no postgrey messages.
I also have another server, with a very similar fc8 install, but it worked fine first time with the postgrey.
I am stumped after spending the last 4 days on this.
Paul

look at 7
http://fedorasolved.org/server-solut...ix-mail-server

Because sqlgrey is starting and running ok, maybe there are problems with it being able to access the database. Are you sure your permissions are set up properly?

- JB

Hi jimbo1708,
I had been using the default database SQLite, but setup and tried the mysql database as indicated in your link above, but still the same problem.
Just in case its relevant, I don't have amavis or clamv or spamassassin or any spam or virus checking installed.
My sqlgrey conf file contains:
## Database settings
# instead of Pg below use "mysql" for MySQL, "SQLite" for SQLite
# any DBD driver is allowed, but only the previous 3 have been tested
db_type = mysql
db_name = sqlgrey
# Note: the following are not used with SQLite
db_host = localhost
db_port = default
db_user = sqlgrey
db_pass = jab001
# db_cleandelay = 1800 # in seconds, how much time between database cleanups

The user and group is set to sqlgrey in the /etc/sqlgrey directory.

Also when I first installed sqlgrey it said clients_fqdn_whitelist.local and clients_ip_whitelist.local did not exist to I created these files, but they are both empty.

Paul