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
------------------------------------------------------------------------------
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
