Discussion:
[PacketFence-users] PF 7 Cluster Help
Mike Campanaro
2017-05-18 14:39:40 UTC
Permalink
I'm using three Packetfence 7 - ZEN machines and trying to cluster them together. I've been following the Cluster Quick Install Guide but I can't seem to get past section 3.5.3 MariaDB sync.

After flushing the mysql data on my two nodes with the rm -fr /var/lib/mysql/* command and then restarting the packetfence-mariadb service as the guide states, nothing seems to happen.

I try to run mysql> show status like 'wsrep%'; to check the sync status but the command returns nothing. If I just running the 'mysql' command I get an error saying "Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (111 "Connection refused")

Any guidance would be appreciated.


Thanks,
Mike Campanaro
Network Administrator I

[cid:***@01D27D5C.1F2F1C10]

19 Corporate Circle
East Syracuse, NY 13057
315-463-1010 | Fax 315-463-1980
For more information, visit us at www.dumac.com<http://www.dumac.com/>

Notice: This E-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. §§2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.
This message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. Messages sent to and from us may be monitored.
Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. If verification is required, please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of DUMAC Business Systems, Inc.
Durand fabrice
2017-05-20 02:24:07 UTC
Permalink
Hello Mike,

In pf.conf it suppose to be that:

[database]
host=127.0.0.1

Can you confirm ?

Regards
Fabrice
I’m using three Packetfence 7 – ZEN machines and trying to cluster
them together. I’ve been following the Cluster Quick Install Guide but
I can’t seem to get past section 3.5.3 MariaDB sync.
After flushing the mysql data on my two nodes with the rm –fr
/var/lib/mysql/* command and then restarting the packetfence-mariadb
service as the guide states, nothing seems to happen.
I try to run mysql> show status like ‘wsrep%’; to check the sync
status but the command returns nothing. If I just running the ‘mysql’
command I get an error saying “Can’t connect to local MySQL server
through socket ‘var/lib/mysql/mysql.sock’ (111 “Connection refused”)
Any guidance would be appreciated.
Thanks,
*Mike Campanaro
**Network Administrator I***
**
19 Corporate Circle
East Syracuse, NY 13057
315-463-1010 | Fax 315-463-1980
For more information, visit us at www.dumac.com <http://www.dumac.com/>
*
**/Notice: This E-mail (including attachments) is covered by the
Electronic Communications Privacy Act, 18 U.S.C. §§2510-2521, is
confidential and may be legally privileged. If you are not the
intended recipient, you are hereby notified that any retention,
dissemination, distribution, or copying of this communication is
strictly prohibited. Please reply to the sender that you have received
the message in error, then delete it. Thank you./**//*
This message (and any associated files) is intended only for the use
of the individual or entity to which it is addressed and may contain
information that is confidential, subject to copyright or constitutes
a trade secret. Messages sent to and from us may be monitored. *//*
Internet communications cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. Therefore,
we do not accept responsibility for any errors or omissions that are
present in this message, or any attachment, that have arisen as a
result of e-mail transmission. If verification is required, please
request a hard-copy version. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
DUMAC Business Systems, Inc.
------------------------------------------------------------------------------
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
https://lists.sourceforge.net/lists/listinfo/packetfence-users
Mike Campanaro
2017-05-22 15:53:41 UTC
Permalink
Hey Fabrice,

I can confirm that those settings are what I have. All of the files seemed to have synced fine from my master server but when I access the admin page via the cluster IP, it's stating that the database is in read only mode. Any thoughts on how I can resolve this?


Thanks,
Mike Campanaro
Network Administrator I

From: Durand fabrice [mailto:***@inverse.ca]
Sent: Friday, May 19, 2017 10:24 PM
To: packetfence-***@lists.sourceforge.net
Subject: Re: [PacketFence-users] PF 7 Cluster Help


Hello Mike,

In pf.conf it suppose to be that:

[database]
host=127.0.0.1
Can you confirm ?

Regards
Fabrice
Le 2017-05-18 à 10:39, Mike Campanaro a écrit :
I'm using three Packetfence 7 - ZEN machines and trying to cluster them together. I've been following the Cluster Quick Install Guide but I can't seem to get past section 3.5.3 MariaDB sync.

After flushing the mysql data on my two nodes with the rm -fr /var/lib/mysql/* command and then restarting the packetfence-mariadb service as the guide states, nothing seems to happen.

I try to run mysql> show status like 'wsrep%'; to check the sync status but the command returns nothing. If I just running the 'mysql' command I get an error saying "Can't connect to local MySQL server through socket 'var/lib/mysql/mysql.sock' (111 "Connection refused")

Any guidance would be appreciated.



Thanks,
Mike Campanaro
Network Administrator I

[cid:***@01D27D5C.1F2F1C10]

19 Corporate Circle
East Syracuse, NY 13057
315-463-1010 | Fax 315-463-1980
For more information, visit us at www.dumac.com<http://www.dumac.com/>

Notice: This E-mail (including attachments) is covered by the Electronic Communications Privacy Act, 18 U.S.C. §§2510-2521, is confidential and may be legally privileged. If you are not the intended recipient, you are hereby notified that any retention, dissemination, distribution, or copying of this communication is strictly prohibited. Please reply to the sender that you have received the message in error, then delete it. Thank you.
This message (and any associated files) is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential, subject to copyright or constitutes a trade secret. Messages sent to and from us may be monitored.
Internet communications cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this message, or any attachment, that have arisen as a result of e-mail transmission. If verification is required, please request a hard-copy version. Any views or opinions presented are solely those of the author and do not necessarily represent those of DUMAC Business Systems, Inc.






------------------------------------------------------------------------------

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

PacketFence-***@lists.sourceforge.net<mailto:PacketFence-***@lists.sourceforge.net>

https://lists.sourceforge.net/lists/listinfo/packetfence-users

Continue reading on narkive:
Loading...