From: Guyler, Rik (rguyler@shp-dayton.org)
Date: Mon Apr 10 2006 - 14:03:30 ART
That looks exactly like what you need. Don't ask me how to do it
though...looks like you almost have to be a SQL DBA to set that up.
Rik
-----Original Message-----
From: Jens Petter [mailto:jenseike@start.no]
Sent: Monday, April 10, 2006 12:35 PM
To: 'Guyler, Rik'; ccielab@groupstudy.com
Subject: RE: cisco acs 3.2 radius and external database
Hi again...
When looking at the documentation I am seeing a section called ODBC
Import
Definitions..
ODBC Import Definitions
http://www.cisco.com/en/US/products/sw/secursw/ps2086/
products_user_guide_ch
apter09186a008007dec0.html
Is this not what I am trying to do
-----Original Message-----
From: nobody@groupstudy.com [mailto:nobody@groupstudy.com] On Behalf Of
Guyler, Rik
Sent: 10. april 2006 18:21
To: 'ccielab@groupstudy.com'
Subject: RE: cisco acs 3.2 radius and external database
Yes, I did misunderstand you. You want to import user info from SQL
into
ACS...
I don't know a specific way to do this but if it's possible it will
probably
require the "csutil" utility.
Rik
-----Original Message-----
From: Jens Petter [mailto:jenseike@start.no]
Sent: Monday, April 10, 2006 11:59 AM
To: 'Guyler, Rik'; ccielab@groupstudy.com
Subject: RE: cisco acs 3.2 radius and external database
HI,
I think you missunderstud me... I am not looking to log to SQL, but to
import user information like username, group, chap and radius
attributes. I
am running on windows platform... This SQL database is again hooked
up to a
oline web based registration system where the customers orders the
lines...
Jens
-----Original Message-----
From: nobody@groupstudy.com [mailto:nobody@groupstudy.com] On Behalf Of
Guyler, Rik
Sent: 10. april 2006 17:40
To: 'ccielab@groupstudy.com'
Subject: RE: cisco acs 3.2 radius and external database
Jens, you didn't mention whether you had the ACS appliance or the
Windows
server version but it does make a difference for reporting and
logging. If
you have the Windows version, ACS can be setup for RADIUS accounting,
which
should include the parameters you listed. This information is dumped
into a
csv file on the ACS box and you should be able to move this over to SQL
with a small amount of effort. I don't believe ACS can be setup to
directly
push its data to a SQL DB but I could be wrong.
Rik
-----Original Message-----
From: nobody@groupstudy.com [mailto:nobody@groupstudy.com] On Behalf
Of Jens
Petter
Sent: Sunday, April 09, 2006 11:18 AM
To: 'Radioactive Frog'
Cc: ccielab@groupstudy.com
Subject: RE: cisco acs 3.2 radius and external database
Nice for you... Not what I was looking for though
-----Original Message-----
From: nobody@groupstudy.com [mailto:nobody@groupstudy.com] On Behalf Of
Radioactive Frog
Sent: 9. april 2006 16:38
To: Jens Petter
Cc: ccielab@groupstudy.com
Subject: Re: cisco acs 3.2 radius and external database
Hi,
I have been using the IC-Radius for 4 yrs without single break-down.
That
was a linux based system and very easy to integrate with mysql database.
Frog..
just an openion..................
On 4/10/06, Jens Petter <jenseike@start.no> wrote:
>
> Hi group.
>
>
>
> Question about cisco acs radius server. I am setting up a radius
> server which are going to authenticate vpn clients and assign them
> several radius attributes. This are framed ip address, framed netmask,
> framed protocol, service type and dns servers.
>
> I was hoping to set up a system where I could use a sql database or
> another database to enter in this information in where the acs servere
> could get them from. I am going trough the documentation but cant
> really find any information of how to do this. I can see that I can
> authenticate against a external database, but see nothing about
> importing this users and settings.
>
>
>
> Anybody that could provide me with this info if this is possible, and
> how??
>
>
>
> Jens Petter
>
> ______________________________________________________________________
> _ Subscription information may be found at:
> http://www.groupstudy.com/list/CCIELab.html
This archive was generated by hypermail 2.1.4 : Tue May 01 2007 - 08:28:38 ART