| 发表于：2007-08-28 17:45:35 楼主 |
freeradius+mysql 的问题，谢谢
平台：red hat 5
配置好freeradius, mysql后，启动radius，然后
radtest radiusdemoclient 123456 localhost 0 test123（数据库中已经导入数据）
radius server 端出现错误信息，并没有任何response:
[root@localhost radius]# radiusd -x
starting - reading configuration files ...
reread_config: reading radiusd.conf
config: including file: /etc/raddb/proxy.conf
config: including file: /etc/raddb/clients.conf
config: including file: /etc/raddb/snmp.conf
config: including file: /etc/raddb/eap.conf
config: including file: /etc/raddb/sql.conf
。。。。。。。。。。。。。。。。。。
module: loaded realm
realm: format = "suffix "
realm: delimiter = "@ "
realm: ignore_default = no
realm: ignore_null = no
module: instantiated realm （suffix)
module: loaded sql
sql: driver = "rlm_sql_mysql "
sql: server = "localhost "
sql: port = " "
sql: login = "root "
sql: password = "soma "
sql: radius_db = "radius "
sql: nas_table = "nas "
sql: sqltrace = yes
sql: sqltracefile = "/var/log/radius/sqltrace.sql "
sql: readclients = no
sql: deletestalesessions = no
sql: num_sql_socks = 5
sql: sql_user_name = " "
sql: default_user_profile = " "
sql: query_on_not_found = no
sql: authorize_check_query = " "
sql: authorize_reply_query = " "
sql: authorize_group_check_query = " "
sql: authorize_group_reply_query = " "
sql: accounting_onoff_query = " "
sql: accounting_update_query = " "
sql: accounting_update_query_alt = " "
sql: accounting_start_query = " "
sql: accounting_start_query_alt = " "
sql: accounting_stop_query = " "
sql: accounting_stop_query_alt = " "
sql: group_membership_query = " "
sql: connect_failure_retry_delay = 60
sql: simul_count_query = " "
sql: simul_verify_query = " "
sql: postauth_query = " "
sql: safe-characters = "@abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz01 23456789.-_: / "
rlm_sql （sql): driver rlm_sql_mysql （module rlm_sql_mysql) loaded and linked
rlm_sql （sql): attempting to connect to root@localhost:/radius
rlm_sql （sql): starting 0
rlm_sql （sql): attempting to connect rlm_sql_mysql #0
rlm_sql_mysql: starting connect to mysql server for #0
rlm_sql （sql): connected new db handle, #0
rlm_sql （sql): starting 1
rlm_sql （sql): attempting to connect rlm_sql_mysql #1
rlm_sql_mysql: starting connect to mysql server for #1
rlm_sql （sql): connected new db handle, #1
rlm_sql （sql): starting 2
rlm_sql （sql): attempting to connect rlm_sql_mysql #2
rlm_sql_mysql: starting connect to mysql server for #2
rlm_sql （sql): connected new db handle, #2
rlm_sql （sql): starting 3
rlm_sql （sql): attempting to connect rlm_sql_mysql #3
rlm_sql_mysql: starting connect to mysql server for #3
rlm_sql （sql): connected new db handle, #3
rlm_sql （sql): starting 4
rlm_sql （sql): attempting to connect rlm_sql_mysql #4
rlm_sql_mysql: starting connect to mysql server for #4
rlm_sql （sql): connected new db handle, #4
module: instantiated sql （sql)
module: loaded acct-unique-session-id
acct_unique: key = "user-name, acct-session-id, nas-ip-address, client-ip-addre ss, nas-port "
module: instantiated acct_unique （acct_unique)
module: loaded detail
detail: detailfile = "/var/log/radius/radacct/%{client-ip-address}/detail-%y%m% d "
detail: detailperm = 384
detail: dirperm = 493
detail: locking = no
module: instantiated detail （detail)
module: loaded system
unix: cache = no
unix: passwd = "（null) "
unix: shadow = "/etc/shadow "
unix: group = "（null) "
unix: radwtmp = "/var/log/radius/radwtmp "
unix: usegroup = no
unix: cache_reload = 600
module: instantiated unix （unix)
module: loaded radutmp
radutmp: filename = "/var/log/radius/radutmp "
radutmp: username = "%{user-name} "
radutmp: case_sensitive = yes
radutmp: check_with_nas = yes
radutmp: perm = 384
radutmp: callerid = yes
module: instantiated radutmp （radutmp)
module: loaded eap
eap: default_eap_type = "md5 "
eap: timer_expire = 60
eap: ignore_unknown_eap_types = no
eap: cisco_accounting_username_bug = no
rlm_eap: loaded and initialized type md5
rlm_eap: loaded and initialized type leap
gtc: challenge = "password: "
gtc: auth_type = "pap "
rlm_eap: loaded and initialized type gtc
mschapv2: with_ntdomain_hack = no
rlm_eap: loaded and initialized type mschapv2
module: instantiated eap （eap)
listening on authentication *:1812
listening on accounting *:1813
ready to process requests.
rad_recv: access-request packet from host 127.0.0.1:32770, id=244, length=68
user-name = "radiusdemoclient "
user-password = "wu\023\342pp\312\203\251\232\304j\244\321\213\211 "
nas-ip-address = 255.255.255.255
nas-port = 0
processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall[authorize]: module "preprocess " returns ok for request 0
modcall[authorize]: module "chap " returns noop for request 0
modcall[authorize]: module "mschap " returns noop for request 0
rlm_realm: no '@ ' in user-name = "radiusdemoclient ", looking up realm null
rlm_realm: no such realm "null "
modcall[authorize]: module "suffix " returns noop for request 0
radius_xlat: ' '
rlm_sql （sql): reserving sql socket id: 4
rlm_sql （sql): sql query error; rejecting user
rlm_sql （sql): released sql socket id: 4
modcall[authorize]: module "sql " returns fail for request 0
modcall: leaving group authorize （returns fail) for request 0
finished request 0
going to the next request
--- walking the entire request list ---
waking up in 6 seconds...
rad_recv: access-request packet from host 127.0.0.1:32770, id=244, length=68
discarding duplicate request from client localhost:32770 - id: 244
--- walking the entire request list ---
waking up in 3 seconds...
--- walking the entire request list ---
cleaning up request 0 id 244 with timestamp 46d3daf7
nothing to do. sleeping until we see a request.
不知道问题出在那里，谢谢回帖 |
|
|
|
|
