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

    Mysql not accepting some mails

    Kopano Groupware Core
    3
    8
    750
    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.
    • kkappel
      kkappel last edited by fbartels

      fetchmail, postfix, kopano are working 100 to 200 of our daily mails.
      But in the mailq remain daily 8 to 12 mails.
      The deferred mails are not specifically big or html, mixed or containing binaries.
      Nor is postfix complaining the content as beeing not standard conform.

      postfix says: 450 mailbox temporarily not available

      dagent says: Unable to deliver message to "zentrale": disk error (80040116)

      server.log says:

      [error  ] SQL [00454463] Failed: MySQL server has gone away, Query Size: 1028280, Query: "REPLACE INTO properties (hierarchyid,tag,type,properties.val_ulong,properties.val_string,properties.val_binary,properties.val_double,properties.val_longint,properties.val_hi,properties.val_lo) VALUES(415741,34062,30,null,'JAS STD',null,null,null,null,null),(415741,34065,30,null,'notjunk:1;V01:K0:2qWpGnVIiKI=:v4qQb0q7HSuM6C4pvbP7Lk+eKw H7f9iz/RTEk6Si2eAFYQYhhMaHQ
      [...]
      \0\0\0\0<AC>!<A9>P@<D3><EE>H<B3>^Y<FB><A7>S0D%^A\0\0\0^F\0\0\0^F\0\0\0lBPUbAt6Ts+NIwBUW9QXuw==\0\0\0\0',null,null,null,null),(415741,64,30,null,'Zentrale',null,null,null,null,null),(415741,65,258,null,null,'\0\0\0\0<81>+^_<A4><BE><A3>^P^Y<9D>n\0<DD>^A^OT^B\0\0^A<80>E\0u\0
      [..]
      Sun Jun 17 06:48:18 2018: [warning] SQL [00454477] info: Try to reconnect
      Sun Jun 17 06:48:18 2018: [warning] SQL [00454281] info: Try to reconnect
      Sun Jun 17 06:48:18 2018: [error  ] SQL [00454479] Failed: MySQL server has gone away, Query Size: 1324594, Query: "REPLACE INTO properties (hierarchyid,tag,type,properties.val_ulong,properties.val_string,properties.val_binary,properties.va
      [...]
      

      At present there is no mention in the mariadb error.log.

      10.1.26-MariaDB-0+deb9u1 Debian 9.1
      kopano Version 8.6.80.45-0+ amd64

      Any suggestions?

      Thanks, if anybody has a clue!

      Klaus

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

        Hi @kkappel ,

        @kkappel said in Mysql not accepting some mails:

        kopano Version 8.6.80.45-0+ amd64

        you are using quite an old version. This was a known issues on Debian 9 a while ago that we meanwhile have fixed. Therefore I advise to upgrade.

        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
        • lacroix
          lacroix last edited by

          Hi there,

          unfort. in Univention 4.3.1 there ist still kopano 8.4.5.0 the newest version available.

          Is there any reference to where to find more information about this bug? Some workaround?

          Thanks
          lacroix

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

            When running Univention and you have a Kopano subscription, then you can update your Kopano version through https://wiki.z-hub.io/display/K4U/Updating+Kopano+packages+directly+from+the+Kopano+download+server.

            The related Jira issue was https://jira.kopano.io/browse/KC-1053

            If you don’t have a Kopano subscription, then there is currenly an update for the Univention app in the pipeline. If everything goes well, then is should be online beginning of next week.

            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
            • kkappel
              kkappel last edited by

              Thanks a lot for pointing that out!

              Upgrade to 8.6.80.1055-0+156.1_amd64.deb did the job!

              If anyone is interested in our repository: http://apt.jugendhilfe-wuemmetal.de

              While updating dagent did not work out of the box. I had to remove:
              #server_bind = 127.0.0.1
              #lmtp_port = 2003
              which helped to start the daemon.

              Great Work,
              we love Kopano!

              Klaus Kappel

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

                I did a downgrade from the unmaintained repo. Downgraded libmariadb2 to 2.0.0-1 , but SQL server is not on the same host. This seems a problem with the client library only.

                #ucr set repository/online/unmaintained=yes
                #aptitude install libmariadb2=2.0.0-1

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

                  @lacroix why that downgrade? the update is available since monday. did it not solve your issue?

                  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
                  • lacroix
                    lacroix last edited by

                    @felix no I missed that. So this is good news. Thanks.

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