I'm trying to use postgresql to store my radius data. I have most of it working except for a stored procedure to return the static routing/addressing information for a login. It tries to work but I don't get the correct output in radtest.


select * from generate_radreply('[EMAIL PROTECTED]');
id | username | attribute | op | value
--------+------------------+-------------------+----+----------------------------------------
104032 | [EMAIL PROTECTED] | Framed-IP-Address | := | 1.2.3.4


When I run radtest:
rad_recv: Access-Accept packet from host 127.0.0.1:1812, id=59, length=56
        Framed-IP-Address = 255.255.255.255
        Service-Type = Framed-User
        Framed-Protocol = PPP
        Framed-Routing = Broadcast-Listen
        Framed-MTU = 1500
        Framed-Compression = Van-Jacobson-TCP-IP

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> :=
Service-Type = Framed-User
Framed-Protocol = PPP
Framed-Routing = Broadcast-Listen
Framed-MTU = 1500
Framed-Compression = Van-Jacobson-TCP-IP
Finished request 0


Any ideas why my data is not making it back?
Thanks
dave


-- Dave Weis [EMAIL PROTECTED] http://www.internetsolver.com/


- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Reply via email to