Informix error in "id" field ?

vanish vanishox at coltel.ru
Wed Jul 19 11:45:07 CEST 2017


Hi all!

1. I have freeradius v3.0.12, iodbc and informix database.

2. In informix i have tables - "accounts" with users logins and
"acct_details" with passwords.

3. One user (login) can have 2 or more passwords in "acct_details"
table.

4. Fields in tables:

...accounts...
 - fscontrol  VARCHAR (64) NOT NULL, - this is username

...acct_details...
 - fiacct_dtl_id SERIAL,
 - fspassword VARCHAR(64)NOT NULL,


5. My radcheck_query:

authorize_check_query = "\
SELECT p.fiacct_dtl_id id, '%{SQL-User-Name}' 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 = '%{SQL-User-Name}'"

6. In debug i see:

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???
ERROR: (2) pppoe: Error parsing user data from database result
ERROR: (2) pppoe: Error getting check attributes
Debug: rlm_sql (pppoe): Released connection (3)
Debug: (2)     modsingle[authorize]: returned from pppoe (rlm_sql)
Debug: (2)     [pppoe] = fail
Debug: (2)   } # authorize = fail

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?





More information about the Freeradius-Users mailing list