Page 1 of 1

Using Innodb Cluster - MySQL Router

Posted: May 11th, 2022, 11:16 pm
by butching
I installed csweb on my pc connecting to innodb cluster using mysqlrouter
my host is 127.0.0.1:6446 and i manage to fixed the error on myisam by converting it to innodb. However, I keep on encountering error 500 and when i checked the log it says
[2022-05-12 05:11:09] request.CRITICAL: Uncaught PHP Exception PDOException: "SQLSTATE[HY000] [2003] Can't connect to remote MySQL server for client connected to 127.0.0.1:59916"
[2022-05-12 05:11:15] php.CRITICAL: Uncaught Exception: SQLSTATE[HY000] [2003] Can't connect to remote MySQL server for client connected to 127.0.0.1:59924
all errors are the same except the port. my question is I defined in my host like this

Code: Select all

define('DBHOST', '127.0.0.1:6446');
so why does it keep on changing in the PDO?

Re: Using Innodb Cluster - MySQL Router

Posted: May 13th, 2022, 1:45 pm
by savy
You need to clear CSWeb/var/cache folder for your changes to take into effect.