Hi Fabrice,
Thank you very much. You are right. It seems my problem was caused by not
excuting "pfcmd configreload hard" and to "restart packetfence-config". After
doing this, the nodes dashboard are loaded correctly. But there are 2 other
issues hope your help.
1. It always shows error "Can't call method "finish" on an undefined value at
/usr/local/pf/lib/pf/dal/class.pm line 39" when I issue "pfcmd configreload
hard". This error causes PF reload failure. After I commented out the line 39
pf can reload as normal. But I know there must be error in somewhere, we can't
just comment this default process.
2. We are about to deploy at least 3 PF servers in production network for our
different remote offices. Is it okay to replace these 3 PF's mariaDB with the
same remote online mysql host ? By the way we have DB proxy for load balance
online. Would these standalone PF with the same mysql connection work well
without configuring haproxy ?
------------------ Original ------------------
From: packetfence-users <[email protected]>
Date: ????,10?? 30,2017 21:04
To: packetfence-users <[email protected]>
Cc: Fabrice Durand <[email protected]>
Subject: Re: [PacketFence-users] PF cluster deployment and remote
mysqlintegration problem
Hello Yan,
yes of course it's possible to move the db from local to remote.
When you export the db, be sure to export the procedures too, or use the
db schema in db directory then import your data.
Also don't forget to do a pfcmd configreload hard and to restart
packetfence-config.
Regards
Fabrice
Le 2017-10-30 ?? 02:23, Yan via PacketFence-users a ??crit :
Hi dear users,
We are going to deploy PF v7.3 in our production network recently.
Our PF works fine in standalone mode. Since I'm not so familiar with DB
operation, I think it's a little difficult for me to operate the mariadb
clustering after reading the cluster deployment guide. I'm afraid I
couldn't handle the cluster issue in the future.
So I'm thinking if it is possible to replace every PF's mysql DB
with the same remote one and we'll handover the DB operation work to our
official DB team. After we tested it for a week, we found PF behaved
strange with remote DB integration. Could you pls help to give us some
suggestions on below problems ? Thank you very much.
If it is possible to replace local PF DB with remote mysql DB ?
We tried to do the replacement in 3 steps: Step1,stop PF service.
Sqldump pf,pf_graphite,and pf_fingerbank DB to mypf.sql.
Step2, connected to remote mysql, import the mypf.sql file to it.
Step3, editing /usr/local/pf/conf/pf.conf,
/usr/local/pf/conf/pfconfig.conf and
/usr/local/fingerbank/conf/fingerbank.conf by replacing the localhost
with remote mysql host,user and password. And then start pf service.
After we doning this, we can start PF successfully. And when user
connected to wifi we can see related accountinglog updated in remote
mysql table. But after we do the same deployment on a second PF, ideally
we could see the two PF sharing the same remote mysql info. But actually
the nodes dashboard info is still form local mariadb on the second PF.
------------------------------------------------------------------------------Check
out the vibrant tech community on one of the world's mostengaging tech sites,
Slashdot.org! http://sdm.link/slashdot
_______________________________________________PacketFence-users mailing
[email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users
-- Fabrice [email protected] :: +1.514.447.4918 (x135) ::
www.inverse.caInverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and
PacketFence (http://packetfence.org)------------------------------------------------------------------------------
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
