<div dir="ltr"><div style="font-family:arial,sans-serif;font-size:14px">Hi </div><div style="font-family:arial,sans-serif;font-size:14px">I wanna use freeradius2 as a radius-server and dhcp-server.</div><div style="font-family:arial,sans-serif;font-size:14px">
When I try to connect to radius-server,following errors show up.</div><div style="font-family:arial,sans-serif;font-size:14px">I think authentication is look fine.then message said sqlippool not defined.</div><div style="font-family:arial,sans-serif;font-size:14px">
but I set up as below.</div><div style="font-family:arial,sans-serif;font-size:14px">What's wrong with my settings?</div><div style="font-family:arial,sans-serif;font-size:14px"><br></div><div style="font-family:arial,sans-serif;font-size:14px">
------------radiusd -X-----------------</div><div style="font-family:arial,sans-serif;font-size:14px"> ... adding new socket proxy address * port 55682</div><div style="font-family:arial,sans-serif;font-size:14px">Listening on authentication address * port 1812</div>
<div style="font-family:arial,sans-serif;font-size:14px">Listening on accounting address * port 1813</div><div style="font-family:arial,sans-serif;font-size:14px">Listening on command file /var/run/radiusd/radiusd.sock</div>
<div style="font-family:arial,sans-serif;font-size:14px">Listening on authentication address 127.0.0.1 port 18120 as server inner-tunnel</div><div style="font-family:arial,sans-serif;font-size:14px">Listening on proxy address * port 1814</div>
<div style="font-family:arial,sans-serif;font-size:14px">Ready to process requests.</div><div style="font-family:arial,sans-serif;font-size:14px">rad_recv: Access-Request packet from host 10.0.5.200 port 50000, id=3, length=205</div>
<div style="font-family:arial,sans-serif;font-size:14px"> User-Password = "test"</div><div style="font-family:arial,sans-serif;font-size:14px"> User-Name = "<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>"</div>
<div style="font-family:arial,sans-serif;font-size:14px"> Acct-Session-Id = "erx FastEthernet 1/6:0011534340"</div><div style="font-family:arial,sans-serif;font-size:14px"> Service-Type = Framed-User</div>
<div style="font-family:arial,sans-serif;font-size:14px"> Framed-Protocol = PPP</div><div style="font-family:arial,sans-serif;font-size:14px"> ERX-Pppoe-Description = "pppoe 00:1d:72:c6:7b:d5"</div>
<div style="font-family:arial,sans-serif;font-size:14px"> Calling-Station-Id = "#ERX-40-b0-7a#E16#0"</div><div style="font-family:arial,sans-serif;font-size:14px"> NAS-Port-Type = Ethernet</div><div style="font-family:arial,sans-serif;font-size:14px">
NAS-Port = 369098752</div><div style="font-family:arial,sans-serif;font-size:14px"> NAS-Port-Id = "FastEthernet 1/6"</div><div style="font-family:arial,sans-serif;font-size:14px"> NAS-IP-Address = 10.0.5.200</div>
<div style="font-family:arial,sans-serif;font-size:14px"> NAS-Identifier = "ERX-40-b0-7a"</div><div style="font-family:arial,sans-serif;font-size:14px"># Executing section authorize from file /etc/raddb/sites-enabled/default</div>
<div style="font-family:arial,sans-serif;font-size:14px">+- entering group authorize {...}</div><div style="font-family:arial,sans-serif;font-size:14px">++[preprocess] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">
++[chap] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">++[mschap] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">++[digest] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">
[suffix] Looking up realm "<a href="http://mondomaine.fr/" target="_blank">mondomaine.fr</a>" for User-Name = "<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>"</div><div style="font-family:arial,sans-serif;font-size:14px">
[suffix] No such realm "<a href="http://mondomaine.fr/" target="_blank">mondomaine.fr</a>"</div><div style="font-family:arial,sans-serif;font-size:14px">++[suffix] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">
[eap] No EAP-Message, not doing EAP</div><div style="font-family:arial,sans-serif;font-size:14px">++[eap] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">[files] users: Matched entry <a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a> at line 6</div>
<div style="font-family:arial,sans-serif;font-size:14px">[files] users: Matched entry DEFAULT at line 183</div><div style="font-family:arial,sans-serif;font-size:14px">++[files] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">
++[expiration] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">++[logintime] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">++[pap] returns updated</div><div style="font-family:arial,sans-serif;font-size:14px">
Found Auth-Type = PAP</div><div style="font-family:arial,sans-serif;font-size:14px"># Executing group from file /etc/raddb/sites-enabled/default</div><div style="font-family:arial,sans-serif;font-size:14px">+- entering group PAP {...}</div>
<div style="font-family:arial,sans-serif;font-size:14px">[pap] login attempt with password "test"</div><div style="font-family:arial,sans-serif;font-size:14px">[pap] Using clear text password "test"</div>
<div style="font-family:arial,sans-serif;font-size:14px">[pap] User authenticated successfully</div><div style="font-family:arial,sans-serif;font-size:14px">++[pap] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">
Login OK: [<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>] (from client GGSN1 port 369098752 cli #ERX-40-b0-7a#E16#0)</div><div style="font-family:arial,sans-serif;font-size:14px"># Executing section post-auth from file /etc/raddb/sites-enabled/default</div>
<div style="font-family:arial,sans-serif;font-size:14px">+- entering group post-auth {...}</div><div style="font-family:arial,sans-serif;font-size:14px">[sqlippool] No Pool-Name defined.</div><div style="font-family:arial,sans-serif;font-size:14px">
[sqlippool] expand: No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> No Pool-Name defined (did cli #ERX-40-b0-7a#E16#0 port 369098752 user <a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>)</div>
<div style="font-family:arial,sans-serif;font-size:14px">No Pool-Name defined (did cli #ERX-40-b0-7a#E16#0 port 369098752 user<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>)</div><div style="font-family:arial,sans-serif;font-size:14px">
++[sqlippool] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">++[exec] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">Sending Access-Accept of id 3 to 10.0.5.200 port 50000</div>
<div style="font-family:arial,sans-serif;font-size:14px"> NAS-IP-Address == 10.0.5.200</div><div style="font-family:arial,sans-serif;font-size:14px"> Framed-Protocol = PPP</div><div style="font-family:arial,sans-serif;font-size:14px">
Framed-Compression = Van-Jacobson-TCP-IP</div><div style="font-family:arial,sans-serif;font-size:14px">Finished request 0.</div><div style="font-family:arial,sans-serif;font-size:14px">Going to the next request</div>
<div style="font-family:arial,sans-serif;font-size:14px">Waking up in 4.9 seconds.</div><div style="font-family:arial,sans-serif;font-size:14px">rad_recv: Accounting-Request packet from host 10.0.5.200 port 50016, id=73, length=246</div>
<div style="font-family:arial,sans-serif;font-size:14px"> Acct-Status-Type = Stop</div><div style="font-family:arial,sans-serif;font-size:14px"> User-Name = "<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>"</div>
<div style="font-family:arial,sans-serif;font-size:14px"> Event-Timestamp = "Apr 27 2014 14:19:10 PDT"</div><div style="font-family:arial,sans-serif;font-size:14px"> Acct-Delay-Time = 0</div><div style="font-family:arial,sans-serif;font-size:14px">
NAS-Identifier = "ERX-40-b0-7a"</div><div style="font-family:arial,sans-serif;font-size:14px"> Acct-Session-Id = "erx FastEthernet 1/6:0011534340"</div><div style="font-family:arial,sans-serif;font-size:14px">
NAS-IP-Address = 10.0.5.200</div><div style="font-family:arial,sans-serif;font-size:14px"> Service-Type = Framed-User</div><div style="font-family:arial,sans-serif;font-size:14px"> Calling-Station-Id = "#ERX-40-b0-7a#E16#0"</div>
<div style="font-family:arial,sans-serif;font-size:14px"> Acct-Input-Gigawords = 0</div><div style="font-family:arial,sans-serif;font-size:14px"> Acct-Input-Octets = 0</div><div style="font-family:arial,sans-serif;font-size:14px">
Acct-Output-Gigawords = 0</div><div style="font-family:arial,sans-serif;font-size:14px"> Acct-Output-Octets = 0</div><div style="font-family:arial,sans-serif;font-size:14px"> ERX-Input-Gigapkts = 0</div>
<div style="font-family:arial,sans-serif;font-size:14px"> Acct-Input-Packets = 0</div><div style="font-family:arial,sans-serif;font-size:14px"> ERX-Output-Gigapkts = 0</div><div style="font-family:arial,sans-serif;font-size:14px">
Acct-Output-Packets = 0</div><div style="font-family:arial,sans-serif;font-size:14px"> NAS-Port-Type = Ethernet</div><div style="font-family:arial,sans-serif;font-size:14px"> NAS-Port = 369098752</div>
<div style="font-family:arial,sans-serif;font-size:14px"> NAS-Port-Id = "FastEthernet 1/6"</div><div style="font-family:arial,sans-serif;font-size:14px"> Acct-Authentic = RADIUS</div><div style="font-family:arial,sans-serif;font-size:14px">
Acct-Session-Time = 0</div><div style="font-family:arial,sans-serif;font-size:14px"> Acct-Terminate-Cause = NAS-Request</div><div style="font-family:arial,sans-serif;font-size:14px"># Executing section preacct from file /etc/raddb/sites-enabled/default</div>
<div style="font-family:arial,sans-serif;font-size:14px">+- entering group preacct {...}</div><div style="font-family:arial,sans-serif;font-size:14px">++[preprocess] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">
[acct_unique] Hashing 'NAS-Port = 369098752,Client-IP-Address = 10.0.5.200,NAS-IP-Address = 10.0.5.200,Acct-Session-Id = "erx FastEthernet 1/6:0011534340",User-Name = "<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>"'</div>
<div style="font-family:arial,sans-serif;font-size:14px">[acct_unique] Acct-Unique-Session-ID = "fbbf6a6fb6bf3d32".</div><div style="font-family:arial,sans-serif;font-size:14px">++[acct_unique] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">
[suffix] Looking up realm "<a href="http://mondomaine.fr/" target="_blank">mondomaine.fr</a>" for User-Name = "<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>"</div><div style="font-family:arial,sans-serif;font-size:14px">
[suffix] No such realm "<a href="http://mondomaine.fr/" target="_blank">mondomaine.fr</a>"</div><div style="font-family:arial,sans-serif;font-size:14px">++[suffix] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">
++[files] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px"># Executing section accounting from file /etc/raddb/sites-enabled/default</div><div style="font-family:arial,sans-serif;font-size:14px">
+- entering group accounting {...}</div><div style="font-family:arial,sans-serif;font-size:14px">[detail] expand: %{Packet-Src-IP-Address} -> 10.0.5.200</div><div style="font-family:arial,sans-serif;font-size:14px">
[detail] expand: /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d -> /var/log/radius/radacct/<a href="http://10.0.5.200/detail-20140427" target="_blank">10.0.5.200/detail-20140427</a></div>
<div style="font-family:arial,sans-serif;font-size:14px">[detail] /var/log/radius/radacct/%{%{Packet-Src-IP-Address}:-%{Packet-Src-IPv6-Address}}/detail-%Y%m%d expands to /var/log/radius/radacct/<a href="http://10.0.5.200/detail-20140427" target="_blank">10.0.5.200/detail-20140427</a></div>
<div style="font-family:arial,sans-serif;font-size:14px">[detail] expand: %t -> Sun Apr 27 22:49:32 2014</div><div style="font-family:arial,sans-serif;font-size:14px">++[detail] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">
++[unix] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">[radutmp] expand: /var/log/radius/radutmp -> /var/log/radius/radutmp</div><div style="font-family:arial,sans-serif;font-size:14px">
[radutmp] expand: %{User-Name} -> <a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a></div><div style="font-family:arial,sans-serif;font-size:14px">rlm_radutmp: Logout for NAS GGSN1 port 369098752, but no Login record</div>
<div style="font-family:arial,sans-serif;font-size:14px">++[radutmp] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">rlm_sql (sql): Reserving sql socket id: 13</div><div style="font-family:arial,sans-serif;font-size:14px">
[sqlippool] expand: %{User-Name} -> <a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a></div><div style="font-family:arial,sans-serif;font-size:14px">[sqlippool] sql_set_user escaped user --> '<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>'</div>
<div style="font-family:arial,sans-serif;font-size:14px">[sqlippool] expand: START TRANSACTION -> START TRANSACTION</div><div style="font-family:arial,sans-serif;font-size:14px">[sqlippool] expand: UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '%{NAS-Port}' AND username = '%{User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}' -> UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', username = '', expiry_time = NULL WHERE nasipaddress = '10.0.5.200' AND pool_key = '369098752' AND username = '<a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>' AND callingstationid = '=23ERX-40-b0-7a=23E16=230' AND framedipaddress = ''</div>
<div style="font-family:arial,sans-serif;font-size:14px">[sqlippool] expand: COMMIT -> COMMIT</div><div style="font-family:arial,sans-serif;font-size:14px">[sqlippool] expand: Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name}) -> Released IP (did cli #ERX-40-b0-7a#E16#0 user <a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>)</div>
<div style="font-family:arial,sans-serif;font-size:14px">Released IP (did cli #ERX-40-b0-7a#E16#0 user <a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a>)</div><div style="font-family:arial,sans-serif;font-size:14px">
rlm_sql (sql): Released sql socket id: 13</div><div style="font-family:arial,sans-serif;font-size:14px">++[sqlippool] returns ok</div><div style="font-family:arial,sans-serif;font-size:14px">++[exec] returns noop</div><div style="font-family:arial,sans-serif;font-size:14px">
[attr_filter.accounting_response] expand: %{User-Name} -> <a href="mailto:user@mondomaine.fr" target="_blank">user@mondomaine.fr</a></div><div style="font-family:arial,sans-serif;font-size:14px">attr_filter: Matched entry DEFAULT at line 12</div>
<div style="font-family:arial,sans-serif;font-size:14px">++[attr_filter.accounting_response] returns updated</div><div style="font-family:arial,sans-serif;font-size:14px">Sending Accounting-Response of id 73 to 10.0.5.200 port 50016</div>
<div style="font-family:arial,sans-serif;font-size:14px">Finished request 1.</div><div style="font-family:arial,sans-serif;font-size:14px">Cleaning up request 1 ID 73 with timestamp +10</div><div style="font-family:arial,sans-serif;font-size:14px">
Going to the next request</div><div style="font-family:arial,sans-serif;font-size:14px">Waking up in 4.9 seconds.</div><div style="font-family:arial,sans-serif;font-size:14px">Cleaning up request 0 ID 3 with timestamp +10</div>
<div style="font-family:arial,sans-serif;font-size:14px">Ready to process requests.</div><div style="font-family:arial,sans-serif;font-size:14px">------------------------------------------------------------</div><div style="font-family:arial,sans-serif;font-size:14px">
<br></div><div style="font-family:arial,sans-serif;font-size:14px"><br></div><div style="font-family:arial,sans-serif;font-size:14px"><br></div><div style="font-family:arial,sans-serif;font-size:14px"><br></div><div style="font-family:arial,sans-serif;font-size:14px">
<br></div><div style="font-family:arial,sans-serif;font-size:14px">---------------------sqlippool.conf------------------------------</div><div style="font-family:arial,sans-serif;font-size:14px"><div>## Configuration for the SQL based IP Pool module (rlm_sqlippool)</div>
<div>##</div><div>## The database schemas are available at:</div><div>##</div><div>## raddb/sql/DB/ippool.sql</div><div>##</div><div>## $Id$</div><div><br></div><div>sqlippool {</div><div><br></div><div> #########################################</div>
<div> ## SQL instance to use (from sql.conf) ##</div><div> ##</div><div> ## If you have multiple sql instances, such as "sql sql1 {...}",</div><div> ## use the *instance* name here: sql1.</div><div> #########################################</div>
<div> sql-instance-name = "sql"</div><div><br></div><div> ## SQL table to use for ippool range and lease info</div><div> ippool_table = "radippool"</div><div><br></div><div> ## IP lease duration. (Leases expire even if Acct Stop packet is lost)</div>
<div> lease-duration = 3600</div><div><br></div><div> ## Attribute which should be considered unique per NAS</div><div> ## Using NAS-Port gives behaviour similar to rlm_ippool. (And ACS)</div><div> ## Using Calling-Station-Id works for NAS that send fixed NAS-Port</div>
<div> ## ONLY change this if you know what you are doing!</div><div> pool-key = "%{NAS-Port}"</div><div> # pool-key = "%{Calling-Station-Id}"</div><div><br></div><div> ################################################################</div>
<div> #</div><div> # WARNING: MySQL has certain limitations that means it can</div><div> # hand out the same IP address to 2 different users.</div><div> #</div><div> # We suggest using an SQL DB with proper transaction</div>
<div> # support, such as PostgreSQL, or using MySQL</div><div> #<span style="white-space:pre-wrap"> </span> with InnoDB.</div><div> #</div><div> ################################################################</div>
<div><br></div><div> #</div><div> # Use the same database as configured in the "sql" module, "database"</div><div> # configuration item. Change the "postgresql" name below to be the</div><div>
# same as the "database" field of the SQL module referred to in the</div><div> # "sql-instance-name", above.</div><div> #</div><div>#$INCLUDE sql/postgresql/ippool.conf</div><div>$INCLUDE sql/mysql/ippool.conf</div>
<div> </div><div> ## Logging configuration. (Comment out to disable logging)</div><div> sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address} \</div><div> (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"</div>
<div><br></div><div> sqlippool_log_success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} \</div><div> (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"</div>
<div><br></div><div> sqlippool_log_clear = "Released IP %{Framed-IP-Address}\</div><div> (did %{Called-Station-Id} cli %{Calling-Station-Id} user %{User-Name})"</div><div><br></div><div> sqlippool_log_failed = "IP Allocation FAILED from %{control:Pool-Name} \</div>
<div> (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"</div><div><br></div><div> sqlippool_log_nopool = "No Pool-Name defined \</div><div> (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"</div>
<div><br></div><div>}</div></div><div style="font-family:arial,sans-serif;font-size:14px">-------------------------------------------------------------------</div><div style="font-family:arial,sans-serif;font-size:14px"><br>
</div><div style="font-family:arial,sans-serif;font-size:14px"><br></div><div style="font-family:arial,sans-serif;font-size:14px"><br></div><div style="font-family:arial,sans-serif;font-size:14px"><br></div><div style="font-family:arial,sans-serif;font-size:14px">
<br></div><div style="font-family:arial,sans-serif;font-size:14px">------------------------------sql.conf---------------------------------</div><div style="font-family:arial,sans-serif;font-size:14px"><div># -*- text -*-</div>
<div>##</div><div>## sql.conf -- SQL modules</div><div>##</div><div>##<span style="white-space:pre-wrap"> </span>$Id$</div><div><br></div><div>######################################################################</div><div>
#</div><div># Configuration for the SQL module</div><div>#</div><div># The database schemas and queries are located in subdirectories:</div><div>#</div><div>#<span style="white-space:pre-wrap"> </span>sql/DB/schema.sql<span style="white-space:pre-wrap"> </span>Schema</div>
<div>#<span style="white-space:pre-wrap"> </span>sql/DB/dialup.conf<span style="white-space:pre-wrap"> </span>Basic dialup (including policy) queries</div><div>#<span style="white-space:pre-wrap"> </span>sql/DB/counter.conf<span style="white-space:pre-wrap"> </span>counter</div>
<div>#<span style="white-space:pre-wrap"> </span>sql/DB/ippool.conf<span style="white-space:pre-wrap"> </span>IP Pools in SQL</div><div>#<span style="white-space:pre-wrap"> </span>sql/DB/ippool.sql<span style="white-space:pre-wrap"> </span>schema for IP pools.</div>
<div>#</div><div># Where "DB" is mysql, mssql, oracle, or postgresql.</div><div>#</div><div><br></div><div>sql {</div><div><span style="white-space:pre-wrap"> </span>#</div><div><span style="white-space:pre-wrap"> </span># Set the database to one of:</div>
<div><span style="white-space:pre-wrap"> </span>#</div><div><span style="white-space:pre-wrap"> </span>#<span style="white-space:pre-wrap"> </span>mysql, mssql, oracle, postgresql</div><div><span style="white-space:pre-wrap"> </span>#</div>
<div><span style="white-space:pre-wrap"> </span>database = "mysql"</div><div><br></div><div><span style="white-space:pre-wrap"> </span>#</div><div><span style="white-space:pre-wrap"> </span># Which FreeRADIUS driver to use.</div>
<div><span style="white-space:pre-wrap"> </span>#</div><div><span style="white-space:pre-wrap"> </span>driver = "rlm_sql_${database}"</div><div><br></div><div><span style="white-space:pre-wrap"> </span># Connection info:</div>
<div><span style="white-space:pre-wrap"> </span>server = "localhost"</div><div><span style="white-space:pre-wrap"> </span>#port = 3306</div><div><span style="white-space:pre-wrap"> </span>login = "userfreeradius"</div>
<div><span style="white-space:pre-wrap"> </span>password = "pwdfreeradius"</div><div><br></div><div><span style="white-space:pre-wrap"> </span># Database table configuration for everything except Oracle</div><div>
<span style="white-space:pre-wrap"> </span>radius_db = "freeradius"</div><div><span style="white-space:pre-wrap"> </span># If you are using Oracle then use this instead</div><div> # radius_db = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=your_sid)))"</div>
<div><br></div><div><span style="white-space:pre-wrap"> </span># If you want both stop and start records logged to the</div><div><span style="white-space:pre-wrap"> </span># same SQL table, leave this as is. If you want them in</div>
<div><span style="white-space:pre-wrap"> </span># different tables, put the start table in acct_table1</div><div><span style="white-space:pre-wrap"> </span># and stop table in acct_table2</div><div><span style="white-space:pre-wrap"> </span>acct_table1 = "radacct"</div>
<div><span style="white-space:pre-wrap"> </span>acct_table2 = "radacct"</div><div><br></div><div><span style="white-space:pre-wrap"> </span># Allow for storing data after authentication</div><div><span style="white-space:pre-wrap"> </span>postauth_table = "radpostauth"</div>
<div><br></div><div><span style="white-space:pre-wrap"> </span>authcheck_table = "radcheck"</div><div><span style="white-space:pre-wrap"> </span>authreply_table = "radreply"</div><div><br></div><div><span style="white-space:pre-wrap"> </span>groupcheck_table = "radgroupcheck"</div>
<div><span style="white-space:pre-wrap"> </span>groupreply_table = "radgroupreply"</div><div><br></div><div><span style="white-space:pre-wrap"> </span># Table to keep group info</div><div><span style="white-space:pre-wrap"> </span>usergroup_table = "radusergroup"</div>
<div><br></div><div><span style="white-space:pre-wrap"> </span># If set to 'yes' (default) we read the group tables</div><div><span style="white-space:pre-wrap"> </span># If set to 'no' the user MUST have Fall-Through = Yes in the radreply table</div>
<div><span style="white-space:pre-wrap"> </span>read_groups = yes</div><div><br></div><div><span style="white-space:pre-wrap"> </span># Remove stale session if checkrad does not see a double login</div><div><span style="white-space:pre-wrap"> </span>deletestalesessions = yes</div>
<div><br></div><div><span style="white-space:pre-wrap"> </span># Print all SQL statements when in debug mode (-x)</div><div><span style="white-space:pre-wrap"> </span>sqltrace = no</div><div><span style="white-space:pre-wrap"> </span>sqltracefile = ${logdir}/sqltrace.sql</div>
<div><br></div><div><span style="white-space:pre-wrap"> </span># number of sql connections to make to server</div><div><span style="white-space:pre-wrap"> </span>num_sql_socks = 15</div><div><br></div><div><span style="white-space:pre-wrap"> </span># number of seconds to dely retrying on a failed database</div>
<div><span style="white-space:pre-wrap"> </span># connection (per_socket)</div><div><span style="white-space:pre-wrap"> </span>connect_failure_retry_delay = 60</div><div><br></div><div><span style="white-space:pre-wrap"> </span># lifetime of an SQL socket. If you are having network issues</div>
<div><span style="white-space:pre-wrap"> </span># such as TCP sessions expiring, you may need to set the socket</div><div><span style="white-space:pre-wrap"> </span># lifetime. If set to non-zero, any open connections will be</div>
<div><span style="white-space:pre-wrap"> </span># closed "lifetime" seconds after they were first opened.</div><div><span style="white-space:pre-wrap"> </span>lifetime = 0</div><div><br></div><div><span style="white-space:pre-wrap"> </span># Maximum number of queries used by an SQL socket. If you are</div>
<div><span style="white-space:pre-wrap"> </span># having issues with SQL sockets lasting "too long", you can</div><div><span style="white-space:pre-wrap"> </span># limit the number of queries performed over one socket. After</div>
<div><span style="white-space:pre-wrap"> </span># "max_qeuries", the socket will be closed. Use 0 for "no limit".</div><div><span style="white-space:pre-wrap"> </span>max_queries = 0</div><div><br></div>
<div><span style="white-space:pre-wrap"> </span># Set to 'yes' to read radius clients from the database ('nas' table)</div><div><span style="white-space:pre-wrap"> </span># Clients will ONLY be read on server startup. For performance</div>
<div><span style="white-space:pre-wrap"> </span># and security reasons, finding clients via SQL queries CANNOT</div><div><span style="white-space:pre-wrap"> </span># be done "live" while the server is running.</div>
<div><span style="white-space:pre-wrap"> </span># </div><div><span style="white-space:pre-wrap"> </span>readclients = yes</div><div><br></div><div><span style="white-space:pre-wrap"> </span># Table to keep radius client info</div>
<div><span style="white-space:pre-wrap"> </span>nas_table = "nas"</div><div><br></div><div><span style="white-space:pre-wrap"> </span># Read driver-specific configuration</div><div><span style="white-space:pre-wrap"> </span>$INCLUDE sql/${database}/dialup.conf</div>
<div>}</div></div><div style="font-family:arial,sans-serif;font-size:14px">---------------------------------------------------------------------------</div><div style="font-family:arial,sans-serif;font-size:14px"><br></div>
<div style="font-family:arial,sans-serif;font-size:14px">If these information is not enough please let me know.</div><div style="font-family:arial,sans-serif;font-size:14px"><br></div><div style="font-family:arial,sans-serif;font-size:14px">
Thanks,</div></div>