<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:times new roman,new york,times,serif;font-size:12pt"><div>Hi, I'm using Debian Lenny with freeradius version 2.0.4 and postgresql database backend.<br>I want to dynamically alocate a range of ip's from a pool i've created but it doesn't work. It only works if I add single ip's not ranges.<br><br>I 've added in the radippool table the following data:<br>192.168.0.0/24 in the framedipaddress & main_pool in the pool_named columns.<br><br>Here's the output of freeradius -X :<br><br>freeradius -X<br>FreeRADIUS Version 2.0.4, for host i486-pc-linux-gnu, built on Sep 7 2008 at 23:35:34<br>Copyright (C) 1999-2008 The FreeRADIUS server project and contributors.<br>There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A<br>PARTICULAR PURPOSE.<br>You may redistribute copies of FreeRADIUS under the terms of the<br>GNU General Public
License.<br>Starting - reading configuration files ...<br>including configuration file /etc/freeradius/radiusd.conf<br>including configuration file /etc/freeradius/clients.conf<br>including configuration file /etc/freeradius/snmp.conf<br>including configuration file /etc/freeradius/sql.conf<br>including configuration file /etc/freeradius/sql/postgresql/dialup.conf<br>including configuration file /etc/freeradius/sqlippool.conf<br>including configuration file /etc/freeradius/sql/postgresql/ippool.conf<br>including configuration file /etc/freeradius/policy.conf<br>including files in directory /etc/freeradius/sites-enabled/<br>including configuration file /etc/freeradius/sites-enabled/default<br>including configuration file /etc/freeradius/sites-enabled/inner-tunnel<br>including dictionary file /etc/freeradius/dictionary<br>main {<br> prefix = "/usr"<br> localstatedir =
"/var"<br> logdir = "/var/log/freeradius"<br> libdir = "/usr/lib/freeradius"<br> radacctdir = "/var/log/freeradius/radacct"<br> hostname_lookups = no<br> max_request_time = 30<br> cleanup_delay = 5<br> max_requests = 1024<br> allow_core_dumps = no<br> pidfile = "/var/run/freeradius/freeradius.pid"<br> user = "freerad"<br> group = "freerad"<br> checkrad = "/usr/sbin/checkrad"<br> debug_level =
0<br> proxy_requests = no<br> security {<br> max_attributes = 200<br> reject_delay = 1<br> status_server = yes<br> }<br>}<br> client localhost {<br> ipaddr = 127.0.0.1<br> require_message_authenticator = no<br> secret = "testing123"<br> nastype = "other"<br> }<br> client 192.168.107.100 {<br> require_message_authenticator = no<br> secret = "authlan"<br> nastype = "other"<br> }<br>radiusd: #### Loading Realms and Home Servers ####<br>radiusd: #### Instantiating modules
####<br> instantiate {<br> Module: Linked to module rlm_exec<br> Module: Instantiating exec<br> exec {<br> wait = yes<br> input_pairs = "request"<br> shell_escape = yes<br> }<br> Module: Linked to module rlm_expr<br> Module: Instantiating expr<br> Module: Linked to module rlm_expiration<br> Module: Instantiating expiration<br> expiration {<br> reply-message = "Password Has Expired "<br> }<br> Module: Linked to module rlm_logintime<br> Module: Instantiating logintime<br> logintime {<br> reply-message = "You are calling outside your allowed timespan "<br> minimum-timeout = 60<br> }<br> }<br>radiusd: #### Loading
Virtual Servers ####<br>server inner-tunnel {<br> modules {<br> Module: Checking authenticate {...} for more modules to load<br> Module: Linked to module rlm_pap<br> Module: Instantiating pap<br> pap {<br> encryption_scheme = "auto"<br> auto_header = yes<br> }<br> Module: Linked to module rlm_chap<br> Module: Instantiating chap<br> Module: Linked to module rlm_mschap<br> Module: Instantiating mschap<br> mschap {<br> use_mppe = yes<br> require_encryption = no<br> require_strong = no<br> with_ntdomain_hack = no<br> }<br> Module: Linked to module rlm_unix<br> Module: Instantiating unix<br> unix
{<br> radwtmp = "/var/log/freeradius/radwtmp"<br> }<br> Module: Checking authorize {...} for more modules to load<br> Module: Linked to module rlm_realm<br> Module: Instantiating suffix<br> realm suffix {<br> format = "suffix"<br> delimiter = "@"<br> ignore_default = no<br> ignore_null = no<br> }<br> Module: Linked to module rlm_files<br> Module: Instantiating files<br> files {<br> usersfile = "/etc/freeradius/users"<br> acctusersfile = "/etc/freeradius/acct_users"<br> preproxy_usersfile = "/etc/freeradius/preproxy_users"<br> compat =
"no"<br> }<br> Module: Checking session {...} for more modules to load<br> Module: Linked to module rlm_radutmp<br> Module: Instantiating radutmp<br> radutmp {<br> filename = "/var/log/freeradius/radutmp"<br> username = "%{User-Name}"<br> case_sensitive = yes<br> check_with_nas = yes<br> perm = 384<br> callerid = yes<br> }<br> Module: Checking post-auth {...} for more modules to load<br> Module: Linked to module rlm_attr_filter<br> Module: Instantiating attr_filter.access_reject<br> attr_filter attr_filter.access_reject {<br> attrsfile =
"/etc/freeradius/attrs.access_reject"<br> key = "%{User-Name}"<br> }<br> }<br>}<br>server {<br> modules {<br> Module: Checking authenticate {...} for more modules to load<br> Module: Checking authorize {...} for more modules to load<br> Module: Linked to module rlm_preprocess<br> Module: Instantiating preprocess<br> preprocess {<br> huntgroups = "/etc/freeradius/huntgroups"<br> hints = "/etc/freeradius/hints"<br> with_ascend_hack = no<br> ascend_channels_per_line = 23<br> with_ntdomain_hack = no<br> with_specialix_jetstream_hack = no<br> with_cisco_vsa_hack =
no<br> with_alvarion_vsa_hack = no<br> }<br> Module: Linked to module rlm_sql<br> Module: Instantiating sql<br> sql {<br> driver = "rlm_sql_postgresql"<br> server = "127.0.0.1"<br> port = "5432"<br> login = "radius"<br> password = "radiusdata"<br> radius_db = "radius"<br> read_groups = yes<br> sqltrace = no<br> sqltracefile = "/var/log/freeradius/sqltrace.sql"<br> readclients = no<br> deletestalesessions =
yes<br> num_sql_socks = 5<br> sql_user_name = "%{User-Name}"<br> default_user_profile = "DEFAULT"<br> nas_query = "SELECT id, nasname, shortname, type, secret FROM nas"<br> authorize_check_query = "SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id"<br> authorize_reply_query = "SELECT id, UserName, Attribute, Value, Op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id"<br> authorize_group_check_query = "SELECT id, GroupName, Attribute, Value, op FROM radgroupcheck WHERE GroupName =
'%{Sql-Group}' ORDER BY id"<br> authorize_group_reply_query = "SELECT id, GroupName, Attribute, Value, op FROM radgroupreply WHERE GroupName = '%{Sql-Group}' ORDER BY id"<br> accounting_onoff_query = "UPDATE radacct SET AcctStopTime = ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), AcctSessionTime = (EXTRACT(EPOCH FROM ('%S'::timestamp with time zone - AcctStartTime::timestamp with time zone - '%{%{Acct-Delay-Time}:-0}'::interval)))::BIGINT, AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = 0 WHERE AcctStopTime IS NULL AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStartTime <= '%S'::timestamp"<br> accounting_update_query = "UPDATE radacct SET
FramedIPAddress = NULLIF('%{Framed-IP-Address}', '')::inet, AcctSessionTime = '%{Acct-Session-Time}', AcctInputOctets = (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Input-Octets}:-0}'::bigint), AcctOutputOctets = (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint) WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress= '%{NAS-IP-Address}' AND AcctStopTime IS NULL"<br> accounting_update_query_alt = "INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctSessionTime, AcctAuthentic, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress,
XAscendSessionSvrKey) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', NULLIF('%{Realm}', ''), '%{NAS-IP-Address}', %{%{NAS-Port}:-NULL}::integer, '%{NAS-Port-Type}', ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval - '%{%{Acct-Session-Time}:-0}'::interval), '%{Acct-Session-Time}', '%{Acct-Authentic}', (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Input-Octets}:-0}'::bigint), (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint), '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', NULLIF('%{Framed-IP-Address}', '')::inet, '%{X-Ascend-Session-Svr-Key}')"<br> accounting_start_query = "INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName,
Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctAuthentic, ConnectInfo_start, CalledStationId, CallingStationId, ServiceType, FramedProtocol, FramedIPAddress, AcctStartDelay, XAscendSessionSvrKey) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', NULLIF('%{Realm}', ''), '%{NAS-IP-Address}', %{%{NAS-Port}:-NULL}::integer, '%{NAS-Port-Type}', ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), '%{Acct-Authentic}', '%{Connect-Info}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', NULLIF('%{Framed-IP-Address}', '')::inet, 0, '%{X-Ascend-Session-Svr-Key}')"<br>
accounting_start_query_alt = "UPDATE radacct SET AcctStartTime = ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), AcctStartDelay = 0, ConnectInfo_start = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime IS NULL"<br> accounting_stop_query = "UPDATE radacct SET AcctStopTime = ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), AcctSessionTime = CASE WHEN '%{Acct-Session-Time}' = '' THEN (EXTRACT(EPOCH FROM ('%S'::TIMESTAMP WITH TIME ZONE - AcctStartTime::TIMESTAMP WITH TIME ZONE - '%{%{Acct-Delay-Time}:-0}'::INTERVAL)))::BIGINT ELSE '%{Acct-Session-Time}' END, AcctInputOctets = (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) +
'%{%{Acct-Input-Octets}:-0}'::bigint), AcctOutputOctets = (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint), AcctTerminateCause = '%{Acct-Terminate-Cause}', AcctStopDelay = 0, FramedIPAddress = NULLIF('%{Framed-IP-Address}', '')::inet, ConnectInfo_stop = '%{Connect-Info}' WHERE AcctSessionId = '%{Acct-Session-Id}' AND UserName = '%{SQL-User-Name}' AND NASIPAddress = '%{NAS-IP-Address}' AND AcctStopTime IS NULL"<br> accounting_stop_query_alt = "INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctStopTime, AcctSessionTime, AcctAuthentic, ConnectInfo_stop, AcctInputOctets, AcctOutputOctets, CalledStationId, CallingStationId, AcctTerminateCause, ServiceType,
FramedProtocol, FramedIPAddress, AcctStopDelay) values('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', NULLIF('%{Realm}', ''), '%{NAS-IP-Address}', %{%{NAS-Port}:-NULL}::integer, '%{NAS-Port-Type}', ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval - '%{%{Acct-Session-Time}:-0}'::interval), ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), NULLIF('%{Acct-Session-Time}', '')::bigint, '%{Acct-Authentic}', '%{Connect-Info}', (('%{%{Acct-Input-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Input-Octets}:-0}'::bigint), (('%{%{Acct-Output-Gigawords}:-0}'::bigint << 32) + '%{%{Acct-Output-Octets}:-0}'::bigint), '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Acct-Terminate-Cause}', '%{Service-Type}',
'%{Framed-Protocol}', NULLIF('%{Framed-IP-Address}', '')::inet, 0)"<br> group_membership_query = "SELECT GroupName FROM radusergroup WHERE UserName='%{SQL-User-Name}' ORDER BY priority"<br> connect_failure_retry_delay = 60<br> simul_count_query = ""<br> simul_verify_query = ""<br> postauth_query = "INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('%{User-Name}', '%{%{User-Password}:-Chap-Password}', '%{reply:Packet-Type}', NOW())"<br> safe-characters = "@abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_: /"<br> }<br>rlm_sql (sql): Driver rlm_sql_postgresql (module rlm_sql_postgresql) loaded and linked<br>rlm_sql (sql): Attempting to connect to
radius@127.0.0.1:5432/radius<br>rlm_sql (sql): starting 0<br>rlm_sql (sql): Attempting to connect rlm_sql_postgresql #0<br>rlm_sql (sql): Connected new DB handle, #0<br>rlm_sql (sql): starting 1<br>rlm_sql (sql): Attempting to connect rlm_sql_postgresql #1<br>rlm_sql (sql): Connected new DB handle, #1<br>rlm_sql (sql): starting 2<br>rlm_sql (sql): Attempting to connect rlm_sql_postgresql #2<br>rlm_sql (sql): Connected new DB handle, #2<br>rlm_sql (sql): starting 3<br>rlm_sql (sql): Attempting to connect rlm_sql_postgresql #3<br>rlm_sql (sql): Connected new DB handle, #3<br>rlm_sql (sql): starting 4<br>rlm_sql (sql): Attempting to connect rlm_sql_postgresql #4<br>rlm_sql (sql): Connected new DB handle, #4<br> Module: Checking preacct {...} for more modules to load<br> Module: Linked to module rlm_acct_unique<br> Module: Instantiating acct_unique<br> acct_unique {<br> key = "User-Name,
Acct-Session-Id, NAS-IP-Address, Client-IP-Address, NAS-Port"<br> }<br> Module: Checking accounting {...} for more modules to load<br> Module: Linked to module rlm_detail<br> Module: Instantiating detail<br> detail {<br> detailfile = "/var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d"<br> header = "%t"<br> detailperm = 384<br> dirperm = 493<br> locking = no<br> log_packet_header = no<br> }<br> Module: Linked to module rlm_sqlippool<br> Module: Instantiating sqlippool<br> sqlippool {<br> sql-instance-name = "sql"<br> lease-duration =
3600<br> pool-name = "main_pool"<br> allocate-begin = "START TRANSACTION"<br> allocate-clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE nasipaddress = '%{NAS-IP-Address}' AND pool_key = '%{NAS-Port}'"<br> allocate-find = "SELECT framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}' AND expiry_time < 'now'::timestamp(0) ORDER BY RANDOM() LIMIT 1 FOR UPDATE"<br> allocate-update = "UPDATE radippool SET nasipaddress = '%{NAS-IP-Address}', pool_key = '%{NAS-Port}', callingstationid = '%{Calling-Station-Id}',
username = '%{SQL-User-Name}', expiry_time = 'now'::timestamp(0) + '3600 second'::interval WHERE framedipaddress = '%I'"<br> allocate-commit = "COMMIT"<br> allocate-rollback = "ROLLBACK"<br> pool-check = "SELECT id FROM radippool WHERE pool_name='%{control:Pool-Name}' LIMIT 1"<br> start-begin = "START TRANSACTION"<br> start-update = "UPDATE radippool SET expiry_time = 'now'::timestamp(0) + '3600 second'::interval WHERE nasipaddress = '%{NAS-IP-Address}' AND pool_key = '%{NAS-Port}'"<br> start-commit = "COMMIT"<br> start-rollback = "ROLLBACK"<br>
alive-begin = "START TRANSACTION"<br> alive-update = "UPDATE radippool SET expiry_time = 'now'::timestamp(0) + '3600 seconds'::interval WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key = '%{NAS-Port}' AND framedipaddress = '%{Framed-IP-Address}' AND username = '%{SQL-User-Name}' AND callingstationid = '%{Calling-Station-Id}'"<br> alive-commit = "COMMIT"<br> alive-rollback = "ROLLBACK"<br> stop-begin = "START TRANSACTION"<br> stop-clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE nasipaddress = '%{Nas-IP-Address}' AND pool_key =
'%{NAS-Port}' AND username = '%{SQL-User-Name}' AND callingstationid = '%{Calling-Station-Id}' AND framedipaddress = '%{Framed-IP-Address}'"<br> stop-commit = "COMMIT"<br> stop-rollback = "ROLLBACK"<br> on-begin = "START TRANSACTION"<br> on-clear = "UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE nasipaddress = '%{Nas-IP-Address}'"<br> on-commit = "COMMIT"<br> on-rollback = "ROLLBACK"<br> off-begin = "START TRANSACTION"<br> off-clear = "UPDATE
radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE nasipaddress = '%{Nas-IP-Address}'"<br> off-commit = "COMMIT"<br> off-rollback = "ROLLBACK"<br> sqlippool_log_exists = "Existing IP: %{reply:Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"<br> sqlippool_log_success = "Allocated IP: %{reply:Framed-IP-Address} from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"<br> sqlippool_log_clear = "Released IP %{Framed-IP-Address} (did %{Called-Station-Id} cli %{Calling-Station-Id} user
%{User-Name})"<br> sqlippool_log_failed = "IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"<br> sqlippool_log_nopool = "No Pool-Name defined (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name})"<br> defaultpool = "main_pool"<br> }<br>rlm_sql (sql): Reserving sql socket id: 4<br> Module: Instantiating attr_filter.accounting_response<br> attr_filter attr_filter.accounting_response {<br> attrsfile = "/etc/freeradius/attrs.accounting_response"<br> key = "%{User-Name}"<br> }<br> Module: Checking session {...} for more modules to load<br> Module: Checking post-auth {...} for
more modules to load<br> }<br>}<br>radiusd: #### Opening IP addresses and Ports ####<br>listen {<br> type = "auth"<br> ipaddr = *<br> port = 0<br>}<br>listen {<br> type = "acct"<br> ipaddr = *<br> port = 0<br>}<br>main {<br> snmp = no<br> smux_password = ""<br> snmp_write_access = no<br>}<br>Listening on authentication address * port 1812<br>Listening on accounting address * port 1813<br>Ready to process requests.<br>rad_recv: Access-Request packet from host 127.0.0.1 port 56795, id=186, length=113<br> Service-Type =
Framed-User<br> Framed-Protocol = PPP<br> User-Name = "akkersson"<br> CHAP-Challenge = 0x82d49b7b65d4926e1291a1fb29cf2b802faa<br> CHAP-Password = 0x0a459cbb9d04878fcc268ed0e18995b321<br> Calling-Station-Id = "00:11:5B:84:FF:ED"<br> NAS-IP-Address = 127.0.0.1<br> NAS-Port = 0<br>+- entering group authorize<br>++[preprocess] returns ok<br> rlm_chap: Setting 'Auth-Type := CHAP'<br>++[chap] returns ok<br>++[mschap] returns noop<br> rlm_realm: No '@' in User-Name = "akkersson", looking up realm NULL<br> rlm_realm: No such realm "NULL"<br>++[suffix] returns noop<br>++[unix] returns notfound<br> users: Matched
entry DEFAULT at line 172<br>++[files] returns ok<br> expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br>rlm_sql (sql): Reserving sql socket id: 3<br> expand: SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, UserName, Attribute, Value, Op FROM radcheck WHERE Username = 'akkersson' ORDER BY id<br>rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows = 1 , fields = 5<br>rlm_sql (sql): User found in radcheck table<br> expand: SELECT id, UserName, Attribute, Value, Op FROM radreply WHERE Username = '%{SQL-User-Name}' ORDER BY id -> SELECT id, UserName, Attribute, Value,
Op FROM radreply WHERE Username = 'akkersson' ORDER BY id<br>rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows = 0 , fields = 5<br> expand: SELECT GroupName FROM radusergroup WHERE UserName='%{SQL-User-Name}' ORDER BY priority -> SELECT GroupName FROM radusergroup WHERE UserName='akkersson' ORDER BY priority<br>rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows = 1 , fields = 1<br> expand: SELECT id, GroupName, Attribute, Value, op FROM radgroupcheck WHERE GroupName = '%{Sql-Group}' ORDER BY id -> SELECT id, GroupName, Attribute, Value, op FROM radgroupcheck WHERE GroupName = 'static' ORDER BY id<br>rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows =
1 , fields = 5<br>rlm_sql (sql): User found in group static<br> expand: SELECT id, GroupName, Attribute, Value, op FROM radgroupreply WHERE GroupName = '%{Sql-Group}' ORDER BY id -> SELECT id, GroupName, Attribute, Value, op FROM radgroupreply WHERE GroupName = 'static' ORDER BY id<br>rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows = 3 , fields = 5<br>rlm_sql (sql): Released sql socket id: 3<br>++[sql] returns ok<br>++[expiration] returns noop<br>++[logintime] returns noop<br>rlm_pap: Found existing Auth-Type, not changing it.<br>++[pap] returns noop<br> rad_check_password: Found Auth-Type CHAP<br>auth: type "CHAP"<br>+- entering group CHAP<br> rlm_chap: login attempt by "akkersson" with CHAP password<br> rlm_chap: Using clear text password "mumulina" for user akkersson
authentication.<br> rlm_chap: chap user akkersson authenticated succesfully<br>++[chap] returns ok<br>Login OK: [akkersson/<CHAP-Password>] (from client localhost port 0 cli 00:11:5B:84:FF:ED)<br>+- entering group post-auth<br>rlm_sql (sql): Reserving sql socket id: 2<br> expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: START TRANSACTION -> START TRANSACTION<br>rlm_sql_postgresql: Status: PGRES_COMMAND_OK<br>rlm_sql_postgresql: query affected rows = 0<br> expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1
second'::interval WHERE nasipaddress = '%{NAS-IP-Address}' AND pool_key = '%{NAS-Port}' -> UPDATE radippool SET nasipaddress = '', pool_key = 0, callingstationid = '', expiry_time = 'now'::timestamp(0) - '1 second'::interval WHERE nasipaddress = '127.0.0.1' AND pool_key = '0'<br>rlm_sql_postgresql: Status: PGRES_COMMAND_OK<br>rlm_sql_postgresql: query affected rows = 0<br> expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: SELECT framedipaddress FROM radippool WHERE pool_name = '%{control:Pool-Name}' AND expiry_time < 'now'::timestamp(0) ORDER BY RANDOM() LIMIT 1 FOR UPDATE -> SELECT framedipaddress FROM radippool WHERE pool_name = 'main_pool' AND expiry_time <
'now'::timestamp(0) ORDER BY RANDOM() LIMIT 1 FOR UPDATE<br>rlm_sql_postgresql: Status: PGRES_TUPLES_OK<br>rlm_sql_postgresql: query affected rows = 1 , fields = 1<br> expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: COMMIT -> COMMIT<br>rlm_sql_postgresql: Status: PGRES_COMMAND_OK<br>rlm_sql_postgresql: query affected rows = 0<br>rlm_sqlippool: Invalid IP number [192.168.0.0/24] returned from database query.<br>rlm_sql (sql): Released sql socket id: 2<br> expand: IP Allocation FAILED from %{control:Pool-Name} (did %{Called-Station-Id} cli %{Calling-Station-Id} port %{NAS-Port} user %{User-Name}) -> IP Allocation FAILED from main_pool (did cli 00:11:5B:84:FF:ED port 0 user akkersson)<br>IP
Allocation FAILED from main_pool (did cli 00:11:5B:84:FF:ED port 0 user akkersson)<br>++[sqlippool] returns noop<br>rlm_sql (sql): Processing sql_postauth<br> expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: %{User-Password} -><br> expand: INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('%{User-Name}', '%{%{User-Password}:-Chap-Password}', '%{reply:Packet-Type}', NOW()) -> INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('akkersson', 'Chap-Password', 'Access-Accept', NOW())<br>rlm_sql (sql) in sql_postauth: query is INSERT INTO radpostauth (username, pass, reply, authdate) VALUES ('akkersson', 'Chap-Password', 'Access-Accept', NOW())<br>rlm_sql (sql): Reserving sql socket
id: 1<br>rlm_sql_postgresql: Status: PGRES_COMMAND_OK<br>rlm_sql_postgresql: query affected rows = 1<br>rlm_sql (sql): Released sql socket id: 1<br>++[sql] returns ok<br>++[exec] returns noop<br>Sending Access-Accept of id 186 to 127.0.0.1 port 56795<br> Framed-Protocol = PPP<br> Framed-Compression = Van-Jacobson-TCP-IP<br> Service-Type = Framed-User<br>Finished request 0.<br>Going to the next request<br>Waking up in 4.9 seconds.<br>rad_recv: Accounting-Request packet from host 127.0.0.1 port 27342, id=187, length=120<br> Acct-Session-Id = "4912BE2378F100"<br> User-Name = "akkersson"<br> Acct-Status-Type = Start<br> Service-Type =
Framed-User<br> Framed-Protocol = PPP<br> Calling-Station-Id = "00:11:5B:84:FF:ED"<br> Acct-Authentic = RADIUS<br> NAS-Port-Type = Async<br> Framed-IP-Address = 10.67.15.6<br> NAS-IP-Address = 127.0.0.1<br> NAS-Port = 0<br> Acct-Delay-Time = 0<br>+- entering group preacct<br>++[preprocess] returns ok<br>rlm_acct_unique: Hashing 'NAS-Port = 0,Client-IP-Address = 127.0.0.1,NAS-IP-Address = 127.0.0.1,Acct-Session-Id = "4912BE2378F100",User-Name = "akkersson"'<br>rlm_acct_unique: Acct-Unique-Session-ID = "c8a56ec2b4afca98".<br>++[acct_unique] returns ok<br> rlm_realm: No '@' in User-Name = "akkersson", looking
up realm NULL<br> rlm_realm: No such realm "NULL"<br>++[suffix] returns noop<br>++[files] returns noop<br>+- entering group accounting<br> expand: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d -> /var/log/freeradius/radacct/127.0.0.1/detail-20081106<br>rlm_detail: /var/log/freeradius/radacct/%{Client-IP-Address}/detail-%Y%m%d expands to /var/log/freeradius/radacct/127.0.0.1/detail-20081106<br> expand: %t -> Thu Nov 6 11:51:31 2008<br>++[detail] returns ok<br>++[unix] returns ok<br> expand: /var/log/freeradius/radutmp -> /var/log/freeradius/radutmp<br> expand: %{User-Name} -> akkersson<br>++[radutmp] returns ok<br>rlm_sql (sql): Reserving sql socket id: 0<br> expand: %{User-Name} ->
akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: START TRANSACTION -> START TRANSACTION<br>rlm_sql_postgresql: Status: PGRES_COMMAND_OK<br>rlm_sql_postgresql: query affected rows = 0<br> expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: UPDATE radippool SET expiry_time = 'now'::timestamp(0) + '3600 second'::interval WHERE nasipaddress = '%{NAS-IP-Address}' AND pool_key = '%{NAS-Port}' -> UPDATE radippool SET expiry_time = 'now'::timestamp(0) + '3600 second'::interval WHERE nasipaddress = '127.0.0.1' AND pool_key = '0'<br>rlm_sql_postgresql: Status: PGRES_COMMAND_OK<br>rlm_sql_postgresql: query affected rows = 0<br>
expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: COMMIT -> COMMIT<br>rlm_sql_postgresql: Status: PGRES_COMMAND_OK<br>rlm_sql_postgresql: query affected rows = 0<br>rlm_sql (sql): Released sql socket id: 0<br>++[sqlippool] returns ok<br> expand: %{User-Name} -> akkersson<br>rlm_sql (sql): sql_set_user escaped user --> 'akkersson'<br> expand: %{NAS-Port} -> 0<br> expand: %{Acct-Delay-Time} -> 0<br> expand: INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctAuthentic, ConnectInfo_start, CalledStationId, CallingStationId, ServiceType, FramedProtocol,
FramedIPAddress, AcctStartDelay, XAscendSessionSvrKey) VALUES('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', '%{SQL-User-Name}', NULLIF('%{Realm}', ''), '%{NAS-IP-Address}', %{%{NAS-Port}:-NULL}::integer, '%{NAS-Port-Type}', ('%S'::timestamp - '%{%{Acct-Delay-Time}:-0}'::interval), '%{Acct-Authentic}', '%{Connect-Info}', '%{Called-Station-Id}', '%{Calling-Station-Id}', '%{Service-Type}', '%{Framed-Protocol}', NULLIF('%{Framed-IP-Address}', '')::inet, 0, '%{X-Ascend-Session-Svr-Key}') -> INSERT INTO radacct (AcctSessionId, AcctUniqueId, UserName, Realm, NASIPAddress, NASPortId, NASPortType, AcctStartTime, AcctAuthentic, ConnectInfo_start, CalledStationId, CallingStationId, ServiceType,
FramedProtocol, FramedIPAddress, AcctStartDelay, XAscendSessionSvrKey) VALUES('4912BE2378F100', 'c8a56ec2b4afca98', 'akkersson', NULLIF('', ''), '127.0.0.1', 0::integer, 'Async', ('2008-11-06 11:51:31'::timestamp - '0'::interval), 'RADIUS', '', '', '00:11:5B:84:FF:ED', 'Framed-User', 'PPP', NULLIF('10.67.15.6', '')::inet, 0, '')<br>rlm_sql (sql): Reserving sql socket id: 3<br>rlm_sql_postgresql: Status: PGRES_COMMAND_OK<br>rlm_sql_postgresql: query affected rows = 1<br>rlm_sql (sql): Released sql socket id: 3<br>++[sql] returns ok<br> expand: %{User-Name} -> akkersson<br> attr_filter: Matched entry DEFAULT at line 12<br>++[attr_filter.accounting_response] returns updated<br>Sending Accounting-Response of
id 187 to 127.0.0.1 port 27342<br>Finished request 1.<br>Cleaning up request 1 ID 187 with timestamp +7<br>Going to the next request<br>Waking up in 4.9 seconds.<br>Cleaning up request 0 ID 186 with timestamp +6<br>Ready to process requests.<br><br><br>It doesn't assign an ip address from the pool i've specify, instead one from the pppoe-server default range.<br>If i put a single ip in radippool table it works as it should. <br>This line is troublesome: rlm_sqlippool: Invalid IP number [192.168.0.0/24] returned from database query. If the framedipaddress is of type inet why it doesn't work properly ???<br><br>Any hints ???<br></div></div><br>
</body></html>