Search Results

Install rpi-clone is on github and is downloaded by cloning the repository. It is a standalone script and the install is a simple copy to a bin directory. When run it checks its program dependencies and offers to install needed packages. But currently rpi-c...

/* This will delete all old XML messages and events older then 5 days SFL 2008-11-29 Created Status 1 FAILED 3 Sucessfull 6 History */ delete from infbigtext where foreignId <> 1 and lastchanged < dateadd(d,-5,getdate()) and foreigntype lik...

Summary This is to setup a logging server to capture logs from any servers on your network. Prerequisites Install of a RedHat or Rocky Linux minimal install Configuration You will need to edit the file "/etc/rsyslog.conf" Editing the file vi /etc/rsyslo...

/* Search and replace for the ESP database and its folders Created By : SFL 08/13/23 Modified By : SFL 08/21/24 Use at own risk */ USE ESP_DEV; /* select * from infParameter where value like '%/%' select * from infPlantValue where value like '%...

/* Delete users from ESP which do not exist in Active Directory Created By : Steve Ling 2024/03/07 The user name is the name from the SAM account in ADD Or if you do the following select select name from infuser */ Declare @username nvarchar...

/* Script to auto add finacial year and its periods if they are missing Created By : Steve Ling 2024/03/02 You may have to change the stating year depending on your finacial year and periods */ GO Declare @y nvarchar(4), @yid int, @ly nvarchar(...

/* This script will add Notifications to all active companies Please run in SQLAgent every 15 minutes. Modified Steven F Ling 2019-11-27 Modified Steven F Ling 2023-08-14 */ DECLARE @companyid INT DECLARE @name VARCHAR(100) DECLARE @regionName VARC...

/************************************************ This script is to delete PD that do not have Orders on them and are in import status 20140207 Steven F Ling created 20230401 Steven F Ling Modified Changed for the new Database structure ********...

/* This will delete all old XML messages and events older then 5 days SFL 2008-11-29 Created Status 6 = history 5 = 4 = processing 3 = success 2 = pending 1 = failed 0 = created */ delete from infbigtext where foreignId <> 1 and lastch...

/* This is to kill off any connection to a database Created by : Steve Ling 2022/03/20 */ --This script will kill when ran USE MASTER GO DECLARE @Spid INT DECLARE @ExecSQL VARCHAR(255) DECLARE KillCursor CURSOR LOCAL STATIC READ_ONLY F...

Server Health Commands Check TLS openssl s_client -connect <IP_ADDRESS>:8443 -tls1 nmap -sV --script ssl-enum-ciphers -p 8443 <IP_ADDRESS> Connections onto Server netstat -anp |grep 'tcp\|udp' | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n ...

1. Getting the required software For an SSL encrypted web server you will need a few things. Depending on your install you may or may not have OpenSSL and mod_ssl, Apache's interface to OpenSSL. Use yum to get them if you need them.   yum install mod_ssl op...

The only thing that you need to do do to deploy to Linux is too change the target runtime setting. This allows for the deployment to add the specific files to the folder.

Introduction This is to prep the Linux server to host Visual Studio code. This is for either RedHat or Rocky Linux installations.  For this configuration were are installing on a Rocky Linux server. Preparation Make sure that the server is up to date dnf...

If you are starting to migrate your web servers over to Linux (or have already done so) and are looking to serve those pages up over secure http (aka https), you're going to need to know how to make this happen. Although https does will not guarantee security ...

This guide will explain how to set up a site over https. The tutorial uses a self signed key so will work well for a personal website or testing purposes. This is provided as is so proceed at your own risk and take backups! 1. Getting the required software F...

dotnet tool install --global dotnet-efdotnet ef migrations add CreateInitialdotnet ef database update//https://www.youtube.com/watch?v=Fbf_ua2t6v4 Scaffold dotnet ef dbcontext scaffold "Data Source=mfb-us-sql-001;Initial Catalog=MyFFLBookAPI;TrustServerCerti...

Try resetting the Windows Update Agent by running these commands from an elevated command prompt: net stop wuauserv rd /s /q %systemroot%\SoftwareDistribution net start wuauserv Reset Windows Update components manually Open a Windows command prompt. T...

Unfortunately when there is no room on the disk to convert the drive from basic to dynamic. Microsoft documents the problem, and notes the solution is to delete the last partition on the disk: Not Enough Space Available to Upgrade to a Dynamic Disk RESOLU...

Example of simple bash script ftp client This script first defines variables such as hostname of the ftp server, username and password and then it creates an ftp session and uploads the specified file into your selected directory: #!/bin/bash ftp_site=127...