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.
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]:<em style='color: #c0392b;'>192.168.169.166</em>: Failed to install ProxySql
[21:51:23]:<em style='color: #c0392b;'>192.168.169.166</em>: stopping 'proxysql' service.
[21:51:23]:<em style='color: #c0392b;'>192.168.169.166</em>:6032: Installation failed, stopping ProxySql if it is running.
[21:51:23]:<em style='color: #c0392b;'>192.168.169.166</em>: Package 'percona-server-client-5.7' not found after installation.
[21:51:23]:<em style='color: #c0392b;'>192.168.169.166</em>: Package <strong style='color: #110679;'>percona-server-client-5.7</strong> is not installed.
[21:51:23]:<em style='color: #c0392b;'>192.168.169.166</em>: Verifying the <strong style='color: #110679;'>percona-server-client-5.7</strong> installation.
[21:51:22]:<em style='color: #c0392b;'>192.168.169.166</em>: 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]:<em style='color: #c0392b;'>192.168.169.166</em>: Command was <strong style='color: orange;'>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</strong>.
[21:51:22]:<em style='color: #c0392b;'>192.168.169.166</em>: Execution failed with return code 100.
[21:51:21]:<em style='color: #c0392b;'>192.168.169.166</em>: 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]:<em style='color: #c0392b;'>192.168.169.166</em>: Command was <strong style='color: orange;'>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</strong>.
[21:51:21]:<em style='color: #c0392b;'>192.168.169.166</em>: Execution failed with return code 100.
[21:51:20]:<em style='color: #c0392b;'>192.168.169.166</em>: No mysql client found. Installing.
[21:51:20]:<em style='color: #c0392b;'>192.168.169.166</em>: Checking if 'mysql' is installed.
[21:51:20]:<em style='color: #c0392b;'>192.168.169.166</em>: Finished with helper packages.
[21:51:19]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>libssl1.1</strong>.
[21:51:18]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>apt-transport-https</strong>.
[21:51:17]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>openssl</strong>.
[21:51:16]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>libatomic1</strong>.
[21:51:15]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>tar</strong>.
[21:51:15]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>iproute2</strong>.
[21:51:14]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>bzip2</strong>.
[21:51:13]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>libmecab2</strong>.
[21:51:12]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>libnuma1</strong>.
[21:51:11]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>pigz</strong>.
[21:51:10]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>curl</strong>.
[21:51:09]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>wget</strong>.
[21:51:09]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>lsb-release</strong>.
[21:51:08]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>socat</strong>.
[21:51:07]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>netcat-openbsd</strong>.
[21:51:06]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>netcat</strong>.
[21:51:05]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>libaio1</strong>.
[21:51:04]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>rsync</strong>.
[21:51:04]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing <strong style='color: #110679;'>psmisc</strong>.
[21:51:01]:<em style='color: #c0392b;'>192.168.169.166</em>: Installing helper packages.
[21:50:57]:<em style='color: #c0392b;'>192.168.169.166</em>: Detected Vendor: <strong style='color: #59a449;'>debian</strong>, Release: <strong style='color: #59a449;'>bullseye</strong>, Release Name: <strong style='color: #59a449;'>bullseye</strong>
[21:50:57]:<em style='color: #c0392b;'>192.168.169.166</em>: 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]:<em style='color: #c0392b;'>192.168.169.166</em>: Checking firewall.
[21:50:54]:<em style='color: #c0392b;'>192.168.169.166</em>: Disabling firewall.
[21:50:52]:<em style='color: #c0392b;'>192.168.169.166</em>: 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 '<strong style='color: #59a449;'>ansible</strong>'.
[21:50:51]:Cluster ID is 1.
[21:50:51]:Using SSH credentials from cluster.
[21:50:51]:CMON version <strong style='color: #59a449;'>1.9.2.5384</strong>.
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
}
]
}
}
```
Please sign in to leave a comment.
Comments
0 comments