I am sorry to post but I am just not getting something right here.
I have been running this freeradius server for quite some time with no
problems. I have just now decided that I want to solve the
Simultaneous-Use problem. I am using 1.0.2 and a mysql database located
on another server. I have followed everything that I can find on the net
about the configuration but I can still logon the same user as many
times as I want. It may help to know that the radius server is only
being used by a website script for login (chillispot).
For my needs I am not setting up any groups or anything special in the
database. I am basically only dealing with the radcheck table. This is
the only table that has the usernames and passwords. All the other
tables seem not to be needed for what I am doing. I am open to suggetion
of course if I need to add entries into any other table to make
simultaneous-use work.
here are my conf files
sql.conf
----------------------------
sql_user_name = "%{User-Name}"
simul_count_query = "SELECT COUNT(*) FROM ${acct_table1} WHERE
UserName='%{SQL-User-Name}' AND AcctSessionTime = 0"
simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName,
NASIPAddress, NASPortId, FramedIPAddress, CallingStationId,
FramedProtocol FROM ${acct_table1} WHERE UserName='%{SQL-User-Name}' AND
AcctStopTime = 0"
group_membership_query = "SELECT GroupName FROM ${usergroup_table} WHERE
UserName='%{SQL-User-Name}'"
postauth_query = "INSERT into ${postauth_table} (id, user, pass, reply,
date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"
radiusd.conf
-------------------------------
instantiate {
exec
expr
}
authorize {
preprocess
chap
mschap
suffix
sql
}
authenticate {
Auth-Type PAP {
pap
}
Auth-Type CHAP {
chap
}
Auth-Type MS-CHAP {
mschap
}
}
preacct {
preprocess
suffix
}
accounting {
acct_unique
detail
unix
sql
radutmp
}
session {
radutmp
}
post-auth {
}
pre-proxy {
}
post-proxy {
eap
}
any suggestions?
thanks
-Blake
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html