<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en">
		<id>https://secure.freeside.biz/mediawiki/index.php?action=history&amp;feed=atom&amp;title=Freeside%3A4%3ADocumentation%3ADeveloper%2Fbin%2Ffreeside-sqlradius-radacctd</id>
		<title>Freeside:4:Documentation:Developer/bin/freeside-sqlradius-radacctd - Revision history</title>
		<link rel="self" type="application/atom+xml" href="https://secure.freeside.biz/mediawiki/index.php?action=history&amp;feed=atom&amp;title=Freeside%3A4%3ADocumentation%3ADeveloper%2Fbin%2Ffreeside-sqlradius-radacctd"/>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:4:Documentation:Developer/bin/freeside-sqlradius-radacctd&amp;action=history"/>
		<updated>2026-08-28T09:31:53Z</updated>
		<subtitle>Revision history for this page on the wiki</subtitle>
		<generator>MediaWiki 1.27.7</generator>

	<entry>
		<id>https://secure.freeside.biz/mediawiki/index.php?title=Freeside:4:Documentation:Developer/bin/freeside-sqlradius-radacctd&amp;diff=9494&amp;oldid=prev</id>
		<title>Jeremyd: Edit via perl MediaWiki framework (1.13)</title>
		<link rel="alternate" type="text/html" href="https://secure.freeside.biz/mediawiki/index.php?title=Freeside:4:Documentation:Developer/bin/freeside-sqlradius-radacctd&amp;diff=9494&amp;oldid=prev"/>
				<updated>2015-11-18T15:46:08Z</updated>
		
		<summary type="html">&lt;p&gt;Edit via perl MediaWiki framework (1.13)&lt;/p&gt;
&lt;p&gt;&lt;b&gt;New page&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==NAME==&lt;br /&gt;
freeside-sqlradius-radacctd - Real-time radacct import daemon&lt;br /&gt;
&lt;br /&gt;
==SYNOPSIS==&lt;br /&gt;
&amp;lt;code&amp;gt;&lt;br /&gt;
  freeside-sqlradius-radacctd username&lt;br /&gt;
&amp;lt;/code&amp;gt;&lt;br /&gt;
==DESCRIPTION==&lt;br /&gt;
Imports records from an the SQL radacct tables of all sqlradius, sqlradius_withdomain and radiator exports (except those with the ignore_accounting flag) and updates the following fields in svc_acct (see [[Freeside:4:Documentation:Developer/FS/svc acct|FS::svc_acct]]) for each account: last_login, last_logout, seconds, upbytes, downbytes, totalbytes. Runs as a daemon and updates the database in real-time.&lt;br /&gt;
&lt;br /&gt;
'''username''' is a username added by freeside-adduser.&lt;br /&gt;
&lt;br /&gt;
==RADIUS DATABASE CHANGES==&lt;br /&gt;
In 1.7.4+, freeside-upgrade should have taken care of these changes already.&lt;br /&gt;
&lt;br /&gt;
ALTER TABLE radacct ADD COLUMN FreesideStatus varchar(32) NULL;&lt;br /&gt;
&lt;br /&gt;
If you want to ignore the existing accountg records, also do:&lt;br /&gt;
&lt;br /&gt;
UPDATE radacct SET FreesideStatus = 'done' WHERE FreesideStatus IS NULL;&lt;br /&gt;
&lt;br /&gt;
==SEE ALSO==&lt;/div&gt;</summary>
		<author><name>Jeremyd</name></author>	</entry>

	</feed>