Hi Andrew/list, Sorry I do not have a response to your question, I am developing something very similar to your system.
I was wondering if you would mind me asking you questions when I get stuck. This is my first SQL/RADIUS project and I was hoping to get some direction from this list. I need to develop a hotspot management system for wifipod (my new employer) so that we can authenticate and bill users. We were looking at FUNK SBR but we would obviously prefer to save money and do it in-house. We want to use Colubris CN3000s at the hotspot locations and use the "white pages" as web-portals to get the user info to our MySQL database at our HQ. This can then be authenticated using RADIUS. It is the initial stage of the project so we are looking at feasibility and timelines right now. How long do you think it would take me to do assuming I can create decent tables and I am new to FreeRADIUS development? All the best, Rob ==================== [EMAIL PROTECTED] www.wifipod.com NuBlu Technologies Gostin Building 32/36 Hanover St Liverpool, UK L1 4LN T: +44 151 705 2074 ==================== > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Andrew Staples > I'm trying to configure a backup radius server (the first one > is working > well). I've pretty much duplicated the first working > system, but having > problems with dialup_admin. > > Although there are users/groups in the mysql db, dialup_admin > can't find/display them. Adding new users via dialup_admin > fails, as they are not written to the database. > > Other things fail, such as "check server"...I get a user test > page, instead of radcheck. > > I've tried using the root user in admin.conf, but that didn't > fix the problem. > > I believe radius and rlm_sql are fine; result of radtest: > > Sending Access-Request of id 253 to 127.0.0.1:1812 > User-Name = "fred" > User-Password = "\001\37o\327$\n\344\202\261\t\374\313\277a7" > NAS-IP-Address = radius2.nwnetcom.com > NAS-Port = 1812 > rad_recv: Access-Accept packet from host 127.0.0.1:1812, > id=253, length=44 > Framed-Compression = Van-Jacobson-TCP-IP > Framed-Protocol = PPP > Service-Type = Framed-User > Framed-MTU = 1500 > > I've enabled sqltrace in sql.conf, but I can't locate that > file, so it probably isn't being written. > > Can anyone point me in the right direction? Is this a > permissions thing on the dialup_admin directory? > > Thanks, > Andrew > > > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
