Open eslee1980 opened 3 years ago
An error occurs if the mha account password contains special characters (ex:!,^,*... ).
Any solution to this problem?
Due to password policy, passwords must contain special characters.
Please help me.
[root@rhel2 masterha]# cat /etc/masterha-default.cnf [server default] user=mha password=root123! <--
ssh_user=root ssh_port=22
repl_user=repl password=root123! <--
...
[root@rhel2 mymha]# masterha_master_switch --master_state=alive --conf=/etc/masterha-default.cnf Mon Jul 19 23:50:44 2021 - [info] MHA::MasterRotate version 0.57. Mon Jul 19 23:50:44 2021 - [info] Starting online master switch.. Mon Jul 19 23:50:44 2021 - [info] Mon Jul 19 23:50:44 2021 - [info] * Phase 1: Configuration Check Phase.. Mon Jul 19 23:50:44 2021 - [info] Mon Jul 19 23:50:44 2021 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Mon Jul 19 23:50:44 2021 - [info] Reading application default configuration from /etc/masterha-default.cnf.. Mon Jul 19 23:50:44 2021 - [info] Reading server configuration from /etc/masterha-default.cnf.. Mon Jul 19 23:50:45 2021 - [info] GTID failover mode = 0 Mon Jul 19 23:50:45 2021 - [info] Current Alive Master: rhel2(192.168.2.129:3306) Mon Jul 19 23:50:45 2021 - [info] Alive Slaves: Mon Jul 19 23:50:45 2021 - [info] rhel1(192.168.2.179:3306) Version=8.0.25 (oldest major version between slaves) log-bin:enabled Mon Jul 19 23:50:45 2021 - [info] Replicating from rhel2(192.168.2.129:3306) Mon Jul 19 23:50:45 2021 - [info] Primary candidate for the new Master (candidate_master is set)
It is better to execute FLUSH NO_WRITE_TO_BINLOG TABLES on the master before switching. Is it ok to execute on rhel2(192.168.2.129:3306)? (YES/no): yes Mon Jul 19 23:50:47 2021 - [info] Executing FLUSH NO_WRITE_TO_BINLOG TABLES. This may take long time.. Mon Jul 19 23:50:47 2021 - [info] ok. Mon Jul 19 23:50:47 2021 - [info] Checking MHA is not monitoring or doing failover.. Mon Jul 19 23:50:47 2021 - [info] Checking replication health on rhel1.. Mon Jul 19 23:50:47 2021 - [info] ok. Mon Jul 19 23:50:47 2021 - [info] Searching new master from slaves.. Mon Jul 19 23:50:47 2021 - [info] Candidate masters from the configuration file: Mon Jul 19 23:50:47 2021 - [info] rhel1(192.168.2.179:3306) Version=8.0.25 (oldest major version between slaves) log-bin:enabled Mon Jul 19 23:50:47 2021 - [info] Replicating from rhel2(192.168.2.129:3306) Mon Jul 19 23:50:47 2021 - [info] Primary candidate for the new Master (candidate_master is set) Mon Jul 19 23:50:47 2021 - [info] rhel2(192.168.2.129:3306) Version=8.0.25 log-bin:enabled Mon Jul 19 23:50:47 2021 - [info] Non-candidate masters: Mon Jul 19 23:50:47 2021 - [info] Searching from candidate_master slaves which have received the latest relay log events.. Mon Jul 19 23:50:47 2021 - [info] From: rhel2(192.168.2.129:3306) (current master) +--rhel1(192.168.2.179:3306)
To: rhel1(192.168.2.179:3306) (new master)
Starting master switch from rhel2(192.168.2.129:3306) to rhel1(192.168.2.179:3306)? (yes/NO): yes Mon Jul 19 23:50:48 2021 - [info] Checking whether rhel1(192.168.2.179:3306) is ok for the new master.. Mon Jul 19 23:50:48 2021 - [info] ok. Mon Jul 19 23:50:48 2021 - [info] * Phase 1: Configuration Check Phase completed. Mon Jul 19 23:50:48 2021 - [info] Mon Jul 19 23:50:48 2021 - [info] Phase 2: Rejecting updates Phase.. Mon Jul 19 23:50:48 2021 - [info] Mon Jul 19 23:50:48 2021 - [info] Executing master ip online change script to disable write on the current master: Mon Jul 19 23:50:48 2021 - [info] /opt/mymha/mha4mysql-manager-0.57/samples/scripts/master_ip_online_change --command=stop --orig_master_host=rhel2 --orig_master_ip=192.168.2.129 --orig_master_port=3306 --orig_master_user='mha' --new_master_host=rhel1 --new_master_ip=192.168.2.179 --new_master_port=3306 --new_master_user='mha' --orig_master_ssh_user=root --new_master_ssh_user=root --orig_master_password=xxx --new_master_password=xxx Semicolon seems to be missing at /opt/mymha/mha4mysql-manager-0.57/samples/scripts/master_ip_online_change line 41. Mon Jul 19 23:50:49 2021 - [error][/usr/local/share/perl5/MHA/ManagerUtil.pm, ln177] Got ERROR: at /usr/local/bin/masterha_master_switch line 53.
An error occurs if the mha account password contains special characters (ex:!,^,*... ).
Any solution to this problem?
Due to password policy, passwords must contain special characters.
Please help me.
[root@rhel2 masterha]# cat /etc/masterha-default.cnf [server default] user=mha password=root123! <--
ssh_user=root ssh_port=22
repl_user=repl password=root123! <--
...
[root@rhel2 mymha]# masterha_master_switch --master_state=alive --conf=/etc/masterha-default.cnf Mon Jul 19 23:50:44 2021 - [info] MHA::MasterRotate version 0.57. Mon Jul 19 23:50:44 2021 - [info] Starting online master switch.. Mon Jul 19 23:50:44 2021 - [info] Mon Jul 19 23:50:44 2021 - [info] * Phase 1: Configuration Check Phase.. Mon Jul 19 23:50:44 2021 - [info] Mon Jul 19 23:50:44 2021 - [warning] Global configuration file /etc/masterha_default.cnf not found. Skipping. Mon Jul 19 23:50:44 2021 - [info] Reading application default configuration from /etc/masterha-default.cnf.. Mon Jul 19 23:50:44 2021 - [info] Reading server configuration from /etc/masterha-default.cnf.. Mon Jul 19 23:50:45 2021 - [info] GTID failover mode = 0 Mon Jul 19 23:50:45 2021 - [info] Current Alive Master: rhel2(192.168.2.129:3306) Mon Jul 19 23:50:45 2021 - [info] Alive Slaves: Mon Jul 19 23:50:45 2021 - [info] rhel1(192.168.2.179:3306) Version=8.0.25 (oldest major version between slaves) log-bin:enabled Mon Jul 19 23:50:45 2021 - [info] Replicating from rhel2(192.168.2.129:3306) Mon Jul 19 23:50:45 2021 - [info] Primary candidate for the new Master (candidate_master is set)
It is better to execute FLUSH NO_WRITE_TO_BINLOG TABLES on the master before switching. Is it ok to execute on rhel2(192.168.2.129:3306)? (YES/no): yes Mon Jul 19 23:50:47 2021 - [info] Executing FLUSH NO_WRITE_TO_BINLOG TABLES. This may take long time.. Mon Jul 19 23:50:47 2021 - [info] ok. Mon Jul 19 23:50:47 2021 - [info] Checking MHA is not monitoring or doing failover.. Mon Jul 19 23:50:47 2021 - [info] Checking replication health on rhel1.. Mon Jul 19 23:50:47 2021 - [info] ok. Mon Jul 19 23:50:47 2021 - [info] Searching new master from slaves.. Mon Jul 19 23:50:47 2021 - [info] Candidate masters from the configuration file: Mon Jul 19 23:50:47 2021 - [info] rhel1(192.168.2.179:3306) Version=8.0.25 (oldest major version between slaves) log-bin:enabled Mon Jul 19 23:50:47 2021 - [info] Replicating from rhel2(192.168.2.129:3306) Mon Jul 19 23:50:47 2021 - [info] Primary candidate for the new Master (candidate_master is set) Mon Jul 19 23:50:47 2021 - [info] rhel2(192.168.2.129:3306) Version=8.0.25 log-bin:enabled Mon Jul 19 23:50:47 2021 - [info] Non-candidate masters: Mon Jul 19 23:50:47 2021 - [info] Searching from candidate_master slaves which have received the latest relay log events.. Mon Jul 19 23:50:47 2021 - [info] From: rhel2(192.168.2.129:3306) (current master) +--rhel1(192.168.2.179:3306)
To: rhel1(192.168.2.179:3306) (new master)
Starting master switch from rhel2(192.168.2.129:3306) to rhel1(192.168.2.179:3306)? (yes/NO): yes Mon Jul 19 23:50:48 2021 - [info] Checking whether rhel1(192.168.2.179:3306) is ok for the new master.. Mon Jul 19 23:50:48 2021 - [info] ok. Mon Jul 19 23:50:48 2021 - [info] * Phase 1: Configuration Check Phase completed. Mon Jul 19 23:50:48 2021 - [info] Mon Jul 19 23:50:48 2021 - [info] Phase 2: Rejecting updates Phase.. Mon Jul 19 23:50:48 2021 - [info] Mon Jul 19 23:50:48 2021 - [info] Executing master ip online change script to disable write on the current master: Mon Jul 19 23:50:48 2021 - [info] /opt/mymha/mha4mysql-manager-0.57/samples/scripts/master_ip_online_change --command=stop --orig_master_host=rhel2 --orig_master_ip=192.168.2.129 --orig_master_port=3306 --orig_master_user='mha' --new_master_host=rhel1 --new_master_ip=192.168.2.179 --new_master_port=3306 --new_master_user='mha' --orig_master_ssh_user=root --new_master_ssh_user=root --orig_master_password=xxx --new_master_password=xxx Semicolon seems to be missing at /opt/mymha/mha4mysql-manager-0.57/samples/scripts/master_ip_online_change line 41. Mon Jul 19 23:50:49 2021 - [error][/usr/local/share/perl5/MHA/ManagerUtil.pm, ln177] Got ERROR: at /usr/local/bin/masterha_master_switch line 53.