3.42.2. AcctSQLStatement Previous topic Parent topic Child topic Next topic

This optional parameter defines the SQL query that will be used to insert accounting details into the Rodopi database. Defaults to:
%0, '%1', %2, %3, %4, %5, %6, %7, %8, %9,
%10, %11, %12, %13, %14, %15, %16, %17, %18, %19,
%20
  • %0 is replaced with Acct-Session-Id
  • %1 with SQL formatted Timestamp
  • %2 with User-Name
  • %3 with Nas-IP-Address
  • %4 with Nas-Port
  • %5 with Service-Type
  • %6 with Framed-Protocol
  • %7 with Framed-IP-Address
  • %8 with Calling-Station-Id
  • %9 with Nas-Identifier
  • %10 with Acct-Status-Type
  • %11 with Acct-Delay-Time
  • %12 with Acct-Input-Octets
  • %13 with Acct-Output-Octets
  • %14 with Acct-Session-Time
  • %15 with Acct-Input-Packets
  • %16 with Acct-Output-Packets
  • %17 with Acct-Terminate- Cause
  • %18 with Nas-Port-Type
  • %19 with Connect-Info
  • %20 with Called-Station- Id
Unlike other AuthBy SQL clauses, if you define AcctSQLStatement in your AuthBy RODOPI configuration file, it will replace the default AcctSQLStatement, rather than add another AcctSQLStatement.