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="22.214.171.12423">
<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>
- 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:
- system ping <interface> <Scout IP> (please choose CC interface)
- If ping returns you 0% packet loss, then try to delete and reconnect the scout back. On CLI, run:
- esi delete <Scout name>
- esi connect <Scout IP>
- 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.
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)
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.
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"
Command to check if port on a device is open. From command center
- echo "foo\n\n" > /dev/tcp/ip/port
- You'll get 3 types of responses: Connection refused, timeout (or hang), and finally a successful connection displayed by line return.
- When we get a "Connection timed out" reply, we consider that port to be neither open or closed.
- When we get a "Connection refused" reply from a port, we consider that port to be closed.
- When we get a "Connection success" reply from a port, we consider that port to be open.
- 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).
- 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.
As root, run the command: /usr/local/lumeta/bin/observer_pki enable false
- Make a copy of the grub.conf file
- cd /etc
- cp grub.conf grub.OLD
- Edit the grub.conf file
- vi grub.conf
- change fips=1 to fips=0
- Reboot system
|title||Essential links . . .|