Saravanan, I tried diferent things, tried 3.0, '3.0' tried put a direct consult like (SELECT "user_password" FROM "CORPORERM"."PPESSOA" WHERE "USERNAME" = 'andre';), I tried another table with the same settings a in example from above link (username[testuser],pass[mypassword,role[employee]), I tried reinstalling the ClearPass, in the begining I was not getting the red error message but after change the database by mistake I started getting again even when correcting it.
Looking on the show logs, I see that the clearpass is not connecting to the postgres server, I don't how because, when I use a wrong snytax I am able to see that in my postgres logs.
But with the correct syntax you can see on the past attached the logs about Radius driver error unixODBC.
I think this is something on clearpass side, I am using Postgres 10, maybe the driver is different.
Request log details for session: R00000008-01-5ac51e12
Time Message
2018-04-04 15:48:50,728 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] INFO RadiusServer.Radius - rlm_service: Starting Service Categorization - 9:205:f0d7aa9d2f09 |
2018-04-04 15:48:50,732 | [RequestHandler-1-0x7fa189f6e700 r=psauto-1522863313-18 h=127 r=R00000008-01-5ac51e12] INFO Core.ServiceReqHandler - Service classification result = TEST_radius-POSTGRES |
2018-04-04 15:48:50,733 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] INFO RadiusServer.Radius - Service Categorization time = 5 ms |
2018-04-04 15:48:50,733 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] INFO RadiusServer.Radius - rlm_service: The request has been categorized into service "TEST_radius-POSTGRES" |
2018-04-04 15:48:50,733 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] INFO RadiusServer.Radius - rlm_sql: searching for user testuser in Sql:192.168.1.14 |
2018-04-04 15:48:50,753 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] ERROR RadiusServer.Radius - rlm_sql_unixodbc: sql state - 07005, sql error - unixODBC]Bindings were not allocated properly. |
2018-04-04 15:48:50,753 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] ERROR RadiusServer.Radius - rlm_sql_unixodbc: SQL down 07005 unixODBC]Bindings were not allocated properly. |
2018-04-04 15:48:50,753 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] INFO RadiusServer.Radius - rlm_sql_unixodbc: rlm_sql will attempt to reconnect |
2018-04-04 15:48:50,770 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] ERROR RadiusServer.Radius - rlm_sql_unixodbc: sql state - HY010, sql error - unixODBC]Driver Manager]Function sequence error |
2018-04-04 15:48:50,770 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] ERROR RadiusServer.Radius - rlm_sql_unixodbc: SQL down HY010 unixODBC]Driver Manager]Function sequence error |
2018-04-04 15:48:50,770 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] INFO RadiusServer.Radius - rlm_sql_unixodbc: rlm_sql will attempt to reconnect |
2018-04-04 15:48:50,770 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] ERROR RadiusServer.Radius - rlm_sql (authsrc_3001): failed after re-connect |
2018-04-04 15:48:50,770 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] ERROR RadiusServer.Radius - rlm_sql_unixodbc: sql state - HY010, sql error - unixODBC]Driver Manager]Function sequence error |
2018-04-04 15:48:50,770 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] ERROR RadiusServer.Radius - rlm_sql_unixodbc: SQL down HY010 unixODBC]Driver Manager]Function sequence error |
2018-04-04 15:48:50,770 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] INFO RadiusServer.Radius - rlm_auth_check: Auth-Type not set. |
2018-04-04 15:48:50,770 | [Th 12 Req 8 SessId R00000008-01-5ac51e12] ERROR RadiusServer.Radius - rlm_auth_check: Auth-Type not set or authentication methods have not been configured. Rejecting it. |