Hi,
I would like to modify SQL accounting in order to :
- only Insert in RADONLINE for Alive packets and not Start packets (I am
using Cisco AS and IP is not present in Start but Alive packets)
- only Insert in ACCOUNTING for Stop packets where FRAMEDIPADDRESS is not
null. Sometimes, due to a problem between the terminal and the NAS, I have :
insert into ACCOUNTING
(USERNAME, TIME_STAMP, ACCTSTATUSTYPE, ACCTDELAYTIME,
ACCTINPUTOCTETS, ACCTOUTPUTOCTETS, ACCTSESSIONID, ACCTSESSIONTIME, NASPORT,
CALLINGID, CALLEDID)
values ('carrefour', 970845773, 'Stop', 0,
89, 137, '000000A7', 4, 3, '670487956', '6641')
Note : FRAMEDIPADDRESS is not present since it is NULL so I do not want and
insert query in that case.
Thanks in advance for your help. Gildas.
===
Archive at http://www.starport.net/~radiator/
Announcements on [EMAIL PROTECTED]
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
