Hi all,
My goal is to use Freeradius with the sql module for authenticating users. I'm using version 0.9.2 (installed from rpms i created with the specfile that came with the tarball). There doesn't seem to be a wealth of information available for using the sql module, but I've been working off of this tutorial: http://www.frontios.com/freeradius.html I got everything working using /etc/shadow to authenticate users, but then I proceeded to follow the instructions for sql and have run in to some trouble. I followed all of the required steps and am unable to authenticate. I'm using the following command to test the server: radtest robtest test localhost 0 testing123 and i get the following result: Sending Access-Request of id 170 to 127.0.0.1:1812 User-Name = "robtest" User-Password = "test" NAS-IP-Address = radius.mydomain.com (changed the domain) NAS-Port = 0 rad_recv: Access-Reject packet from host 127.0.0.1:1812, id=170, length=20 Here is a snippet of the output produced when i run in debug mode: rad_recv: Access-Request packet from host 127.0.0.1:32819, id=170, length=59 User-Name = "robtest" User-Password = "test" NAS-IP-Address = 255.255.255.255 NAS-Port = 0 modcall: entering group authorize for request 0 modcall[authorize]: module "preprocess" returns ok for request 0 radius_xlat: '' modcall[authorize]: module "sql" returns fail for request 0 modcall: group authorize returns fail for request 0 There was no response configured: rejecting request 0 Server rejecting request 0. And here's the only entry in my radcheck table: +----+----------+-----------+----+-------+ | id | UserName | Attribute | op | Value | +----+----------+-----------+----+-------+ | 1 | robtest | Password | == | test | +----+----------+-----------+----+-------+ Debug mode doesn't seem to provide very verbose output when it comes time to call the sql module. I turned on sqltrace in my sql module configuration file, but no queries are showing up. I even turned on query logging on my MySQL server and none show up, which means it's not even getting to the part where it tries to find a matching user in the radcheck table. What could be preventing it from getting it that far? Any suggestions would be greatly appreciated. I've been working on this for several days now and haven't made much progress. I hope I've done enough footwork on my own to keep away the flames :) Thanks in advance, Rob - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
