[BlueOnyx:23510] Re: E-Mail and GeoIP

[Michael Stauber]

Hi Darren,

> Recently I installed the AV-SPAM package on 5209R for the GeoIP features
> but when I start the e-mail server I see the GeoIP errors below (not
> available) - does anyone know how to go about debugging this?

I just checked. There was a GeoIP update from CentOS, which replaced the
GeoIP that we have in the BlueOnyx YUM repos.

That messed with which database our GeoIP uses. We're using the legacy
"GeoLite2 Country", which is available without subscription. It is less
accurate and no longer being maintained, though.

Check if you have a /usr/share/GeoIP/GeoLiteCountry.dat and that it is
larger than 0 bytes. It should be around 1.2 MB:

]# ls -hals /usr/share/GeoIP/GeoLiteCountry.dat
1,2M -rw-r--r-- 1 root root 1,2M  1. Apr 2018
/usr/share/GeoIP/GeoLiteCountry.dat

Your /usr/share/GeoIP/GeoIP.dat *should* be a symbolic link to
/usr/share/GeoIP/GeoLiteCountry.dat, but the recent update might have
pointed it to GeoIP-initial.dat instead.

Fix:

rm /usr/share/GeoIP/GeoIP.dat
ln -s /usr/share/GeoIP/GeoLiteCountry.dat /usr/share/GeoIP/GeoIP.dat

That should fix it.

I will publish a YUM update that will correctly point GeoIP to the right
database again.

> Dec  2 11:52:43 bugblatter sendmail[14038]: xB2BqhtX014038: Milter
> (spamassassin): local socket name /var/run/spamass.sock unsafe
> Dec  2 11:52:43 bugblatter sendmail[14038]: xB2BqhtX014038: Milter
> (spamassassin): to error state
Please run this to restart all services in the correct sequence:

/usr/sausalito/sbin/avspam_init.pl -restart

Then check the status with this command and it should be fine:

/usr/sausalito/sbin/avspam_init.pl -status

-- 
With best regards

Michael Stauber