<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16643" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Verdana color=#000080 size=2>Hi Ivan,</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>As per your mail, I have modified
the subnet mask to 255.255.255.255 and below is other config.</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>/usr/local/etc/raddb/radiusd.conf</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2> ippool main_pool
{</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# range-start,range-stop: The start and end
ip<BR>
# addresses for the ip
pool<BR>
range-start =
192.168.1.1<BR>
range-stop = 192.168.3.254</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# netmask: The network mask used for the
ip's<BR>
netmask = 255.255.255.255</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# cache-size: The gdbm cache size for the
db<BR>
# files. Should be equal to the number of
ip's<BR>
# available in the ip
pool<BR>
cache-size = 800</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# session-db: The main db file used to allocate ip's to
clients<BR>
session-db = ${raddbdir}/db.ippool</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# ip-index: Helper db index file used in
multilink<BR>
ip-index = ${raddbdir}/db.ipindex</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# override: Will this ippool override a Framed-IP-Address already
set<BR>
override = no</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# maximum-timeout: If not zero specifies the maximum time in seconds
an<BR>
# entry may be active. Default:
0<BR>
maximum-timeout = 0<BR> }</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2> # ANSI X9.9 token
support. Not included by
default.<BR> # $INCLUDE
${confdir}/x99.conf</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>}<BR></FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>main_pool is enabled in accounting
& post-auth modules. I have kept nothing in USERS file right now. Just
wanted to see if radius starts or not. I did run radiusd -XXX but give me below
error.</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>Sun Apr 13 06:04:17 2008 : Info:
Starting - reading configuration files ...<BR>Sun Apr 13 06:04:17 2008 : Debug:
reread_config: reading radiusd.conf<BR>Sun Apr 13 06:04:17 2008 : Debug:
Config: including file: /usr/local/etc/raddb/clients.conf<BR>Sun Apr
13 06:04:17 2008 : Debug: Config: including file:
/usr/local/etc/raddb/snmp.conf<BR>Sun Apr 13 06:04:17 2008 : Debug:
Config: including file: /usr/local/etc/raddb/eap.conf<BR>Sun Apr 13
06:04:17 2008 : Debug: Config: including file:
/usr/local/etc/raddb/sql.conf<BR>Sun Apr 13 06:04:17 2008 : Debug: main:
prefix = "/usr/local"<BR>Sun Apr 13 06:04:17 2008 : Debug: main:
localstatedir = "/usr/local/var"<BR>Sun Apr 13 06:04:17 2008 : Debug:
main: logdir = "/usr/local/var/log/radius"<BR>Sun Apr 13 06:04:17 2008 :
Debug: main: libdir = "/usr/local/lib"<BR>Sun Apr 13 06:04:17 2008 :
Debug: main: radacctdir = "/usr/local/var/log/radius/radacct"<BR>Sun Apr
13 06:04:17 2008 : Debug: main: hostname_lookups = no<BR>Sun Apr 13
06:04:17 2008 : Debug: main: max_request_time = 30<BR>Sun Apr 13 06:04:17
2008 : Debug: main: cleanup_delay = 5<BR>Sun Apr 13 06:04:17 2008 :
Debug: main: max_requests = 1024<BR>Sun Apr 13 06:04:17 2008 :
Debug: main: delete_blocked_requests = 0<BR>Sun Apr 13 06:04:17 2008 :
Debug: main: port = 1645<BR>Sun Apr 13 06:04:17 2008 : Debug: main:
allow_core_dumps = no<BR>Sun Apr 13 06:04:17 2008 : Debug: main:
log_stripped_names = no<BR>Sun Apr 13 06:04:17 2008 : Debug: main:
log_file = "/usr/local/var/log/radius/radius.log"<BR>Sun Apr 13 06:04:17 2008 :
Debug: main: log_auth = no<BR>Sun Apr 13 06:04:17 2008 : Debug:
main: log_auth_badpass = no<BR>Sun Apr 13 06:04:17 2008 : Debug: main:
log_auth_goodpass = no<BR>Sun Apr 13 06:04:17 2008 : Debug: main: pidfile
= "/usr/local/var/run/radiusd/radiusd.pid"<BR>Sun Apr 13 06:04:17 2008 :
Debug: main: user = "(null)"<BR>Sun Apr 13 06:04:17 2008 : Debug:
main: group = "(null)"<BR>Sun Apr 13 06:04:17 2008 : Debug: main:
usercollide = no<BR>Sun Apr 13 06:04:17 2008 : Debug: main: lower_user =
"no"<BR>Sun Apr 13 06:04:17 2008 : Debug: main: lower_pass = "no"<BR>Sun
Apr 13 06:04:17 2008 : Debug: main: nospace_user = "no"<BR>Sun Apr 13
06:04:17 2008 : Debug: main: nospace_pass = "no"<BR>Sun Apr 13 06:04:17
2008 : Debug: main: checkrad = "/usr/local/sbin/checkrad"<BR>Sun Apr 13
06:04:17 2008 : Debug: main: proxy_requests = no<BR>Sun Apr 13 06:04:17
2008 : Debug: security: max_attributes = 200<BR>Sun Apr 13 06:04:17 2008 :
Debug: security: reject_delay = 1<BR>Sun Apr 13 06:04:17 2008 :
Debug: security: status_server = no<BR>Sun Apr 13 06:04:17 2008 :
Debug: main: debug_level = 0<BR>Sun Apr 13 06:04:17 2008 : Debug:
read_config_files: reading dictionary<BR>Sun Apr 13 06:04:17 2008 : Debug:
read_config_files: reading naslist<BR>Sun Apr 13 06:04:17 2008 : Info:
Using deprecated naslist file. Support for this will go away soon.<BR>Sun
Apr 13 06:04:17 2008 : Debug: read_config_files: reading clients<BR>Sun
Apr 13 06:04:17 2008 : Debug: read_config_files: reading realms<BR>Sun Apr
13 06:04:17 2008 : Debug: radiusd: entering modules setup<BR>Sun Apr 13
06:04:17 2008 : Debug: Module: Library search path is /usr/local/lib<BR>Sun Apr
13 06:04:17 2008 : Debug: Module: Loaded exec <BR>Sun Apr 13 06:04:17 2008 :
Debug: exec: wait = yes<BR>Sun Apr 13 06:04:17 2008 : Debug: exec:
program = "(null)"<BR>Sun Apr 13 06:04:17 2008 : Debug: exec: input_pairs
= "request"<BR>Sun Apr 13 06:04:17 2008 : Debug: exec: output_pairs =
"(null)"<BR>Sun Apr 13 06:04:17 2008 : Debug: exec: packet_type =
"(null)"<BR>Sun Apr 13 06:04:17 2008 : Info: rlm_exec: Wait=yes but no output
defined. Did you mean output=none?<BR>Sun Apr 13 06:04:17 2008 : Debug: Module:
Instantiated exec (exec) <BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Loaded
expr <BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Instantiated expr (expr)
<BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Loaded PAP <BR>Sun Apr 13 06:04:17
2008 : Debug: pap: encryption_scheme = "crypt"<BR>Sun Apr 13 06:04:17 2008
: Debug: Module: Instantiated pap (pap) <BR>Sun Apr 13 06:04:17 2008 : Debug:
Module: Loaded CHAP <BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Instantiated
chap (chap) <BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Loaded MS-CHAP <BR>Sun
Apr 13 06:04:17 2008 : Debug: mschap: use_mppe = yes<BR>Sun Apr 13
06:04:17 2008 : Debug: mschap: require_encryption = no<BR>Sun Apr 13
06:04:17 2008 : Debug: mschap: require_strong = no<BR>Sun Apr 13 06:04:17
2008 : Debug: mschap: with_ntdomain_hack = no<BR>Sun Apr 13 06:04:17 2008
: Debug: mschap: passwd = "(null)"<BR>Sun Apr 13 06:04:17 2008 :
Debug: mschap: authtype = "MS-CHAP"<BR>Sun Apr 13 06:04:17 2008 :
Debug: mschap: ntlm_auth = "(null)"<BR>Sun Apr 13 06:04:17 2008 : Debug:
Module: Instantiated mschap (mschap) <BR>Sun Apr 13 06:04:17 2008 : Debug:
Module: Loaded System <BR>Sun Apr 13 06:04:17 2008 : Debug: unix: cache =
no<BR>Sun Apr 13 06:04:17 2008 : Debug: unix: passwd = "(null)"<BR>Sun Apr
13 06:04:17 2008 : Debug: unix: shadow = "(null)"<BR>Sun Apr 13 06:04:17
2008 : Debug: unix: group = "(null)"<BR>Sun Apr 13 06:04:17 2008 :
Debug: unix: radwtmp = "/usr/local/var/log/radius/radwtmp"<BR>Sun Apr 13
06:04:17 2008 : Debug: unix: usegroup = no<BR>Sun Apr 13 06:04:17 2008 :
Debug: unix: cache_reload = 600<BR>Sun Apr 13 06:04:17 2008 : Debug:
Module: Instantiated unix (unix) <BR>Sun Apr 13 06:04:17 2008 : Debug: Module:
Loaded eap <BR>Sun Apr 13 06:04:17 2008 : Debug: eap: default_eap_type =
"md5"<BR>Sun Apr 13 06:04:17 2008 : Debug: eap: timer_expire = 60<BR>Sun
Apr 13 06:04:17 2008 : Debug: eap: ignore_unknown_eap_types = no<BR>Sun
Apr 13 06:04:17 2008 : Debug: eap: cisco_accounting_username_bug =
no<BR>Sun Apr 13 06:04:17 2008 : Debug: rlm_eap: Loaded and initialized type
md5<BR>Sun Apr 13 06:04:17 2008 : Debug: rlm_eap: Loaded and initialized type
leap<BR>Sun Apr 13 06:04:17 2008 : Debug: gtc: challenge = "Password:
"<BR>Sun Apr 13 06:04:17 2008 : Debug: gtc: auth_type = "PAP"<BR>Sun Apr
13 06:04:17 2008 : Debug: rlm_eap: Loaded and initialized type gtc<BR>Sun Apr 13
06:04:17 2008 : Debug: mschapv2: with_ntdomain_hack = no<BR>Sun Apr 13
06:04:17 2008 : Debug: rlm_eap: Loaded and initialized type mschapv2<BR>Sun Apr
13 06:04:17 2008 : Debug: Module: Instantiated eap (eap) <BR>Sun Apr 13 06:04:17
2008 : Debug: Module: Loaded preprocess <BR>Sun Apr 13 06:04:17 2008 :
Debug: preprocess: huntgroups = "/usr/local/etc/raddb/huntgroups"<BR>Sun
Apr 13 06:04:17 2008 : Debug: preprocess: hints =
"/usr/local/etc/raddb/hints"<BR>Sun Apr 13 06:04:17 2008 : Debug:
preprocess: with_ascend_hack = no<BR>Sun Apr 13 06:04:17 2008 : Debug:
preprocess: ascend_channels_per_line = 23<BR>Sun Apr 13 06:04:17 2008 :
Debug: preprocess: with_ntdomain_hack = no<BR>Sun Apr 13 06:04:17 2008 :
Debug: preprocess: with_specialix_jetstream_hack = no<BR>Sun Apr 13
06:04:17 2008 : Debug: preprocess: with_cisco_vsa_hack = no<BR>Sun Apr 13
06:04:17 2008 : Debug: Module: Instantiated preprocess (preprocess) <BR>Sun Apr
13 06:04:17 2008 : Debug: Module: Loaded realm <BR>Sun Apr 13 06:04:17 2008 :
Debug: realm: format = "suffix"<BR>Sun Apr 13 06:04:17 2008 : Debug:
realm: delimiter = "@"<BR>Sun Apr 13 06:04:17 2008 : Debug: realm:
ignore_default = no<BR>Sun Apr 13 06:04:17 2008 : Debug: realm:
ignore_null = no<BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Instantiated realm
(suffix) <BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Loaded files <BR>Sun Apr
13 06:04:17 2008 : Debug: files: usersfile =
"/usr/local/etc/raddb/users"<BR>Sun Apr 13 06:04:17 2008 : Debug: files:
acctusersfile = "/usr/local/etc/raddb/acct_users"<BR>Sun Apr 13 06:04:17 2008 :
Debug: files: preproxy_usersfile =
"/usr/local/etc/raddb/preproxy_users"<BR>Sun Apr 13 06:04:17 2008 : Debug:
files: compat = "no"<BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Instantiated
files (files) <BR>Sun Apr 13 06:04:17 2008 : Debug: Module: Loaded SQL <BR>Sun
Apr 13 06:04:17 2008 : Debug: sql: driver = "rlm_sql_mysql"<BR>Sun Apr 13
06:04:17 2008 : Debug: sql: server = "localhost"<BR>Sun Apr 13 06:04:17
2008 : Debug: sql: port = ""<BR>Sun Apr 13 06:04:17 2008 : Debug:
sql: login = "root"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: password =
"rootpass"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: radius_db =
"radius"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: acct_table =
"radacct"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: acct_table2 =
"radacct"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: authcheck_table =
"radcheck"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: authreply_table =
"radreply"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: groupcheck_table =
"radgroupcheck"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: groupreply_table
= "radgroupreply"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql:
usergroup_table = "usergroup"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql:
nas_table = "nas"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: dict_table =
"dictionary"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: sqltrace =
no<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: sqltracefile =
"/usr/local/var/log/radius/sqltrace.sql"<BR>Sun Apr 13 06:04:17 2008 :
Debug: sql: readclients = no<BR>Sun Apr 13 06:04:17 2008 : Debug:
sql: deletestalesessions = yes<BR>Sun Apr 13 06:04:17 2008 : Debug: sql:
num_sql_socks = 5<BR>Sun Apr 13 06:04:17 2008 : Debug: sql: sql_user_name
= "%{User-Name}"<BR>Sun Apr 13 06:04:17 2008 : Debug: sql:
default_user_profile = ""<BR>Sun Apr 13 06:04:17 2008 : Debug: sql:
query_on_not_found = no<BR>Sun Apr 13 06:04:17 2008 : Debug: sql:
authorize_check_query = "SELECT id,UserName,Attribute,Value,op FROM radcheck
WHERE Username = '%{SQL-User-Name}' ORDER BY id"<BR>Sun Apr 13 06:04:17 2008 :
Debug: sql: authorize_reply_query = "SELECT id,UserName,Attribute,Value,op
FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id"<BR>Sun Apr 13
06:04:17 2008 : Debug: 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>Sun
Apr 13 06:04:17 2008 : Debug: 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>Sun
Apr 13 06:04:17 2008 : Debug: 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>Sun Apr
13 06:04:17 2008 : Debug: 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>Sun Apr 13 06:04:17 2008 : Debug: 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>Sun
Apr 13 06:04:17 2008 : Debug: 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>Sun
Apr 13 06:04:19 2008 : Debug: 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>Sun
Apr 13 06:04:19 2008 : Debug: 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>Sun Apr 13 06:04:19 2008 : Debug:
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>Sun
Apr 13 06:04:19 2008 : Debug: sql: group_membership_query = "SELECT
GroupName FROM usergroup WHERE UserName='%{SQL-User-Name}'"<BR>Sun Apr 13
06:04:19 2008 : Debug: sql: connect_failure_retry_delay = 60<BR>Sun Apr 13
06:04:19 2008 : Debug: sql: simul_count_query = ""<BR>Sun Apr 13 06:04:19
2008 : Debug: sql: simul_verify_query = "SELECT RadAcctId, AcctSessionId,
UserName, NASIPAddress, NASPortId, FramedIPAddress, CallingStationId,
FramedProtocol FROM radacct WHERE UserName='%{SQL-User-Name}' AND AcctStopTime =
0"<BR>Sun Apr 13 06:04:19 2008 : Debug: sql: postauth_table =
"radpostauth"<BR>Sun Apr 13 06:04:19 2008 : Debug: sql: postauth_query =
"INSERT into radpostauth (id, user, pass, reply, date) values ('',
'%{User-Name}', '%{User-Password:-Chap-Password}', '%{reply:Packet-Type}',
NOW())"<BR>Sun Apr 13 06:04:19 2008 : Debug: sql: safe-characters =
"@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<BR>Sun
Apr 13 06:04:19 2008 : Info: rlm_sql (sql): Driver rlm_sql_mysql (module
rlm_sql_mysql) loaded and linked<BR>Sun Apr 13 06:04:19 2008 : Info: rlm_sql
(sql): Attempting to connect to <A
href="mailto:root@localhost:/radius">root@localhost:/radius</A><BR>Sun Apr 13
06:04:19 2008 : Debug: rlm_sql (sql): starting 0<BR>Sun Apr 13 06:04:19 2008 :
Debug: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0<BR>Sun Apr 13
06:04:19 2008 : Info: rlm_sql_mysql: Starting connect to MySQL server for
#0<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql (sql): Connected new DB handle,
#0<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql (sql): starting 1<BR>Sun Apr 13
06:04:19 2008 : Debug: rlm_sql (sql): Attempting to connect rlm_sql_mysql
#1<BR>Sun Apr 13 06:04:19 2008 : Info: rlm_sql_mysql: Starting connect to MySQL
server for #1<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql (sql): Connected new
DB handle, #1<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql (sql): starting
2<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql (sql): Attempting to connect
rlm_sql_mysql #2<BR>Sun Apr 13 06:04:19 2008 : Info: rlm_sql_mysql: Starting
connect to MySQL server for #2<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql
(sql): Connected new DB handle, #2<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql
(sql): starting 3<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql (sql): Attempting
to connect rlm_sql_mysql #3<BR>Sun Apr 13 06:04:19 2008 : Info: rlm_sql_mysql:
Starting connect to MySQL server for #3<BR>Sun Apr 13 06:04:19 2008 : Debug:
rlm_sql (sql): Connected new DB handle, #3<BR>Sun Apr 13 06:04:19 2008 : Debug:
rlm_sql (sql): starting 4<BR>Sun Apr 13 06:04:19 2008 : Debug: rlm_sql (sql):
Attempting to connect rlm_sql_mysql #4<BR>Sun Apr 13 06:04:19 2008 : Info:
rlm_sql_mysql: Starting connect to MySQL server for #4<BR>Sun Apr 13 06:04:19
2008 : Debug: rlm_sql (sql): Connected new DB handle, #4<BR>Sun Apr 13 06:04:19
2008 : Debug: Module: Instantiated sql (sql) <BR>Sun Apr 13 06:04:19 2008 :
Debug: Module: Loaded Acct-Unique-Session-Id <BR>Sun Apr 13 06:04:19 2008 :
Debug: acct_unique: key = "User-Name, Acct-Session-Id, NAS-IP-Address,
Client-IP-Address, NAS-Port"<BR>Sun Apr 13 06:04:19 2008 : Debug: Module:
Instantiated acct_unique (acct_unique) <BR>Sun Apr 13 06:04:19 2008 : Debug:
Module: Loaded detail <BR>Sun Apr 13 06:04:19 2008 : Debug: detail:
detailfile =
"/usr/local/var/log/radius/radacct/%{Client-IP-Address}/detail-%Y%m%d"<BR>Sun
Apr 13 06:04:19 2008 : Debug: detail: detailperm = 384<BR>Sun Apr 13
06:04:19 2008 : Debug: detail: dirperm = 493<BR>Sun Apr 13 06:04:19 2008 :
Debug: detail: locking = no<BR>Sun Apr 13 06:04:19 2008 : Debug: Module:
Instantiated detail (detail) <BR>Sun Apr 13 06:04:19 2008 : Debug: Module:
Loaded radutmp <BR>Sun Apr 13 06:04:19 2008 : Debug: radutmp: filename =
"/usr/local/var/log/radius/radutmp"<BR>Sun Apr 13 06:04:19 2008 : Debug:
radutmp: username = "%{User-Name}"<BR>Sun Apr 13 06:04:19 2008 : Debug:
radutmp: case_sensitive = yes<BR>Sun Apr 13 06:04:19 2008 : Debug:
radutmp: check_with_nas = yes<BR>Sun Apr 13 06:04:19 2008 : Debug:
radutmp: perm = 384<BR>Sun Apr 13 06:04:19 2008 : Debug: radutmp: callerid
= yes<BR>Sun Apr 13 06:04:19 2008 : Debug: Module: Instantiated radutmp
(radutmp) <BR>Segmentation fault<BR></FONT><FONT face=Verdana color=#000080
size=2></FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>Any suggestions
please.</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>Regards,</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2>Joel</DIV></FONT>
<BLOCKQUOTE dir=ltr
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000080 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=joelsolanki@gmail.com href="mailto:joelsolanki@gmail.com">Joel @
Gmail</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=freeradius-users@lists.freeradius.org
href="mailto:freeradius-users@lists.freeradius.org">freeradius-users@lists.freeradius.org</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Saturday, April 12, 2008 7:11
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Dynamic IP Allocation With
Freeradius</DIV>
<DIV><BR></DIV>
<DIV><FONT face=Verdana color=#000080 size=2>Dear Friends,</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>Right now I have setup working of
freeradius with mysql authentication. I have static & dynamic group
created in mysql and all seems working. Currently static IPs are provided by
radius with mysql backend. But dynamic IP is provided by Cisco Router. Cisco
router is configured as PPPOE/PPPOA. Cisco does all authentication with
freeradius. </FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>Now what I want is to provided
Dynamic IPs with freeradius instead of Cisco. I have searched alot and tried
few setting but that didnt worked. Is it possible to configure USERS file and
have all dynamic users get dynamically using USERS file ? I checked but wasnt
sucessful. Or a solution in mysql itself. </FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>For testing i had activated below
config in radiusd.conf</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2> ippool main_pool {</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# range-start,range-stop: The start and end
ip<BR>
# addresses for the ip
pool<BR>
range-start =
192.168.1.1<BR>
range-stop = 192.168.3.254</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# netmask: The network mask used for the
ip's<BR>
netmask = 255.255.255.0</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# cache-size: The gdbm cache size for the
db<BR>
# files. Should be equal to the number of
ip's<BR>
# available in the ip
pool<BR>
cache-size = 800</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# session-db: The main db file used to allocate ip's to
clients<BR>
session-db = ${raddbdir}/db.ippool</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# ip-index: Helper db index file used in
multilink<BR>
ip-index = ${raddbdir}/db.ipindex</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# override: Will this ippool override a Framed-IP-Address already
set<BR>
override = no</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana color=#000080
size=2>
# maximum-timeout: If not zero specifies the maximum time in seconds
an<BR>
# entry may be active. Default:
0<BR>
maximum-timeout = 0<BR>
}<BR></FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2>main_pool in accounting &
post-auth modules.</FONT></DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana color=#000080 size=2></FONT> </DIV>
<DIV><FONT face=Verdana><FONT size=2><FONT color=#000080>doing this and
starting the radius gives me segmentation error. </FONT></FONT></FONT></DIV>
<DIV><FONT face=Verdana><FONT size=2><FONT
color=#000080></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Verdana><FONT size=2><FONT color=#000080>Any suggestion please
?<BR></FONT></FONT></FONT></DIV>
<DIV><FONT face=Verdana><FONT size=2><FONT
color=#000080></FONT></FONT></FONT> </DIV>
<DIV><FONT face=Verdana><FONT size=2><FONT
color=#000080>Regards,</FONT></FONT></FONT></DIV>
<DIV><FONT face=Verdana><FONT size=2><FONT
color=#000080>Joel</DIV></BLOCKQUOTE></FONT></FONT></FONT></BODY></HTML>