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

fbartels

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

tjoen

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

tjoen

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

tjoen

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

tjoen

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

jengelh

@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

tjoen

@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

tjoen

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

tjoen

[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

tjoen

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

fbartels

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”