Details
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 | |
+------+---------+----------+
|