Install Kopano 8.7.80.27 on Ubuntu 18.04 LTS

fbartels

@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

PartTimeNerd

That’s very helpful. Thank you.
For the next installation, I’ll consider this.

PartTimeNerd

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 97756

And 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

fbartels

@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.

PartTimeNerd

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).

fbartels

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?

PartTimeNerd

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

fbartels

@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.

PartTimeNerd

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.

fbartels

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.