Informix error in "id" field ?

[Alan DeKok]

On Jul 19, 2017, at 5:45 AM, vanish via Freeradius-Users <freeradius-users at lists.freeradius.org> wrote:
> Debug: (2) pppoe: Executing select query: SELECT p.fiacc_dtl_id id,
> '0015w' username, 'Cleartext-Password' attribute, trim(p.fspassword)
> value, ':=' op FROM accounts a inner join acct_details p on
> a.fiaccount_id = p.fiaccount_id WHERE a.fscontrol = '0015w'
> ERROR: (2) pppoe: Invalid op "??s???" for attribute ??s???

  The data returned from the database isn't what FreeRADIUS expects.

> In informix cli i see next result for query:
> 
> "id"	 ; username ; attribute          ; value        ; op
> "2567890"; 0015w    ; Cleartext-Password ; password     ; :=
> 
> 7. If replace "p.fiacct_dtl_id id" on "1 id" in query, then everything
> work fine.
> 
> Where can be the problem?

  Informix is weird.

  The ID is used mainly for sorting entries in the default configuration.  If you're not using the default configuration, then just making the ID always "1" is fine.

  Alan DeKok.