Hi All, During testing (we're not live yet), a co-worker made some changes to dialup.conf to get simultaneous checking working with our NAS (Juniper E-120, I believe). I haven't been updated on whether or not the simultaneous check actually works (just got back from vacation), but I'd like to know from people here if the edits made are even a good idea.
Here are the changes made to dialup.conf config (i.e. the "#" lines are things commented out that the default dialup.conf file has enabled, and anything else listed below is actually changed): # accounting_update_query_alt = " \ # INSERT INTO ${acct_table1} \ # (acctsessionid, acctuniqueid, username, \ # realm, nasipaddress, nasportid, \ # nasporttype, acctstarttime, acctsessiontime, \ # acctauthentic, connectinfo_start, acctinputoctets, \ # acctoutputoctets, calledstationid, callingstationid, \ # servicetype, framedprotocol, framedipaddress, \ # acctstartdelay, xascendsessionsvrkey) \ # 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-Gigawords}:-0}' << 32 | \ # '%{%{Acct-Input-Octets}:-0}', \ # '%{%{Acct-Output-Gigawords}:-0}' << 32 | \ # '%{%{Acct-Output-Octets}:-0}', \ # '%{Called-Station-Id}', '%{Calling-Station-Id}', \ # '%{Service-Type}', '%{Framed-Protocol}', \ # '%{Framed-IP-Address}', \ # '0', '%{X-Ascend-Session-Svr-Key}')" # accounting_start_query = " \ # INSERT INTO ${acct_table1} \ # (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, xascendsessionsvrkey) \ # VALUES \ # ('%{Acct-Session-Id}', '%{Acct-Unique-Session-Id}', \ # '%{SQL-User-Name}', \ # '%{Realm}', '%{NAS-IP-Address}', '%{NAS-Port}', \ # '%{NAS-Port-Type}', '%S', NULL, \ # '0', '%{Acct-Authentic}', '%{Connect-Info}', \ # '', '0', '0', \ # '%{Called-Station-Id}', '%{Calling-Station-Id}', '', \ # '%{Service-Type}', '%{Framed-Protocol}', '%{Framed-IP-Address}', \ # '%{%{Acct-Delay-Time}:-0}', '0', '%{X-Ascend-Session-Svr-Key}')" simul_count_query = "SELECT COUNT(*) \ FROM radippool \ WHERE framedipaddress = '%{Framed-IP-Address}' \ AND nasipaddress = '%{NAS-IP-Address}'" # simul_verify_query = "SELECT radacctid, acctsessionid, username, \ # nasipaddress, nasportid, framedipaddress, \ # callingstationid, framedprotocol \ # FROM ${acct_table1} \ # WHERE username = '%{SQL-User-Name}' \ # AND acctstoptime IS NULL" -- Kanwar Ranbir Sandhu Linux 2.6.27.25-170.2.72.fc10.x86_64 x86_64 GNU/Linux 17:08:41 up 2 days, 23:39, 4 users, load average: 0.19, 0.23, 0.27 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html