[solved] db-backend kopano-cli MAPI error 80040111 (MAPI_E_LOGON_FAILED)

kopanocore-8.6.80.1005
mariadb-10.2.14
System; x86_64 LFS (from sources)
I had configured and used Zarafa in the past

# grep -v "^#" /etc/kopano/server.cfg | grep -v ^$
server_listen = *:236
local_admin_users = root kopano
log_file = /var/log/kopano/server.log
log_level = 6
#mysql_user = kopano gives same errors
mysql_password = kopano
mysql> CREATE DATABASE kopano;
mysql> CREATE USER 'kopano'@'localhost' IDENTIFIED BY 'kopano';
mysql> GRANT ALL ON kopano.* TO 'kopano'@'localhost';

After restarting mariadb and kopano-server:

# kopano-cli --list-users
[error  ] virtual HRESULT M4LMAPISession::OpenMsgStore(ULONG_PTR, ULONG, const ENTRYID*, LPCIID, ULONG, IMsgStore**): msp->Logon failed: logon failed (80040111)
MAPI error 80040111 (MAPI_E_LOGON_FAILED)
$ cat /var/log/kopano/server.log
Tue Jun 26 15:43:32 2018: [debug  ] Accepted incoming connection from file:///var/run/kopano/server.sock

/var/lib/mysql/localhost.log shows 7 times

Connect   root@localhost as anonymous on kopano

and other sql statements

Suggestions how to fix this problem?

Same error with

user_plugin = unix
# kopano-cli --list-users --debug
[error  ] virtual HRESULT M4LMAPISession::OpenMsgStore(ULONG_PTR, ULONG, const ENTRYID*, LPCIID, ULONG, IMsgStore**): msp->Logon failed: logon failed (80040111)
Traceback (most recent call last):
  File "/usr/lib/python2.7/site-packages/kopano_cli/__init__.py", line 590, in main
    check_options(parser, options, server)
  File "/usr/lib/python2.7/site-packages/kopano_cli/__init__.py", line 576, in check_options
    if server.multitenant and not (options.companies or options.groups or options.users):
  File "/usr/lib/python2.7/site-packages/kopano/server.py", line 503, in multitenant
    self._companylist()
  File "/usr/lib/python2.7/site-packages/kopano/server.py", line 497, in _companylist
    return [eccompany.Companyname for eccompany in self.sa.GetCompanyList(MAPI_UNICODE)]
  File "/usr/lib/python2.7/site-packages/kopano/server.py", line 282, in sa
    self._sa = self.mapistore.QueryInterface(IID_IECServiceAdmin)
  File "/usr/lib/python2.7/site-packages/kopano/server.py", line 276, in mapistore
    self._mapistore = GetDefaultStore(self.mapisession)
  File "/usr/lib/python2.7/site-packages/MAPI/Util/__init__.py", line 101, in GetDefaultStore
    return session.OpenMsgStore(0, row[1].Value, None, MDB_WRITE)
  File "/usr/lib/python2.7/site-packages/MAPICore.py", line 1464, in OpenMsgStore
    return _MAPICore.IMAPISession_OpenMsgStore(self, ulUIParam, cbEntryID, lpInterface, ulFlags)
MAPIErrorLogonFailed: MAPI error 80040111 (MAPI_E_LOGON_FAILED)
$ cat /var/lib/mysql/localhost.log
180627 20:14:57    31 Connect   kopano@localhost as anonymous on kopano
                   31 Query     SHOW tables
                   31 Query     SHOW variables LIKE 'max_allowed_packet'
                   31 Query     SET NAMES utf8
                   31 Query     SHOW SESSION VARIABLES LIKE 'group_concat_max_len'
                   31 Query     set max_sp_recursion_depth = 255
                   31 Query     SET SESSION sql_mode = 'STRICT_ALL_TABLES,NO_UNSIGNED_SUBTRACTION'
                   31 Query     SELECT hierarchy.id, stores.guid, stores.hierarchy_id, stores.type FROM stores join hierarchy on stores.hierarchy_id=hierarchy.parent WHERE stores.user_id=2 AND stores.type=0 LIMIT 1
                   24 Query     SELECT hierarchy.id, stores.guid, stores.hierarchy_id, stores.type FROM stores JOIN hierarchy on stores.hierarchy_id=hierarchy.parent WHERE stores.user_id = 1 LIMIT 1

