Adding a new MAC Vendor to macvendor table
To insert mac value in macvendor table:
insert into system.macvendor(prefix, vendor,hi, lo) values ('90:6C:AC','ARUBA NETWORKS', -1, -1);
Once done, import a macvendor pattern with expression set to ‘ARUBA NETWORKS’ (vendor name that you inserted with above sql) along with other profiling attributes.
<patterns xmlns="urn:lumeta:pattern:6.0" user-provided="true" version="220.127.116.1123">
<attribute type="Model" confidence="69">(Aruba Networks)</attribute>
<attribute type="OS" confidence="69">(Aruba Networks)</attribute>
<attribute type="DeviceType" confidence="83">Firewall</attribute>
<attribute type="Version" confidence="69">(Aruba Networks)</attribute>
<attribute type="Vendor" confidence="83">Aruba Networks</attribute>
When Discovery is not happening
- Check the /var/log/lumeta-webapp.out file and see if there are entries “skip adding devices”. These entries mean that your rescan interval for collector is too small and your collector is not able to finish up its discovery phase. In this case, you need to increase your collector’s rescan interval.
- If your CC is connected to a Scout, then check the CC <-> Scout connectivity:
1) Ping the Scout from CC to verify that we can ping the Scout (or to see if Scout is up and running and CC can get a response back from it). On CLI, run:
i. system ping <interface> <Scout IP> (please choose CC interface)
2) If ping returns you 0% packet loss, then try to delete and reconnect the scout back. On CLI, run:
i. esi delete <Scout name>
ii. esi connect <Scout IP>
3) If the above error is "ERROR: connect timed out" then we don't seem to have full connectivity between the CC and Scout. In this case, please send /var/log/discovery-agent.log file and /var/log/lumeta-webapp.out file to Lumeta.
When we cannot login to the Spectre CC box
- First thing to verify is that the license has not expired due to license IP count exceeding the limit. Login to your CC via console as root or login to your CC as admin user and then become root:
- type db to enter the database
- Run the query: select name, message, time, details, priority from event.notification_all where type like 'LICENSE%' order by time desc limit 1;
- This will show you if you got any warnings or alerts regarding license expiration. If so, then continue on and find the number of IPs that were discovered by your CC.
- select zone_id, count(distinct ip) from zone.device group by zone_id;
- That will show the number of devices in each zone
- To find the name of zone associated with the zone_id:
- select * from system.zone;
- to exit the database
- Please verify the number of IPs that your license was generated for by logging in to CLI and running the command: certificate spectre view. If your number of IPs have exceeded, contact Lumeta for further information.
When your VM runs out of disk space
If your Spectre CC VM is running out of disk space, there are certain tables in the database that can be cleaned up to make more space. Please login to your CC as admin and run “support db” or login to your CC as root from console and run “db” (in both cases, you will be entering database mode). Then execute:
- select count(*) from event.notification_all;
- truncate table event.notification_all;
- select count(*) from event.notification_all; ( just to confirm that we were able to delete all those records)
- select count(*) from event.event_all;
- truncate table event.event_all;
- select count(*) from event.event_all; (just to confirm that we were able to delete all those records)
When deleting a zone from GUI/CLI does not work (How to force deleting of a zone)
If for some reason, you cannot delete the zone via GUI or CLI (because it is timing out or resulting in an error), you will need to login to db and delete it
- Login to your CC as admin and then run support db (to enter database mode) OR Login to your CC and su to root. Then run db (to enter database mode)
- Find the zone_id associated with your zone by running select * from system.zone; This will give the name of the zones and their id. Then run the following commands based on your zone id.
- select * from zone_0023 config;
- drop schema zone_0023 cascade;
- delete from system.zone where id=35;
NOTE: In the above example, even though the zone id is 35, in hex it becomes 0023.
How to manually disable NTPD on Spectre boxes
Here are the manual steps to disable NTP for ESI:
1. Log into the CLI as admin (or any superuser)
2. Get a bash shell using command "support bash"
3. Become root by running "su" and giving the root password
4. Stop the NTP daemon: "service ntpd stop"
5. Make sure daemon won't be started on reboot: "chkconfig ntpd off"
How to verify open ports for a device (similar to how Spectre verifies)
Command to check if port on a device is open. From command center
a. echo "foo\n\n" > /dev/tcp/ip/port
b. You'll get 3 types of responses: Connection refused, timeout (or hang), and finally a successful connection displayed by line return.
c. When we get a "Connection timed out" reply, we consider that port to be neither open or closed.
d. When we get a "Connection refused" reply from a port, we consider that port to be closed.
e. When we get a "Connection success" reply from a port, we consider that port to be open.
f. If a port comes up as open and later on we get a "Connection timed out" reply from that port we do not clear up that port from open port list. This is the functionality in ESI 3.2.6 and prior. (ESI 3.2.7 will introduce a data retention policy that will allow clear up data based on the reply that we get back).
How to change Spectre’s hostname
- On a CentOS box, hostname comes from /etc/sysconfig/network. You can display the hostname by running the command: hostname
- Spectre prompts user for a host name during postinstall. This is saved in the db at system.system table. When user runs “system hostname” command at CLI prompt, the above is retrieved and displayed.
If for some reason, the hostname under database and application filesystem is not in sync, then you will need to reboot the system.
In more depth, here's a bit more about the two names, how to see them, and how you might change them (these assume you're at a root shell prompt)
- Edit the file /etc/sysconfig/network and change the HOSTNAME= line. Restart network: service network restart” for the hostname to be changed.
- Run "hostname <new host name>" to make the change immediately (otherwise CentOS would pick it up next time the network restarts)
- Run at bash prompt: sudo -u postgres psql observer -c 'select name from system.system'
- hostname will be displayed. This can be changed manually:
- sudo -u postgres psql observer -c "update system.system set name='<new system name>' where name='<old system name>'"
All these changes should occur automatically via the "system hostname" CLI command, but that's where you can look if that doesn't work out.
How to disable PKI from bash prompt
As root, run the command: /usr/local/lumeta/bin/observer_pki enable false