 |  |
We are running 2.5.something...
Re: SQL hook
From: Luke Skidmore
Date: Thursday, June 7, 2001
Time: 11:38:46 am
If I remember right if you add a column of ConnectInfo (nvarchar255) in your calls table it will then propagate it with the connection speed. We have portmasters that it works great with but it doesn't work with our AS5400. It is kind of cool info to have. Might want to check IEA listproc for the specifics, but it _may_ work.
Luke
----------
Luke Skidmore
lskidmore@rathis.com
Rath Information Systems
2access.net Technical Support
937.593.1911
---------- Original Message ----------------------------------
From: <mbailey@journey.net>
Reply-To: "Optigold ISP List" <isp-list@optigold.com>
Date: Thu, 7 Jun 2001 14:08:12 -0400 (EDT)
>Looks alot like mine :) I figured that out yesterday :)
>
>However I don;t seem to hae ConnectInfo in my fields.. Which version of
>RadiusNT are you using?
>
>--Matt
>
>On Thu, 7 Jun 2001, Luke Skidmore wrote:
>
>>
>> For those using msSQL (I am using IEA RadiusNT), you can just get the time separated using SQL statements. Below is what we are using if anyone wants it...
>>
>> SELECT CallDate, CONVERT(char(8), CallDate, 114), AcctSessionTime, ConnectInfo, FramedAddress
>> FROM calls
>> WHERE UserName = '<Login>' AND AcctStatusType = '2'
>> ORDER BY CallDate DESC
>>
>> ----------
>> Luke Skidmore
>> lskidmore@rathis.com
>> Rath Information Systems
>> 2access.net Technical Support
>> 937.593.1911
>>
>>
>>
>> ---------- Original Message ----------------------------------
>> From: "Flash" <flashl@bigfoot.com>
>> Reply-To: "Optigold ISP List" <isp-list@optigold.com>
>> Date: Tue, 5 Jun 2001 01:27:17 -0400
>>
>> >I have succeeded in parsing the date/time stamp, I created a view that
>> >contains the format 'YY-MM-DD'; the problem is OG passing the single digit
>> >month vs the double digit month in the query to the SQL database.
>> >
>> >Regards,
>> >Flash
>> >
>> >----- Original Message -----
>> >From: "Shawn Hogan" <shawn@digitalpoint.com>
>> >To: "Optigold ISP List" <isp-list@optigold.com>
>> >Sent: Monday, June 04, 2001 11:00 PM
>> >Subject: Re: [Optigold ISP] SQL hook
>> >
>> >
>> >> Flash wrote:
>> >>
>> >> > Why would we need the JSQL plug-in?
>> >>
>> >> So that you can talk to your SQL database(s).
>> >>
>> >>
>> >> > We are using accounting information from VOP Radius that stores logdate
>> >as
>> >> > 'YYYY-MM-DD HH:MM' in Oracle.
>> >>
>> >> Next version I'm going to see about adding support for the date/time stamp
>> >> field types instead of them being in separate fields.
>> >>
>> >> - Shawn
>> >>
>> >> -------------------------------
>> >> Shawn D. Hogan
>> >> President, Digital Point Solutions
>> >> http://www.digitalpoint.com
>> >> (858) 452-3696
>> >>
>> >>
>> >> ---------------------------------------------------
>> >> To subscribe, unsubscribe or to search list archive
>> >> please visit http://www.optigold.com/lists/isp.html
>> >> ---------------------------------------------------
>> >>
>> >
>> >
>> >---------------------------------------------------
>> >To subscribe, unsubscribe or to search list archive
>> >please visit http://www.optigold.com/lists/isp.html
>> >---------------------------------------------------
>> >
>>
>>
>> ---------------------------------------------------
>> To subscribe, unsubscribe or to search list archive
>> please visit http://www.optigold.com/lists/isp.html
>> ---------------------------------------------------
>>
>
>
>---------------------------------------------------
>To subscribe, unsubscribe or to search list archive
>please visit http://www.optigold.com/lists/isp.html
>---------------------------------------------------
>
---------------------------------------------------
To subscribe, unsubscribe or to search list archive
please visit http://www.optigold.com/lists/isp.html
---------------------------------------------------
Messages In This Thread:
Return to Digital Point Solutions' Home Page