Advanced Search
Search Results
161 total results found
Linux - Re-Mapping Drives or Combining Drives
The document is walk you through the re-mapping or combining of mapped drives on a Linux server. This is to make the root drive aka "/" drive one drive to be able to use the space of the full drive. First you will have to look at the current setup sudo fdis...
Linux Server - Install Rocky 9.4
Summary Instructions on the install and configuration of a Linux server for Kiwiplan. Details Prerequisites VMware, KVM, Hyper-V machine to host the installation You will need to use the following command when you vi your files as you cut and paste: On...
Kiwiplan - KIDSENV Settings
MAXPROC=999 TERM=vt100 KIDSLOGDIR=$PLANT/tmpKIDSLOGMAX=1000000KIDSLOGLEVEL=-4 The KWSQL_LOG variable is a system-level setting in Kiwiplan that controls logging options for the SQL interface, although ISAM can also utilize these logs. It allows you to speci...
Kiwiplan - Server Load Monitor
This script is based on this initial loadmon script This is to monitor specific objects at a Advantive/Kiwiplan sites It will send something like this for PCS #!/bin/bash ############################################ # # Author: Steve Ling 5/2/25 # M...
Linux - Server Load Monitor Script
This is to monitor various objects on a given server and email notifications out when thresholds are exceeded IT will send out something like this #!/bin/bash ############################################ # # Author: Steve Ling 5/2/25 # # Purpose: Moni...
Raspberry PI- Pi-Nut Network
Installing Network UPS Tools (NUT) version 2.8.3 from source on a Raspberry Pi 4 running Raspberry Pi OS (based on Debian) requires compiling the software from the source code, as a pre-built Debian package for this specific version may not be available. Below...
MsSQL - Restore Master/Model/MSDB
Steps to Restore the master Database: Stop the SQL Server Instance: Open SQL Server Configuration Manager or Windows Services. Locate the SQL Server service (e.g., SQL Server (MSSQLSERVER) for a default instance). Stop the service. ...
MsSQL - Restore Agent Jobs from Another MSDB database
This is to copy by specific Job --- ErangaMSDB is the copy of the old msdb --- DECLARE @JobID UNIQUEIDENTIFIER DECLARE @SchedulerID Int SELECT @JobID = job_id FROM ErangaMSDB.dbo.sysjobs WHERE NAME='Restore IPay' --- Insert the jobs INSERT msdb.dbo.sys...
SQL - Try Catch Rollback
BEGIN TRY BEGIN TRANSACTION; -- SQL statements that are part of the transaction -- e.g., INSERT, UPDATE, DELETE statements COMMIT TRANSACTION; END TRY BEGIN CATCH -- Error handling logic IF @@TRANCOUNT > 0 BEGIN ...
SQL - Blocking Process
These scripts are using to help how to determine what is blocking process are occurring. SELECT text,* FROM sys.dm_exec_requests CROSS APPLY sys.dm_exec_sql_text(sql_handle) WHERE DB_NAME(database_id) = '[dBName]' AND blocking_session_id <> 0 ...
Windows - Glossary of Terms
AAD = Azure Active Directory ADCS = Active Directory Certificate Services ADDS = Active Directory Domain Services AIA = Authority Information Access CA = Certificate Authority CDP = CRL Distribution Point CRL = Certificate Revocation List CSR = Certific...
MySQL - Parameters Explained
performance_schema = ON tmpdir = /run/mariadb thread_cache_size = 4 table_open_cache = 16384 table_definition_cache = 8384 sql_mode = ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION query_cache_type = 0 query_cache_size = 0 que...
MySQL - Cannot use select on user table
ERROR 1356 (HY000): View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Looks like database is corrupted. Try the following workaround:1. Insert missing privileges: Code: INSERT INTO `...
Linux - Setup RedHat 10 SMTP Server
System Configuration Upgrade Current System subscription-manager repos --enable codeready-builder-for-rhel-10-$(arch)-rpms dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-10.noarch.rpm -y dnf upgrade -y Configure SELinux setenforce ...
Raspberry PI - Error encountered raspi-firmware sense-hat
Error dpkg: error processing package sense-hat (--configure): dependency problems - leaving unconfiguredProcessing triggers for initramfs-tools (0.142+rpt4+deb12u3) ...Errors were encountered while processing: raspi-firmware sense-hatE: Sub-process /usr...
Raspberry Pi - Upgrade bulleys to trixie
First upgrade to bookworm sudo apt update sudo apt full-upgrade sudo sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list sudo sed -i 's/bullseye/bookworm/g' /etc/apt/sources.list.d/*.list sudo apt update sudo apt full-upgrade sudo reboot You may get t...
FSMO - Transfer Seize the roles to a new server
Old School Way: Using Graphical Tools (MMC) Check Current Roles: Run netdom query fsmo on any DC to see who holds them. Transfer Domain Roles (RID, PDC, Infrastructure): Open Active Directory Users and Computers (ADUC). Right-click the domain name and ...
Dataset - Restrict Date in MAP MES VUE ESP
This is to freeze a datasets for different Kiwiplan modules. MAP / CLASSIC / FFF Create a file named [PROFILE] in the KIWISEA path. The best place to put it is in the $DATA folder. The DATA and TIME are the settings you wish to freeze the data at. RESTRICT:...
Postgres - Install on Redhat 9
**To install the `pgvector` extension** (the popular open-source vector similarity search extension for PostgreSQL, which provides the `vector` data type and operators) on **Red Hat Enterprise Linux (RHEL) 9** with **PostgreSQL 16**, follow these steps. **`ve...
Synology - Bag of Tricks
sudo -i ip link set eth1 down My DS118 idles at 24% after disabling all the junk. //run once as root to disable services *you* don't need synopkg stop pkgctl-SynoFindersynopkg uninstall SynoFindersynopkg stop pkgctl-ActiveInsightsynopkg uninstall Active...