23

Dec

2019

Postgresql VACUUM and ANALYZE all tables in a database

December 23, 2019 jonny Uncategorized

The example below uses the database named netbox so change as needed. It gets a list of the tables in the database and for each one performs a full vacuum and analyze. There is probably a more efficient way to do this from the psql prompt but this is... » More

02

Dec

2019

Proxmox: adding internal private nework

December 2, 2019 jonny Uncategorized

In this scenario I wanted to be able to run several VMs that can communicate with each other on a private subnet e.g. 10.10.10.* and also be access the internet for updates etc. Eventually I want to expose some of the internal services. My proxmox... » More

22

Nov

2019

SELinux: Create Policy for NRPE Writing

November 22, 2019 jonny Uncategorized

Had a problem with Nagios/NRPE checks that are configured to write a status file as part of their check. The path /var/logstate was the target created the policy below. Andrew (Urban Penguin) Youtube video is an excellent resource. Install selinux... » More

12

Nov

2019

Nagios NRPE omreport errors

November 12, 2019 jonny Uncategorized

Nagios check for Dell OpenManage was failing after upgrade to srvadmin 9.2 with: UNKNOWN: Problem running 'omreport chassis memory': Error: SMStatus: 700 UNKNOWN: Problem running 'omreport chassis batteries': Error! XML Transformation failed UNKNOWN:... » More

05

Nov

2019

check_mk: Check http service

November 5, 2019 jonny check_mk

In the WATO menu choose 'Check Plugins' and then 'Networking checks without an agent'. Find the 'HTTP/HTTPS connection' option and then click on 'Check HTTP service' beside Parameter rule set: Scroll down to the bottom and click 'Create rule... » More

05

Nov

2019

check_mk: Check APT updates

November 5, 2019 jonny check_mk

On your check_mk install under the WATO menu navigate to 'Monitoring Agents' find and click on the link for 'Check for APT updates (Debian, Ubuntu)'. This is the check plugin to add to the server so copy that code. Copy the contents of that check... » More

04

Nov

2019

ThingsBoard API: Get telemetry values

November 4, 2019 jonny Uncategorized

I'm using Insomnia for testing and after already getting the auth token I use that in Insomnia as follows: The URL I used for the query... » More

04

Nov

2019

ThingsBoard API: Get Auth Token

November 4, 2019 jonny Uncategorized

The auth token will be required for future API requests. I did the following using the Insomnia REST client: As a curl command that would be: curl -X POST --header 'Content-Type: application/json' --header 'Accept: application/json' -d... » More

29

Oct

2019

Blink Hard Disk Light on Dell

October 29, 2019 jonny Uncategorized

To blink the light on a hard disk on Dell Server from the command line first get a list of the physical disks so you can check the disk ID: omreport storage pdisk controller=0 then to blink the disk: omconfig storage pdisk action=blink... » More

26

Oct

2019

check_mk: Emails Not Sent

October 26, 2019 jonny check_mk

On a CentOS 7 server with postifx already installed and working I found the emails from check_mk / OMD were not being sent. I needed a symlink for sendmail: ln -s /usr/lib/sendmail.postfix /usr/lib/sendmail Test with su - omduserecho... » More