freeradius+mysql 718錯誤
調試信息
rad_recv: Access-Request packet from host 127.0.0.1:45951, id=170, length=89
Service-Type = Framed-User
Framed-Protocol = PPP
User-Name = "cnbird"
CHAP-Challenge = 0x6d439ff6c16fadef1d29659cc7972686
CHAP-Password = 0xa485b676fc3b180f7fb6ab6c6f72957ceb
NAS-IP-Address = 10.2.26.82
NAS-Port = 0
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 0
modcall: module "preprocess" returns ok for request 0
rlm_chap: Setting 'Auth-Type := CHAP'
modcall: module "chap" returns ok for request 0
modcall: module "mschap" returns noop for request 0
rlm_realm: No '@' in User-Name = "cnbird", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall: module "suffix" returns noop for request 0
rlm_eap: No EAP-Message, not doing EAP
modcall: module "eap" returns noop for request 0
users: Matched entry DEFAULT at line 152
users: Matched entry DEFAULT at line 171
users: Matched entry DEFAULT at line 183
modcall: module "files" returns ok for request 0
radius_xlat: 'cnbird'
rlm_sql (sql): sql_set_user escaped user --> 'cnbird'
radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'cnbird' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 4
rlm_sql: Failed to create the pair: Unknown attribute "Cleartext-Password"
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 4
modcall: 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...
--- Walking the entire request list ---
Cleaning up request 0 ID 170 with timestamp 4d87281b
Nothing to do. Sleeping until we see a request.
rad_recv: Access-Request packet from host 127.0.0.1:45951, id=170, length=89
Service-Type = Framed-User
Framed-Protocol = PPP
User-Name = "cnbird"
CHAP-Challenge = 0x6d439ff6c16fadef1d29659cc7972686
CHAP-Password = 0xa485b676fc3b180f7fb6ab6c6f72957ceb
NAS-IP-Address = 10.2.26.82
NAS-Port = 0
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 1
modcall: module "preprocess" returns ok for request 1
rlm_chap: Setting 'Auth-Type := CHAP'
modcall: module "chap" returns ok for request 1
modcall: module "mschap" returns noop for request 1
rlm_realm: No '@' in User-Name = "cnbird", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall: module "suffix" returns noop for request 1
rlm_eap: No EAP-Message, not doing EAP
modcall: module "eap" returns noop for request 1
users: Matched entry DEFAULT at line 152
users: Matched entry DEFAULT at line 171
users: Matched entry DEFAULT at line 183
modcall: module "files" returns ok for request 1
radius_xlat: 'cnbird'
rlm_sql (sql): sql_set_user escaped user --> 'cnbird'
radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'cnbird' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 3
rlm_sql: Failed to create the pair: Unknown attribute "Cleartext-Password"
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 3
modcall: module "sql" returns fail for request 1
modcall: leaving group authorize (returns fail) for request 1
Finished request 1
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 1 ID 170 with timestamp 4d872825
Nothing to do. Sleeping until we see a request.
rad_recv: Access-Request packet from host 127.0.0.1:45951, id=170, length=89
Service-Type = Framed-User
Framed-Protocol = PPP
User-Name = "cnbird"
CHAP-Challenge = 0x6d439ff6c16fadef1d29659cc7972686
CHAP-Password = 0xa485b676fc3b180f7fb6ab6c6f72957ceb
NAS-IP-Address = 10.2.26.82
NAS-Port = 0
Processing the authorize section of radiusd.conf
modcall: entering group authorize for request 2
modcall: module "preprocess" returns ok for request 2
rlm_chap: Setting 'Auth-Type := CHAP'
modcall: module "chap" returns ok for request 2
modcall: module "mschap" returns noop for request 2
rlm_realm: No '@' in User-Name = "cnbird", looking up realm NULL
rlm_realm: No such realm "NULL"
modcall: module "suffix" returns noop for request 2
rlm_eap: No EAP-Message, not doing EAP
modcall: module "eap" returns noop for request 2
users: Matched entry DEFAULT at line 152
users: Matched entry DEFAULT at line 171
users: Matched entry DEFAULT at line 183
modcall: module "files" returns ok for request 2
radius_xlat: 'cnbird'
rlm_sql (sql): sql_set_user escaped user --> 'cnbird'
radius_xlat: 'SELECT id, UserName, Attribute, Value, op FROM radcheck WHERE Username = 'cnbird' ORDER BY id'
rlm_sql (sql): Reserving sql socket id: 2
rlm_sql: Failed to create the pair: Unknown attribute "Cleartext-Password"
rlm_sql (sql): Error getting data from database
rlm_sql (sql): SQL query error; rejecting user
rlm_sql (sql): Released sql socket id: 2
modcall: module "sql" returns fail for request 2
modcall: leaving group authorize (returns fail) for request 2
Finished request 2
Going to the next request
--- Walking the entire request list ---
Waking up in 6 seconds...
--- Walking the entire request list ---
Cleaning up request 2 ID 170 with timestamp 4d87282f
Nothing to do. Sleeping until we see a request.
《解決方案》
這裡不是寫的很清楚嗎?
lm_sql: Failed to create the pair: Unknown attribute "Cleartext-Password"