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

Maxscale ignores lower_case_table_names=1 on config file

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.4.5, 22.08.4, 23.02.0
    • 2.5.25, 6.4.6, 22.08.5, 23.02.2
    • Core
    • None
    • RHEL 7.9+

    Description

      Hi Team,

      I enabled lower_case_table_names 1 on maxscale config.. In DB nodes lower_case_table_names is 0..

      MariaDB [(none)]> show global variables like 'lower_case_table_names';
      +------------------------+-------+
      | Variable_name          | Value |
      +------------------------+-------+
      | lower_case_table_names | 0     |
      +------------------------+-------+
      1 row in set (0.001 sec)
      

      [Read-Write-Listener]
      type=listener
      service=Read-Write-Service
      protocol=MariaDBClient
      port=4006
      authenticator_options=lower_case_table_names=1
      

      when I try to connect,

      [root@centos15 lib]# mysql -u monitor_6 -p'xxx' -h 192.168.xx.xx -P 4006 -D NAGIOS_MONITOR -e "select * from CONFIG;"
      ERROR 1049 (42000): Unknown database 'NAGIOS_MONITOR'
      

      If I set lower_case_table_names=2 on maxscale config it's working as expected,

      [Read-Write-Listener]
      type=listener
      service=Read-Write-Service
      protocol=MariaDBClient
      port=4006
      authenticator_options=lower_case_table_names=2
      

      #  mysql -u monitor_6 -p'xxxx' -h 192.168.xx.xx -P 4006 -D NAGIOS_MONITOR -e "select * from CONFIG;"
      +------+---------+----------+
      | id   | name    | password |
      +------+---------+----------+
      |    1 | mariadb | mm@123   |
      +------+---------+----------+
      

      Attachments

        Activity

          People

            markus makela markus makela
            ponsuresh.pandians Pon Suresh Pandian (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.