RDBMS Synchronisation on ACS 3.2 appliance

[luc.vanacker]

Hello,

It seems that synchronisiation does not work, I have setup an FTP server and put an "accountactions.csv" file into it.

The ACS downloads the file (the file is renamed into accountActions.csv.downloaded) but there is no action taken.

hereafter the content of the file:

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

1;0;luc;;100;;luc;;;01/01/2004;;;;

2;0;luc;;102;;passw;;;01/01/2004;;;;

Any Idea ??

thanks

Luc

[vimal1980]

HI!

The Below Link WIll help you much.

http://www.cisco.com/univercd/cc/td/doc/product/access/acs_soft/csacsapp/user/sad.htm#451762

HTH.

Rgds

Vimal

[mmccallebaut]

Hi,

I don't know if you found the solution yet but hereunder you can find the right syntax of the accountAction.csv file:

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

1,0,luc,,100,,luc,,,,0,,,0

2,0,luc,,102,,passw,,,,0,,,0

This will result in adding user "luc" with the initial password "luc" and setting the PAP password for user "luc" to "passw".

I hope this will do the trick.

I think that field 11 (MessageNo) and 15 (Status) are

necessary to excecute RDBMS.(although on CCO they only say that field 1 SequenceID , field 5 Action and

field 10 DateTime are not to be empty !)

Good luck !

Kind regards,

Mike