cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1080
Views
0
Helpful
2
Replies

ACS v3.2 RDBMS import

STEFAN KLUEPPEL
Level 1
Level 1

hi,

we are using Cisco Secure ACS v3.2 installed on a Win2k US-Server,using a MS-ODBC Driver

and want to import userprofiles via RDBMS.

We imported a user like in the example of UserGuide

1;remark SequenceID,Priority,UserName,GroupName,Action,ValueName,Value1,Value2,Value3,DateTime,MessageNo,ComputerNames,AppId,Status

2;0;testuser05;group 5;100;;foobar;;;26/08/1998 00:00;0;;;0

With this line a user testuser05 is added in CSDB sorted to group 5 and pwd foobar.

So far so good.

Now we want to add specific radius attributes.

When we try to add the cisco specific av-pair (026/009/001)attribute (eg. addr-pool=pool2)

like shown in UserGuide, we get an Error/parsing message in RDBMS-Reports

"Parse Error:Reason - Unknown attribute name [SI=3 A=163 UN="testuser05" GN="" AI="" VN="26" V1="addr-pool=pool2" V2="9" V3="1"]

(we have increased logging to full) and no input in the field of the user (009/001).

We tried following:

3;0;testuser05;;163;26;addr-pool=pool2;9;1;26/08/1998 00:00;0;;;0

What is wrong in this syntax ?

or is there something specific to configure in the ODBC driver settings ?

Thx for help in advance.

Stefan Klueppel

2 Replies 2

jsivulka
Level 5
Level 5

Did you use the Radius Attribute name in the VN field? It seems that doing this is necessary.

hi,

yes, indeed, the VN has to be fulfilled correctly.

Thank you!

Stefan