31

Mar

2020

Gitlab API and Python

March 31, 2020 jonny python

To start, create a config file with your Gitlab personal token: vi ~/.python-gitlab.cfg With contents similar to below: default = gitlab ssl_verify = true timeout = 5 url = https://gitlab.com private_token = 1234ABCD1234ABCD... » More

21

Feb

2020

Chef Beginner First Cookbook

February 21, 2020 jonny configuration management

I wanted to play around with Chef locally for testing pulling encrypted variables from data bags. Prerequisites ChefDK (includes chef-solo) Encryption Create a Cookbook: chef generate cookbook "firstcookbook" Data Bags Create the... » More

11

Feb

2020

Chef Knife List Nodes with IPs

February 11, 2020 jonny Uncategorized

I had to fiddle a bit with this so possibly worth keeping a note of it. I wanted to pull all the node hostnames and ip addresses from chef for use in hostname lookups and ssh config. knife exec -E 'nodes.find("*:*") {|n| printf "%s - %s \n",... » More

04

Jan

2020

Resetting MySQL root password on newer MySQL 5.7

January 4, 2020 jonny mysql

In newer versions of MySQL it looks like the 'Password' field has been replaced with the 'authentication_string' field so older instructions online may not work. Stop the currently running MySQL service: systemctl stop mysql Start mysql... » More

02

Jan

2020

LHT65 setup and UART Serial Connection

January 2, 2020 jonny IoT

I wired a CP2102 USB to TTL Serial Converter to the LHT65 UART connector - see images below: Then on the linux command line ran: dmesg | tail to check the device name that was added by the system. I then connected to that serial device... » More

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