How to install Kopano on Ubuntu Server 18.04

thctlo

@fbartels why are you saying that you wont have to split the amd64 and i386 package, if you dont you get a mess and this will result in errors.
Yes its possible but how may have setup Multi-arch?

Felix, please note, im not attacking here, im in learing mode If im wrong here, please point me to the source info…

fbartels

It wasn’t an attack from my side either. If you are running 64bit (which you should definitely do), then only download the 64bit archive and create your repo from there. There is no need to download the 32bit archive and therefore no need to separate the repo.

And even if you provide a repository with 32 and 64bit packages I am not sure if it makes a difference to put the packages in different sub directories.

thctlo

Great ;-), Always remember me as in, thctlo is trying to help not flame… i do that for you also. ;-)

Ok, yes, clear, im totaly pro dropping 32bit, saves lots of hassle… but some users still might want a 32bit version, think in the small media pc’s. like a Pi low power devices… I think a few years and 32bit is gone.

If you provide a repo with 32 and 64bit package you must split these, if these are mixed, the package cant determine what to install and the install will fail.
I have also a few 32bits servers. If i put all packages in one folder and done make the separation in arch, packages fail when installing. I provide Debian samba packages for people on the samba list, i also learned the hardway …
that how i know for sure… The samba and debian devs are great help in learning things like this.

hispeed

Thanks for your answers.
I downloaded now the 64bit version. It was a mistake (for me) I usually use 64 Bit.

cd /tmp
wget https://download.kopano.io/community/core:/core-8.6.80.760_0%2B90-Debian_9.0-amd64.tar.gz
cd core-8.6.80.760_0+90-Debian_9.0-amd64

Now I probably have to do this command:

apt-ftparchive packages . | gzip -9c > Packages.gz && echo „deb file:$(pwd) ./“ > /etc/apt/sources.list.d/kopano.list”

What do I need to write into (pwd) ? A password for the package?

fbartels

@hispeed said in How to install Kopano on Ubuntu Server 18.04:

Debian_9.0-amd64

but that is now Debian 9. not Ubuntu 18.04

@hispeed said in How to install Kopano on Ubuntu Server 18.04:

What do I need to write into (pwd) ? A password for the package?

