Freeside:3:Documentation:Developer/FS/part export/sqlradius - Revision history

Jeremyd: Edit via perl MediaWiki framework (1.13)

2015-09-28T14:31:23Z

Edit via perl MediaWiki framework (1.13)

Jeremyd: Edit via perl MediaWiki framework (1.13)

2015-02-10T13:48:50Z

Edit via perl MediaWiki framework (1.13)

Jeremyd: Edit via perl MediaWiki framework (1.13)

2014-06-27T21:44:15Z

Edit via perl MediaWiki framework (1.13)

Ivan: Edit via perl MediaWiki framework (1.13)

2012-06-28T04:08:30Z

Edit via perl MediaWiki framework (1.13)

New page

; usage_sessions HASHREF; usage_sessions TIMESTAMP_START TIMESTAMP_END [ SVC_ACCT [ IP [ PREFIX [ SQL_SELECT ] ] ] ]
:New-style: pass a hashref with the following keys:
:; stoptime_start - Lower bound for AcctStopTime, as a UNIX timestamp:; stoptime_end - Upper bound for AcctStopTime, as a UNIX timestamp:; open_sessions - Only show records with no AcctStopTime (typically used without stoptime_* options and with starttime_* options instead):; starttime_start - Lower bound for AcctStartTime, as a UNIX timestamp:; starttime_end - Upper bound for AcctStartTime, as a UNIX timestamp:; svc_acct:; ip:; prefix
:Old-style:

:TIMESTAMP_START and TIMESTAMP_END are specified as UNIX timestamps; see [[perlfunc#time|"time" in perlfunc]]. Also see [[Freeside:3:Documentation:Developer/Time/Local|Time::Local]] and [[Freeside:3:Documentation:Developer/Date/Parse|Date::Parse]] for conversion functions.

:SVC_ACCT, if specified, limits the results to the specified account.

:IP, if specified, limits the results to the specified IP address.

:PREFIX, if specified, limits the results to records with a matching Called-Station-ID.

:#SQL_SELECT defaults to * if unspecified. It can be useful to set it to #SUM(acctsessiontime) or SUM(AcctInputOctets), etc.

:Returns an arrayref of hashrefs with the following fields:
:; username:; framedipaddress:; acctstarttime:; acctstoptime:; acctsessiontime:; acctinputoctets:; acctoutputoctets:; calledstationid; update_svc; export_nas_insert NAS; export_nas_delete NAS; export_nas_replace NEW_NAS OLD_NAS
:Update the NAS table (allowed RADIUS clients) on the attached RADIUS server. Currently requires the table to be named 'nas' and to follow the stock schema (/etc/freeradius/nas.sql).
; export_attr_insert RADIUS_ATTR; export_attr_delete RADIUS_ATTR; export_attr_replace NEW_RADIUS_ATTR OLD_RADIUS_ATTR
:Update the group attribute tables (radgroupcheck and radgroupreply) on the RADIUS server. In delete and replace actions, the existing records are identified by the combination of group name and attribute name.

:In the special case where attributes are being replaced because a group name ([[Freeside:3:Documentation:Developer/FS/radius group|FS::radius_group]]->groupname) is changing, the pseudo-field 'groupname' must be set in OLD_RADIUS_ATTR. It's probably best to do this
; export_group_replace NEW OLD
:Replace the [[Freeside:3:Documentation:Developer/FS/radius group|FS::radius_group]] object OLD with NEW. This will change the group name and priority in all radusergroup records, and the group name in radgroupcheck and radgroupreply.

==POD ERRORS==
Hey! '''The above document had some coding errors, which are explained below:'''

; Around line 583:
:'=item' outside of any '=over'

@@ Line 23: / Line 23: @@
 ; export_group_replace NEW OLD
 :Replace the [[Freeside:3:Documentation:Developer/FS/radius group|FS::radius_group]] object OLD with NEW. This will change the group name and priority in all radusergroup records, and the group name in radgroupcheck and radgroupreply.
 ==POD ERRORS==
 Hey! '''The above document had some coding errors, which are explained below:'''
-; Around line 591&#58;
+; Around line 667&#58;
 :'=item' outside of any '=over'

@@ Line 15: / Line 15: @@
 :Returns an arrayref of hashrefs with the following fields:
-:; username:; framedipaddress:; acctstarttime:; acctstoptime:; acctsessiontime:; acctinputoctets:; acctoutputoctets:; calledstationid; update_svc; export_nas_insert NAS; export_nas_delete NAS; export_nas_replace NEW_NAS OLD_NAS
+:; username:; framedipaddress:; acctstarttime:; acctstoptime:; acctsessiontime:; acctinputoctets:; acctoutputoctets:; callingstationid:; calledstationid; update_svc; export_nas_insert NAS; export_nas_delete NAS; export_nas_replace NEW_NAS OLD_NAS
 :Update the NAS table (allowed RADIUS clients) on the attached RADIUS server. Currently requires the table to be named 'nas' and to follow the stock schema (/etc/freeradius/nas.sql).
 ; export_attr_insert RADIUS_ATTR; export_attr_delete RADIUS_ATTR; export_attr_replace NEW_RADIUS_ATTR OLD_RADIUS_ATTR

@@ Line 1: / Line 1: @@
 ; usage_sessions HASHREF; usage_sessions TIMESTAMP_START TIMESTAMP_END [ SVC_ACCT [ IP [ PREFIX [ SQL_SELECT ] ] ] ]
 :New-style: pass a hashref with the following keys:
-:; stoptime_start - Lower bound for AcctStopTime, as a UNIX timestamp:; stoptime_end - Upper bound for AcctStopTime, as a UNIX timestamp:; open_sessions - Only show records with no AcctStopTime (typically used without stoptime_* options and with starttime_* options instead):; starttime_start - Lower bound for AcctStartTime, as a UNIX timestamp:; starttime_end - Upper bound for AcctStartTime, as a UNIX timestamp:; svc_acct:; ip:; prefix
+:; stoptime_start - Lower bound for AcctStopTime, as a UNIX timestamp:; stoptime_end - Upper bound for AcctStopTime, as a UNIX timestamp:; session_status - 'closed' to only show records with AcctStopTime, 'open' to only show records ''without'' AcctStopTime, empty to show both.:; starttime_start - Lower bound for AcctStartTime, as a UNIX timestamp:; starttime_end - Upper bound for AcctStartTime, as a UNIX timestamp:; svc_acct:; ip:; prefix
 :Old-style:
@@ Line 20: / Line 20: @@
 :Update the group attribute tables (radgroupcheck and radgroupreply) on the RADIUS server. In delete and replace actions, the existing records are identified by the combination of group name and attribute name.
-:In the special case where attributes are being replaced because a group name ([[Freeside:3:Documentation:Developer/FS/radius group|FS::radius_group]]->groupname) is changing, the pseudo-field 'groupname' must be set in OLD_RADIUS_ATTR. It's probably best to do this
+:In the special case where attributes are being replaced because a group name ([[Freeside:3:Documentation:Developer/FS/radius group|FS::radius_group]]->groupname) is changing, the pseudo-field 'groupname' must be set in OLD_RADIUS_ATTR.
 ; export_group_replace NEW OLD
 :Replace the [[Freeside:3:Documentation:Developer/FS/radius group|FS::radius_group]] object OLD with NEW. This will change the group name and priority in all radusergroup records, and the group name in radgroupcheck and radgroupreply.
@@ Line 27: / Line 27: @@
 Hey! '''The above document had some coding errors, which are explained below:'''
-; Around line 583&#58;
+; Around line 591&#58;
 :'=item' outside of any '=over'