Freeradius and Voip

[Alan DeKok]

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.