ERROR: relation "..." does not exist

[didier@…]

Hi,

My /var/log/ebox/ebox.log is full of this kind of error:

ERROR> PgDBEngine.pm:258 EBox::PgDBEngine::multiInsert - Error inserting data: INSERT INTO mail_message (from_address,message_type,status,event,message,to_address,client_host_name,timestamp,client_host_ip) VALUES (?,?,?,?,?,?,?,?,?)
ERROR:  relation "mail_message" does not exist
LINE 1: INSERT INTO mail_message (from_address,message_type,status,e...
                    ^ 
Values: $VAR1 = [
          {
            'from_address' => 'XXX@XXX',
            'message_type' => 'received',
            'status' => 'reject',
            'event' => 'greylist',
            'message' => '450 4.2.0 <XXXX@XXXX>: Recipient address rejected: Greylisted, see http://postgrey.schweikert.ch/help/beca.be.html',
            'to_address' => 'XXX@XXX',
            'client_host_name' => '178235057017.ustka.vectranet.pl',
            'timestamp' => '2011-May-2 21:55:19',
            'client_host_ip' => 'XX.XX.XX.XX'
          }
        ];
[...]
DEBUG> PgDBEngine.pm:349 EBox::PgDBEngine::query - Error querying data: SELECT * FROM mailfilter_smtp_report WHERE event = 'SPAM' AND action = 'Passed' AND from_domain = 'abbc.org' AND to_domain = 'XXX.XX' AND date = '2011-4-01 00:00:00' ; , ERROR:  relation "mailfilter_smtp_report" does not exist
LINE 1: SELECT * FROM mailfilter_smtp_report WHERE event = 'SPAM' AN...
[...]
DEBUG> PgDBEngine.pm:194 EBox::PgDBEngine::unbufferedInsert - Values: $VAR1 = [
          '1',
          'XXXX.XX',
          'abbc.org',
          '2011-4-01 00:00:00',
          'Passed',
          'SPAM'
        ];
[...]
DEBUG> PgDBEngine.pm:349 EBox::PgDBEngine::query - Error querying data: SELECT * FROM mailfilter_pop_traffic_weekly ORDER BY date  , ERROR:  relation "mailfi
lter_pop_traffic_weekly" does not exist
LINE 1: SELECT * FROM mailfilter_pop_traffic_weekly ORDER BY date

It is also notable that my logs "Mail" and "SMTP Filter" in the Zentyal web administration are empty.

~# apt-cache policy ebox ebox-mail ebox-mailfilter
ebox:
  Installed: 2.0.17
  Candidate: 2.0.17
  Version table:
 *** 2.0.17 0
        500 http://ppa.launchpad.net/zentyal/2.0/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status
     1.5-0ubuntu1 0
        500 http://be.archive.ubuntu.com/ubuntu/ lucid/universe Packages
ebox-mail:
  Installed: 2.0.6
  Candidate: 2.0.6
  Version table:
 *** 2.0.6 0
        500 http://ppa.launchpad.net/zentyal/2.0/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status
ebox-mailfilter:
  Installed: 2.0.2
  Candidate: 2.0.2
  Version table:
 *** 2.0.2 0
        500 http://ppa.launchpad.net/zentyal/2.0/ubuntu/ lucid/main Packages
        100 /var/lib/dpkg/status

The installation is a fresh install of 3 weeks. Has an installation script failed during a recent update of the system?

[jacalvo@…]

We can't reproduce this, but probably it was due to some fail on your postgreSQL database during the installation (the tables wasn't created).

Please try to execute the following:

sudo apt-get install --reinstall ebox-mail

That should create the tables if your database is working properly now.

[didier@…]

sudo apt-get install --reinstall ebox-mail 

Indeed, that's solved my problem. Thanks for your help.