Using Custom table in FreeRadius

[Ahmed Munir]

Hi,

I've successfully using table sip_buddies instead of radcheck table(which is
used by default by FreeRadius). The problem I'm facing is that I can not
call more than 5 attribute in table sip_buddies in dialup.conf i.e. id,
name, attribute, secret and op. But when I call more than 5 attributes i.e.
id, name, zero_name, attribute, secret, op  I'm getting error as listed
below;

[sql]   expand: SELECT id, name, attribute, zero_name, secret, op
FROM sip_buddies           WHERE name = '%{SQL-User-Name}'           ORDER
BY id -> SELECT id, name, attribute, zero_name, secret, op           FROM
sip_buddies           WHERE name = '3225555025'           ORDER BY id
rlm_sql: Invalid operator "3225555025" for attribute Cleartext-Password
rlm_sql (sql): Error getting data from database
[sql] SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 3
++[sql] returns fail
Using Post-Auth-Type Reject
+- entering group REJECT {...}


But when I use this query as mentioned below;
SELECT id, name, attribute, secret, op           FROM sip_buddies
WHERE name = '%{SQL-User-Name}'           ORDER BY id

Its working fine then.

Kindly advise me how can I resolve this(calling more than 5 attributes in
sip_buddies table) issue. Please reply this at your earliest.



-- 
Regards,

Ahmed Munir
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20100524/d5539e31/attachment.html>