LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 03-20-2008, 06:43 PM   #1
pfa
LQ Newbie
 
Registered: Jun 2007
Posts: 3

Rep: Reputation: 0
sqlgrey postfix installation problem


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
 
Old 03-21-2008, 12:07 AM   #2
jimbo1708
Member
 
Registered: Jan 2007
Location: Pennsylvania
Distribution: Ubuntu 8.10 Server/9.04 Desktop, openSUSE 11.1
Posts: 154

Rep: Reputation: 31
reply

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

http://sqlgrey.sourceforge.net/
 
Old 03-21-2008, 01:30 AM   #3
pfa
LQ Newbie
 
Registered: Jun 2007
Posts: 3

Original Poster
Rep: Reputation: 0
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
 
Old 03-21-2008, 09:53 AM   #4
jimbo1708
Member
 
Registered: Jan 2007
Location: Pennsylvania
Distribution: Ubuntu 8.10 Server/9.04 Desktop, openSUSE 11.1
Posts: 154

Rep: Reputation: 31
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
 
Old 03-21-2008, 10:36 PM   #5
pfa
LQ Newbie
 
Registered: Jun 2007
Posts: 3

Original Poster
Rep: Reputation: 0
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix installation basak Linux - Software 1 12-11-2006 04:13 PM
Basic Postfix Installation Problem InTech Linux - Software 3 10-30-2006 12:20 AM
Postfix installation jitheshmurali Linux - General 1 06-08-2006 09:30 AM
Postfix send mail problem(In RH9, kernal 2.4.20, postfix 2.1.5) minor Linux - General 4 07-11-2005 10:12 PM
postfix server installation, samba server problem eozdoganci Linux - Networking 0 06-04-2004 07:14 AM


All times are GMT -5. The time now is 12:06 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration