Thanks for the reply Luca,

I’ve been checking that – and the master server is joined and synced:

  *   Shows cluster size 1
  *   Shows IP of master in incoming addresses
  *   Local state comment is synced
  *   Cluster status is primary

It looks like the master has connected to itself. Any other ideas, or have I 
misinterpreted the status?

--
Jason Trinklein
Wireless Engineering Manager
College of Charleston
81 St. Philip Street | Office 311D | Charleston, SC 29403
[email protected]<mailto:[email protected]> | (843) 300–8009

From: luca comes via PacketFence-users <[email protected]>
Reply-To: "[email protected]" 
<[email protected]>
Date: Friday, January 19, 2018 at 4:39 AM
To: "[email protected]" 
<[email protected]>
Cc: luca comes <[email protected]>
Subject: [PacketFence-users] R: Can't synchronize new cluster databases

Hi Jason,
I had the same problem last week. First check on your master server if it is 
joined and synced with the cluster you can do that reading the file .err in 
/var/lib/mysql/ and in the database with the query show status like 'wsrep%' as 
stated in the clustering guide.

Luca




________________________________
Da: Trinklein, Jason R via PacketFence-users 
<[email protected]>
Inviato: giovedì 18 gennaio 2018 20:19
A: Rafael Rocha via PacketFence-users
Cc: Trinklein, Jason R
Oggetto: [PacketFence-users] Can't synchronize new cluster databases


I’m setting up a new cluster with three total members.



Server1 is running with /usr/local/pf/sbin/pf-mariadb --force-new-cluster

Server2 runs systemctl restart packetfence-mariadb

But fails with:

Job for packetfence-mariadb.service failed because a timeout was exceeded. See 
"systemctl status packetfence-mariadb.service" and "journalctl -xe" for details.

And journalctl shows:

https://pastebin.com/pWn6Nr1D<https://na01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpastebin.com%2FpWn6Nr1D&data=02%7C01%7C%7C7976b59530924835e8ab08d55f207cc6%7Ce285d438dbba4a4c941c593ba422deac%7C0%7C0%7C636519515502788419&sdata=egbUuqj8HX5eynYyrPOnHtnkVZ0GB5IunQtepoxh7aY%3D&reserved=0>



The systems can ping each other and tcpdump shows mysql packets being sent and 
received by both hosts. There is no firewall between them and they are on the 
same network.



Any ideas?

Thanks,

--

Jason Trinklein

Wireless Engineering Manager

College of Charleston

81 St. Philip Street | Office 311D | Charleston, SC 29403

[email protected]<mailto:[email protected]> | (843) 300–8009
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to