Milter-greylist

I am seeing lots of the following in my logs:
milter-greylist: GeoIP is not available

However, I know that GeoIP is installed:
[root@host ~]# rpm -qa | grep -i geo
perl-Geography-Countries-1.4-2.2.el5.rf
GeoIP-devel-1.4.3-1
GeoIP-1.4.3-1

[root@thor ~]# /usr/bin/geoiplookup milter-greylist.sf.net
GeoIP Country Edition: US, United States
[root@thor ~]#

I had rebuilt the milger-greylist from src, pointed it to the
libraries... and it indicated it found them.
I am currently running "milter-greylist-4.0rc1"

From my message in August:

> > geoipdb "/path/to/GeoIP.dat"
> 
> Ok, that got me going, thanks. I looked in the source and that "GeoIP is 
> not available" is issued when no database is specified.



Kai

-- 
Kai Sch\ufffdtzl, Berlin, Germany
Get your web at Conactive Internet Services: http://www.conactive.com

Please add a configuration option to disable GeoIP.

Fedora is packaging milter-greylist with GeoIP enabled at compile time, but
the user may not have a GeoIP account; in that case syslog gets lots of
"GeoIP is not available" messages.


Thanks a lot for your great milter!!,
Ernesto.

> Fedora is packaging milter-greylist with GeoIP enabled at compile  
> time, but
> the user may not have a GeoIP account; in that case syslog gets  
> lots of
> "GeoIP is not available" messages.

You don't need a GeoIP account.
The problem is that the greylist.conf file from the RPM doesn't have  
the correct path to the installed GeoIP database

You need :

geoipdb "/usr/share/GeoIP/GeoIP.dat"

in your /etc/mail/greylist.conf file

Using the provided "geoipupdate" to get a newer database will fail  
with a "Invalid UserID" message, and the correct Requires aren't in  
the GeoIP RPM to pull in the modules needed by the perl scripts  
included, so they don't work either.

1)
You can go to the maxmind website and download a newer copy of the  
database manually fairly easily.

2)
Install the modules for the perl script -

sudo yum install perl-libwww-perl

then

sudo perl /usr/share/doc/GeoIP-1.4.3/fetch-geoipdata.pl
Fetching GeoIP.dat from http://www.maxmind.com/download/geoip/ 
database/GeoIP.dat.gz
GeoIP database updated. Old copy is at GeoIP.dat.20080326

or add that to your monthly cron jobs.
The free database is updated monthly.


Charles Dostale
System Admin - Silver Oaks Communications
http://www.silveroaks.com/
824 17th Street, Moline  IL  61265

Thanks !

In Fedora 8 just adding the line in greylist.conf file did the trick, as the
database is included in the RPM package GeoIP.

Ernesto.


  -----Mensaje original-----
  De: milter-greylist@yahoogroups.com
[mailto:milter-greylist@yahoogroups.com]En nombre de chasd
  Enviado el: Miercoles, 26 de Marzo de 2008 05:53 p.m.
  Para: milter-greylist@yahoogroups.com
  Asunto: Re: [milter-greylist] GeoIP is not available


  > Fedora is packaging milter-greylist with GeoIP enabled at compile
  > time, but
  > the user may not have a GeoIP account; in that case syslog gets
  > lots of
  > "GeoIP is not available" messages.

  You don't need a GeoIP account.
  The problem is that the greylist.conf file from the RPM doesn't have
  the correct path to the installed GeoIP database

  You need :

  geoipdb "/usr/share/GeoIP/GeoIP.dat"

  in your /etc/mail/greylist.conf file

  Using the provided "geoipupdate" to get a newer database will fail
  with a "Invalid UserID" message, and the correct Requires aren't in
  the GeoIP RPM to pull in the modules needed by the perl scripts
  included, so they don't work either.

  1)
  You can go to the maxmind website and download a newer copy of the
  database manually fairly easily.

  2)
  Install the modules for the perl script -

  sudo yum install perl-libwww-perl

  then

  sudo perl /usr/share/doc/GeoIP-1.4.3/fetch-geoipdata.pl
  Fetching GeoIP.dat from http://www.maxmind.com/download/geoip/
  database/GeoIP.dat.gz
  GeoIP database updated. Old copy is at GeoIP.dat.20080326

  or add that to your monthly cron jobs.
  The free database is updated monthly.

  Charles Dostale
  System Admin - Silver Oaks Communications
  http://www.silveroaks.com/
  824 17th Street, Moline IL 61265

> In Fedora 8 just adding the line in greylist.conf file did the  
> trick, as the
> database is included in the RPM package GeoIP.

Yes but it is from last year when F8 was released.
It is a good idea to update the database at least when you install  
GeoIP.

When F9 is released in May, an updated database should be installed.  
Any Fedora release will update the database as well, but those come  
roughly every 6 months. If you want to keep your GeoIP database more  
current, or you don't upgrade this OS consistently, you have to  
initiate the database updates yourself.

I see you beat me to filling the milter-greylist bug

<https://bugzilla.redhat.com/show_bug.cgi?id=439087>

I filed a GeoIP bug -

<https://bugzilla.redhat.com/show_bug.cgi?id=439267>


Charles Dostale
System Admin - Silver Oaks Communications
http://www.silveroaks.com/
824 17th Street, Moline  IL  61265