Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5.1
-
None
-
Running rhel 7.8, php 7.1.30 from redhat software collections with mariadb 10.1 backends
Description
When attempting to connect to a db using php with either mysqli or PDO I get the errors
Fatal error: Uncaught PDOException: SQLSTATE[HY000] [1043] Bad handshake in /opt/app/etddev/releases/20200710192026/www/test1.php:4 Stack trace: #0 /opt/app/etddev/releases/20200710192026/www/test1.php(4): PDO->__construct('mysql:host=maxs...', '****', '*****') #1
{main}thrown in /opt/app/etddev/releases/20200710192026/www/test1.php on line 4
And
Warning: mysqli::__construct(): (HY000/1043): Bad handshake in /opt/app/etddev/releases/20200710192026/www/test.php on line 11
Connection failed: Bad handshake
receptively
This is my config file
[maxscale]
threads=auto
admin_host=0.0.0.0
admin_secure_gui=false
log_debug=1
[mysqlcl-dev01]
type=server
address=10.76.10.171
port=3306
protocol=MariaDBBackend
[mysqlcl-dev02]
type=server
address=10.76.10.172
port=3306
protocol=MariaDBBackend
[mysqlcl-dev03]
type=server
address=10.76.10.173
port=3306
protocol=MariaDBBackend
[Galera-Monitor]
type=monitor
module=galeramon
servers=mysqlcl-dev01,mysqlcl-dev02,mysqlcl-dev03
user=monitor_user
password=************
monitor_interval=2000ms
[Splitter-Service]
type=service
router=readwritesplit
servers=mysqlcl-dev01,mysqlcl-dev02,mysqlcl-dev03
user=maxscale
password=***************
master_failure_mode=fail_on_write
master_reconnection=true
[Splitter-Listener]
type=listener
service=Splitter-Service
protocol=MariaDBClient
#protocol=MariaDBBackend
address=0.0.0.0
port=3306
We are attempting to switch from haproxy to maxscale after talk from your people
Attachments
Issue Links
- is duplicated by
-
MXS-3171 PHP 7.2 + PDO - invalid HandShakeResponse
- Closed