pcs cluster auth TBSLinuxNode1 TBSLinuxNode2 -u hacluster in node1 and node2 respectively When you paste , Authorized appears on each node only, and error occurs in the remaining nodes. For example, if you insert pcs cluster auth TBSLinuxNode1 TBSLinuxNode2 -u hacluster in node1, TBSLinuxNode1 : Authorized Error: Unable to communicate with TBSLinuxNode2 Is there a solution?
Check PCS status on both nodes, nodes can’t communicate with each other, if you don’t fix it it will create issues in next steps - check if firewall is disabled
Hi, Thanks for video i have configured everything with your steps but i have an issue with when i check pcs status on node 1 the second node "Node backup.inspectcheck.com: UNCLEAN (offline)" how i solve this issue ?
Hi Rafee, did you follow all steps, it’s kind of no step skip video and can you check if firewall is disabled on Node1 and 2? If above is true, can you send me log file just few lines when issue happens?
Hi, while running the command --> pcs cluster auth SQLNode1 SQLNode2 -u hacluster , i get following error : Error: SQLNode1: Username and/or password is incorrect SQLNode2: Authorized Please suggest the solution for the same thats gonna be a great help. Thanks, Shubham Arora
Couple things here, check to see if user hacluster exists, make sure the firewall is off between both nodes so they have communication open, did you run this command on Node2? Try running the same command on node1 and you see node1 is authorized but not node 2 - if still the same error, reset password for hacluster on node1 and rerun the command - let me know if this resolve the issue
@@TechBrothersIT User hacluster exists on both the nodes, firewall is off between 2 nodes, i run the same command on node 1 as well as node 2, it returns success on node 2 and failure on node one on both the nodes, i have tried resetting password many times but no luck..i followed this article to fix the issue as i am experiencing the same issue in my environment but didnt help --www.freesoftwareservers.com/pages/viewpage.action?pageId=10649603 and { "format_version": 3, "data_version": 8, "tokens": { "SQLNode2": "efb31c82-e8fa-4916-bf22-cfb4e69655d3" }, "ports": { "SQLNode2": 2224 } }
Ok, do me a favor, please run below command to disable SELinux as well, Also check PCS status on node 2 as well? vi /etc/sysconfig/selinux Change SELINUX=enforcing to Permissive and save the file on both nodes and setenforce 0 systemctl stop firewalld systemctl disable firewalld Make sure firewall is disabled, not just stopped as shown in above command. Reset the box and run your command again on node2. If still issue is there, please run below command on node 2 if you have run the command on node 2, paste the PCS log here and we will figure out what it is complaining about? cd /etc/corosync cat /corosync.conf Finding the Location of Log should be like this: LogFile: /var/log/Cluster/corosync.log Please send me contents most recent one when you run your command Thanks,
If you don’t want to use Putty, you can login directly in the node using root - each user has its own terminal - if you have installed desktop feature you can search for terminal and it will open. Usually it is on the desktop - is this what you were asking?
Great tutorial. Was part 2 uploaded for setting up High Availability Sql server?
th-cam.com/video/HpoRqs5QzRQ/w-d-xo.html
Hi, I have another issue when i turn off node1 cluster node2 ip not showing node1 html page
Could you please Share RHL 8.8 and sql server 2019 AG cobfiguration
pcs cluster auth TBSLinuxNode1 TBSLinuxNode2 -u hacluster in node1 and node2 respectively
When you paste , Authorized appears on each node only, and error occurs in the remaining nodes.
For example, if you insert pcs cluster auth TBSLinuxNode1 TBSLinuxNode2 -u hacluster in node1, TBSLinuxNode1 : Authorized
Error: Unable to communicate with TBSLinuxNode2
Is there a solution?
Check PCS status on both nodes, nodes can’t communicate with each other, if you don’t fix it it will create issues in next steps - check if firewall is disabled
Can you upload clustering in redhat 8 . No one posted it.
This is really great video , complete series for sql on linux setup. ,,may i know the trainer name?
I am sorry Barqawi, I didn’t get your question,do you mean Trainee’s name?
@@TechBrothersIT i mean the trainer name?
@@AlaaBarqawi My Name is Raza
Hi, Thanks for video i have configured everything with your steps but i have an issue with when i check pcs status on node 1 the second node "Node backup.inspectcheck.com: UNCLEAN (offline)" how i solve this issue ?
Hi Rafee, did you follow all steps, it’s kind of no step skip video and can you check if firewall is disabled on Node1 and 2? If above is true, can you send me log file just few lines when issue happens?
Hi, while running the command --> pcs cluster auth SQLNode1 SQLNode2 -u hacluster
, i get following error : Error: SQLNode1: Username and/or password is incorrect
SQLNode2: Authorized
Please suggest the solution for the same thats gonna be a great help.
Thanks,
Shubham Arora
Couple things here, check to see if user hacluster exists, make sure the firewall is off between both nodes so they have communication open, did you run this command on Node2? Try running the same command on node1 and you see node1 is authorized but not node 2 - if still the same error, reset password for hacluster on node1 and rerun the command - let me know if this resolve the issue
@@TechBrothersIT User hacluster exists on both the nodes, firewall is off between 2 nodes, i run the same command on node 1 as well as node 2, it returns success on node 2 and failure on node one on both the nodes, i have tried resetting password many times but no luck..i followed this article to fix the issue as i am experiencing the same issue in my environment but didnt help --www.freesoftwareservers.com/pages/viewpage.action?pageId=10649603 and
{
"format_version": 3,
"data_version": 8,
"tokens": {
"SQLNode2": "efb31c82-e8fa-4916-bf22-cfb4e69655d3"
},
"ports": {
"SQLNode2": 2224
}
}
Ok, do me a favor, please run below command to disable SELinux as well, Also check PCS status on node 2 as well?
vi /etc/sysconfig/selinux
Change SELINUX=enforcing to Permissive and save the file on both nodes and
setenforce 0
systemctl stop firewalld
systemctl disable firewalld
Make sure firewall is disabled, not just stopped as shown in above command. Reset the box and run your command again on node2. If still issue is there, please run below command on node 2 if you have run the command on node 2, paste the PCS log here and we will figure out what it is complaining about?
cd /etc/corosync
cat /corosync.conf
Finding the Location of Log
should be like this:
LogFile: /var/log/Cluster/corosync.log
Please send me contents most recent one when you run your command
Thanks,
Shubham, did you try this resolution that I shared in last comment?
@@TechBrothersIT Tried this as well, selinux was already set to permissive state by me..No luck
How to open a node on terminal?
If you don’t want to use Putty, you can login directly in the node using root - each user has its own terminal - if you have installed desktop feature you can search for terminal and it will open. Usually it is on the desktop - is this what you were asking?
Maybe this will help
ssh username@remotehost.example.com