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