Hi,
Is there a procedure to follow to ask for a new feature to be added?
I seem to have some sort of anomoly that sqltrace is active in my server
even though its not in debug mode. Thats not a big deal.
What I would like, though, is in src/modules/rlm_sql/sql.c for a
timestamp to prepend the sql output. I'm trying to track down the last time
a specific unit sent an accounting record, and I'd like to track it down to
a time. Unfortunately, the sql statement is :
UPDATE radacct SET framedipaddress =
'192.168.182.2', acctsessiontime = '4032',
acctinputoctets = '0' << 32 |
'4028824', acctoutputoctets = '0' << 32 |
'2535198' WHERE acctsessionid = '481f035100000001'
AND username = 'gasmac6' AND nasipaddress =
'192.168.50.35';
I realize I could add acctsessiontime to the original :
INSERT INTO radacct (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
('481f035100000001', 'dbbf6395a6c658d9', 'gasmac6',
'', '192.168.50.35', '1', 'Wireless-802.11', '2008-05-05
13:11:36', NULL, '0', '', '', '', '0', '0',
'00-16-01-D2-AE-F8', '00-13-02-B5-79-7C', '', '', '',
'192.168.182.2', '0', '0', '');
and come up with the time... But I'd prefer to have confirmation it was
4032 later in reality.
Thanks, Tuc
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
