<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Here is my radiusd -X <br>
<br>
Starting - reading configuration files ...<br>
reread_config: reading radiusd.conf<br>
Config: including file: /etc/raddb/proxy.conf<br>
Config: including file: /etc/raddb/clients.conf<br>
Config: including file: /etc/raddb/snmp.conf<br>
Config: including file: /etc/raddb/eap.conf<br>
Config: including file: /etc/raddb/sql.conf<br>
main: prefix = "/usr"<br>
main: localstatedir = "/var"<br>
main: logdir = "/var/log/radius"<br>
main: libdir = "/usr/lib"<br>
main: radacctdir = "/var/log/radius/radacct"<br>
main: hostname_lookups = no<br>
main: max_request_time = 30<br>
main: cleanup_delay = 5<br>
main: max_requests = 1024<br>
main: delete_blocked_requests = 0<br>
main: port = 0<br>
main: allow_core_dumps = no<br>
main: log_stripped_names = no<br>
main: log_file = "/var/log/radius/radius.log"<br>
main: log_auth = yes<br>
main: log_auth_badpass = no<br>
main: log_auth_goodpass = no<br>
main: pidfile = "/var/run/radiusd/radiusd.pid"<br>
main: user = "radiusd"<br>
main: group = "radiusd"<br>
main: usercollide = no<br>
main: lower_user = "no"<br>
main: lower_pass = "no"<br>
main: nospace_user = "no"<br>
main: nospace_pass = "no"<br>
main: checkrad = "/usr/sbin/checkrad"<br>
main: proxy_requests = yes<br>
proxy: retry_delay = 5<br>
proxy: retry_count = 3<br>
proxy: synchronous = no<br>
proxy: default_fallback = yes<br>
proxy: dead_time = 120<br>
proxy: post_proxy_authorize = yes<br>
proxy: wake_all_if_all_dead = no<br>
security: max_attributes = 200<br>
security: reject_delay = 1<br>
security: status_server = no<br>
main: debug_level = 0<br>
read_config_files: reading dictionary<br>
read_config_files: reading naslist<br>
Using deprecated naslist file. Support for this will go away soon.<br>
read_config_files: reading clients<br>
read_config_files: reading realms<br>
radiusd: entering modules setup<br>
Module: Library search path is /usr/lib<br>
Module: Loaded exec <br>
exec: wait = yes<br>
exec: program = "(null)"<br>
exec: input_pairs = "request"<br>
exec: output_pairs = "(null)"<br>
exec: packet_type = "(null)"<br>
rlm_exec: Wait=yes but no output defined. Did you mean output=none?<br>
Module: Instantiated exec (exec) <br>
Module: Loaded expr <br>
Module: Instantiated expr (expr) <br>
Module: Loaded PAP <br>
pap: encryption_scheme = "clear"<br>
Module: Instantiated pap (pap) <br>
Module: Loaded CHAP <br>
Module: Instantiated chap (chap) <br>
Module: Loaded MS-CHAP <br>
mschap: use_mppe = yes<br>
mschap: require_encryption = no<br>
mschap: require_strong = no<br>
mschap: with_ntdomain_hack = no<br>
mschap: passwd = "(null)"<br>
mschap: authtype = "MS-CHAP"<br>
mschap: ntlm_auth = "(null)"<br>
Module: Instantiated mschap (mschap) <br>
Module: Loaded System <br>
unix: cache = no<br>
unix: passwd = "(null)"<br>
unix: shadow = "/etc/shadow"<br>
unix: group = "(null)"<br>
unix: radwtmp = "/var/log/radius/radwtmp"<br>
unix: usegroup = no<br>
unix: cache_reload = 600<br>
Module: Instantiated unix (unix) <br>
Module: Loaded LDAP <br>
ldap: server = "localhost"<br>
ldap: port = 389<br>
ldap: net_timeout = 1<br>
ldap: timeout = 4<br>
ldap: timelimit = 3<br>
ldap: identity = "cn=Manager,dc=."<br>
ldap: tls_mode = no<br>
ldap: start_tls = no<br>
ldap: tls_cacertfile = "(null)"<br>
ldap: tls_cacertdir = "(null)"<br>
ldap: tls_certfile = "(null)"<br>
ldap: tls_keyfile = "(null)"<br>
ldap: tls_randfile = "(null)"<br>
ldap: tls_require_cert = "allow"<br>
ldap: password = "oceld@p"<br>
ldap: basedn = "dc=ocesb,dc=com,dc=my,dc=."<br>
ldap: filter = "(uid=%{Stripped-User-Name:-%{User-Name}})"<br>
ldap: base_filter = "(objectclass=radiusprofile)"<br>
ldap: default_profile = "(null)"<br>
ldap: profile_attribute = "(null)"<br>
ldap: password_header = "(null)"<br>
ldap: password_attribute = "userPassword"<br>
ldap: access_attr = "dialupAccess"<br>
ldap: groupname_attribute = "cn"<br>
ldap: groupmembership_filter =
"(|(&(objectClass=GroupOfNames)(member=%{Ldap-UserDn}))(&(objectClass=GroupOfUniqueNames)(uniquemember=%{Ldap-UserDn})))"<br>
ldap: groupmembership_attribute = "(null)"<br>
ldap: dictionary_mapping = "/etc/raddb/ldap.attrmap"<br>
ldap: ldap_debug = 0<br>
ldap: ldap_connections_number = 5<br>
ldap: compare_check_items = no<br>
ldap: access_attr_used_for_allow = yes<br>
ldap: do_xlat = yes<br>
rlm_ldap: Registering ldap_groupcmp for Ldap-Group<br>
rlm_ldap: Creating new attribute ldap_1x-Ldap-Group<br>
rlm_ldap: Registering ldap_groupcmp for ldap_1x-Ldap-Group<br>
rlm_ldap: Registering ldap_xlat with xlat_name ldap_1x<br>
rlm_ldap: reading ldap<->radius mappings from file
/etc/raddb/ldap.attrmap<br>
rlm_ldap: LDAP radiusCheckItem mapped to RADIUS $GENERIC$<br>
rlm_ldap: LDAP radiusReplyItem mapped to RADIUS $GENERIC$<br>
rlm_ldap: LDAP radiusAuthType mapped to RADIUS Auth-Type<br>
rlm_ldap: LDAP radiusSimultaneousUse mapped to RADIUS Simultaneous-Use<br>
rlm_ldap: LDAP radiusCalledStationId mapped to RADIUS Called-Station-Id<br>
rlm_ldap: LDAP radiusCallingStationId mapped to RADIUS
Calling-Station-Id<br>
rlm_ldap: LDAP sambaLMPassword mapped to RADIUS LM-Password<br>
rlm_ldap: LDAP sambaNTPassword mapped to RADIUS NT-Password<br>
rlm_ldap: LDAP sambaAcctFlags mapped to RADIUS SMB-Account-CTRL-TEXT<br>
rlm_ldap: LDAP radiusExpiration mapped to RADIUS Expiration<br>
rlm_ldap: LDAP userPassword mapped to RADIUS User-Password<br>
rlm_ldap: LDAP radiusTunnelType mapped to RADIUS Tunnel-Type<br>
rlm_ldap: LDAP radiusTunnelMediumType mapped to RADIUS
Tunnel-Medium-Type<br>
rlm_ldap: LDAP radiusTunnelPrivateGroupId mapped to RADIUS
Tunnel-Private-Group-Id<br>
rlm_ldap: LDAP radiusServiceType mapped to RADIUS Service-Type<br>
rlm_ldap: LDAP radiusFramedProtocol mapped to RADIUS Framed-Protocol<br>
rlm_ldap: LDAP radiusFramedIPAddress mapped to RADIUS Framed-IP-Address<br>
rlm_ldap: LDAP radiusFramedIPNetmask mapped to RADIUS Framed-IP-Netmask<br>
rlm_ldap: LDAP radiusFramedRoute mapped to RADIUS Framed-Route<br>
rlm_ldap: LDAP radiusFramedRouting mapped to RADIUS Framed-Routing<br>
rlm_ldap: LDAP radiusFilterId mapped to RADIUS Filter-Id<br>
rlm_ldap: LDAP radiusFramedMTU mapped to RADIUS Framed-MTU<br>
rlm_ldap: LDAP radiusFramedCompression mapped to RADIUS
Framed-Compression<br>
rlm_ldap: LDAP radiusLoginIPHost mapped to RADIUS Login-IP-Host<br>
rlm_ldap: LDAP radiusLoginService mapped to RADIUS Login-Service<br>
rlm_ldap: LDAP radiusLoginTCPPort mapped to RADIUS Login-TCP-Port<br>
rlm_ldap: LDAP radiusCallbackNumber mapped to RADIUS Callback-Number<br>
rlm_ldap: LDAP radiusCallbackId mapped to RADIUS Callback-Id<br>
rlm_ldap: LDAP radiusFramedIPXNetwork mapped to RADIUS
Framed-IPX-Network<br>
rlm_ldap: LDAP radiusClass mapped to RADIUS Class<br>
rlm_ldap: LDAP radiusSessionTimeout mapped to RADIUS Session-Timeout<br>
rlm_ldap: LDAP radiusIdleTimeout mapped to RADIUS Idle-Timeout<br>
rlm_ldap: LDAP radiusTerminationAction mapped to RADIUS
Termination-Action<br>
rlm_ldap: LDAP radiusLoginLATService mapped to RADIUS Login-LAT-Service<br>
rlm_ldap: LDAP radiusLoginLATNode mapped to RADIUS Login-LAT-Node<br>
rlm_ldap: LDAP radiusLoginLATGroup mapped to RADIUS Login-LAT-Group<br>
rlm_ldap: LDAP radiusFramedAppleTalkLink mapped to RADIUS
Framed-AppleTalk-Link<br>
rlm_ldap: LDAP radiusFramedAppleTalkNetwork mapped to RADIUS
Framed-AppleTalk-Network<br>
rlm_ldap: LDAP radiusFramedAppleTalkZone mapped to RADIUS
Framed-AppleTalk-Zone<br>
rlm_ldap: LDAP radiusPortLimit mapped to RADIUS Port-Limit<br>
rlm_ldap: LDAP radiusLoginLATPort mapped to RADIUS Login-LAT-Port<br>
conns: 0x947bb18<br>
Module: Instantiated ldap (ldap_1x) <br>
Module: Loaded eap <br>
eap: default_eap_type = "ttls"<br>
eap: timer_expire = 60<br>
eap: ignore_unknown_eap_types = no<br>
eap: cisco_accounting_username_bug = no<br>
rlm_eap: Loaded and initialized type md5<br>
rlm_eap: Loaded and initialized type leap<br>
gtc: challenge = "Password: "<br>
gtc: auth_type = "PAP"<br>
rlm_eap: Loaded and initialized type gtc<br>
tls: rsa_key_exchange = no<br>
tls: dh_key_exchange = yes<br>
tls: rsa_key_length = 512<br>
tls: dh_key_length = 512<br>
tls: verify_depth = 0<br>
tls: CA_path = "(null)"<br>
tls: pem_file_type = yes<br>
tls: private_key_file = "/etc/raddb/certs/cert-srv.pem"<br>
tls: certificate_file = "/etc/raddb/certs/cert-srv.pem"<br>
tls: CA_file = "/etc/raddb/certs/demoCA/cacert.pem"<br>
tls: private_key_password = "whatever"<br>
tls: dh_file = "/etc/raddb/certs/dh"<br>
tls: random_file = "/etc/raddb/certs/random"<br>
tls: fragment_size = 1024<br>
tls: include_length = yes<br>
tls: check_crl = no<br>
tls: check_cert_cn = "(null)"<br>
rlm_eap: Loaded and initialized type tls<br>
ttls: default_eap_type = "gtc"<br>
ttls: copy_request_to_tunnel = yes<br>
ttls: use_tunneled_reply = yes<br>
rlm_eap: Loaded and initialized type ttls<br>
mschapv2: with_ntdomain_hack = no<br>
rlm_eap: Loaded and initialized type mschapv2<br>
Module: Instantiated eap (eap) <br>
Module: Loaded preprocess <br>
preprocess: huntgroups = "/etc/raddb/huntgroups"<br>
preprocess: hints = "/etc/raddb/hints"<br>
preprocess: with_ascend_hack = no<br>
preprocess: ascend_channels_per_line = 23<br>
preprocess: with_ntdomain_hack = no<br>
preprocess: with_specialix_jetstream_hack = no<br>
preprocess: with_cisco_vsa_hack = no<br>
Module: Instantiated preprocess (preprocess) <br>
Module: Loaded realm <br>
realm: format = "suffix"<br>
realm: delimiter = "@"<br>
realm: ignore_default = no<br>
realm: ignore_null = no<br>
Module: Instantiated realm (suffix) <br>
Module: Loaded files <br>
files: usersfile = "/etc/raddb/users"<br>
files: acctusersfile = "/etc/raddb/acct_users"<br>
files: preproxy_usersfile = "/etc/raddb/preproxy_users"<br>
files: compat = "no"<br>
Module: Instantiated files (files) <br>
Module: Loaded Acct-Unique-Session-Id <br>
acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address,
Client-IP-Address, NAS-Port"<br>
Module: Instantiated acct_unique (acct_unique) <br>
Module: Loaded detail <br>
detail: detailfile =
"/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"<br>
detail: detailperm = 384<br>
detail: dirperm = 493<br>
detail: locking = no<br>
Module: Instantiated detail (detail) <br>
Module: Loaded radutmp <br>
radutmp: filename = "/var/log/radius/radutmp"<br>
radutmp: username = "%{User-Name}"<br>
radutmp: case_sensitive = yes<br>
radutmp: check_with_nas = yes<br>
radutmp: perm = 384<br>
radutmp: callerid = yes<br>
Module: Instantiated radutmp (radutmp) <br>
Module: Loaded SQL <br>
sql: driver = "rlm_sql_mysql"<br>
sql: server = "localhost"<br>
sql: port = ""<br>
sql: login = "root"<br>
sql: password = "mysql@dmin"<br>
sql: radius_db = "bkradius"<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 = "/var/log/radius/sqltrace.sql"<br>
sql: readclients = no<br>
sql: deletestalesessions = yes<br>
sql: num_sql_socks = 5<br>
sql: sql_user_name = "%{User-Name}"<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}', ? AcctSessionTime = '%{Acct-Session-Time}', ?
AcctInputOctets = '%{Acct-Input-Octets}', ? AcctOutputOctets =
'%{Acct-Output-Octets}' ? WHERE AcctSessionId = '%{Acct-Session-Id}' ?
AND UserName = '%{SQL-User-Name}' ? AND NASIPAddress=
'%{NAS-IP-Address}'"<br>
sql: accounting_update_query_alt = "INSERT into radacct
(AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId,
CallingStationId, ServiceType, FramedProtocol, FramedIPAddress,
AcctStartDelay) 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), '%{Acct-Session-Time}',
'%{Acct-Authentic}', '', '%{Acct-Input-Octets}',
'%{Acct-Output-Octets}', '%{Called-Station-Id}',
'%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}',
'%{Framed-IP-Address}', '0')"<br>
sql: accounting_start_query = "INSERT into radacct (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}'"<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}'"<br>
sql: accounting_stop_query_alt = "INSERT into radacct (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 = "SELECT COUNT(*) FROM radacct WHERE
UserName='%{SQL-User-Name}' AND AcctStopTime = 0"<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>
sql: postauth_table = "radpostauth"<br>
sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply,
date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"<br>
sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<br>
rlm_sql (sql1): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked<br>
rlm_sql (sql1): Attempting to connect to root@localhost:/bkradius<br>
rlm_sql (sql1): starting 0<br>
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #0<br>
rlm_sql_mysql: Starting connect to MySQL server for #0<br>
rlm_sql (sql1): Connected new DB handle, #0<br>
rlm_sql (sql1): starting 1<br>
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #1<br>
rlm_sql_mysql: Starting connect to MySQL server for #1<br>
rlm_sql (sql1): Connected new DB handle, #1<br>
rlm_sql (sql1): starting 2<br>
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #2<br>
rlm_sql_mysql: Starting connect to MySQL server for #2<br>
rlm_sql (sql1): Connected new DB handle, #2<br>
rlm_sql (sql1): starting 3<br>
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #3<br>
rlm_sql_mysql: Starting connect to MySQL server for #3<br>
rlm_sql (sql1): Connected new DB handle, #3<br>
rlm_sql (sql1): starting 4<br>
rlm_sql (sql1): Attempting to connect rlm_sql_mysql #4<br>
rlm_sql_mysql: Starting connect to MySQL server for #4<br>
rlm_sql (sql1): Connected new DB handle, #4<br>
Module: Instantiated sql (sql1) <br>
sql: driver = "rlm_sql_mysql"<br>
sql: server = "localhost"<br>
sql: port = ""<br>
sql: login = "root"<br>
sql: password = "mysql@dmin"<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 = "/var/log/radius/sqltrace.sql"<br>
sql: readclients = no<br>
sql: deletestalesessions = yes<br>
sql: num_sql_socks = 5<br>
sql: sql_user_name = "%{User-Name}"<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}', ? AcctSessionTime = '%{Acct-Session-Time}', ?
AcctInputOctets = '%{Acct-Input-Octets}', ? AcctOutputOctets =
'%{Acct-Output-Octets}' ? WHERE AcctSessionId = '%{Acct-Session-Id}' ?
AND UserName = '%{SQL-User-Name}' ? AND NASIPAddress=
'%{NAS-IP-Address}'"<br>
sql: accounting_update_query_alt = "INSERT into radacct
(AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId,
NASPortType, AcctStartTime, AcctSessionTime, AcctAuthentic,
ConnectInfo_start, AcctInputOctets, AcctOutputOctets, CalledStationId,
CallingStationId, ServiceType, FramedProtocol, FramedIPAddress,
AcctStartDelay) 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), '%{Acct-Session-Time}',
'%{Acct-Authentic}', '', '%{Acct-Input-Octets}',
'%{Acct-Output-Octets}', '%{Called-Station-Id}',
'%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}',
'%{Framed-IP-Address}', '0')"<br>
sql: accounting_start_query = "INSERT into radacct (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}'"<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}'"<br>
sql: accounting_stop_query_alt = "INSERT into radacct (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 = "SELECT COUNT(*) FROM radacct WHERE
UserName='%{SQL-User-Name}' AND AcctStopTime = 0"<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>
sql: postauth_table = "radpostauth"<br>
sql: postauth_query = "INSERT into radpostauth (id, user, pass, reply,
date) values ('', '%{User-Name}', '%{User-Password:-Chap-Password}',
'%{reply:Packet-Type}', NOW())"<br>
sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<br>
rlm_sql (sql2): Driver rlm_sql_mysql (module rlm_sql_mysql) loaded and
linked<br>
rlm_sql (sql2): Attempting to connect to root@localhost:/radius<br>
rlm_sql (sql2): starting 0<br>
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #0<br>
rlm_sql_mysql: Starting connect to MySQL server for #0<br>
rlm_sql (sql2): Connected new DB handle, #0<br>
rlm_sql (sql2): starting 1<br>
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #1<br>
rlm_sql_mysql: Starting connect to MySQL server for #1<br>
rlm_sql (sql2): Connected new DB handle, #1<br>
rlm_sql (sql2): starting 2<br>
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #2<br>
rlm_sql_mysql: Starting connect to MySQL server for #2<br>
rlm_sql (sql2): Connected new DB handle, #2<br>
rlm_sql (sql2): starting 3<br>
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #3<br>
rlm_sql_mysql: Starting connect to MySQL server for #3<br>
rlm_sql (sql2): Connected new DB handle, #3<br>
rlm_sql (sql2): starting 4<br>
rlm_sql (sql2): Attempting to connect rlm_sql_mysql #4<br>
rlm_sql_mysql: Starting connect to MySQL server for #4<br>
rlm_sql (sql2): Connected new DB handle, #4<br>
Module: Instantiated sql (sql2) <br>
Listening on authentication *:1812<br>
Listening on accounting *:1813<br>
Listening on proxy *:1814<br>
Ready to process requests.<br>
rad_recv: Access-Request packet from host 202.73.10.13:52001, id=1,
length=161<br>
Framed-MTU = 1380<br>
NAS-Identifier = "202.73.10.13"<br>
User-Name = <a class="moz-txt-link-rfc2396E" href="mailto:user@ocesb.com.my">"user@ocesb.com.my"</a><br>
NAS-Port-Id = ":4:3"<br>
Service-Type = Framed-User<br>
NAS-Port-Type = Wireless-802.11<br>
Called-Station-Id = "00-18-6e-35-ac-c4"<br>
Calling-Station-Id = "00-14-a5-d9-09-07"<br>
EAP-Message = 0x0201001801646c696e6b33406f636573622e636f6d2e6d79<br>
Message-Authenticator = 0x60416d0082e814aad26bffd83edd9d63<br>
Processing the authorize section of radiusd.conf<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>
modcall[authorize]: module "mschap" returns noop for request 0<br>
rlm_realm: Looking up realm "ocesb.com.my" for User-Name =
<a class="moz-txt-link-rfc2396E" href="mailto:user@ocesb.com.my">"user@ocesb.com.my"</a><br>
rlm_realm: Found realm "ocesb.com.my"<br>
rlm_realm: Adding Stripped-User-Name = "user"<br>
rlm_realm: Proxying request from user user to realm ocesb.com.my<br>
rlm_realm: Adding Realm = "ocesb.com.my"<br>
rlm_realm: Authentication realm is LOCAL.<br>
modcall[authorize]: module "suffix" returns noop for request 0<br>
rlm_eap: EAP packet type response id 1 length 24<br>
rlm_eap: No EAP Start, assuming it's an on-going EAP conversation<br>
modcall[authorize]: module "eap" returns updated for request 0<br>
users: Matched DEFAULT at 171<br>
users: Matched DEFAULT at 208<br>
modcall[authorize]: module "files" returns ok for request 0<br>
modcall: group authorize returns updated for request 0<br>
Processing the authorize section of radiusd.conf<br>
modcall: entering group Autz-Type for request 0<br>
rlm_ldap: - authorize<br>
rlm_ldap: performing user authorization for user<br>
radius_xlat: '(uid=user)'<br>
radius_xlat: 'dc=ocesb,dc=com,dc=my,dc=.'<br>
rlm_ldap: ldap_get_conn: Checking Id: 0<br>
rlm_ldap: ldap_get_conn: Got Id: 0<br>
rlm_ldap: attempting LDAP reconnection<br>
rlm_ldap: (re)connect to localhost:389, authentication 0<br>
rlm_ldap: bind as cn=Manager,dc=./oceld@p to localhost:389<br>
rlm_ldap: waiting for bind result ...<br>
rlm_ldap: Bind was successful<br>
rlm_ldap: performing search in dc=ocesb,dc=com,dc=my,dc=., with filter
(uid=user)<br>
rlm_ldap: checking if remote access for user is allowed by dialupAccess<br>
rlm_ldap: Added password xxxxxxx in check items<br>
rlm_ldap: looking for check items in directory...<br>
rlm_ldap: Adding userPassword as User-Password, value xxxxxxx &
op=21<br>
rlm_ldap: looking for reply items in directory...<br>
rlm_ldap: user user authorized to use remote access<br>
rlm_ldap: ldap_release_conn: Release Id: 0<br>
modcall[authorize]: module "ldap_1x" returns ok for request 0<br>
modcall: group Autz-Type returns ok for request 0<br>
rad_check_password: Found Auth-Type LDAP1<br>
auth: type "LDAP1"<br>
Processing the authenticate section of radiusd.conf<br>
modcall: entering group Auth-Type for request 0<br>
rlm_ldap: - authenticate<br>
rlm_ldap: Attribute "User-Password" is required for authentication.<br>
modcall[authenticate]: module "ldap_1x" returns invalid for request 0<br>
modcall: group Auth-Type returns invalid for request 0<br>
auth: Failed to validate the user.<br>
Login incorrect: [<a class="moz-txt-link-abbreviated" href="mailto:user@ocesb.com.my">user@ocesb.com.my</a>] (from client Nexthop-WCS port 0
cli 00-14-a5-d9-09-07)<br>
Delaying request 0 for 1 seconds<br>
Finished request 0<br>
Going to the next request<br>
--- Walking the entire request list ---<br>
Waking up in 1 seconds...<br>
--- Walking the entire request list ---<br>
Waking up in 1 seconds...<br>
--- Walking the entire request list ---<br>
Sending Access-Reject of id 1 to 202.73.10.13:52001<br>
Waking up in 4 seconds...<br>
--- Walking the entire request list ---<br>
Cleaning up request 0 ID 1 with timestamp 468a1bd4<br>
Nothing to do. Sleeping until we see a request.<br>
rad_recv: Access-Request packet from host 202.73.10.13:52001, id=2,
length=161<br>
Framed-MTU = 1380<br>
NAS-Identifier = "202.73.10.13"<br>
User-Name = <a class="moz-txt-link-rfc2396E" href="mailto:user@ocesb.com.my">"user@ocesb.com.my"</a><br>
NAS-Port-Id = ":4:3"<br>
Service-Type = Framed-User<br>
NAS-Port-Type = Wireless-802.11<br>
Called-Station-Id = "00-18-6e-35-ac-c4"<br>
Calling-Station-Id = "00-14-a5-d9-09-07"<br>
EAP-Message = 0x0201001801646c696e6b33406f636573622e636f6d2e6d79<br>
Message-Authenticator = 0x2a7e084f3da3b9dbbc7bf113259d1120<br>
Processing the authorize section of radiusd.conf<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>
modcall[authorize]: module "mschap" returns noop for request 1<br>
rlm_realm: Looking up realm "ocesb.com.my" for User-Name =
<a class="moz-txt-link-rfc2396E" href="mailto:user@ocesb.com.my">"user@ocesb.com.my"</a><br>
rlm_realm: Found realm "ocesb.com.my"<br>
rlm_realm: Adding Stripped-User-Name = "user"<br>
rlm_realm: Proxying request from user user to realm ocesb.com.my<br>
rlm_realm: Adding Realm = "ocesb.com.my"<br>
rlm_realm: Authentication realm is LOCAL.<br>
modcall[authorize]: module "suffix" returns noop for request 1<br>
rlm_eap: EAP packet type response id 1 length 24<br>
rlm_eap: No EAP Start, assuming it's an on-going EAP conversation<br>
modcall[authorize]: module "eap" returns updated for request 1<br>
users: Matched DEFAULT at 171<br>
users: Matched DEFAULT at 208<br>
modcall[authorize]: module "files" returns ok for request 1<br>
modcall: group authorize returns updated for request 1<br>
Processing the authorize section of radiusd.conf<br>
modcall: entering group Autz-Type for request 1<br>
rlm_ldap: - authorize<br>
rlm_ldap: performing user authorization for user<br>
radius_xlat: '(uid=user)'<br>
radius_xlat: 'dc=ocesb,dc=com,dc=my,dc=.'<br>
rlm_ldap: ldap_get_conn: Checking Id: 0<br>
rlm_ldap: ldap_get_conn: Got Id: 0<br>
rlm_ldap: performing search in dc=ocesb,dc=com,dc=my,dc=., with filter
(uid=user)<br>
rlm_ldap: checking if remote access for user is allowed by dialupAccess<br>
rlm_ldap: Added password xxxxxxx in check items<br>
rlm_ldap: looking for check items in directory...<br>
rlm_ldap: Adding userPassword as User-Password, value xxxxxxx &
op=21<br>
rlm_ldap: looking for reply items in directory...<br>
rlm_ldap: user user authorized to use remote access<br>
rlm_ldap: ldap_release_conn: Release Id: 0<br>
modcall[authorize]: module "ldap_1x" returns ok for request 1<br>
modcall: group Autz-Type returns ok for request 1<br>
rad_check_password: Found Auth-Type LDAP1<br>
auth: type "LDAP1"<br>
Processing the authenticate section of radiusd.conf<br>
modcall: entering group Auth-Type for request 1<br>
rlm_ldap: - authenticate<br>
rlm_ldap: Attribute "User-Password" is required for authentication.<br>
modcall[authenticate]: module "ldap_1x" returns invalid for request 1<br>
modcall: group Auth-Type returns invalid for request 1<br>
auth: Failed to validate the user.<br>
Login incorrect: [<a class="moz-txt-link-abbreviated" href="mailto:user@ocesb.com.my">user@ocesb.com.my</a>] (from client Nexthop-WCS port 0
cli 00-14-a5-d9-09-07)<br>
Delaying request 1 for 1 seconds<br>
Finished request 1<br>
Going to the next request<br>
--- Walking the entire request list ---<br>
Waking up in 1 seconds...<br>
--- Walking the entire request list ---<br>
Waking up in 1 seconds...<br>
--- Walking the entire request list ---<br>
Sending Access-Reject of id 2 to 202.73.10.13:52001<br>
Waking up in 4 seconds...<br>
--- Walking the entire request list ---<br>
Cleaning up request 1 ID 2 with timestamp 468a1be8<br>
Nothing to do. Sleeping until we see a request.<br>
<br>
<br>
Alan DeKok wrote:
<blockquote cite="mid4689D7C1.3070006@deployingradius.com" type="cite">
<pre wrap=""><a class="moz-txt-link-abbreviated" href="mailto:cktan@ocesb.com.my">cktan@ocesb.com.my</a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">I've try to setup a new freeradius server for my wireless users using
WPA/WPA2 with 802.1x authentication. all the clients are using secureW2
to login. FYI, I've another freeradius which is currently run for EAPOL
(802.1x over L2 switch) with EAP-MD5 and it is working fine for me.
After trying for 2 weeks, I'm still cannot do EAP-TTLS with PAP for
wireless. However, if I configure secureW2 to user EAP-TTLS with EAP-MD5
as inner tunnel, the user is able to authenticate.You may find my config
as below. Looking for your kind assistance... thanks.
</pre>
</blockquote>
<pre wrap=""><!---->
Please post the debug log as suggested in the README, INSTAL, FAQ, and
regularly on this list.
Alan DeKok.
-
List info/subscribe/unsubscribe? See <a class="moz-txt-link-freetext" href="http://www.freeradius.org/list/users.html">http://www.freeradius.org/list/users.html</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
CK Tan
IT Manager
Optical Communication Engineering S/B
19, Jalan Semangat,
46200 Petaling Jaya, Selangor Darul Ehsan
Tel: +60 3 76808000 EXT:1205
Fax: +60 3 76808010
H/P: +60 12 9033077
email: <a class="moz-txt-link-abbreviated" href="mailto:cktan@ocesb.com.my">cktan@ocesb.com.my</a></pre>
</body>
</html>