Context Navigation

← Previous Ticket
Next Ticket →

Modify ↓

Ticket #3608 (closed defect: worksforme)

Last modified 17 months ago

SLAPD Errors running updates

Reported by:	expertgeeks@…	Owned by:	cperez@…
Milestone:	2.2.X	Component:	users
Severity:	blocker	Keywords:	LDAP SLAPD upgrade
Cc:

Description

LDAP/SAMBA is working on the server but am concerned that if the upgrade goes ahead the users module will run into problems. When running apt-get update in a console, I get the following;

Reading package lists... Done Building dependency tree Reading state information... Done dnsutils is already the newest version. The following packages were automatically installed and are no longer required:

dnsmasq-base python-numpy novnc libfreeradius2 mimetex liblapack3gf smarty freeradius-common libblas3gf libgfortran3 libvirt-bin freeradius freeradius-ldap

Use 'apt-get autoremove' to remove them. 0 upgraded, 0 newly installed, 0 to remove and 21 not upgraded. 1 not fully installed or removed. After this operation, 0B of additional disk space will be used. Setting up slapd (2.4.21-0ubuntu5.6) ...

Backing up /etc/ldap/slapd.d/ in /var/backups/slapd-2.4.21-0ubuntu5.5... done.

chown: cannot access `olcDbDirectory\nolcDbDirectory\nolcDbDirectory\nolcDbDirectory\nolcDbDirectory': No such file or directory dpkg: error processing slapd (--configure):

subprocess installed post-installation script returned error exit status 1

Errors were encountered while processing:

slapd

E: Sub-process /usr/bin/dpkg returned an error code (1) root@server:/etc/bind#

Attachments

Change History

comment:1 Changed 18 months ago by expertgeeks@…

On reflection, I'm not sure this should be submitted as a defect, as is not a problem with Zentyal as such.. Should this be dealt with as a forum post ?

comment:2 Changed 17 months ago by expertgeeks@…

priority changed from normal to highest
Severity changed from normal to blocker

Yes, this is definately a problem with Zentyal. Heard nothing back from yourselves via trac so I attempted updating. re: http://trac.zentyal.org/ticket/3620 Now cannot log in to GUI & am getting seriously worrying LDAP messages. Cannot export passwords etc from LDAP database because cannot log in to GUI to get the LDAP password.

comment:3 Changed 17 months ago by cperez@…

Status changed from new to assigned

Hi, I've found this old bug in launchpad:

https://bugs.launchpad.net/ubuntu/+source/openldap/+bug/450645

They say:

Yep, in your case, the problem is the existence of the "olcDatabase={1}hdb.ldif~" backup file.

(The postinst script currently assumes that only one file will contain the string "olcSuffix: dc=nasgul,dc=local", but here both the .ldif and .ldif~ file contain it.)

If you don't care much about keeping that backup file, you could delete it (or at least move it out of the slapd.d/cn=config directory), then run "dpkg --configure slapd" to try running the slapd configuration step again.

Have you edited manually your ldap configuration? Can you check the same ls? Maybe that fix works for you

Regards

comment:4 Changed 17 months ago by expertgeeks@…

I have installed phpLDAPadmin logged in to the LDAP database to export data regarding Netbios names of PCs in the domain. I don't think I edited the database, but it's possible I did so accidentally when setting up.

This is what's in my /etc/ldap/slapd.d/cn=config folder;

cn=module{0}.ldif cn=schema cn=schema.ldif olcDatabase={0}config.ldif olcDatabase={-1}frontend.ldif olcDatabase={1}hdb.ldif olcDatabase={1}hdb.ldif.new olcDatabase={1}hdb.ldif.no olcDatabase={1}hdb.ldif.old olcDatabase={1}hdb.ldif.orig olcDatabase={1}hdb

I moved the .new .no .old and .orig files and ran 'dpkg --configure slapd'

Setting up slapd (2.4.21-0ubuntu5.6) ...

Backing up /etc/ldap/slapd.d/ in /var/backups/slapd-2.4.21-0ubuntu5.5... done.

Not starting slapd: SLAPD_NO_START set in /etc/default/slapd Processing triggers for libc-bin ... ldconfig deferred processing now taking place

which completed successfully. Unfortunately the GUI still cannot be accessed. I tried to restart the users module manually;

/etc/init.d/zentyal zentyal-users restart zentyal-users is not a valid module name Module list: Can't call method "ldap" on an undefined value at /usr/share/perl5EBox/MailVDomainsLdap.pm line 40, <DATA> line 466.

How can I restart the zentyal-users module from the command line without rebooting the server? Currently network authentication works so I don't want to make things worse!

comment:5 Changed 17 months ago by expertgeeks@…

Thanks for the help. It's much appreciated.

comment:6 Changed 17 months ago by cperez@…

"/etc/init.d/zentyal users restart" will restart users module, along with slapd

comment:7 Changed 17 months ago by expertgeeks@…

I get the same result;

root@server# /etc/init.d/zentyal users restart
users is not a valid module name
Module list:
Can't call method "ldap" on an undefined value at /usr/share/perl5/EBox/MailVDomainsLdap.pm line 40, <DATA> line 466.

line 40 reads: $self->{ldap} = EBox::Global->modInstance('users')->ldap();

comment:8 Changed 17 months ago by expertgeeks@…

FYI. I have pulled the LDAP password from the server;

sudo cat /var/lib/zentyal/conf/ebox-ldap.passwd

and successfully logged in to phpLDAPadmin. I am now able to edit the LDAP database if required.

comment:9 Changed 17 months ago by expertgeeks@…

I'm guessing the problem is most likely to be due to the users module not being able to restart. Would it be helpful to find what '<DATA> line 466' refers to?

The following warnings are reported when starting phpLDAPadmin, there were no errors reported.

Unknown XML setting [array]
Unknown attribute setting will be ignored. [s:2:"10";]

Missing [post] setting in XML file [helper]
[helper] needs an accompanying [post] action.

Unknown XML setting [location]
Unknown XML type setting for helper will be ignored. [side]

Automatically removed attribute from template
User Group: memberUid removed from template as it is not defined by an ObjectClass

Automatically removed objectClass from template
Thunderbird: Address Book Entry: mozillaOrgPerson removed from template as it is not defined in the schema

Automatically removed attribute from template
Thunderbird: Address Book Entry: c removed from template as it is not defined by an ObjectClass

comment:10 Changed 17 months ago by cperez@…

I think your LDAP database is corrupted, reinstall and restore your last backup. For an easy reinstall do:

/usr/share/zentyal-users/reinstall

Best regards

comment:11 Changed 17 months ago by expertgeeks@…

I tried as you suggested but none of the system backups could be restored. Each time I would get the same errors as in comment 4.

As none of the back-ups worked I was forced to manually re-create the users, groups and shares after re-running the /usr/share/zentyal-users/reinstall script. As the domain had been recreated, none of the workstations now recognised the domain and I had to manually leave and rejoin the domain on each of the 75 machines..

I have set up the email accounts but am getting errors when enabling the mail filter..

2012/01/05 00:49:12 INFO> Base.pm:228 EBox::Module::Base::save - Restarting service for module: mailfilter
2012/01/05 00:49:39 ERROR> Ldap.pm:699 EBox::Ldap::_errorOnLdap - $VAR1 = {
          'changes' => [
                         'add',
                         [
                           'objectClass',
                           'vdmailfilter',
                           'domainMailPortion',
                           '@domain-emailaddress.com'
                         ]
                       ]
        };
2012/01/05 00:49:39 ERROR> Ldap.pm:701 EBox::Ldap::_errorOnLdap - Unknown error at EBox::MailFilter::VDomainsLdap::_addVDomain objectClass: value #0 invalid per syntax
2012/01/05 00:49:39 ERROR> GlobalImpl.pm:612 EBox::GlobalImpl::__ANON__ - Failed to save changes in module mailfilter: Unknown error at EBox::MailFilter::VDomainsLdap::_addVDomain objectClass: value #0 invalid per syntax
2012/01/05 00:49:39 INFO> Base.pm:228 EBox::Module::Base::save - Restarting service for module: logs
2012/01/05 00:49:40 ERROR> GlobalImpl.pm:664 EBox::GlobalImpl::saveAllModules - The following modules failed while saving their changes, their state is unknown: mailfilter

Any ideas as to why this is happening? Can this be related to the original problem? I'm almost there !

comment:12 Changed 17 months ago by expertgeeks@…

I tried removing and reinstalling the mailfilter module, but the errors are the same.

comment:13 Changed 17 months ago by expertgeeks@…

I have removed and re-installed the mail, mailfilter and webmail modules and am no-longer getting any errors in the logs when saving changes. I have successfully imported the old mail & am sending/receiving via mail clients. The webmail is still broken however;

DATABASE ERROR: CONNECTION FAILED!

Unable to connect to the database!
Please contact your server-administrator.

I have tried /usr/share/zentyal/purge-module webmail but didn't get any output or change in errors.

This is the last thing to fix :)

comment:14 Changed 17 months ago by cperez@…

Status changed from assigned to closed
Resolution set to worksforme

Hi,

I couldn't reproduce this, it seems that there was some kind of corruption in your postgresql database. Please provide logging info if you can.

Best regards

comment:15 Changed 17 months ago by expertgeeks

here's a chunk from the postgres log;

2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2005-10-1 00:00:00' AND samba_quarantine.timestamp < date '2005-10-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2005-11-1 00:00:00' AND samba_quarantine.timestamp < date '2005-11-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2005-12-1 00:00:00' AND samba_quarantine.timestamp < date '2005-12-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-1-1 00:00:00' AND samba_quarantine.timestamp < date '2006-1-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-2-1 00:00:00' AND samba_quarantine.timestamp < date '2006-2-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-3-1 00:00:00' AND samba_quarantine.timestamp < date '2006-3-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-4-1 00:00:00' AND samba_quarantine.timestamp < date '2006-4-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-5-1 00:00:00' AND samba_quarantine.timestamp < date '2006-5-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-6-1 00:00:00' AND samba_quarantine.timestamp < date '2006-6-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-7-1 00:00:00' AND samba_quarantine.timestamp < date '2006-7-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-8-1 00:00:00' AND samba_quarantine.timestamp < date '2006-8-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-9-1 00:00:00' AND samba_quarantine.timestamp < date '2006-9-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-10-1 00:00:00' AND samba_quarantine.timestamp < date '2006-10-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-11-1 00:00:00' AND samba_quarantine.timestamp < date '2006-11-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2006-12-1 00:00:00' AND samba_quarantine.timestamp < date '2006-12-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-1-1 00:00:00' AND samba_quarantine.timestamp < date '2007-1-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-2-1 00:00:00' AND samba_quarantine.timestamp < date '2007-2-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-3-1 00:00:00' AND samba_quarantine.timestamp < date '2007-3-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-4-1 00:00:00' AND samba_quarantine.timestamp < date '2007-4-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-5-1 00:00:00' AND samba_quarantine.timestamp < date '2007-5-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-6-1 00:00:00' AND samba_quarantine.timestamp < date '2007-6-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-7-1 00:00:00' AND samba_quarantine.timestamp < date '2007-7-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-8-1 00:00:00' AND samba_quarantine.timestamp < date '2007-8-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-9-1 00:00:00' AND samba_quarantine.timestamp < date '2007-9-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-10-1 00:00:00' AND samba_quarantine.timestamp < date '2007-10-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-11-1 00:00:00' AND samba_quarantine.timestamp < date '2007-11-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2007-12-1 00:00:00' AND samba_quarantine.timestamp < date '2007-12-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-1-1 00:00:00' AND samba_quarantine.timestamp < date '2008-1-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-2-1 00:00:00' AND samba_quarantine.timestamp < date '2008-2-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-3-1 00:00:00' AND samba_quarantine.timestamp < date '2008-3-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-4-1 00:00:00' AND samba_quarantine.timestamp < date '2008-4-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-5-1 00:00:00' AND samba_quarantine.timestamp < date '2008-5-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-6-1 00:00:00' AND samba_quarantine.timestamp < date '2008-6-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-7-1 00:00:00' AND samba_quarantine.timestamp < date '2008-7-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-8-1 00:00:00' AND samba_quarantine.timestamp < date '2008-8-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-9-1 00:00:00' AND samba_quarantine.timestamp < date '2008-9-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-10-1 00:00:00' AND samba_quarantine.timestamp < date '2008-10-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-11-1 00:00:00' AND samba_quarantine.timestamp < date '2008-11-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2008-12-1 00:00:00' AND samba_quarantine.timestamp < date '2008-12-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-1-1 00:00:00' AND samba_quarantine.timestamp < date '2009-1-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-2-1 00:00:00' AND samba_quarantine.timestamp < date '2009-2-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-3-1 00:00:00' AND samba_quarantine.timestamp < date '2009-3-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-4-1 00:00:00' AND samba_quarantine.timestamp < date '2009-4-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-5-1 00:00:00' AND samba_quarantine.timestamp < date '2009-5-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-6-1 00:00:00' AND samba_quarantine.timestamp < date '2009-6-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-7-1 00:00:00' AND samba_quarantine.timestamp < date '2009-7-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-8-1 00:00:00' AND samba_quarantine.timestamp < date '2009-8-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-9-1 00:00:00' AND samba_quarantine.timestamp < date '2009-9-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-10-1 00:00:00' AND samba_quarantine.timestamp < date '2009-10-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-11-1 00:00:00' AND samba_quarantine.timestamp < date '2009-11-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2009-12-1 00:00:00' AND samba_quarantine.timestamp < date '2009-12-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-1-1 00:00:00' AND samba_quarantine.timestamp < date '2010-1-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-2-1 00:00:00' AND samba_quarantine.timestamp < date '2010-2-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-3-1 00:00:00' AND samba_quarantine.timestamp < date '2010-3-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-4-1 00:00:00' AND samba_quarantine.timestamp < date '2010-4-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-5-1 00:00:00' AND samba_quarantine.timestamp < date '2010-5-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-6-1 00:00:00' AND samba_quarantine.timestamp < date '2010-6-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-7-1 00:00:00' AND samba_quarantine.timestamp < date '2010-7-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-8-1 00:00:00' AND samba_quarantine.timestamp < date '2010-8-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-9-1 00:00:00' AND samba_quarantine.timestamp < date '2010-9-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-10-1 00:00:00' AND samba_quarantine.timestamp < date '2010-10-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-11-1 00:00:00' AND samba_quarantine.timestamp < date '2010-11-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2010-12-1 00:00:00' AND samba_quarantine.timestamp < date '2010-12-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-1-1 00:00:00' AND samba_quarantine.timestamp < date '2011-1-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-2-1 00:00:00' AND samba_quarantine.timestamp < date '2011-2-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-3-1 00:00:00' AND samba_quarantine.timestamp < date '2011-3-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-4-1 00:00:00' AND samba_quarantine.timestamp < date '2011-4-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-5-1 00:00:00' AND samba_quarantine.timestamp < date '2011-5-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-6-1 00:00:00' AND samba_quarantine.timestamp < date '2011-6-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-7-1 00:00:00' AND samba_quarantine.timestamp < date '2011-7-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-8-1 00:00:00' AND samba_quarantine.timestamp < date '2011-8-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-9-1 00:00:00' AND samba_quarantine.timestamp < date '2011-9-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-10-1 00:00:00' AND samba_quarantine.timestamp < date '2011-10-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-11-1 00:00:00' AND samba_quarantine.timestamp < date '2011-11-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2011-12-1 00:00:00' AND samba_quarantine.timestamp < date '2011-12-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:09 GMT ERROR:  column "share" does not exist at character 8
2012-01-09 18:17:09 GMT STATEMENT:  SELECT share, count(*) as virus FROM samba_quarantine WHERE event='quarantine' AND (samba_quarantine.timestamp >= '2012-1-1 00:00:00' AND samba_quarantine.timestamp < date '2012-1-01 00:00:00' + interval '1 month') GROUP BY filename ;
2012-01-09 18:17:15 GMT LOG:  unexpected EOF on client connection
2012-01-09 18:18:03 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-09 18:18:03 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-09 18:25:26 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-09 18:29:44 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-09 18:29:44 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-09 18:29:55 GMT ERROR:  null value in column "clientconn" violates not-null constraint
2012-01-09 18:29:55 GMT STATEMENT:  INSERT INTO mailfilter_pop (spam,timestamp,mails,address,virus,clean,event,clientConn) VALUES ($1,$2,$3,$4,$5,$6,$7,$8)
2012-01-09 18:33:37 GMT ERROR:  null value in column "clientconn" violates not-null constraint
2012-01-09 18:33:37 GMT STATEMENT:  INSERT INTO mailfilter_pop (spam,timestamp,mails,address,virus,clean,event,clientConn) VALUES ($1,$2,$3,$4,$5,$6,$7,$8)
2012-01-09 18:38:04 GMT FATAL:  Ident authentication failed for user "amavis"

comment:16 Changed 17 months ago by expertgeeks

Status changed from closed to reopened
Resolution worksforme deleted

comment:17 Changed 17 months ago by jacalvo@…

Status changed from reopened to closed
Resolution set to worksforme

Hi,

I'm afraid this is a different problem not related with the original issue of the tickets, and I'm not sure if it has anything to do with Zentyal itself. I mean, it seems some kind of database corruption (the postgresql database), so please, reopen only if you can reproduce this in a clean installation. Thanks.

comment:18 Changed 17 months ago by expertgeeks

I agree that whatever caused this has affected two different databases, but both databases seem to have become corrupted during normal operation..

I have resolved the LDAP issues by reinstalling users and groups. How can I re-initialise the postgresql db ?

comment:19 Changed 17 months ago by expertgeeks

I have turned off events module and this seems to have stopped the majority of errors from appearing in the zentyal log. I don't use events so this is not a big problem. I'm still regularly getting this in the postgresql logs;

2012-01-11 08:53:49 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-11 08:54:51 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-11 08:55:39 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-11 09:00:25 GMT FATAL:  Ident authentication failed for user "amavis"
2012-01-11 09:00:41 GMT FATAL:  Ident authentication failed for user "amavis"

I want to try http://trac.zentyal.org/ticket/3436 but I'm not allowed to download the schema. Can you change the permissions or add it to this ticket please ?

View ↑

Add a comment

You may use WikiFormatting here.

Modify Ticket

Change Properties

Summary:
Type:	Milestone:
Component:	Severity:
Keywords:	Add/Remove from Cc:	<Author field>

Action

leave as closed

reopen The resolution will be deleted. Next status will be 'reopened'

Author

Your email or username:

E-mail address and user name can be saved in the Preferences.

Attachments ↑

Note: See TracTickets for help on using tickets.

Download in other formats: