SQL connect

Thuizt

Hello,

Trying to get Kopano up and running on Ubuntu 18

Cannot get the server up as it gives an error on MySQL in the server.log file

Access denied for user ‘kopano-server’@‘localhost’ to database kopanoserver

The strange thing is that the server.cfg file does not contain any reference to user: kopano-server or database kopanoserver
It should be the default: ‘kopano’@‘localhost’ and databasename kopano

Where do these settings come from and how to get this fixed.

Thanks

fbartels

Hi @Thuizt ,

yes these values are definitely not our defaults. Sadly you give very few other information apart from your used distro.

How and from where did you install Kopano?
Which version are you currently running?

Could it be that you are using the packages from the downstream Ubuntu repo?

Thuizt

Indeed, I was a bit limited in the info.
Did indeed install from the Ubuntu Repo. Easiest way to get up an running it looked to me. In the meantime already ran into other strange issues.
Will reinstall and start over and this time not “the easy way”
Thanks for answering,

fbartels

Yes, I think the Ubuntu devs just took the half finished packages from Debian Testing. A lot has effort has gone into the Debian downstream packaging since then so starting with Debian Buster this experience will definitely improve.

Thuizt

Getting lost and it isn’t that complicated … or is it …

Reinstalled (repartitioned) Ubuntu 18 from mini image with SSH, curl and gnupg.

Followed these instructions for Kopano install https://kb.kopano.io/display/WIKI/Core

kopano-server-packages wasn’t known so installed packages seperate

And again kopano server doesn’t start

from /var/log/kopana/server.log:
Access denied for user ‘kopano-server’@‘localhost’ (using password: YES)

from: /etc/kopano/server/cfg

The user under which we connect with MySQL

mysql_user = kopano

The password for the user (leave empty for no password)

mysql_password = xxxxxxxxxx*

Can someone please point me to a working installation on Ubuntu 18 or explain how to fix ??

fbartels

@Thuizt said in SQL connect:

Followed these instructions for Kopano install https://kb.kopano.io/display/WIKI/Core
kopano-server-packages wasn’t known

if you really followed the link then the package would have been known.

thctlo

Felix,

Im repeating installs based on the documation site and really its not getting easier to install it.
it laks, a clear install order, the documentation info is good, just hard to follow.
But yes, This is a big improvement https://kb.kopano.io/display/WIKI/Core
And that user did not read the “Configure SQL database” part.