Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

ACS - adding access restrictions using RDBMS

I'm trying to setup IP-based network restrictions for users on my ACS server. This is easy enough to do manually but i want to add these via RDBMS and the accountactions.csv file.

my problem is the documentation suggests the following:

"V1 should contain a single (AAA client name, AAA client port, remote address, CLID) tuple; for example:

NAS01,tty0,0898-69696969"

now how exactly do you place a value with commas in it into a comma-seperated file? If I try it the ACS server (understandably) throws up a parse error.

2 REPLIES
Silver

Re: ACS - adding access restrictions using RDBMS

You can enclose the field in quotes:

value1, value2, "value3a,value3b",value4

Should then work fine. Depending on locale you may need to use single quote.

Darran

New Member

Re: ACS - adding access restrictions using RDBMS

I've tried

30,0,username,,122,,"nasname,*,*",,,,,0

this gives a parse error:

Error: ACS 'server' Action failed [SI=30 A=122 UN="username" GN="" AI="" VN="" V1="nasname * *" V2="" V3=""] Reason: - The named user variable cannot be found

and

30,0,username,,122,,'nasname,*,*',,,,,0

this is just ignored and no action is processed.

and

30,0,username,,122,,`nasname,*,*`,,,,,0

which gives:

Parse Error: Reason - Value has incorrect format [SI=30 A=122 UN="username" GN="" AI="" VN="" V1="`nasname" V2="*" V3="*`"]

145
Views
0
Helpful
2
Replies
CreatePlease to create content