Modérateur: modos Ixus
<BR> sql: radius_db = "radius"
<BR> sql: acct_table = "radacct"
<BR> sql: acct_table2 = "radacct"
<BR> sql: authcheck_table = "radcheck"
<BR> sql: authreply_table = "radreply"
<BR> sql: groupcheck_table = "radgroupcheck"
<BR> sql: groupreply_table = "radgroupreply"
<BR> sql: usergroup_table = "usergroup"
<BR> sql: nas_table = "nas"
<BR> sql: dict_table = "dictionary"
<BR> sql: sqltrace = no
<BR> sql: sqltracefile = "/usr/local/var/log/radius/sqltrace.sql"
<BR> sql: deletestalesessions = yes
<BR> sql: num_sql_socks = 5
<BR> sql: sql_user_name = "%{Stripped-User-Name:-%{User-Name:-DEFAULT}}"
<BR> sql: default_user_profile = ""
<BR> sql: query_on_not_found = no
<BR> sql: authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id"
<BR> sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value,op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id"
<BR> sql: authorize_group_check_query = "SELECT radgroupcheck.id,radgroupcheck.GroupName,radgroupcheck.Attribute,radgroupcheck.Value,radgroupcheck.op FROM radgroupcheck,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = radgroupcheck.GroupName ORDER BY radgroupcheck.id"
<BR> sql: authorize_group_reply_query = "SELECT radgroupreply.id,radgroupreply.GroupName,radgroupreply.Attribute,radgroupreply.Value,radgroupreply.op FROM radgroupreply,usergroup WHERE usergroup.Username = '%{SQL-User-Name}' AND usergroup.GroupName = radgroupreply.GroupName ORDER BY radgroupreply.id"
<BR> sql: accounting_onoff_query = "UPDATE radacct SET AcctStopTime='%S', AcctSessionTime=unix_timestamp('%S') - unix_timestamp(AcctStartTime), AcctTerminateCause='%{Acct-Terminate-Cause}', AcctStopDelay = %{Acct-Delay-Time} WHERE AcctSessionTime=0 AND AcctStopTime=0 AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'"
<BR> sql: accounting_update_query = "UPDATE radacct SET FramedIPAddress = '%{Framed-IP-Address}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime = 0"
<BR> sql: accounting_start_query = "INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', '%S', '0', '0', '%{Acct-Authentic}', '%{Connect-Info}', '', '0', '0', '%{Called-Station-Id}', '%{Calling-Station-Id}', '', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '%{Acct-Delay-Time}', '0')"
<BR> sql: accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = '%S', AcctStartDelay = '%{Acct-Delay-Time}', ConnectInfo_start = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime = 0"
<BR> sql: accounting_stop_query = "UPDATE radacct SET AcctStopTime = '%S', AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = '%{Acct-Input-Octets}', AcctOutputOctets = '%{Acct-Output-Octets}', AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = '%{Acct-Delay-Time}', ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime = 0"
<BR> sql: accounting_stop_query_alt = "INSERT into radacct (RadAcctId, AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_start, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, AcctStopDelay) values('', '%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', '%{NAS-Port-Type}', DATE_SUB('%S',INTERVAL (%{Acct-Session-Time:-0} + %{Acct-Delay-Time:-0}) SECOND), '%S', '%{Acct-Session-Time}', '%{Acct-Authentic}', '', '%{Connect-Info}', '%{Acct-Input-Octets}', '%{Acct-Output-Octets}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', '0', '%{Acct-Delay-Time}')"
<BR> sql: group_membership_query = "SELECT GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'"
<BR> sql: connect_failure_retry_delay = 60
<BR> sql: simul_count_query = ""
<BR> sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId, UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId, FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime = 0"
<BR>rlm_sql (sql): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and linked
<BR>rlm_sql (sql): Attempting to connect to <!-- BBcode auto-mailto start --><a href="mailto:root@localhost:/radius">root@localhost:/radius</a><!-- BBCode auto-mailto end -->
<BR>rlm_sql (sql): starting 0
<BR>rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
<BR>rlm_sql_mysql: Starting connect to MySQL server for #0
<BR>rlm_sql (sql): Connected new DB handle, #0
<BR>
<BR>
<BR>rad_recv: Access-Request packet from host 192.168.216.205:1645, id=249, length=139
<BR> User-Name = "ODYSSEEerlegiga"
<BR> Framed-MTU = 1400
<BR> Called-Station-Id = "0002.8a42.26b0"
<BR> Calling-Station-Id = "00c0.49a8.e8e8"
<BR> Message-Authenticator = 0x9083baa9aa10a8faf14a6f4a79d5cd45
<BR> EAP-Message = 0x02010015014f4459535345455c65726c6567696761
<BR> NAS-Port-Type = Virtual
<BR> NAS-Port = 509
<BR> NAS-IP-Address = 192.168.216.205
<BR> NAS-Identifier = "ap"
<BR>modcall: entering group authorize for request 0
<BR> modcall[authorize]: module "preprocess" returns ok for request 0
<BR> modcall[authorize]: module "chap" returns noop for request 0
<BR> rlm_eap: EAP packet type notification id 1 length 21
<BR> rlm_eap: EAP Start not found
<BR> modcall[authorize]: module "eap" returns updated for request 0
<BR> rlm_realm: No '@' in User-Name = "ODYSSEEerlegiga", looking up realm NULL
<BR> rlm_realm: No such realm "NULL"
<BR> modcall[authorize]: module "suffix" returns noop for request 0
<BR> users: Matched DEFAULT at 149
<BR> modcall[authorize]: module "files" returns ok for request 0
<BR> rlm_realm: No '@' in User-Name = "ODYSSEEerlegiga", looking up realm NULL
<BR> rlm_realm: No such realm "NULL"
<BR> modcall[authorize]: module "suffix" returns noop for request 0
<BR> users: Matched DEFAULT at 149
<BR> modcall[authorize]: module "files" returns ok for request 0
<BR> modcall[authorize]: module "mschap" returns noop for request 0
<BR>modcall: group authorize returns updated for request 0
<BR> rad_check_password: Found Auth-Type EAP
<BR>auth: type "EAP"
<BR>modcall: entering group authenticate for request 0
<BR> rlm_eap: EAP packet type notification id 1 length 21
<BR> rlm_eap: EAP Start not found
<BR> rlm_eap: EAP Identity
<BR> rlm_eap: processing type md5
<BR>rlm_eap_md5: Issuing Challenge
<BR> modcall[authenticate]: module "eap" returns ok for request 0
<BR>modcall: group authenticate returns ok for request 0
<BR>Sending Access-Challenge of id 249 to 192.168.216.205:1645
<BR> EAP-Message = 0x01020016041018647bc8d4dcb303f84617128828f69f
<BR> Message-Authenticator = 0x00000000000000000000000000000000
<BR> State = 0xdab52f0816ab707ecca3d8fce1af9eb12aaec33f9fb6a2f2ae21c0457c0a16b4609e4afb
<BR>Finished request 0
<BR>Going to the next request
<BR>--- Walking the entire request list ---
<BR>Waking up in 6 seconds...
<BR>rad_recv: Access-Request packet from host 192.168.216.205:1645, id=250, length=178
<BR> User-Name = "ODYSSEEerlegiga"
<BR> Framed-MTU = 1400
<BR> Called-Station-Id = "0002.8a42.26b0"
<BR> Calling-Station-Id = "00c0.49a8.e8e8"
<BR> Message-Authenticator = 0x59e81ba62e6139c0b31f84ecb85197d5
<BR> EAP-Message = 0x020200160410a3be96db63712186fdd7821e84d5ce69
<BR> NAS-Port-Type = Virtual
<BR> NAS-Port = 509
<BR> State = 0xdab52f0816ab707ecca3d8fce1af9eb12aaec33f9fb6a2f2ae21c0457c0a16b4609e4afb
<BR> NAS-IP-Address = 192.168.216.205
<BR> NAS-Identifier = "ap"
<BR>modcall: entering group authorize for request 1
<BR> modcall[authorize]: module "preprocess" returns ok for request 1
<BR> modcall[authorize]: module "chap" returns noop for request 1
<BR> rlm_eap: EAP packet type notification id 2 length 22
<BR> rlm_eap: EAP Start not found
<BR> modcall[authorize]: module "eap" returns updated for request 1
<BR> rlm_realm: No '@' in User-Name = "ODYSSEEerlegiga", looking up realm NULL
<BR> rlm_realm: No such realm "NULL"
<BR> modcall[authorize]: module "suffix" returns noop for request 1
<BR> users: Matched DEFAULT at 149
<BR> modcall[authorize]: module "files" returns ok for request 1
<BR> rlm_realm: No '@' in User-Name = "ODYSSEEerlegiga", looking up realm NULL
<BR> rlm_realm: No such realm "NULL"
<BR> modcall[authorize]: module "suffix" returns noop for request 1
<BR> users: Matched DEFAULT at 149
<BR> modcall[authorize]: module "files" returns ok for request 1
<BR> modcall[authorize]: module "mschap" returns noop for request 1
<BR>modcall: group authorize returns updated for request 1
<BR> rad_check_password: Found Auth-Type EAP
<BR>auth: type "EAP"
<BR>modcall: entering group authenticate for request 1
<BR> rlm_eap: EAP packet type notification id 2 length 22
<BR> rlm_eap: EAP Start not found
<BR> rlm_eap: Request found, released from the list
<BR> rlm_eap: EAP_TYPE - md5
<BR> rlm_eap: processing type md5
<BR>rlm_eap_md5: No password configured for this user
<BR> modcall[authenticate]: module "eap" returns invalid for request 1
<BR>modcall: group authenticate returns invalid for request 1
<BR>auth: Failed to validate the user.
<BR>Delaying request 1 for 1 seconds
<BR>Finished request 1
<BR>Going to the next request
<BR>Waking up in 6 seconds...
<BR>
<BR>
<BR>Help !!!
<BR>
Utilisateur(s) parcourant actuellement ce forum : Aucun utilisateur inscrit et 1 invité