Hi Gary,
That’s very odd.
I’d like to debug this off list with you for a bit to cut down on the back and
forth.
Email me directly with your contact information and I’ll be in touch.
Regards,
--
Louis Munro
[email protected] :: www.inverse.ca
+1.514.447.4918 x125 :: +1 (866) 353-6153 x125
Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence
(www.packetfence.org)
> On Feb 11, 2016, at 16:59 , Gary Stansbury <[email protected]> wrote:
>
> Hello,
>
> I've just upgraded from 4.7 to 5.6.1 and worked through all the upgrade doc,
> fixed all my violation syntax, upgraded the db schema incrementally from 4.7
> to 5.0 to 5.1 to 5.2 blah blah all the way to 5.6, added the db credentials
> to pfconf.conf, and generally gotten the thing working again, but I see that
> the accounting sections of the packetfence server and packetfence-tunnel
> servers are now using sql accounting whereas the 4.x series did not. This is
> causing me some trouble that I need some help working out, if I leave the
> "sql" and "packetfence" statements enabled in
>
> /usr/local/pf/conf/radiusd/packetfence
>
> I receive a onslaught of messages like these:
>
> Thu Feb 11 16:44:13 2016 : Error: [sql] Couldn't update SQL accounting ALIVE
> record - Result consisted of more than one row
> Thu Feb 11 16:44:13 2016 : Error: rlm_sql_mysql: Cannot store result
> Thu Feb 11 16:44:13 2016 : Error: rlm_sql_mysql: MySQL error 'Result
> consisted of more than one row'
> Thu Feb 11 16:44:13 2016 : Error: rlm_perl: No or invalid reply in RPC
> communication with server. Check server side logs for details.
> Thu Feb 11 16:44:13 2016 : Error: [sql] Couldn't update SQL accounting ALIVE
> record - Result consisted of more than one row
> Thu Feb 11 16:44:13 2016 : Error: rlm_sql_mysql: Cannot store result
> Thu Feb 11 16:44:13 2016 : Error: rlm_sql_mysql: MySQL error 'Result
> consisted of more than one row'
> Thu Feb 11 16:44:13 2016 : Error: [sql] Couldn't update SQL accounting ALIVE
> record - Result consisted of more than one row
> Thu Feb 11 16:44:13 2016 : Error: rlm_sql_mysql: Cannot store result
> Thu Feb 11 16:44:13 2016 : Error: rlm_sql_mysql: MySQL error 'Result
> consisted of more than one row'
> Thu Feb 11 16:44:13 2016 : Error: rlm_perl: An error occurred while
> processing the accounting RPC request: An error occured while processing the
> MessagePack request return code (500) at /usr/local/pf/lib//pf/radius/rpc.pm
> <http://rpc.pm/> line 47.
> Thu Feb 11 16:44:13 2016 : Error: rlm_perl: An error occurred while
> processing the accounting RPC request: An error occured while processing the
> MessagePack request return code (500) at /usr/local/pf/lib//pf/radius/rpc.pm
> <http://rpc.pm/> line 47.
> Thu Feb 11 16:44:13 2016 : Error: rlm_perl: An error occurred while
> processing the accounting RPC request: An error occured while processing the
> MessagePack request return code (500) at /usr/local/pf/lib//pf/radius/rpc.pm
> <http://rpc.pm/> line 47.
>
>
> in my radius.log, and utilization on the db and on the pf server gets pretty
> high and I end up getting user complaints of having to retry logging in to
> the wifi repeatedly to gain access.
>
> Any hints on what I may have missed in my upgrade or what to do to fix this
> accounting issue? For now I've just disabled accounting all together in
>
> /usr/local/pf/conf/radiusd/packetfence
>
> by remming out the "sql" and "packetfence" statements.
>
> Incidentally, I was initially also experiencing the issues detailed in bug
> 1169 with the acct_stop and acct_update stored procedures and replaced them
> according to the patch, which did resolve those acct_stop and acct_update
> errors, but now I'm faced with these similar errors. Little help please!
>
> Thanks,
>
> --
> Gary Stansbury
> Network Engineer
> Troup County Board of Education, LaGrange, GA
> 706-594-3928
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
