Connexion to database interrupted at router bootstrap
Hello to all
I use my mysql-router 8.0.32 on Redhat 8.4, the remote dabase is a v8 cluster
Here is the error :
# mysqlrouter --bootstrap myuser@dbp01:3306 --conf-bind-address 127.0.0.1 --account myuser --user mysqlrouter --account-create never --force
Please enter MySQL password for myuser:
# Bootstrapping system MySQL Router instance...
Please enter MySQL password for myuser:
- Using existing certificates from the '/var/lib/mysqlrouter' directory
- Verifying account (using it to run SQL queries that would be run by Router)
- Storing account in keyring
- Adjusting permissions of generated files
- Creating configuration /etc/mysqlrouter/mysqlrouter.conf
Error: Error executing MySQL query "select view_id from mysql_innodb_cluster_metadata.v2_ar_members where CAST(member_id AS char ascii) = CAST(@@server_uuid AS char ascii)": Lost connection to MySQL server during query (2013)
#
In the database, I can see:
Aborted connection 5216418 to db: 'unconnected' user: 'myuser' host: 'vm43a' (Got an error reading communication packets)
The user myuser can connect remotely with mysql> without issue and the query is ok
What could be the cause please ? Thank you
Subject
Views
Written By
Posted
Connexion to database interrupted at router bootstrap
526
April 17, 2023 04:04AM
255
April 20, 2023 09:38AM
243
April 20, 2023 10:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.