Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4067

MariaDB client library not compatible with mysql-proxy

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Not a Bug
    • 5.5.28a
    • None
    • None
    • None
    • CentOS Linux release 6.0 (Final) MariaDB server release 5.5.28a-MariaDB-log
      Tested MySQL client lib from source MySQL mysql-5.5.25a and mariadb-5.5.25a. Tested with mysql-proxy 8.2 and 9.0

    Description

      export LD_LIBRARY_PATH=/usr/local/skysql/mariadb-client/lib/
      [root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.10 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 3306 -o /var/lib/skysql/bench1/clientUser skysql Pass skyvodka
      opening 10 conenction(s) to dbt2...
      listening to port 30000
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      cannot connect to database(see details in error.log file, exiting...
      [root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.10 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 3306 -o /var/lib/skysql/bench1/clientUser skysql Pass skyvodka
      opening 10 conenction(s) to dbt2...
      listening to port 30000
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      cannot connect to database(see details in error.log file, exiting...
      [root@ip-10-0-0-47 ~]# export LD_LIBRARY_PATH=/usr/local/skysql/mysql-client/lib/ [root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.10 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 3306 -o /var/lib/skysql/bench1/clientUser skysql Pass skyvodka
      opening 10 conenction(s) to dbt2...
      listening to port 30000
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      client has started
      ^C
      [root@ip-10-0-0-47 ~]# export LD_LIBRARY_PATH=/usr/local/skysql/mariadb-client/lib/[root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.10 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 3306 -o /var/lib/skysql/bench1/clientUser skysql Pass skyvodka
      opening 10 conenction(s) to dbt2...
      listening to port 30000
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.10| user: |skysql| pass: |skyvodka| port: |3306| socket: ||
      cannot connect to database(see details in error.log file, exiting...
      [root@ip-10-0-0-47 ~]# /usr/local/skysql/dbt2/bin/client -u skysql -h 10.0.0.102 -a skyvodka -f -c 10 -s 2 -d dbt2 -l 5010 -o /var/lib/skysql/bench1/client
      User skysql Pass skyvodka
      opening 10 conenction(s) to dbt2...
      listening to port 30000
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||
      connect to mysql server with parameters: db_name: |dbt2| host: |10.0.0.102| user: |skysql| pass: |skyvodka| port: |5010| socket: ||

      Attachments

        Activity

          People

            elenst Elena Stepanova
            stephane@skysql.com VAROQUI Stephane
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.