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 <mailto:[email protected]> > Sent: 5/26/2015 8:32 AM > To: [email protected] > <mailto:[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] >> <mailto:[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] >> <mailto:[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] >> <mailto:[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] <mailto:[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] <mailto:[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 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)
0xF78F957E.asc
Description: application/pgp-keys
------------------------------------------------------------------------------ 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
