-
Type:
Bug
-
Status: Done
-
Priority:
Medium
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Trying to use proxysql-admin to set up a new PXC on to ProxySQL. Doesn't recognize IP address of localhost.
[root@proxy-sql-1 ~]# proxysql-admin --enable --mode=singlewrite --proxysql-hostname=127.0.0.1 --proxysql-port=6203 --proxysql-username=admin --proxysql-password This script will assist with configuring ProxySQL (currently only Percona XtraDB cluster in combination with ProxySQL is supported) ProxySQL read/write configuration mode is singlewrite mysql: [ERROR] Unknown suffix '.' used for variable 'port' (value '127.0.0.1') mysql: [ERROR] mysql: Error while setting value '127.0.0.1' to 'port' Please check the ProxySQL connection parameters! Terminating. [root@proxy-sql-1 ~]# [root@proxy-sql-1 ~]# proxysql-admin --enable --mode=singlewrite --proxysql-port=6203 --proxysql-username=admin --proxysql-password Enter ProxySQL password: This script will assist with configuring ProxySQL (currently only Percona XtraDB cluster in combination with ProxySQL is supported) ProxySQL read/write configuration mode is singlewrite ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (111) Please check the ProxySQL connection parameters! Terminating. [root@proxy-sql-1 ~]# [root@proxy-sql-1 ~]# proxysql-admin --enable --mode=singlewrite --proxysql-hostname=127.0.0.1 --proxysql-port=6203 --proxysql-username=admin --proxysql-password This script will assist with configuring ProxySQL (currently only Percona XtraDB cluster in combination with ProxySQL is supported) ProxySQL read/write configuration mode is singlewrite mysql: [ERROR] Unknown suffix '.' used for variable 'port' (value '127.0.0.1') mysql: [ERROR] mysql: Error while setting value '127.0.0.1' to 'port' Please check the ProxySQL connection parameters! Terminating.
- is cloned by
-
-
- Done
-