This is kopanocore-8.6.80.1005. Would a newer version work?

Can you try an installation from our packages and see if you get the same errors?

I see they are newer: 8.6.80.1055
I’ll build my own rpm and report back
I think it is also needed to delete the database

intermediate report
8.6.80.1076 fom souces resulted in same error
Python2 was built after openssl
Installed 8.6.80.1055.rpms for Fedora Rawhide
I have icu-60.2, So dependency icu-61.1 compiled.
Missing dependency libgsoapssl++-2.8.60.so
I think I can create it from libgsoapssl+±.a

core-8.6.80.1055 from Fedora_Rawhide-x86_64 with gsoap-2.8.66 from Fedora-28
resuted in same error with command

#  kopano-cli --list-users

Same result after dropping database and user kopano and rescreating user and grantt all without CREATE DATABASE kopano;
(startiup kopano-server creates database if not exists)
Something wrong with my Python-2.7.14? I built it with

./configure --prefix=/usr --enable-shared --with-system-expat \
  --with-system-ffi --enable-unicode=ucs4 --with-ensurepip=yes

kopanocore-8.6.80.1248
After recompiling with previously missing libkcoidc-0.3.0 and ibs3-4.1 and upgradet to icu-61.1 results same MAPI error 80040111
Clean installed Fedora-28 same error.
There are packaging bugs:
1 Fedora-28 has only libicu-60 but the kopano packackages are linked to libicu-61
2 python2-kopano dependency python-tz doesnt exist. Should be python2-pytz

@tjoen said in db-backend kopano-cli MAPI error 80040111 (MAPI_E_LOGON_FAILED):

1 Fedora-28 has only libicu-60 but the kopano packackages are linked to libicu-61

17:06 a4:../core_master/kopano > rpm -qRp binaries/libkcutil0-8.6.80.1317-189.4.x86_64.rpm |grep icu
warning: binaries/libkcutil0-8.6.80.1317-189.4.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID ec07c591: NOKEY
libicudata.so.60()(64bit)
libicui18n.so.60()(64bit)
libicuuc.so.60()(64bit)

2 python2-kopano dependency python-tz doesnt exist. Should be python2-pytz

17:06 a4:../core_master/kopano > rpm -qRp binaries/python2-kopano-8.6.80.1317-189.4.x86_64.rpm 
warning: binaries/python2-kopano-8.6.80.1317-189.4.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID ec07c591: NOKEY
python(abi) = 2.7
python-dateutil
python-pytz
python2-mapi

@jengelh

17:06 a4:…/core_master/kopano > rpm -qRp binaries/libkcutil0-8.6.80.1317-189.4.x86_64.rpm |grep icu
libicudata.so.60()(64bit)

I see that has been solved compared to version-8.6.80.1248 of mine.
I have used my own icu-61.1 but same MAPI error 80040111

2 python2-kopano dependency python-tz doesnt exist. Should be python2-pytz

17:06 a4:…/core_master/kopano > rpm -qRp binaries/python2-kopano-8.6.80.1317-189.4.x86_64.rpm
python-pytz

$ rpm -qf /usr/lib/python2.7/site-packages/pytz
python2-pytz-2017.2-7.fc28.noarch

I see why it works:

$ rpm -q --provides python2-pytz
python-pytz = 2017.2-7.fc28
python2-pytz = 2017.2-7.fc28
python2.7dist(pytz) = 2017.2
python2dist(pytz) = 2017.2
pytz = 2017.2-7.fc28

kopanocore-8.6.80.1350-1.x86_64 compiled from sources. System LFS-like
Steps to reproduce the error

