First off, many thanks to Alan and others for their efforts!
I have freeradius working against the md5 passwords in shadow. So I moved
on to the next step of getting it to work in MySQL. I read the man pages,
config files, docs, etc... I also read every single message in the archives
that had 'sql' in the title and went through the page at the following URL
which was most helpful in getting started:
http://www.frontios.com/freeradius.html. Forgive me if I'm just being dense
on this...it's been a long week.
Now on to the problem. The following is a snip from "radiusd -xx -s" and
shows the parameters used in sql.conf with some substitued out for generic
stuff to protect the innocent. The only wierdness here that I can see is
port="" but since it appears to eventually establish the connection, I'm
guessing it really knows what port to use.
_____________ BEGIN SNIP ______________
Module: Loaded SQL
sql: driver = "rlm_sql_mysql"
sql: server = "localhost"
sql: port = ""
sql: login = "root"
sql: password = "youwish"
sql: radius_db = "radius"
sql: acct_table = "radacct"
sql: acct_table2 = "radacct"
sql: authcheck_table = "radcheck"
sql: authreply_table = "radreply"
sql: groupcheck_table = "radgroupcheck"
sql: groupreply_table = "radgroupreply"
sql: usergroup_table = "usergroup"
sql: nas_table = "nas"
sql: dict_table = "dictionary"
sql: sqltrace = yes
sql: sqltracefile = "/var/log/radius/sqltrace.sql"
sql: deletestalesessions = yes
sql: num_sql_socks = 5
sql: sql_user_name = "%{Stripped-User-Name}"
_____________ END SNIP ______________
......
bunch of stuff from other Modules, which all looked OK
......
Now here is a snip from an incoming request after the server has said
"Sleeping until we see a request.":
_____________ BEGIN SNIP ______________
rad_recv: Access-Request packet from host xxx.xxx.xxx.xxx:yyyy, id=34,
length=80
NAS-IP-Address = xxx.xxx.xxx.xxx
NAS-Port = 66
NAS-Port-Type = Virtual
User-Name = "testuser"
Calling-Station-Id = "xxx.xxx.xxx.xxx"
Password = "<normal escaped character sequences, etc...>"
rad_rmspace_pair: User-Name now 'testuser'
rad_rmspace_pair: Password now 'testpass'
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
modcall[authorize]: module "suffix" returns ok
rlm_sql: Reserving sql socket id: 4
radius_xlat: ''
rlm_sql: Released sql socket id: 4
modcall[authorize]: module "sql" returns fail
modcall: group authorize returns fail
There was no response configured: rejecting request 8
Server rejecting request 8.
Sending Access-Reject of id 34 to xxx.xxx.xxx.xxx:yyyy
Finished request 8
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 8 ID 34 with timestamp 3c771525
Nothing to do. Sleeping until we see a request.
______________ END SNIP _______________
So what's the problem? It doesn't look like any SQL queries are getting
executed. The sqltrace.sql file never shows up in the log directory where
it is supposed to be (I'm guessing because it never get's to that point).
It reserves the socket and immediately releases after debug output shows
radius_xlat: ''
All the traces I've seen in other peoples messages have lots of interesting
stuff in them like queries and the like. I've check the db uid, pwd, db
name, and every other parameter I can think of but still nothing.
Also, I've placed into the schema that comes with 0.4 source, some test data
similar to the references in the URL at the top of this section. I've also
manually executed the queries found in sql.conf and they appear to return
the right values (assuming I know what the right values are). I get the
same thing whether I'm using radtest or the actual NAS I'm using. Any
suggestions? Thanks so much for your time and for reading (or at least
scanning) all this!
vec
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