just leave it as it is. this part will be replaced by the current directory by bash (http://tldp.org/LDP/abs/html/commandsub.html).

hispeed

Yes you’re right. So once again:

cd /tmp
wget https://download.kopano.io/community/core:/core-8.6.80.760_0%2B90-Ubuntu_18.04-amd64.tar.gz
tar xfvz core-8.6.80.760_0+90-Ubuntu_18.04-amd64.tar.gz
cd core-8.6.80.760_0+90-Ubuntu_18.04-amd64
apt-ftparchive packages . | gzip -9c > Packages.gz && echo „deb file:$(pwd) ./“ > /etc/apt/sources.list.d/kopano.list”

and now I need to start the installation…? Which command do I use now?

When I do apt update:

root@svgwma-kopa-01:/tmp/core-8.6.80.760_0+90-Ubuntu_18.04-amd64# apt update
N: Datei »kopano.list”« in Verzeichnis »/etc/apt/sources.list.d/« wird ignoriert, da sie eine ungültige Dateinamen-Erweiterung hat.
E: Typ »„deb« in Zeile 1 der Quellliste /etc/apt/sources.list.d/kopano.list ist unbekannt.
E: Die Liste der Quellen konnte nicht gelesen werden.
root@svgwma-kopa-01:/tmp/core-8.6.80.760_0+90-Ubuntu_18.04-amd64#

thctlo

look here : https://documentation.kopano.io/kopanocore_administrator_manual/installing.html#installation
and if the repo works:

apt install kopano-server-packages

thctlo

and what i do after,

RANDOMPASSWD(){ < /dev/urandom tr -dc _A-Z-a-z-0-9 | head -c${1:-16};echo; }

or run this on CLI or put it in .bashrc ( and type source .bashrc or logout/login again )
With the latest versions of kopano the (most) of the defaults are ok.

After the install create the kopano database. Read the manual, or use this more easy way, in my optionion.

##### Setup the Database
# Set a random mysql password.
SQLDBPWD="$(RANDOMPASSWD)"
##### Create database and set rights. 
mysql --defaults-file=/etc/mysql/debian.cnf -Bse "CREATE DATABASE dbkopano"; 
mysql --defaults-file=/etc/mysql/debian.cnf -Bse "CREATE USER ukopano@localhost IDENTIFIED BY '$SQLDBPWD'";
mysql --defaults-file=/etc/mysql/debian.cnf -Bse "GRANT all ON dbkopano.* TO 'ukopano'@'localhost' IDENTIFIED BY '$SQLDBPWD'";

ukopano = user
dbkopano = database name

change the “secret key in kopano-presence”

sed -i "s/#server_secret_key = GEHEIM/server_secret_key = $(RANDOMPASSWD)/" /etc/kopano/presence.cfg

thctlo

@fbartels, the above options can also be used to create the sql database at install.

hispeed

If I do your command for the installation I get this error:

root@svgwma-kopa-01:/tmp/core-8.6.80.760_0+90-Ubuntu_18.04-amd64# apt install kopano-server-packages
N: Datei »kopano.list”« in Verzeichnis »/etc/apt/sources.list.d/« wird ignoriert, da sie eine ungültige Dateinamen-Erweiterung hat.
E: Typ »„deb« in Zeile 1 der Quellliste /etc/apt/sources.list.d/kopano.list ist unbekannt.
E: Die Liste der Quellen konnte nicht gelesen werden.
N: Datei »kopano.list”« in Verzeichnis »/etc/apt/sources.list.d/« wird ignoriert, da sie eine ungültige Dateinamen-Erweiterung hat.

So probably is something wrong with the repo. It’s a fresh installation and I have only installed LAMP. I have not made any other changes to the system.

thctlo

@hispeed

ok, i’ll make it more easy for you. Follow this to the letter.

mkdir -p /home/kopano/amd64
mv /tmp/core-8.6.80.760_0+90-Ubuntu_18.04-amd64/*.deb /home/kopano/amd64/
cd /home/kopano
apt-ftparchive packages amd64/ > amd64/Packages
echo "deb [trusted=yes] file:/home/kopano amd64/" > /etc/apt/sources.list.d/kopano-com.list
apt update
apt install kopano-server-packages

That should do it.

Please note that after a reboot your /tmp is empty and the folder core-8.6.80… is gone and you wil have message on every apt update

hispeed

Unfortunately it is still not working. The problem must be in the following file:

/etc/apt/sources.list.d/kopano.list
„deb file:/home/kopano/amd64/core-8.6.80.760_0+90-Ubuntu_18.04-amd64 ./“

This is the error i get:

root@svgwma-kopa-01:/home/kopano/amd64# apt update
N: Datei »kopano.list”« in Verzeichnis »/etc/apt/sources.list.d/« wird ignoriert, da sie eine ungültige Dateinamen-Erweiterung hat.
E: Typ »„deb« in Zeile 1 der Quellliste /etc/apt/sources.list.d/kopano.list ist unbekannt.
E: Die Liste der Quellen konnte nicht gelesen werden.
root@svgwma-kopa-01:/home/kopano/amd64# nano /etc/apt/sources.list.d/kopano.list

fbartels

@hispeed the quotes in your posts look weird. maybe that is actual a unicode quote? I’d recommend to just copy & paste the above examples.

hispeed

I set up a new server again because i probably messed around to much.

So far everything is fine.

mkdir -p /home/kopano/amd64
cd /home/kopano/amd64
wget https://download.kopano.io/community/core:/core-8.6.80.760_0%2B90-Ubuntu_18.04-amd64.tar.gz
tar xfvz core-8.6.80.760_0+90-Ubuntu_18.04-amd64.tar.gz
cd core-8.6.80.760_0+90-Ubuntu_18.04-amd64
cd /home/kopano
apt-ftparchive packages amd64/ > amd64/Packages
echo "deb [trusted=yes] file:/home/kopano amd64/" > /etc/apt/sources.list.d/kopano-com.list
apt update
apt install kopano-server-packages

@fbartels you wrote about the " which were looking strange to you. It comes from copy paste from your comment:

https://www.pc-howto.com/kopano-der-neue-stern-am-groupwarehimmel-teil-1/#comment-152876

Thanks for your help, Core installation successfull with those steps.

thctlo

Good to see it works now.

So the full “copy past part” is the following for others…
And you only need to change the filename/version for new versions.

if [ ! -d /home/kopano/amd64 ]
then
     mkdir -p /home/kopano/amd64
fi
cd /home/kopano/

wget https://download.kopano.io/community/core:/core-8.6.80.760_0%2B90-Ubuntu_18.04-amd64.tar.gz
tar xfvz core-8.6.80.760_0%2B90-Ubuntu_18.04-amd64.tar.gz
mv core-8.6.80.760_0+90-Ubuntu_18.04-amd64/*.deb /home/kopano/amd64/

apt-ftparchive packages amd64/ > amd64/Packages
if [ ! -f /etc/apt/sources.list.d/kopano-com.list ]
then
    echo "deb [trusted=yes] file:/home/kopano amd64/" > /etc/apt/sources.list.d/kopano-com.list
fi

apt update
apt install kopano-server-packages

@ fbartels
To make the community package better accessable. How about. this.

getting the latest version not with:
wget https://download.kopano.io/community/core:/core-8.6.80.760_0%2B90-Ubuntu_18.04-amd64.tar.gz
but with :
wget https://download.kopano.io/community/core:/core-8.6-latest-Ubuntu_18.04-amd64.tar.gz

This simplies getting the latest much.
Just an idee.

fbartels

@thctlo said in How to install Kopano on Ubuntu Server 18.04:

This simplies getting the latest much.

you could also do it dynamically. e.g. like curl -L `lynx -listonly -nonumbers -dump https://download.kopano.io/community/core:/ | grep Ubuntu_16.04-amd64.tar.gz` | tar -xz --strip-components 1 -f -

thctlo

Thank you very much, thats a nice one to know.
Any tips on … preventing downloading the same file again with this… :-),

When my get all community files script is ready i’ll post it on the forum.
I was at 99% and … i acedently deleted it… back to the old version and change it again.

mhope

@thctlo Hello,
did you succeed in writing a script which downloads and installes the community files?
I’m trying to install the community version on a fresh ubuntu 18.04 vm and am referring to the documentation.
I was wondering, because no default configuration files where present in the /etc/kopano folder after installing all .deb packages.
Therefore I’d like to try your script.
Best regards,
Marco

fbartels

@mhope said in How to install Kopano on Ubuntu Server 18.04:

because no default configuration files where present in the /etc/kopano folder

this is expected as explained in https://documentation.kopano.io/kopanocore_administrator_manual/configure_kc_components.html#configure-the-kopano-server

mhope

@fbartels Thank you very much for your quick response! I’ll refer to the manual.
Best regards,

Marco