DIATOR] Migrate Cisco CAR MCD database to Radiator
Hello Rohan,
We have tools to migrate data from Cisco ACS database dumps.
If you send us a database dump that includes a couple of tests entries, we can
test if our tools works with Cisco CAR too.
Best Regards,
Sami
On 24/08/16 00:07, rohan.
Hello,
Has anyone ever migrated from Cisco CAR radius to Radiator
I need to dump userlist tables from Cisco CAR database for migration to
Radiator but cannot find any documentation even from Cisco website.
Thanks.
Rohan
___
radiator mailing list
Thanks Heikki.
Will let you know.
Rohan
On Thu, Mar 27, 2014 at 2:00 PM, Heikki Vatiainen wrote:
> On 03/27/2014 05:27 AM, rohan.henry @cwjamaica.com wrote:
>
> > We use radlogin radius test tool. It sends auth request using username
> > and password and measures
, Mar 21, 2014 at 2:33 PM, Heikki Vatiainen wrote:
> On 03/19/2014 09:21 PM, rohan.henry @cwjamaica.com wrote:
>
> > How can I monitor Radiator's response time when using NAS Port ID
> > instead of username for authentication?
>
> Hello Rohan,
>
> can you describ
Hello,
How can I monitor Radiator's response time when using NAS Port ID instead
of username for authentication?
Rohan
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
since the new Acct-Session-Id will
not allow a database match.
Rohan
On Wed, Feb 19, 2014 at 3:40 PM, Heikki Vatiainen wrote:
> On 02/19/2014 09:22 PM, rohan.henry @cwjamaica.com wrote:
>
> > How can fix an issue where the DeleteQuery statement in my Sessions DB
> > config del
Hello,
How can fix an issue where the DeleteQuery statement in my Sessions DB
config deletes the row for a new active session because of a delayed Stop
record?
Scenario:
1. A session is up (and row entered in the database for active session)
2. The session is dropped because of a premature disco
Please ignore.
I was able to resolve using the individual variable.
to_date(’%e %m %Y %H:%M:%S’, ’DD MM HH24:MI:SS’)
Rohan
On Tue, Jan 7, 2014 at 7:34 PM, rohan.henry @cwjamaica.com <
rohan.he...@cwjamaica.com> wrote:
> Can the TO_DATE be used with AddQuery like below?
>
Can the TO_DATE be used with AddQuery like below?
AddQueryinsert into ACTIVE_SESSIONS \
(USER_NAME,NAS_IP_ADDRESS,NAS_PORT,ACCT_SESSION_ID,ACCT_START_TIME,FRAMED_IP_ADDRESS,
\
NAS_PORT_TYPE,SERVICE_TYPE) \
values \
('%U','%{NAS-IP-Address}','%{NAS-Port}','
Heikki,
Thanks. It works!
DBSource dbi:Oracle:sid=xe;host=192.168.1.10;port=1521
But it wouldn't work until I specified the port number even though its the
default.
Rohan
On Tue, Jan 7, 2014 at 7:13 AM, Heikki Vatiainen wrote:
> On 01/07/2014 01:59 PM, Hartmaier Alexander wrote:
>
> >> T
14-01-03 00:14, rohan.henry @cwjamaica.com wrote:
>
> Hello,
>
> How is a non default port specified when connecting to a remote Oracle
> server? Thanks.
>
> DBSource dbi:oracle:server
> DBUsername
> DBAuth
>
> Rohan
>
> The Oracle InstantClient configu
Hello,
How is a non default port specified when connecting to a remote Oracle
server? Thanks.
DBSource dbi:oracle:server
DBUsername
DBAuth
Rohan
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
tabase NULL
>
> Note: NULL is not a command or configuration, but an Identifier.
>
>
>
>
>
> On 29/11/13 04:50 PM, rohan.henry @cwjamaica.com wrote:
>
>
> Hello,
>
> I have configured a Handler clause to proxy Radius requests to a remote
> server. Why is Radia
Alan,
The change did take effect since the logs show that requests are being sent
to the remote server.
On Fri, Nov 29, 2013 at 5:10 PM, wrote:
> Hi,
>
> how did you restart the server? its likely the parent didnt die
> and the new config isnt actually being used.
>
> alan
>
__
I do it like this:
>
> Identifier NULL
>
>
> then in your handler, specify :
> SessionDatabase NULL
>
> Note: NULL is not a command or configuration, but an Identifier.
>
>
>
>
>
> On 29/11/13 04:50 PM, rohan.henry @cwjamaica.com wrote:
>
>
Hello,
I have configured a Handler clause to proxy Radius requests to a remote
server. Why is Radiator processing one of my sessions database
configuration even though I have not specified one under the Handler. The
SessionDatabase entry is commented out.
See sample config below.
# AddToRequest
f $zone;
> $req->change_attr('uid', $uid) if $uid;
> $req->change_attr('auth-un', $authed_un) if $authed_un;
>
> &main::log($main::LOG_DEBUG, "$script_name: loading csv values
> from Class into their own attributes:
> [zone=$zone,uid=$u
u just want to save 1 value in the Class, and later log
> the Class value, no Hook should be needed.
>
>
> Mike
>
>
> On 26/11/13 02:20 PM, rohan.henry @cwjamaica.com wrote:
>
> Thanks Hugh.
>
> I am already seeing the attributes using trace 4. Just exploring other
S, and “Timestamp” which is internal to Radiator.
>
> Have a look at a trace 4 debug to see exactly what you are receiving in
> the RADIUS accounting requests.
>
> regards
>
> Hugh
>
>
> On 26 Nov 2013, at 08:26, rohan.henry @cwjamaica.com <
> rohan.he...@cwjamaica.
een “Event-Timestamp” as shown below
> which may be sent by the NAS, and “Timestamp” which is internal to Radiator.
>
> Have a look at a trace 4 debug to see exactly what you are receiving in
> the RADIUS accounting requests.
>
> regards
>
> Hugh
>
>
> On 26 No
Hello,
Are values for any of the foll. attributes automatically stored somewhere
in Radiator where they can be fetched anytime during or at the end of the
session? For example the Timestamp attribute.
If not, how can I store values for use later in or at the end of the
session?
Attributes:
Thanks Hugh.
On Tue, 28 May 2013 09:02:53 +1000
Hugh Irvine wrote:
>
>Hello Rohan -
>
>All of the Radmin code uses the current table names, so you can't really
>change them.
>
>Depending on your database you may be able to use some form of synonym for the
>table names to add whatever you want.
Hello All,
Can Radmin be installed with my own database schema (e.i. my own table_names)?
Or must I conform to the database schema in Radiator sample files for Radmin to
work properly?
Thanks.
Rohan
___
radiator mailing list
radiator@open.com.au
http
Inline comments below.
On Wed, 22 May 2013 17:35:35 +1000
Hugh Irvine wrote:
>
>Hello Rohan -
>
>You can do this more simply by only processing stop records and subtracting
>the Acct-Session-Time from the Timestamp to get the start time.
>
>This can be done directly in the SQL statement.
Yes.
Heikki,
Sample records below include one row per session (I haven't yet been able to do
a proper conversion of epoch time to date for the START_TIME).
+---+---+-++---+
| USER_NAME | NAS_PORT | ACCT_START_TIME | ACCT_ST
Hello All,
Can Radmin work in an environment where Radiator writes a single record
(containing both Start and Stop fields) to MySQL for each session as oppose to
two records per session?
Rohan
___
radiator mailing list
radiator@open.com.au
http://www.
Hugh,
Oh yes! I could isolate one of the clients (BRAS).
As I read your suggestion I realize that I could configure Radiator to use our
current database as a session and accounting database and then modify only a
single client to point to Radiator (removing NavisRadius servers). That way I
am
Agreed. The ultimate plan is to use a session database. But for now I need to
integrate Radiator into our current platform using the easiest and simplest
approach. I am also exploring options for configuring NavisRadius to use a
session database instead of USS. So whichever I am able to accompli
The plan is to replace NavisRadius but want to integrate Radiator into the
production environment as a test run.
NavisRadius servers are configured to use a USS (NavisRadius Universal State
Server installed on a separate server). I was hoping to get Radiator to use the
USS. Eventually we would
Hello,
I want to integrate Radiator into my NavisRadius production platform. How can I
configure Radiator to use NavisRadius USS? Thanks.
Rohan
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
Thanks Hugh.
I thought about using the %A but wanted to explore other options since I was
already processing the Accounting Stop. But I will explore using the Accounting
Start with options for updating the database record with the Accounting Stop
time when a session ends.
On Sat, 9 Mar 2013 18
Hello,
How can I get the following to insert date into my database in the format "Mar
9, 2013 01:52"
AcctColumnDef ACCT_START_TIME,%b-0%{Acct-Session-Time},literal
Thanks,
Rohan
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/
Thanks Hugh. It's working now!
The Socket6.pm module needed to be installed.
Tue Nov 6 09:28:28 2012: DEBUG: Handling request with Handler
'NAS-Identifier="Juniper_E320_2"'
Tue Nov 6 09:28:28 2012: DEBUG: SQLSDB Deleting session for fritzsamuels1,
208.138.43.125, 805307373
Tue Nov 6 09:28:28
Hugh,
re: server crash see config and log files attached.
Rohan
On Sat, 3 Nov 2012 09:06:44 +1100
Hugh Irvine wrote:
>
>Hello Rohan -
>
>The easiest way to do this is to store only the Stop records, and calculate
>the start time from the attributes present in the accounting stop request.
>
>S
Thanks. That technique works! Except that I used below.
ACCT_START_TIME,%b-0%{Acct-Session-Time},literal
The field is NULL if I used type integer-date (below).
mcatra1 | Juniper_E320_2 | 805307373 | 208.131.170.180 | NULL
| Nov 2, 2012 18:35
Regards,
Rohan
On Sat, 3 Nov 201
Hugh,
So does it mean that I wouldn't need to process the Start record as defined by:
HandleAcctStatusTypes Start,Stop?
And in this way a session only gets inserted into the database only if the Stop
record is processed?
On Sat, 3 Nov 2012 09:06:44 +1100
Hugh Irvine wrote:
>
>Hello Rohan -
>
Hugh,
After some additional advice I realize that how Radiator adds the the records
makes perfect sense. Since I have the option of inserting Interim records as
well.
So you can ignore.
But I would still would like to know why Simultaneous-Use or Maxsessions does
not work and crash the applic
Hugh,
Now that records are being written to the database, I want a single record per
session that includes both Stop and Start times like below.
User_Name, NAS_IP_Address, NAS_Port, Framed_IP_Address, Acct_Start_Time,
Acct_Stop_Time, Acct_Session_ID
jwilliams12 208.138.43.123 805306450 72.27.33
Thanks Michael,
I was able to go further with the advice using the AuthByPolicy and AuthBy
GROUP under the existing Handler. Only that two records are added to my
accounting database for a single session - one at Start and one at Stop.
AddToRequest SERVICESTATUS = ACTIVE
Sess
Hugh,
Config and logs attached.
And the application crashed when testing Simultaneous-Use for both
configurations below.
In my AuthBy config:
"DefaultSimultaneousUse 1" With "AuthAttrDef
Simultaneous-Use,Simultaneous-Use,check"
Or
In my Handler:
MaxSessions 1
On Fri, 2 Nov 2012 07:19
Hello,
Why doesn't the following work?
Identifier SQLAccounting
DBSource dbi:mysql:inetdb_test
DBUsername inet
DBAuth inet@inetdb
#Disable SQL authentication
AuthSelect
HandleAcctStatusTypes Start,Stop
AccountingTable ARCH_ACCOUNTING
AcctColumnDef USER_NAME,User-Name
AcctColumnDef ACCT_START_TIM
Thanks Kiernan.
On Tue, 16 Oct 2012 01:24:34 +
Kiernan McColl wrote:
>Hi Rohan,
>
>I'd suggest looking in the 'goodies' directory that comes with Radiator. There
>should be some example scripts in there that you could rip bits out of to send
>a radius packet somewhere.
>
>Although I can't
Thanks much Hugh.
On Thu, 18 Oct 2012 09:26:22 +1100
Hugh Irvine wrote:
>
>Hello Rohan -
>
>What I described was one typical way it is done automatically, but obviously
>other methods are possible.
>
>regards
>
>Hugh
>
>
>On 18 Oct 2012, at 02:49, wrote:
>
>> Thanks Hugh.
>>
>>
>> Oh Yes! I
Thanks Hugh.
Oh Yes! I recall there was discussion around tracking usage via interim
accounting. But its an external system (linked to our billing system) that will
monitor user sessions for usage thresholds and initiate the COA as well as
modify the user profile in LDAP temporarily should a u
Thanks Hugh,
I will pass on your hello to Elon :). Seems like a bit of configuration.
Are you confirming that Interim-Update is required for COA?
And how is COA triggered from the Billing/Provisional system?
Is COA described anywhere in the RADIATOR documentation?
On Tue, 16 Oct 2012 13:22:48 +1
Michael.
Thanks much for the start. I am going to do some further reading to see what i
can come up with. I must also confirm COA support on our Juniper E320 NAS
devices.
Rohan
On Mon, 15 Oct 2012 13:34:38 -0400
Michael wrote:
>
>This was the hardest thing to get working and automated for m
Hello all,
I do not see any info on the captioned in the Radiator documentation. Where do
I go to see details on implementing COA?
Thanks.
Rohan
___
radiator mailing list
radiator@open.com.au
http://www.open.com.au/mailman/listinfo/radiator
47 matches
Mail list logo