miha- wrote:
I am first time setting freeradius. I am setting it for voip accounting. I need a little help form you guys :) I read that I need to enable sql in radiusd.conf. I have also run a script for creating a tables. I changed sql.conf to voip-postpaid.conf ( I changed login, pass, and server in conf file).
Is this the right scipt for crating tables : http://wiki.freeradius.org/MySQL_DDL_script http://wiki.freeradius.org/MySQL_DDL_script
I am getting this error beacuse I do not know where must I put users and etc.
See doc/rlm_sql, or the Wiki. This is documented.
rlm_sql (sql): sql_set_user escaped user --> '081609000' radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = '081609000' ORDER BY id' rlm_sql (sql): Reserving sql socket id: 4 rlm_sql: Failed to create the pair: Unknown attribute "1234"
You have put garbage into the SQL table. Use the default schema, and follow the documentation for how to add users. Alan DeKok.