MySQL Forums
Forum List  »  Router & Proxy

Connexion to database interrupted at router bootstrap
Posted by: Fred Milonni
Date: April 17, 2023 04:04AM

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

Options: ReplyQuote

Written By
Connexion to database interrupted at router bootstrap
April 17, 2023 04:04AM

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.