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

    Is someone able to help me out here?

    – PTN


  • Kopano

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


  • Kopano

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


  • Kopano

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


  • Kopano

    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
    

  • Kopano

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


  • Kopano

    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.


Log in to reply