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

    K-1537: Unable to move object user

    Kopano Groupware Core
    7
    24
    1555
    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.
    • Chris2
      Chris2 last edited by

      Thank you very much for your reply, but in this case the server is not crashing, it keeps running functional, but those mentioned log entries are flooding the log all 15 minutes.

      There are no further informations in the log, also in log mode = debug.

      If there is anything i can do, help fixing this bug, please let ne know.

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

        @Chris2 said in K-1537: Unable to move object user:

        informations in the log, also in log mode = debug.

        disable kopano-monitor and kopano-statsd

        That did help me in the log flood.
        I got my kopano stable running again, but i disabled everything i didnt need.

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

          Thanks, sounds like a good plan to get the log clean again as workaround, until the bug is fixed.

          But in long term i would like to fix the problem itself, so if i can do anything to support this, please let me know.

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

            Just to keep this thread complete on what im doing in my DB.

            this database also suffert from the problem.
            SQL Failed: Duplicate key name ‘tmptag’, Query: “ALTER TABLE properties ADD INDEX tmptag (tag)”

            after a look at git : f43e00622a9624e31b58c280058c2bb6580e6be2
            im gambled that this would help me to fix this problem.

            so my steps,
            While everything is running.

            mysql -u root
            
            use kopano;
            ALTER TABLE properties drop INDEX tmptag;
            ALTER TABLE tproperties drop INDEX tmptag;
            ALTER TABLE mvproperties drop INDEX tmptag;
            ALTER TABLE indexedproperties drop INDEX tmptag;
            ALTER TABLE singleinstances drop INDEX tmptag;
            ALTER TABLE lob drop INDEX tmptag;
            \q;
            
            systemctl restart kopano-server
            kopano-dbadm k-1216
            

            which cleared the INDEX, removed the error, make kopano-server do it thing, and re-added the INDEX with kopano-dbadm.

            Can someone confirm these steps if i did not miss anything here.

            At least, i happy to see these messages, are gone.

            Fri May  3 12:02:04 2019: [error  ] 0x7fbc8365c890: SQL Failed: Duplicate key name 'tmptag', Query: "ALTER TABLE properties ADD INDEX tmptag (tag)"
            Fri May  3 12:02:04 2019: [error  ] KDatabase::I_Update() query failed: "Duplicate key name 'tmptag'", query: ALTER TABLE properties ADD INDEX tmptag (tag)
            
            1 Reply Last reply Reply Quote 0
            • thctlo
              thctlo last edited by thctlo

              hm, i’ve tried to update today also .

              From 8.7.80.931 to 8.7.80.936.529d71bca-0+193.1

              kopano-server still crashes if you check the users/group/company list.
              if this is still enabled in server.cfg
              user_safe_mode = yes

              set to no, kopano-server does not crash.

              im still not seeing my last added company and user, disapeared again.
              and im sure thats related to :

              Fri May  3 14:03:56 2019: [info   ] Auto-deleting company 1353 from external source
              

              Any suggestion to remove that manual from the DB? or how can i find that.

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

                Hi everyone,
                It took me more than a day but I’ve found a workaround to this problem while setting up a brand new install to avoid corrupting real data.
                Anyway, I also stumbled on the “K-1537: Unable to move object user” issue. Moreover I also got “K-1537: Unable to move object security group” on top of that after a while. After investigating closely all the log entries I all of a sudden got an idea. Eureka!!!
                The workaround is as follows and I bet this will also will help the dev-team:
                I all the time noticed that the username in the log looked like joe@example.comExample Ltd. So the company name was added too.
                I renamed all the company names in my ldap tree to the FQDN. i.e. renamed “Example Ltd” into “example.com”.
                Changed loginname_format into just loginname_format = %u in the server.cfg.
                Stopped kopano-server service and dropped all the tables and started the kopano-server service. (Could do this as I was starting from scratch. Next I will try to apply it to a life database using the kopano-dbadm tools although I experienced also odd behaviour as it broke the relations between groups and companies several times while figuring out what the problem was but that maybe was caused by the fact of the K-1537 error.)
                executed kopano-admin --list-companies, kopano-admin --list-groups, kopano-admin --list-users and checked the users table which looked OK.
                Note: Another problem I ran into is that kopano-cli --list-companies works but kopano-cli --list-groups, kopano-cli --list-users don’t!!! Another bug?
                After the above I’m able to login using the email address as username and works like charm. Obviously this is not a permanent solution but I hope that the dev-team understands what to look for. Please let me know when this bug is ironed out…

                Next day edit:
                Maybe cheered too early! Although I was (and still am) able to login after the above exercise nasty log entrees keep on coming:
                1) K-1515: Object not found unknown user “example.com”: example.com not found in LDAP:
                This is repeated for all 6 defined companies in the LDAP tree. (example.com, example2.com, example3.com, example4.com, example5.com, example6.com). Though these are defined as objectClass: kopano-company. Does Kopano thinks these are users?
                2) K-1537: Unable to move object user “joe@example.com” (id=19):
                Only for this user as only one user is defined.

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

                  Just wanted to mention that the latest nightly build solves the problem, error log is clean now.

                  Thanks to all suggestions and the dev-team for fixing this bug.

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

                    I did install version core-8.7.81.48-Ubuntu_18.04-amd64 today, the previous errors disappeared indeed but instead now “[warning] K-1515: Object not found unknown user “example.com”: example.com not found in LDAP” while this entry is not a user but a company. Same for the other companies in the LDAP tree. Any ideas?

                    I just noticed that after the upgrade kopano-cli no longer exists in /usr/sbin/

                    A day later: same with core-8.7.81.88-Ubuntu_18.04-amd64, does not contain kopano-cli (???).

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

                      @gduran said in K-1537: Unable to move object user:

                      A day later: same with core-8.7.81.88-Ubuntu_18.04-amd64, does not contain kopano-cli (???).

                      yes, that was already mentioned in https://forum.kopano.io/post/13627. it will return, no worries.

                      @gduran said in K-1537: Unable to move object user:

                      while this entry is not a user but a company. Same for the other companies in the LDAP tree.

                      yes, that is an old behaviour and can safely be ignored. I thought we had a ticket for that already, but could not find it with a quick search.

                      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/

                      gduran 1 Reply Last reply Reply Quote 0
                      • gduran
                        gduran @fbartels last edited by

                        @fbartels Hi Felix,
                        OK, that clarifies, thanks. I noticed that the log entries “K-1515: Object not found unknown user” appear exactly every 15 minutes so this must be part of a scheduler routine. Maybe that helps to nail it down.

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

                          @gduran yes, that message will indeed be logged every time the user list is synced.

                          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
                          • First post
                            Last post