ProxySQL deploy failed on Debian 11 node

Hello,

I am getting following error when trying to deploy proxySQL on debian 11 HA nodes.

I am following this page to deploy Galera cluster, all nodes are running Debian 11.

https://severalnines.com/database-blog/how-deploy-production-ready-mysql-or-mariadb-galera-cluster-using-clustercontrol

What should i do to correct it?

Thank you.

```

[21:51:24]:Load balancer management job failed.
[21:51:24]:Stopping job. Could not setup load balancer on host: 192.168.169.166
[21:51:24]:192.168.169.166: Failed to install ProxySql
[21:51:23]:192.168.169.166: stopping 'proxysql' service.
[21:51:23]:192.168.169.166:6032: Installation failed, stopping ProxySql if it is running.
[21:51:23]:192.168.169.166: Package 'percona-server-client-5.7' not found after installation.
[21:51:23]:192.168.169.166: Package percona-server-client-5.7 is not installed.
[21:51:23]:192.168.169.166: Verifying the percona-server-client-5.7 installation.
[21:51:22]:192.168.169.166: Output W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Unable to locate package percona-server-client-5.7
E: Couldn't find any package by glob 'percona-server-client-5.7'
E: Couldn't find any package by regex 'percona-server-client-5.7'
.
[21:51:22]:192.168.169.166: Command was DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install percona-server-client-5.7 2>&1.
[21:51:22]:192.168.169.166: Execution failed with return code 100.
[21:51:21]:192.168.169.166: Output W: --force-yes is deprecated, use one of the options starting with --allow instead.
E: Unable to locate package percona-server-client-5.7
E: Couldn't find any package by glob 'percona-server-client-5.7'
E: Couldn't find any package by regex 'percona-server-client-5.7'
.
[21:51:21]:192.168.169.166: Command was DEBIAN_FRONTEND=noninteractive LC_ALL=C apt-get -o Dpkg::Options::='--force-confnew' -o Dpkg::Options::='--force-confmiss' -qq -y --force-yes install percona-server-client-5.7 2>&1.
[21:51:21]:192.168.169.166: Execution failed with return code 100.
[21:51:20]:192.168.169.166: No mysql client found. Installing.
[21:51:20]:192.168.169.166: Checking if 'mysql' is installed.
[21:51:20]:192.168.169.166: Finished with helper packages.
[21:51:19]:192.168.169.166: Installing libssl1.1.
[21:51:18]:192.168.169.166: Installing apt-transport-https.
[21:51:17]:192.168.169.166: Installing openssl.
[21:51:16]:192.168.169.166: Installing libatomic1.
[21:51:15]:192.168.169.166: Installing tar.
[21:51:15]:192.168.169.166: Installing iproute2.
[21:51:14]:192.168.169.166: Installing bzip2.
[21:51:13]:192.168.169.166: Installing libmecab2.
[21:51:12]:192.168.169.166: Installing libnuma1.
[21:51:11]:192.168.169.166: Installing pigz.
[21:51:10]:192.168.169.166: Installing curl.
[21:51:09]:192.168.169.166: Installing wget.
[21:51:09]:192.168.169.166: Installing lsb-release.
[21:51:08]:192.168.169.166: Installing socat.
[21:51:07]:192.168.169.166: Installing netcat-openbsd.
[21:51:06]:192.168.169.166: Installing netcat.
[21:51:05]:192.168.169.166: Installing libaio1.
[21:51:04]:192.168.169.166: Installing rsync.
[21:51:04]:192.168.169.166: Installing psmisc.
[21:51:01]:192.168.169.166: Installing helper packages.
[21:50:57]:192.168.169.166: Detected Vendor: debian, Release: bullseye, Release Name: bullseye
[21:50:57]:192.168.169.166: Installing ProxySql package: 'proxysql2'.
[21:50:57]:Including 192.168.169.163:3306 for loadbalancing.
[21:50:57]:Including 192.168.169.162:3306 for loadbalancing.
[21:50:57]:Including 192.168.169.161:3306 for loadbalancing.
[21:50:54]:192.168.169.166: Checking firewall.
[21:50:54]:192.168.169.166: Disabling firewall.
[21:50:52]:192.168.169.166: Disabling SELinux/Apparmor.
[21:50:51]:Setting up ProxySql version 2.
[21:50:51]:Checking job parameters.
[21:50:51]:Starting proxysql.setupproxysql job.
[21:50:51]:Manage proxysql load-balancer (action: setupproxysql).
[21:50:51]:The username is 'ansible'.
[21:50:51]:Cluster ID is 1.
[21:50:51]:Using SSH credentials from cluster.
[21:50:51]:CMON version 1.9.2.5384.
Job spec:
{
"command": "proxysql",
"job_data": {
"action": "setupProxySql",
"admin_password": "9VsnJE@pro",
"admin_user": "proxysql-admin",
"clusterId": "1",
"db_database": "*.*",
"db_password": null,
"db_privs": "",
"db_username": null,
"disable_firewall": true,
"disable_selinux": true,
"listening_port": 6033,
"monitor_password": "9VsnJE@pro",
"monitor_user": "proxysql-monitor",
"use_clustering": false,
"use_rw_split": false,
"version": 2,
"node": {
"hostname": "192.168.169.166",
"port": 6032
},
"node_addresses": [
{
"hostname": "192.168.169.161",
"max_connection": 100,
"max_replication_lag": 10,
"port": 3306,
"weight": 1
},
{
"hostname": "192.168.169.162",
"max_connection": 100,
"max_replication_lag": 10,
"port": 3306,
"weight": 1
},
{
"hostname": "192.168.169.163",
"max_connection": 100,
"max_replication_lag": 10,
"port": 3306,
"weight": 1
}
]
}
}

```

ProxySQL deploy failed on Debian 11 node

Comments

Didn't find what you were looking for?