Hi,<br><br>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;<br>
<br>[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<br>
rlm_sql: Invalid operator "3225555025" for attribute Cleartext-Password<br>rlm_sql (sql): Error getting data from database<br>[sql] SQL query error; rejecting user<br>rlm_sql (sql): Released sql socket id: 3<br>
++[sql] returns fail<br>Using Post-Auth-Type Reject<br>+- entering group REJECT {...}<br><br clear="all"><br>But when I use this query as mentioned below;<br>SELECT id, name, attribute, secret, op FROM
sip_buddies WHERE name = '%{SQL-User-Name}' ORDER BY
id<br><br>Its working fine then.<br><br>Kindly advise me how can I resolve this(calling more than 5 attributes in sip_buddies table) issue. Please reply this at your earliest.<br><br><br> <br>-- <br>Regards,<br><br>Ahmed Munir<br>
<br><br>