On Fri, 23 Jul 2004 11:20:26 -0400, Alan DeKok <[EMAIL PROTECTED]> wrote: > "Mr. The Plague" <[EMAIL PROTECTED]> wrote: > > I'm using a braindeadish MSSQL billing program and I can't change the > > schema in the database lest it break massively. Unfortunately, the > > system requires a few things: > > > > * AcctSessionTime in MS-SQL date format > > * AcctTerminateCause as a numeric value > > I suggest poking at the source code to the server. These > requirements are specific enough that they won't be nuch use to anyone > else. >
Bleh. I'll just use the GETDATE() command in MSSQL - we don't really need the times the users are logged in, just the fact that they did log in, and their Input/Output octets :) > For the second requirement, just delete the "VALUE > Acct-Terminate-Cause..." lines from the dictionaries. Without names, > the server will print numeric values. > Thank you. Also, on a tangent, I'm noticing users just disappearing from the radutmp file after being logged in for an hour or so. These users are all on a cisco 7204 and are DSL users. Is this a known issue? I'll watch the packets for signs of stop requests from the router, and get back to the list, actually. > Alan DeKok. > mtp - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
