simultaneous checking

20 Jul 2009

      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