SQL connect



  • 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


  • Kopano

    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?



  • 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,


  • Kopano

    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.



  • 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 ??


  • Kopano

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



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


Log in to reply