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

    Kopano core with Debian 9

    Kopano Groupware Core
    6
    20
    3782
    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.
    • benusa
      benusa last edited by

      i have install the ucs, its good!
      do you now where the Password for SQL Root.
      i will import my database from my old zarafa server

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

        Hi,

        should be in /etc/mysql.secret and kopano-mysql.secret for kopano user

        rg
        Christian

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

          Hi externa
          question
          i make a backup with mysqldump from kopano UCS server, the DB ist 1,3MB
          my old zarafa DB with same date have 100MB.
          its a problem with dump?

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

            hi,
            pretty sure it’s a problem.
            Which command did you use?
            mysqldump kopano --skip-lock-tables --single-transaction -ukopano -pXXXXXX >kopanoDB.sql
            best regards

            benusa 1 Reply Last reply Reply Quote 0
            • benusa
              benusa @AnotherAndy last edited by

              @anotherandy thx. I have test with your parameter --> is the same result

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

                Hi,

                only a thougt from me.
                But Zarafa in earlier versions stored the attachements in SQL DB and now in kopano they are stored in file system - can this be the cause of your different size in DB Dump ?
                what was your zarafa config ? and how did you migrate the data to new server ?

                rg
                Christian

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

                  • i have install a new UCS Server Standrad with all kopano Apps
                  • then i copy my data with z-push from Outlook to new Kopano
                  • all data ok and SYNC with smartphone ok.
                  • then i must a SQLDUMP with your parameters

                  So

                  • i install a new Version from UCS Server on a notebook a testsystem.
                  • then i make a mysql restore with the data from orginal kopano
                    the testsystem has no data.
                    the database ist very smal befor i restore

                  i dont no
                  i have test with manual mysqldump and parameters
                  and with “automysqlbackup” tool fpr linux

                  thx ben

                  externa1 1 Reply Last reply Reply Quote 0
                  • externa1
                    externa1 @benusa last edited by

                    @benusa said in Kopano core with Debian 9:

                    • i have install a new UCS Server Standrad with all kopano Apps
                    • then i copy my data with z-push from Outlook to new Kopano
                    • all data ok and SYNC with smartphone ok.
                    • then i must a SQLDUMP with your parameters

                    So

                    • i install a new Version from UCS Server on a notebook a testsystem.
                    • then i make a mysql restore with the data from orginal kopano
                      the testsystem has no data.
                      the database ist very smal befor i restore

                    i dont no
                    i have test with manual mysqldump and parameters
                    and with “automysqlbackup” tool fpr linux

                    thx ben

                    • then i copy my data with z-push from Outlook to new Kopano

                    How did you do that ?

                    • you can not import mails through z-push as activesync does not provide this - you’ll have to export to pst instead and import though kopano server console kopano-migration-pst tool

                    rg
                    Christian

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

                      E-mail was not important in this case.
                      get the over kopano per imap from external system.
                      There they are still.
                      I am primarily concerned with calendars and contacts

                      externa1 1 Reply Last reply Reply Quote 0
                      • externa1
                        externa1 @benusa last edited by

                        @benusa

                        as i said in my previous port - dump to pst from outlook on old server - copy the pst to new server and run kopano-migrate-pst to import to new server and user - this implies mail, contacts and calendar items

                        rg
                        Christian

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

                          @externa1 said in Kopano core with Debian 9:

                          as i said in my previous port - dump to pst from outlook on old server - copy the pst to new server and run kopano-migrate-pst to import to new server and user - this implies mail, contacts and calendar items

                          Thank you
                          In principle, I have achieved my goal, the system is running excellent.
                          BUT
                          I wanted to test one if I fail the productive system, I set up the new system and want to import the SQL DB.
                          I also do a snapshot of the server all ok.
                          The goal is to create a SQL DB backup, which I can use again at any time.

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

                            You are thinking way to complex. Just use kopano-backup to backup and restore your system. No need to go through ActiveSync and a PST export.

                            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
                            • Sinux
                              Sinux @benusa last edited by

                              @benusa said in Kopano core with Debian 9:

                              i have install the kopano core with debian 9

                              • when i restart computer the kopano-server not aktiv
                                i must start from console.

                              in “/init.d/” are not startscripts from all services for kopano

                              thx
                              ben

                              Hi ben,
                              if you still want to try it with debian 9 that would be your solution,

                              systemctl list-units | grep kopano
                              systemctl enable kopano-dagent
                              systemctl enable kopano-server

                              Bro 1 Reply Last reply Reply Quote 0
                              • Bro
                                Bro @Sinux last edited by

                                @sinux

                                you can add:
                                systemctl enable kopano-spooler
                                (en if necessarry for your setup ‘systemctl enable kopano-gateway’)

                                to that list. Took me hours of troubleshooting to find out the kopano-spooler should be running but wasn’t. :-/

                                Regards,

                                Bro

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