Install Kopano 8.7.80.27 on Ubuntu 18.04 LTS
-
Hello,
I’m running Zarafa 7.something on Ubuntu 14.04 LTS and, well it is about time to update and switching to Kopano.
I did a test installation on 16.04, about a year ago or so and was able to migrate the data, all good.
But now, trying to install 8.7.80.27 on 18.04 seems to get a pain in the a**… :(Methods I’ve tried so far on a fresh 18.04 installation:
- Download .tar.gz
- dpkg -i *.deb
- apt-install -f install
This failes, because apt-install -f install suggests to remove all kopano packages, installed by **dpkg -i **.
- apt install ./*.deb results in a list of dependencies:
The following packages have unmet dependencies: kopano-dagent : Depends: libicu55 (>= 55.1-1~) but it is not installable kopano-gateway : Depends: libicu55 (>= 55.1-1~) but it is not installable kopano-ical : Depends: libical1a (>= 1.0) but it is not installable Depends: libicu55 (>= 55.1-1~) but it is not installable kopano-server : Depends: libicu55 (>= 55.1-1~) but it is not installable kopano-statsd : Depends: libmicrohttpd10 (>= 0.9.20) but it is not installable Depends: librrd4 (>= 1.3.0) but it is not installable libkcicalmapi0 : Depends: libical1a (>= 1.0) but it is not installable libkcpyplug0 : Depends: libpython3.5 (>= 3.5.0~b1) but it is not installable libkcserver0 : Depends: libicu55 (>= 55.1-1~) but it is not installable libkcutil0 : Depends: libicu55 (>= 55.1-1~) but it is not installable php7-mapi : Depends: phpapi-20151012 but it is not installable python3-mapi : Depends: libpython3.5 (>= 3.5.0~b1) but it is not installable E: Unable to correct problems, you have held broken packages.Trying to resolve this, I discovered libicu55 is not available for Ubuntu 18.04 LTS.
I’ve created some links, but this didn’t help out:root@somehost:/usr/lib/x86_64-linux-gnu# ll libicu* lrwxrwxrwx 1 root root 18 Nov 6 08:41 libicudata.so.55 -> libicudata.so.60.2 lrwxrwxrwx 1 root root 18 Nov 6 09:33 libicudata.so.55.1 -> libicudata.so.60.2 lrwxrwxrwx 1 root root 18 Mar 22 2018 libicudata.so.60 -> libicudata.so.60.2 -rw-r--r-- 1 root root 26904264 Mar 22 2018 libicudata.so.60.2 lrwxrwxrwx 1 root root 18 Nov 6 08:41 libicui18n.so.55 -> libicui18n.so.60.2 lrwxrwxrwx 1 root root 18 Nov 6 09:33 libicui18n.so.55.1 -> libicui18n.so.60.2 lrwxrwxrwx 1 root root 18 Mar 22 2018 libicui18n.so.60 -> libicui18n.so.60.2 -rw-r--r-- 1 root root 2754872 Mar 22 2018 libicui18n.so.60.2 lrwxrwxrwx 1 root root 16 Nov 6 08:41 libicuio.so.55 -> libicuio.so.60.2 lrwxrwxrwx 1 root root 16 Nov 6 09:33 libicuio.so.55.1 -> libicuio.so.60.2 lrwxrwxrwx 1 root root 16 Mar 22 2018 libicuio.so.60 -> libicuio.so.60.2 -rw-r--r-- 1 root root 55304 Mar 22 2018 libicuio.so.60.2 lrwxrwxrwx 1 root root 18 Nov 6 08:42 libicutest.so.55 -> libicutest.so.60.2 lrwxrwxrwx 1 root root 18 Nov 6 09:33 libicutest.so.55.1 -> libicutest.so.60.2 lrwxrwxrwx 1 root root 18 Mar 22 2018 libicutest.so.60 -> libicutest.so.60.2 -rw-r--r-- 1 root root 64864 Mar 22 2018 libicutest.so.60.2 lrwxrwxrwx 1 root root 16 Nov 6 08:42 libicutu.so.55 -> libicutu.so.60.2 lrwxrwxrwx 1 root root 16 Nov 6 09:34 libicutu.so.55.1 -> libicutu.so.60.2 lrwxrwxrwx 1 root root 16 Mar 22 2018 libicutu.so.60 -> libicutu.so.60.2 -rw-r--r-- 1 root root 203536 Mar 22 2018 libicutu.so.60.2 lrwxrwxrwx 1 root root 16 Nov 6 08:42 libicuuc.so.55 -> libicuuc.so.60.2 lrwxrwxrwx 1 root root 16 Nov 6 09:34 libicuuc.so.55.1 -> libicuuc.so.60.2 lrwxrwxrwx 1 root root 16 Mar 22 2018 libicuuc.so.60 -> libicuuc.so.60.2 -rw-r--r-- 1 root root 1792008 Mar 22 2018 libicuuc.so.60.2Is someone able to help me out here?
– PTN
-
@PartTimeNerd said in Install Kopano 8.7.80.27 on Ubuntu 18.04 LTS:
Trying to resolve this, I discovered libicu55 is not available for Ubuntu 18.04 LTS.
you must have downloaded the wrong archive then. the 18.04 packages should depend on libicu60
dpkg -i *.deb
this will pull in a lot of packages, that you may not need or want. the better practice is to build a local repo and the install
kopano-server-packages. -
Argh… :) Bash History say’s you’re right.
I’ve tried a local repository as well but stopped this way, because all this signing stuff is kind of annoying for me.
Ok… I’ll download the correct package and try to be more attentive…Thanks!
-
@PartTimeNerd said in Install Kopano 8.7.80.27 on Ubuntu 18.04 LTS:
because all this signing stuff is kind of annoying for me.
You don’t have to sign the repo (especially if its local and you trust yourself).
#!/bin/bash read -p "Create a local apt repo from the current dir? (y/n) " RESP if [ "$RESP" = "y" ]; then apt-ftparchive packages . | gzip -9c > Packages.gz fi echo "To use this repo just add the following line to /etc/apt/sources.list:" echo "deb [trusted=yes] file:$(pwd) ./" echo -
That’s very helpful. Thank you.
For the next installation, I’ll consider this. -
Ok… I had some progress. Basic installation seems to be done.
Imported SQL database dump from my Zarafa system, the server is running in general, login via Webapp works.
But unfortunately, I am not able to see any data (mails, appointments,…).
There seems to be an error with the db:Wed Nov 7 07:49:40 2018: [error ] ECDatabaseAttachment::LoadAttachmentInstance(): no row returned Wed Nov 7 07:49:40 2018: [error ] SerializeObject failed with error code 0x80000007 for object 97756And when I use kopano-cli --list-users I get:
root@somehost:/etc/kopano# kopano-cli --list-users User list for Default (7): User Full Name Homeserver Store --------------------------------------------------------------------------------------------------- MAPI error 80070057 (MAPI_E_INVALID_PARAMETER)Beside the MAPI error, is setup of konnect (OIDC) and kopano api mandatory or optional?
Any help appreciated.0x80070057 MAPI_E_INVALID_PARAMETER– PTN
-
@PartTimeNerd said in Install Kopano 8.7.80.27 on Ubuntu 18.04 LTS:
is setup of konnect (OIDC) and kopano api mandatory or optional?
If you just want to use kopano, webapp and z-push, then these two components are not required (or even used).
For the rest you have to share more information about your environment.
-
I am sorry, what’s missing?
It is one single system for db, kopano, webserver,…Using Ubuntu 18.04 LTS with apache and mariadb (which was apparently replaced from apt during installation, just learned that).
-
For example: from which version are you now actually updating? where do you store your attachments? how do you manage your users? Anything else logged in the server.log?
-
Ok, to avoid any misunderstanding:
It is a fresh installation and I just import the database from the “old” system.
The old system is ZCP 7.1.10-44973 on Ubuntu 14.04 LTS.
Attachments are currently stored in the database.
User_Plugin is DB
Server log shows the same error again and again…Wed Nov 7 08:56:29 2018: [=======] Starting kopano-server version 8.7.80 (pid 18516 uid 0) Wed Nov 7 08:56:29 2018: [=======] Starting kopano-server version 8.7.80 (pid 18516 uid 999) Wed Nov 7 08:56:31 2018: [error ] ECDatabaseAttachment::LoadAttachmentInstance(): no row returned Wed Nov 7 08:56:31 2018: [error ] SerializeObject failed with error code 0x80000007 for object 97756 Wed Nov 7 08:56:37 2018: [error ] ECDatabaseAttachment::LoadAttachmentInstance(): no row returned Wed Nov 7 08:56:37 2018: [error ] SerializeObject failed with error code 0x80000007 for object 97756 Wed Nov 7 08:56:44 2018: [error ] ECDatabaseAttachment::LoadAttachmentInstance(): no row returned Wed Nov 7 08:56:44 2018: [error ] SerializeObject failed with error code 0x80000007 for object 97756 -
@PartTimeNerd said in Install Kopano 8.7.80.27 on Ubuntu 18.04 LTS:
It is a fresh installation and I just import the database from the “old” system.
I would not call it a fresh installation, since you have imported data from an old installation.
Did you follow the instructions in https://kb.kopano.io/display/WIKI/Migrating+from+ZCP+7.1+or+earlier+to+Kopano+Core+8.5+or+later for upgrading (you must have one way or the other, since otherwise the server would have refused to start).
Since you have your attachments in the database the error hints towards the fact that (I guess we are talking about webapp here) is expecting some attachments in the database, that are not actually there anymore. Normally this just leads to a 0kb attachment in an email, I have not yet see that this causes all elements to not load any longer.
-
Hey Felix… thanks for your help so far.
Unfortunately, I didn’t. Haven’t noticed it, yet. :(
I have a local system with Kipano 8.3.0~999-7.1 installed a year ago to have a first look at Kopano.
Can I use this for migration?- Export SQL on ZCP server
- Import SQL on Kopano 8.3.0~999-7.18.7.80.27
- Perform Kopano Backup on 8.3.0~999-7.1
- Restore Backup on 8.7.80.27
I imported an actual SQL dump form ZCP 7.1 on this local system (8.7.80.27) today for troubleshooting and on first sight, all data is there.
To make sure, that I didn’t screw up the installation of the 8.7 system, I’ll drop the database and take a look on the behavior after that. -
When you want to anyways want to go through kopano-backup, then you can also pull the backup directly from your old Zarafa system.
You also do not need to import your mysql database twice if you want to go through the proper update routine. you simply need to start you database once with the required kopano-server (or zarafa-server) binary.
