Hi all,
I'm trying to install Freebsd 4.5 with freeradius-0.6 and mysql-3.23.51.
Since I'm new to freeradius, I'm trying my best to follow the
instructions at http://www.frontios.com/freeradius.html &
http://www.y-min.or.jp/~nob/FreeBSD/freeradius-MySQL.html.
My users, sql.conf and radius.conf configuration are below plus when I
try to run radiusd -X and use the ntradping utility, I get the error msg
below.
THANK YOU.
/usr/local/etc/raddb/users
DEFAULT Auth-Type := System
Fall-Through = 1
--------------------------------------------
/usr/local/etc/raddb/sql.conf
sql {
# Database type
# Current supported are: rlm_sql_mysql, rlm_sql_postgresql,
# rlm_sql_iodbc, rlm_sql_oracle, rlm_sql_unixodbc,
rlm_sql_freetds
driver = "rlm_sql_mysql"
# Connect info
server = "localhost"
login = "root"
password = "welcome"
# Database table configuration
radius_db = "radius"
-------------------------------------------
/usr/local/etc/raddb/radiusd.conf
authenticate {
# pam
unix
# sql
# radutmp
mschap
}
IF I UNCOMMENT SQL AND I RUN RADIUD -X I GET THE ERROR "radiusd.conf:
"SQL" modules aren't allowed in 'authenticate' sections -- they
have no such method."
rlm_sql: Attempting to connect to root@localhost:/radius
rlm_sql: Connected new DB handle, #0
rlm_sql: Connected new DB handle, #1
rlm_sql: Connected new DB handle, #2
rlm_sql: Connected new DB handle, #3
rlm_sql: Connected new DB handle, #4
Module: Instantiated sql (sql)
Module: Loaded files
files: usersfile = "/usr/local/etc/raddb/users"
files: acctusersfile = "/usr/local/etc/raddb/acct_users"
files: compat = "no"
Module: Instantiated files (files)
Module: Loaded realm
realm: format = "suffix"
realm: delimiter = "@"
Module: Instantiated realm (suffix)
Module: Loaded radutmp
radutmp: filename = "/usr/local/var/log/radius/radutmp"
radutmp: username = "%{User-Name}"
radutmp: perm = 384
radutmp: callerid = yes
Module: Instantiated radutmp (radutmp)
Listening on IP address *, ports 1645/udp and 1646/udp, with proxy on
1647/udp.
Ready to process requests.
rad_recv: Access-Request packet from host 192.168.3.4:1131, id=28,
length=45
User-Name = "mbaki"
User-Password = "8|M\232N\244\333\005\305=,%"p\013r"
modcall: entering group authorize
modcall[authorize]: module "preprocess" returns ok
radius_xlat: 'mbaki'
sql_set_user: escaped user --> 'mbaki'
radius_xlat: 'SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE
Username = 'mbaki' ORDER BY id'
rlm_sql: Reserving sql socket id: 4
rlm_sql: User mbaki not found
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.
Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'mbaki' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.
Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'mbaki' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
sql_set_user: escaped user --> 'DEFAULT'
radius_xlat: 'SELECT
radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.
Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE
usergroup.Username = 'DEFAULT' AND usergroup.GroupName =
radgroupcheck.GroupName ORDER BY radgroupcheck.id'
radius_xlat: 'SELECT
radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.
Value,radgroupreply.op FROM radgroupreply,usergroup WHERE
usergroup.Username = 'DEFAULT' AND usergroup.GroupName =
radgroupreply.GroupName ORDER BY radgroupreply.id'
rlm_sql: DEFAULT not found
rlm_sql: Released sql socket id: 4
modcall[authorize]: module "sql" returns notfound
users: Matched DEFAULT at 152
modcall[authorize]: module "files" returns ok
modcall[authorize]: module "mschap" returns notfound
modcall: group authorize returns ok
rad_check_password: Found Auth-Type System
auth: type "System"
modcall: entering group authenticate
HASH: user mbaki found in hashtable bucket 79206
modcall[authenticate]: module "unix" returns reject
modcall: group authenticate returns reject
auth: Failed to validate the user.
WARNING: Unprintable characters in the password. ? Double-check the
shared secret on the server and the NAS!
Delaying request 0 for 1 seconds
Finished request 0
Going to the next request
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Waking up in 1 seconds...
--- Walking the entire request list ---
Sending Access-Reject of id 28 to 192.168.3.4:1131
Waking up in 4 seconds...
--- Walking the entire request list ---
Cleaning up request 0 ID 28 with timestamp 3d404a5f
Nothing to do. Sleeping until we see a request.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
