I've read through quite a few posts working out the proper SQL query syntax to get Authorization from an external server - an needed it to get my query working, thanks everyone!
Now the query which was working last time I touched it is failing.
(of course the server admin insists that nothing has changed at his end)
Of course Windows updates have been applied and CPPM has rev'd a few times, so everything has changed.
My query goes out and the server responds (packet capture says so) and the Access Tracker logs show:
2019-04-15 10:55:20,579 [Th 154984 Req 6201862 SessId R001f7567-01-5cb4b778] INFO RadiusServer.Radius - rlm_sql: searching for user 4083deef4807 in Sql:bgosql02.go.winco.local
2019-04-15 10:55:20,587 [Th 154984 Req 6201862 SessId R001f7567-01-5cb4b778] ERROR RadiusServer.Radius - rlm_sql (authsrc_3092): Error parsing data from database
In my packet capture I see the match request go out for MAC address: 40-83-de-ef-48-07 and the query response with 40-83-DE-EF-48-07
How do I figure out why ClearPass reports "Error parsing data from database?" or is ClearPass just unhappy about the capital letters?