Any update on this behavior? I don't know where the code is for the
post-auth SQL accounting updates or I'd go take a look myself...
Thanks,
Gary Stansbury
On Fri, Feb 19, 2016 at 3:43 PM, Gary Stansbury <[email protected]>
wrote:
> Hello,
>
>
> after the update we're seeing names with apostrophe's in them are breaking
> the post-auth sql sequence:
>
> Fri Feb 19 15:25:28 2016 : Auth: Login OK: [ka'[email protected]] (from
> client 10.3.240.92 port 0 cli cc:79:4a:65:aa:d5 via TLS tunnel)
> Fri Feb 19 15:25:28 2016 : Auth: rlm_perl: Returning vlan 210 to request
> from cc:79:4a:65:aa:d5 port 0
> Fri Feb 19 15:25:28 2016 : Error: rlm_sql (sql) in sql_postauth: Database
> query error - You have an error in your SQL syntax; check the manual that
> corresponds to your My
> SQL server version for the right syntax to use near '[email protected]"
> NAS-Identifier = "ahap-lhs-a105" EAP-Messag' at line 1
> Fri Feb 19 15:25:28 2016 : Auth: Login incorrect: [ka'[email protected]]
> (from client 10.3.240.92 port 0 cli cc:79:4a:65:aa:d5)
>
> and causing these users to fail login.
>
> The same users have always succeeded radius and LDAP logins in the past
> (and it looks like they continue to succeed those portions), but now it
> looks like we need to sanitize the sql for the post-auth sequence and
> escape the apostrophe.
>
> Any guidance on where to go to do this?
>
> Thanks,
>
> --
> Gary Stansbury
> Network Engineer
> Troup County Board of Education, LaGrange, GA
> 706-594-3928
>
--
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
