Skip to main content

Recently Updated Pages

MsSQL - Backups

Database Toolset

Introduction This is to create auto backups on a SQL server and place them on a drive. Credits ...

Updated 3 hours ago by Steve Ling

MySQL - Cannot use select on user table

Database Toolset

ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or ...

Updated 19 hours ago by Steve Ling

MySQL - Parameters Explained

Kiwiplan

performance_schema = ON tmpdir = /run/mariadb thread_cache_size = 4 table_open_cache = 16384 ...

Updated 1 week ago by Steve Ling

Linux Server - Install RedHat 9.4

Kiwiplan

Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details...

Updated 2 weeks ago by Steve Ling

Linux Server - Install RedHat 8.6

Kiwiplan

Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details...

Updated 2 weeks ago by Steve Ling

Linux Server - Install Rocky 9.4

Kiwiplan

Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details...

Updated 2 weeks ago by Steve Ling

Pi-Hole - Adding blocklist urls to the Gravity DB from the command-line

All Others Stuff

This is to add block list to the Gravity DB from the command line from a text file. You will nee...

Updated 3 weeks ago by Steve Ling

PiHole - Synology Configuration

Docker

This is to create a MAC vlan on you synology to bridge interfaces You will need to create the fo...

Updated 3 weeks ago by Steve Ling

ImageMagick - Install on Redhat 9 from Source

All Others Stuff

Installing ImageMagick 7 from Source Code To install ImageMagick from source, you need a proper ...

Updated 3 weeks ago by Steve Ling

Linux - Increase the size of a LVM Partition

Linux

This will cover how to increase the disk space for a VMware virtual machine running Linux that is...

Updated 3 weeks ago by Steve Ling

SQL - Blocking Process

Database Toolset

These scripts are using to help how to determine what is blocking process are occurring. SELECT ...

Updated 1 month ago by Steve Ling

MailServer - Test SMTP

All Others Stuff

Your best, easiest and most globally available tool: telnet or Windows CMD At command prompt, ...

Updated 1 month ago by Steve Ling

SQL - Try Catch Rollback

Database Toolset

BEGIN TRY BEGIN TRANSACTION; -- SQL statements that are part of the transaction ...

Updated 1 month ago by Steve Ling

MsSQL - Restore Agent Jobs from Another MSDB database

Database Toolset

This is to copy by specific Job --- ErangaMSDB is the copy of the old msdb --- DECLARE @JobID U...

Updated 2 months ago by Steve Ling

MsSQL - Restore Master/Model/MSDB

Database Toolset

Steps to Restore the master Database: Stop the SQL Server Instance: Open SQL Serv...

Updated 2 months ago by Steve Ling

Raspberry PI- Pi-Nut Network

All Others Stuff

Installing Network UPS Tools (NUT) version 2.8.3 from source on a Raspberry Pi 4 running Raspberr...

Updated 2 months ago by Steve Ling

Kiwiplan - Server Load Monitor

Kiwiplan

This script is based on this initial loadmon script This is to monitor specific objects at a Adv...

Updated 3 months ago by Steve Ling

Linux - Server Load Monitor Script

Linux

This is to monitor various objects on a given server and email notifications out when thresholds ...

Updated 3 months ago by Steve Ling

VMWare - Copy and Paste from Console to VM

All Others Stuff

On any Powered Off VM, click the "Advanced Parameters" tab. Click filter icon of Attri...

Updated 3 months ago by Steve Ling

Kiwiplan - KIDSENV Settings

Kiwiplan

MAXPROC=999 TERM=vt100 KIDSLOGDIR=$PLANT/tmpKIDSLOGMAX=1000000KIDSLOGLEVEL=-4 The KWSQL_LOG va...

Updated 3 months ago by Steve Ling