ACS - adding access restrictions using RDBMS

[liamkennedy]

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.

[darpotter]

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

[liamkennedy]

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="*`"]