Hello Yan,
Le 2017-10-30 ?? 11:28, Yan via PacketFence-users a ??crit?0?2:
> 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.
>
You can fill a issue on github about that.
> 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 ?*
*Yes it will
Regards
Fabrice
*
>
>
> ------------------ 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?0?2:
>> 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.?0?2 ?0?2
>>
>> 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 ??0?2
>> We tried to do the replacement in 3 steps: Step1,stop PF service.
>> Sqldump pf,pf_graphite,and pf_fingerbank DB to mypf.sql.?0?2
>> Step2, connected to remote mysql, import the mypf.sql file to it.?0?2
>> Step3,?0?2editing /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
--
Fabrice Durand
[email protected] :: +1.514.447.4918 (x135) :: www.inverse.ca
Inverse 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
