Search Again: realms and usage import From: Ryan Ghering Date: Wednesday, November 3, 2004 Time: 10:51:49 am The "official" Optigold ISP forum has moved: http://forums.digitalpoint.com/forumdisplay.php?f=29 ---------------------------------------------------- We are haing trouble with usage imports now that we have started using realms on our radius server. our import statement is SELECT username OR username,count(username),sum(acctsessiontime),(sum(acctoutputoctets)/1000000) FROM radacct WHERE acctstarttime > '<Y1>-<M1>-<D1>' AND acctstoptime <= '<Y2>-<M2>-<D2>' GROUP BY username; We are using freeradius, however when a user logs in with a realm they show no usage in optigold. what can we do to fix this? Thank you Ryan Ghering --------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.optigold.com/lists/isp.html ---------------------------------------------------

Messages In This Thread: realms and usage import by Ryan Ghering on Nov 3, 2004 at 10:51:49 am