Hello Fabrice, Although, I restarted packetfenc-config, packetfence but on webpage still showing PF v5.0.2 while
> [root@vmvnnetsec01 bin]# ./pfcmd version > PacketFence 5.1.0 > [root@vmvnnetsec01 ~]# rpm -qa | grep packetfence > packetfence-5.1.0-1.el6.noarch > packetfence-freeradius2-3.4.1-1.el6.noarch > packetfence-release-1-1.el6.noarch > packetfence-pfcmd-suid-5.1.0-1.el6.x86_64 > packetfence-config-5.1.0-1.el6.noarch > Any one can tell me how to solved? Best regards, On 26 May 2015 at 21:29, Fabrice DURAND <[email protected]> wrote: > Hello Minh, > > check the UPGRADE.asciidoc: > > https://github.com/inverse-inc/packetfence/blob/packetfence-5.0.2/UPGRADE.asciidoc > > Regards > Fabrice > > > Le 2015-05-26 10:25, minh van a écrit : > > Hello Fabrice, > > Seems to lack of many tables here. > I just only fresh install PF4.7, then upgrade to v5 as repo. > Should i have to do now? Drop pf database and install db again or > something like that? > > Best regards, > ------------------------------ > From: Durand fabrice <[email protected]> > Sent: 5/26/2015 8:32 AM > To: [email protected] > Subject: Re: [PacketFence-users] Apply to Vlan > > Hello Minh, > > it miss a procedure in your database. > > Let's do: > mysqldump -uroot -p pf --no-data --routines > > and compare with db/pf-schema.sql > > Regards > Fabrice > > > Le 2015-05-25 04:57, Minh Trung a écrit : > > Hello, > > I am still not able to resolved this issue: > >> Mon May 25 15:33:20 2015 : Error: [sql] Couldn't update SQL accounting >> STOP record - PROCEDURE pf.acct_stop does not exist >> Mon May 25 15:33:20 2015 : Error: rlm_sql_mysql: Cannot store result >> Mon May 25 15:33:20 2015 : Error: rlm_sql_mysql: MySQL error 'PROCEDURE >> pf.acct_stop does not exist' >> >> Although, the client can access the portal and authorize successful. > > Do i am wrong any file configured? > > Any help is appreciated, > > > > On 6 May 2015 at 22:11, Juan Camilo Valencia < > [email protected]> wrote: > >> Hi Minh, >> >> I don´t have the excatly procedure write it, however is very simple. >> >> 1. Open up in a text editor, nedit is my preference, the schema of the >> database that match your version of pf. >> 2. At the same time connect to pf database, "mysql -u pf -p pf". >> 3. Search in the schema for the keyword "procedure", the first match is >> in a comment that says "-- Adding RADIUS Updates Stored Procedure". >> 4. Copy and paste in the mysql command the entire code that start with " >> DROP..." until says "DELIMITER ; ..." >> 5. Yo need to do this as many times as procedures you find in the schema, >> I tried to cp and paste all at once and for some reason failed, so do it >> step by step with each procedure. >> >> I hope that this help you, >> >> Best Regards, >> >> On Tue, May 5, 2015 at 10:14 PM, Minh Trung <[email protected]> wrote: >> >>> Hello Juan, >>> >>> I showed and it empty. >>> >>> >>> >>> >>> >>> >>> *mysql> use pf; Database changed mysql> show procedure status; Empty set >>> (0.00 sec) * >>> Now, i using PF v5.0.5 and i saw many procedures just after the radius >>> tables at docs in db's PF directory. >>> >>> Would you please point me the exact command to insert them? >>> >>> Thank a lot. >>> >>> Regards, >>> >>> >>> On 29 April 2015 at 20:40, Juan Camilo Valencia < >>> [email protected]> wrote: >>> >>>> Hi minh, >>>> >>>> Probably you are missing the storage procedures that radius needs for >>>> the accounting, login into your db and execute >>>> show procedures status; >>>> >>>> If does not appear any information you are missing that, probably >>>> because you made a backup of your info without the procedures next time use >>>> the modifiers --procedures in mysqldump command. To fix this open your sql >>>> schema for your pf version in db packetfence directory and look for the >>>> procedures just after the radius tables and start insert those ones >>>> manually. >>>> >>>> I hope that this can help you. >>>> >>>> Best regards >>>> >>>> El mar, abr 28, 2015 08:08, Minh Trung <[email protected]> escribió: >>>> >>>>> Hello Fabrice, >>>>> >>>>> I was successful in configured the vmware machine in tag the vlan as >>>>> above we discussed (it take long time to figure out [?]) and i also >>>>> see the portal on device which is plugged in the port testing. >>>>> But on radius log still show the error: >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> *Tue Apr 28 16:53:57 2015 : Auth: Login OK: [c80aa930b31f] (from >>>>> client 10.126.123.10 port 50001 cli C8-0A-A9-30-B3-1F) Tue Apr 28 16:53:58 >>>>> 2015 : Auth: rlm_perl: Returning vlan 210 to request from >>>>> c8:0a:a9:30:b3:1f >>>>> port 50001 Tue Apr 28 16:53:58 2015 : Error: [sql] Couldn't insert SQL >>>>> accounting START record - PROCEDURE pf.acct_start does not exist Tue Apr >>>>> 28 >>>>> 16:54:00 2015 : Error: [sql] Couldn't update SQL accounting STOP record - >>>>> PROCEDURE pf.acct_stop does not exist Tue Apr 28 16:54:00 2015 : Error: >>>>> rlm_sql_mysql: Cannot store result Tue Apr 28 16:54:00 2015 : Error: >>>>> rlm_sql_mysql: MySQL error 'PROCEDURE pf.acct_stop does not exist' Tue Apr >>>>> 28 16:54:05 2015 : Error: [sql] Couldn't update SQL accounting STOP record >>>>> - PROCEDURE pf.acct_stop does not exist Tue Apr 28 16:54:05 2015 : Error: >>>>> rlm_sql_mysql: Cannot store result Tue Apr 28 16:54:05 2015 : Error: >>>>> rlm_sql_mysql: MySQL error 'PROCEDURE pf.acct_stop does not exist' * >>>>> Do i miss configured any on database? >>>>> >>>>> I have DHCP(windows OS) existed with DHCP range 10.126.123.x how to >>>>> make clients will retrieved DHCP from Windows OS after clients finished >>>>> register? >>>>> Should i need change all ports on switch L2 to default(Vlan1)? >>>>> Any help is appreciated, >>>>> >>>>> Thanks & regards, >>>>> >>>>> >>>>> >>>>> On 2 April 2015 at 00:46, Durand fabrice <[email protected]> wrote: >>>>> >>>>>> Hello Minh, >>>>>> >>>>>> you have to tag the vlan 210 and 220 on the switch port where >>>>>> packetfence has been plugged on the vswitch. >>>>>> I don't have the exact way to do it but it look like there is >>>>>> documentation on internet to do that. >>>>>> >>>>>> Regards >>>>>> Fabrice >>>>>> >>>>>> >>>>>> >>>>>> Le 2015-03-31 23:11, Minh Trung a écrit : >>>>>> >>>>>> > [The entire original message is not included.] > > > ------------------------------------------------------------------------------ > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM > Insight.http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > > > > _______________________________________________ > PacketFence-users mailing > [email protected]https://lists.sourceforge.net/lists/listinfo/packetfence-users > > > > -- > Fabrice [email protected] :: +1.514.447.4918 (x135) :: www.inverse.ca > Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence > (http://packetfence.org) > > > > ------------------------------------------------------------------------------ > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM Insight. > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > _______________________________________________ > PacketFence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users > >
------------------------------------------------------------------------------
_______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
