Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-56

MySQL insert binary blob don't works

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.0.5
    • Fix Version/s: 1.2.1
    • Component/s: Core
    • Labels:
      None
    • Environment:
      Ubuntu 14.04
      Maxscale 1.1 DEB from your APT Repo
      MariaDB 10.0.0.17
      Galera 3 Node Cluster

      Description

      We're using OTRS 4.0.6 ( www.otrs.org ) as ticketsystem.
      When trying to use an attachment (JPEG Images or ZIP) in an outgoing mail, which is saved as binarys blob in the attachment table, it does not work.

      OTRS log says:
      Access denied for user 'ԅÜ-ªC´†�¢[É\r*\"5}4r;\Z�Ɓ�vË°.2\0…S˜?t�Ă°ÆsghuÒ!g×C^�¹[íR¯\'ŽR�k=�Aß�r†Öqg(wò{Ã�JNÑ.i4sb>ÅÌISjzL.ü4‰¯ý15?èBLÿÀ\'\"�

      {Dç�ÍnË}

      '@'192.168.10.50' (using password: YES), SQL: '
      MySQL server has gone away, SQL:

      You can try with this file: http://download.wsusoffline.net/wsusoffline951.zip

      When i change the Config.pm of OTRS to use the Mysql server directly (without maxscale as loadbalancer) it works.

      Unfortunately there are no other log entrys available. Neither maxscale or mysql.

      Seems to me this could be some escaping problem of the binatry part of the sql query?
      Dont knwo where he takes the 192.168.10.50 host from but its not our maxscale server but the otrs server itself.
      Any hints?

        Attachments

          Activity

            People

            Assignee:
            Massimiliano Pinto Massimiliano Pinto (Inactive)
            Reporter:
            monotek André Bauer
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.