Network Management

Reply
Contributor I

Import CSV to Airwave Event Log Errors

Trying to import controllers into Airwave via CSV files.  CSV file is set up as follows:

Line 1:

IP Address,SNMP Community String,Name,Type, Auth Password,SNMPv3 Auth Protocol,Privacy Password,SNMPv3 Privacy Protocol,SNMPv3 Username,Telnet Username,Telnet Password,Enable Password,SNMP Port

Lines 2 thru 28

Comma delimited values matching those headings.

 

Error message is:  SNMPv3 Privacy Protocol: invalid value. SNMPv3 Auth Protocol: invalid value.  I set these values to match those in the Device Setup > Communication > SNMPv3 Informs User entry (MD5 and AES).

Contributor I

Re: Import CSV to Airwave Event Log Errors

Pretty sure I have this working.  The Auth Type and Privacy protocol appear to be case sensitive in the CSV file.

Moderator

Re: Import CSV to Airwave Event Log Errors

I attempted to do the same, and it worked for me.  here's a copy of what my csv looked like:

 

[root@airwave tmp]# cat controller.csv
IP Address,SNMP Community String,Name,Type,Auth Password,SNMPv3 Auth Protocol,Privacy Password,SNMPv3 Privacy Protocol,SNMPv3 Username,Telnet Username,Telnet Password,Enable Password,SNMP Port
10.10.10.137,public,,,snmp3user,md5,snmp3user,aes,snmp3user,,,,

 

I did cheat a little by using excel to generate the csv to make sure I had enough comma's to make the data line up.  I did try to type the data a few different ways and looks like it's case sensitive to using lowercase md5/aes which I'm filing a defect for.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company
Contributor I

Re: Import CSV to Airwave Event Log Errors

Interesting.  I did the same thing.  All collumn headers are the same.  I don't have all the stuff below it populated, just the IP, and SNMPv3 info (collumns1,6-9).  The first CSV import of about 40 controllers worked when I changed the MD5 and AES to lower case.  The 2nd and 3rd CSVs won't import at all despite being lower case.

Contributor I

Re: Import CSV to Airwave Event Log Errors

For all lines in CSV

Error parsing line 2 (IP x.x.x.x): Device ignored, or approved in wrong group/folder.

Moderator

Re: Import CSV to Airwave Event Log Errors

Can you do a check of the db to see if the other IPs already have entries?

 

# dbcsv "select id,name,state,ap_folder_id,ap_group_id from ap where apparent_ip='<conflicting IP>';"

If it does exist, you can delete or move the entry to the proper folder/group from the UI.  If it's in state=3, then you can delete from the db and then re-add manually or using the import from CSV.


Rob Gin
Senior QA Engineer - Network Services
Aruba Networks, a Hewlett Packard Enterprise Company
Search Airheads
cancel
Showing results for 
Search instead for 
Did you mean: