Strangeness in work 'radgroup_check_query' through 'rlm_sql_unixodbc'

[Alan DeKok]

On Jan 15, 2016, at 5:47 AM, vanish <vanishox at coltel.ru> wrote:
> 2. The error persists:
> ...............
> 
> Fri Jan 15 13:17:22 2016 : Info: [sql] 	expand: SELECT 'simult'
> groupname FROM TABLE(SET {1}) -> SELECT 'simult' groupname FROM
> TABLE(SET {1})
> Fri Jan 15 13:17:22 2016 : Debug: query:  SELECT 'simult' groupname FROM
> TABLE(SET {1})
> Fri Jan 15 13:17:22 2016 : Error: rlm_sql_unixodbc: 07009
> [unixODBC][Informix][Informix ODBC Driver]Invalid descriptor index. 
> Fri Jan 15 13:17:22 2016 : Debug: rlm_sql (sql): Released sql socket id:
> 3

  OK.  Doing a little more research, it looks like it's a problem with the ODBC API.

  The short summary is that the API is broken in undocumented ways.

  The longer summary is that you should probably switch to a different SQL driver.

> 3. I want implement simultaneous use check by username. 
> (Device send periodically accounting packets to freeradius. He writes it
> into the Informix.)
> 
> I can do this only after receiving "Simultaneous use := 1" to my
> request , and no further?

  That's how Simultaneous-Use works.  See the Wiki.  This is documented.

  Alan DeKok.