Alan DeKok wrote:
Dave Weis <[EMAIL PROTECTED]> wrote:The other reply items come from radgroupreply. When I run radiusd -X I see this in the logs:
modcall[post-auth]: module "sql" returns ok for request 0
modcall: group post-auth returns ok for request 0
Sending Access-Accept of id 59 to 127.0.0.1:57298
Framed-IP-Address <BARE-WORD> :=It looks like the SQL module is giving the wrong value to the "create attribute" function. From looking as your example, your data doesn't match the schema FreeRADIUS expects.
select * from generate_radreply('[EMAIL PROTECTED]');
id | username | attribute | op | value
That should be "... attribute value op" See the SQL schema included with the server.
I'm looking at db_postgresql.sql and see this:
CREATE TABLE radreply ( id SERIAL PRIMARY KEY, UserName VARCHAR(30) DEFAULT '' NOT NULL, Attribute VARCHAR(30), op VARCHAR(2) NOT NULL DEFAULT '=', Value VARCHAR(40) );
which is what I used for the layout. It looks the same in db_mysql.sql also.
Is it position sensitive or does it use column names?
Thanks dave
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html