Navigation

    Kopano
    • Register
    • Login
    • Search
    • Categories
    • Get Official Kopano Support
    • Recent
    Statement regarding the closure of the Kopano community forum and the end of the community edition

    SQL connect

    Kopano Groupware Core
    3
    7
    859
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Thuizt
      Thuizt last edited by

      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 1 Reply Last reply Reply Quote 0
      • fbartels
        fbartels Kopano @Thuizt last edited by

        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?

        Regards Felix

        Resources:
        https://kopano.com/blog/how-to-get-kopano/
        https://documentation.kopano.io/
        https://kb.kopano.io/

        Support overview:
        https://kopano.com/support/

        1 Reply Last reply Reply Quote 0
        • Thuizt
          Thuizt last edited by

          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,

          1 Reply Last reply Reply Quote 0
          • fbartels
            fbartels Kopano last edited by

            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.

            Regards Felix

            Resources:
            https://kopano.com/blog/how-to-get-kopano/
            https://documentation.kopano.io/
            https://kb.kopano.io/

            Support overview:
            https://kopano.com/support/

            1 Reply Last reply Reply Quote 0
            • Thuizt
              Thuizt last edited by

              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 1 Reply Last reply Reply Quote 0
              • fbartels
                fbartels Kopano @Thuizt last edited by

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

                Regards Felix

                Resources:
                https://kopano.com/blog/how-to-get-kopano/
                https://documentation.kopano.io/
                https://kb.kopano.io/

                Support overview:
                https://kopano.com/support/

                1 Reply Last reply Reply Quote 0
                • thctlo
                  thctlo last edited by

                  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.

                  1 Reply Last reply Reply Quote 0
                  • First post
                    Last post