Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

    "User unknown in virtual mailbox table" after adding olcDbIndex: mail eq

    Kopano Groupware Core
    1
    2
    395
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • BMWfan
      BMWfan last edited by BMWfan

      Hello,

      i have seen many of this log entries under /var/log/syslog:

      Dec 27 20:47:19 euve264608 slapd[21619]: <= bdb_equality_candidates: (uidNumber) not indexed 
      Dec 27 20:46:40 euve264608 slapd[21619]: <= bdb_equality_candidates: (memberUid) not indexed
      Dec 27 20:41:38 euve264608 slapd[11858]: <= bdb_equality_candidates: (cn) not indexed
      Dec 27 20:41:38 euve264608 slapd[11858]: <= bdb_equality_candidates: (kopanoAliases) not indexed
      Dec 27 20:41:38 euve264608 slapd[11858]: <= bdb_equality_candidates: (mail) not indexed
      

      why i was adding these entries as explained here https://documentation.kopano.io/kopanocore_administrator_manual/configure_kc_components.html#configure-kopano-for-user-management-with-ldap-e-g-openldap-ads

      olcDbIndex: cn eq
      olcDbIndex: gidNumber eq
      olcDbIndex: mail eq
      olcDbIndex: memberUid eq
      olcDbIndex: ou eq
      olcDbIndex: uid eq
      olcDbIndex: uidNumber eq
      olcDbIndex: uniqueMember eq
      olcDbIndex: kopanoAccount eq
      olcDbIndex: kopanoAliases eq
      olcDbIndex: kopanoViewPrivilege eq
      

      After adding these entries no mails are arriving my server and the sender gets this message:

      CLIENT -> SERVER: RCPT TO:
      SERVER -> CLIENT: 550 5.1.1 : Recipient address rejected: User unknown in virtual mailbox table
      SMTP ERROR: RCPT TO command failed: 550 5.1.1 : Recipient address rejected: User unknown in virtual mailbox table
      

      If i delete only this entry olcDbIndex: mail eq then it seems to be functioning, but i getting furthermore this log entries:

      Dec 28 10:10:49 euve264608 slapd[27847]: <= bdb_equality_candidates: (mail) not indexed
      

      So it seems that this entry let postfix not more find the mailbox user, but why?

      Best Regards

      Daniel

      1 Reply Last reply Reply Quote 0
      • BMWfan
        BMWfan last edited by BMWfan

        So, i could fix this issue.

        i added the following

        olcDbIndex: mail eq,pres
        

        to /etc/ldap/slapd.d/cn\=config/olcDatabase\=\{1\}hdb.ldif

        and built a new checksum

        apt-get install rhash
        tail -n +3 /etc/ldap/slapd.d/cn\=config/olcDatabase\=\{1\}hdb.ldif | rhash -C - | awk '/stdin/ {print tolower($2)}'
        

        i have to take this new created checksum and to replace the old in line two in the file /etc/ldap/slapd.d/cn\=config/olcDatabase\=\{1\}hdb.ldif behind # CRC32.

        i hope this helps somebody.

        Best Regards

        Daniel

        1 Reply Last reply Reply Quote 0
        • First post
          Last post