Dave,
Not sure if I'll be much help on this one, but I'll do my best. In my radgroupreply I have Auth-Type := Local I don't know if that will fix it or not.
Also, I think freeradius had a file sql.conf that had to have stuff uncommented
to get it to record certain info. Yours should be postgresql.conf. You also need to tell
radiusd.conf to use that file if you haven't already.
Have you been down through the radiusd.conf file to uncomment things in there too?
I remember having to read over it and make changes there.
Hope this helps. If I think of anything else I'll let you know.
Nice activation interface.
Also when you get time this today give me a call. I want to get with you on the
DSL lines for us and put together a plan of attack.
SQL result Host: localhost Database: radius Generation Time: May 09, 2005 at 10:02 AM Generated by: phpMyAdmin 2.6.0-pl2 / MySQL 3.23.58 SQL-query: SELECT * FROM `radgroupreply` LIMIT 0, 30; Rows: 8
id GroupName Attribute op Value prio
1 dialin Framed-Compression := Van-Jacobsen-TCP-IP 0
2 dialin Framed-Protocol := PPP 0
3 dialin Service-Type := Framed-User 0
4 dialin Auth-Type := Local 0
5 dialin Framed-MTU := 1500 0
6 dialin Session-Timeout := 14400 0
7 dialin Idle-Timeout := 1200 0
8 dialin Port-Limit := 1 0
________________________________________________________________________________________
----- Original Message ----- From: "Dave Weis" <[EMAIL PROTECTED]>
To: <freeradius-users@lists.freeradius.org>
Sent: Monday, May 09, 2005 6:58 AM
Subject: postgresql problem/question
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
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
