FATAL: Ident authentication failed for user "amavis"

[antpeter@…]

There are a lot of errors in PostgreSQL log file

~$ tail -10 /var/log/postgresql/postgresql-8.4-main.log.1
2011-10-30 04:17:06 MSK LOG:  unexpected EOF on client connection
2011-10-30 05:17:06 MSK LOG:  unexpected EOF on client connection
2011-10-30 06:17:05 MSK LOG:  unexpected EOF on client connection
2011-10-30 06:18:01 MSK FATAL:  Ident authentication failed for user "amavis"
2011-10-30 06:18:01 MSK FATAL:  Ident authentication failed for user "amavis"
2011-10-30 07:17:06 MSK LOG:  unexpected EOF on client connection
2011-10-30 07:25:02 MSK FATAL:  Ident authentication failed for user "amavis"
2011-10-30 07:25:09 MSK LOG:  unexpected EOF on client connection
2011-10-30 07:35:02 MSK FATAL:  Ident authentication failed for user "amavis"
2011-10-30 07:35:02 MSK FATAL:  Ident authentication failed for user "amavis"


~$ cat /etc/lsb-release
DISTRIB_ID=Ubuntu
DISTRIB_RELEASE=10.04
DISTRIB_CODENAME=lucid
DISTRIB_DESCRIPTION="Ubuntu 10.04.3 LTS"


$ dpkg -l | grep amavis
ii  amavisd-new                            1:2.6.4-1ubuntu5                  Interface between MTA and virus scanner/cont


$ dpkg -l | grep zentyal
ii  duplicity                              0.6.13-0ubuntu1+zentyal1          encrypted bandwidth-efficient backup
ii  language-pack-zentyal-ru               2.2.1                             Zentyal translations for language Russian
ii  libhtml-mason-perl                     1:1.44-1+zentyal1                 HTML::Mason Perl module
ii  libjs-jquery                           1.5-2ubuntu1+zentyal1             JavaScript library for dynamic web applicati
ii  liblog-any-perl                        0.11-1+zentyal1                   Log anywhere
ii  libredis-perl                          2:2.0.1-0ubuntu1+zentyal1         persistent key-value database with network i
ii  p3scan                                 2:2.3.2-7ubuntu1+zentyal2         transparent POP3-proxy with virus- and spam-
ii  php-mail-mime                          1.8.0-2+zentyal1                  PHP PEAR module for creating MIME messages
ii  php-net-smtp                           1.4.2-3+zentyal1                  PHP PEAR module implementing SMTP protocol
ii  roundcube                              0.5.3+dfsg-1+zentyal1             skinnable AJAX based webmail solution for IM
ii  roundcube-core                         0.5.3+dfsg-1+zentyal1             skinnable AJAX based webmail solution for IM
ii  roundcube-pgsql                        0.5.3+dfsg-1+zentyal1             metapackage providing PostgreSQL dependencie
ii  roundcube-plugins                      0.5.3+dfsg-1+zentyal1             skinnable AJAX based webmail solution for IM
ii  roundcube-sqlite                       0.5.3+dfsg-1+zentyal1             metapackage providing sqlite dependencies fo
ii  zentyal                                2.2                               Zentyal - Core metapackage
ii  zentyal-antivirus                      2.2                               Zentyal - Antivirus
ii  zentyal-ca                             2.2.2                             Zentyal - Certification Authority
ii  zentyal-common                         2.2.1                             Zentyal - Common Library
ii  zentyal-core                           2.2.3                             Zentyal - Core
ii  zentyal-ebackup                        2.2.1                             Zentyal - Backup
ii  zentyal-firewall                       2.2                               Zentyal - Firewall
ii  zentyal-mail                           2.2                               Zentyal - Mail Service
ii  zentyal-mailfilter                     2.2                               Zentyal - Mail Filter
ii  zentyal-monitor                        2.2                               Zentyal - Monitor
ii  zentyal-network                        2.2.3                             Zentyal - Network Configuration
ii  zentyal-objects                        2.2                               Zentyal - Network Objects
ii  zentyal-openvpn                        2.2                               Zentyal - VPN Service
ii  zentyal-printers                       2.2                               Zentyal - Printer Sharing Service
ii  zentyal-remoteservices                 2.2.2                             Zentyal - Cloud Client
ii  zentyal-samba                          2.2                               Zentyal - File Sharing Service
ii  zentyal-services                       2.2                               Zentyal - Network Services
ii  zentyal-software                       2.2.2                             Zentyal - Software Management
ii  zentyal-squid                          2.2.1                             Zentyal - HTTP Proxy (Cache and Filter)
ii  zentyal-usercorner                     2.2                               Zentyal - User Corner
ii  zentyal-users                          2.2.3                             Zentyal - Users and Groups
ii  zentyal-webmail                        2.2                               Zentyal - Web Mail Service
ii  zentyal-webserver                      2.2.2                             Zentyal - Web Server

[antpeter@…]

Additional information:

Analysis of PostgreSQL base shows that user "amavis" does not exist

:~$ sudo su - postgres
postgres@~$ psql
psql (8.4.9)
Type "help" for help.

postgres=# select usename from pg_user;
  usename
-----------
 postgres
 ebox
 roundcube
(3 rows)

[antpeter@…]

Another ERROR in PostgreSQL log after adding "amavis" user:

~$ sudo su - postgres
~$ psql
psql (8.4.9)
Type "help" for help.

postgres=# CREATE USER amavis;
CREATE
postgres=# GRANT ALL PRIVILEGES ON DATABASE spamassassin to amavis;
GRANT
postgres=# \q



~$ sudo tail /var/log/postgresql/postgresql-8.4-main.log
2011-11-13 19:49:59 MSK ERROR:  relation "bayes_global_vars" does not exist at character 19
2011-11-13 19:49:59 MSK STATEMENT:  SELECT value FROM bayes_global_vars WHERE variable = 'VERSION'
2011-11-13 20:17:06 MSK LOG:  unexpected EOF on client connection
2011-11-13 21:17:06 MSK LOG:  unexpected EOF on client connection
2011-11-13 21:18:02 MSK ERROR:  relation "bayes_global_vars" does not exist at character 19
2011-11-13 21:18:02 MSK STATEMENT:  SELECT value FROM bayes_global_vars WHERE variable = 'VERSION'
2011-11-13 21:18:02 MSK ERROR:  relation "bayes_global_vars" does not exist at character 19
2011-11-13 21:18:02 MSK STATEMENT:  SELECT value FROM bayes_global_vars WHERE variable = 'VERSION'
2011-11-13 21:18:02 MSK ERROR:  relation "bayes_global_vars" does not exist at character 19
2011-11-13 21:18:02 MSK STATEMENT:  SELECT value FROM bayes_global_vars WHERE variable = 'VERSION'

[jamor@…]

(In [23734]) Fixed regression in spamassassin database setup closes #3436

[jamor@…]

Thanks Antpeter to point this out.

However the fix is only for new installations, to fix your installation you hsould follow the following steps:

1) Grab the spamassassin.sql file from  http://trac.zentyal.org/export/23734/branches/jag/2.2-oct10/mailfilter/schemas/sql/spamassassin.sql

2) Copy it to /usr/share/zentyal-mailfilter/sql with the following prermissions:

root@z22:/usr/share/zentyal-mailfilter/sql# ls -l spamassassin.sql 
-rw-r--r-- 1 root root 4077 2011-12-02 13:37 spamassassin.sql

3) execute as superuser '/usr/share/zentyal-mailfilter/mailfilter-sql update'

4) execute as superuser '/etc/init.d/zentyal mailfitler restart'

Regards,

Javier