MariaDB [(none)]> DROP DATABASE kopano ;
MariaDB [(none)]> DROP USER 'kopano'@'localhost';
MariaDB [(none)]> CREATE USER 'kopano'@'localhost' IDENTIFIED BY 'kopano';
MariaDB [(none)]> GRANT ALL ON kopano.* TO 'kopano'@'localhost';
$ diff -uN /usr/share/doc/kopano/example-config/server.cfg /etc/kopano/server.cfg
--- /usr/share/doc/kopano/example-config/server.cfg     2018-07-27 13:30:37.000000000 +0200
+++ /etc/kopano/server.cfg      2018-07-27 14:02:46.313139693 +0200
@@ -128,10 +128,10 @@
 #mysql_port = 3306

 # The user under which we connect with MySQL
-#mysql_user = root
+mysql_user = kopano

 # The password for the user (leave empty for no password)
-#mysql_password =
+mysql_password = kopano

 # Override the default MySQL socket to access mysql locally
 # Works only if the mysql_host value is empty or 'localhost'
root$ systemctl start kopano-server
$ systemctl status kopano-server
   ...
   Active: active (running) since Fri 2018-07-27 21:42:01 CEST; 18s ago
   ...
root$ kopano-cli --create-store
[error  ] virtual HRESULT M4LMAPISession::OpenMsgStore(ULONG_PTR, ULONG, const ENTRYID*, LPCIID, ULONG, IMsgStore**): msp>Logon failed: logon failed (80040111)MAPI error 80040111 (MAPI_E_LOGON_FAILED)

In Fedora-28 kopano-server doesn’t start

$ systemctl status kopano-server
● kopano-server.service - Kopano Core Storage Server
   Loaded: loaded (/usr/lib/systemd/system/kopano-server.service; disabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Fri 2018-07-27 12:27:33 CEST; 1min 23s ago
     Docs: man:kopano-server(8)
           man:kopano-server.cfg(5)
           man:kopano-admin(8)
  Process: 2547 ExecStart=/usr/sbin/kopano-server -F (code=exited, status=203/EXEC)
 Main PID: 2547 (code=exited, status=203/EXEC)

Jul 27 12:27:33 localhost.localdomain systemd[1]: Started Kopano Core Storage Server.
Jul 27 12:27:33 localhost.localdomain systemd[1]: kopano-server.service: Main process exited, code=exited, status=203/EXEC
Jul 27 12:27:33 localhost.localdomain systemd[1]: kopano-server.service: Failed with result 'exit-code'.

Installed packages:
kopano-client-8.6.80.1350-212.1.x86_64
kopano-common-8.6.80.1350-212.1.x86_64
kopano-lang-8.6.80.1350-212.1.x86_64
kopano-server-8.6.80.1350-212.1.x86_64
kopano-utils-8.6.80.1350-212.1.x86_64
libkcarchiver0-8.6.80.1350-212.1.x86_64
libkcfreebusy0-8.6.80.1350-212.1.x86_64
libkcicalmapi0-8.6.80.1350-212.1.x86_64
libkcinetmapi0-8.6.80.1350-212.1.x86_64
libkcoidc0-0.3.0-17.1.x86_64
libkcrosie0-8.6.80.1350-212.1.x86_64
libkcserver0-8.6.80.1350-212.1.x86_64
libkcsoap0-8.6.80.1350-212.1.x86_64
libkcutil0-8.6.80.1350-212.1.x86_64
libmapi1-8.6.80.1350-212.1.x86_64
libs3-4-4.1.git257-2.2.x86_64
libtidy5-5.1.9-3.1.x86_64
libvmime-kopano1-0.9.2.50-10.1.x86_64
python2-kopano-8.6.80.1350-212.1.x86_64
python2-mapi-8.6.80.1350-212.1.x86_64

[SOLVED] in kopanocore-8.6.80.1420-1.x86_64 built from sources

$ kopano-cli --list-users
User list for Default (1):
            User           Full Name          Homeserver                                   Store
------------------------------------------------------------------------------------------------
          SYSTEM              SYSTEM             Unknown        8962FFEFFB7B4D639BC5967C4BB58234

@fbartels
How can I add “[SOLVED]” to the subjectline?

Hi @tjoen ,

you would need to edit the first post, from there you should be able to edit the subject. alternatively there is a plugin installed here where you could mark your first post as a question and then select one of the replies as “the answer”