Freeradius and Voip

Alan DeKok aland at
Wed Dec 1 12:16:36 CET 2010

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 : 
> 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.

More information about the Freeradius-Users mailing list