How to move MySQL to another drive in CentOS

Published on Author JFLeave a comment

This article covers the basic steps of moving a database to a new folder. It includes moving the db, as well as resetting SELinux/Apparmor policies. Depending on the OS configuration, MySQL may be running the /root mount where it is installed by default. There may be more drive space available in the /home directory. In… Continue reading How to move MySQL to another drive in CentOS

Migrating On Prem GitLab EE to Azure VM

Published on Author JFLeave a comment

Here’s what worked for me: I replaced LDAP with OAuth 2.0 Upgrade GitLab I upgraded to the latest from 13.6.0. It took a long time going through all the different steps because I was major versions behind. I attempted at 13.6.0 but it just wasn’t working. Here are my steps for reference: yum install gitlab-ee-13.6.0-ee.0.el7… Continue reading Migrating On Prem GitLab EE to Azure VM

How to export Barracuda F80 Firewall Rules to Excel/Sheets

Published on Author JFLeave a comment

Trying to get a list of your firewall rules out of your Barracuda F80 and into Excel or Google Sheets so can easily review them? If you use the standard “export to clipboard” in Barracuda Firewall Admin, then paste into a sheet you will get what I assume is JSON: All you need to do… Continue reading How to export Barracuda F80 Firewall Rules to Excel/Sheets

Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Published on Author JFLeave a comment

When using Microsoft SQL Server Import and Export Wizard you might get this error when attempting to import an XLSX file: TITLE: SQL Server Import and Export WizardThe operation could not be completed.ADDITIONAL INFORMATION:The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)BUTTONS:OK This is because the default wizard is launches the 32 bit… Continue reading Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

How to CORRECTLY install PHP 7.4.16 for IIS on Windows

Published on Author JFLeave a comment

It is easy to fall into old learnings and habits with Windows because it can be difficult to keep up with the latest methods. Also, you’re not in a position to run PHP on a linux stack, so Windows it is. If you’ve been around Windows and IIS for a long time, you might still… Continue reading How to CORRECTLY install PHP 7.4.16 for IIS on Windows

Add random string to a field using SQL Update

Published on Author JFLeave a comment

Here’s a simple script to add a random string to a SQL Update: update <dbname>set <field> = (SELECT SUBSTRING(CONVERT(VARCHAR(40), NEWID()),0,9)) This will update each row with a distinct 8 alphanumeric characters, e.g. C2552926 Breaking this down in terms of functionality: NEWID() – generates a UUID VARCHAR(40) – tells CONVERT() what string data type, max len… Continue reading Add random string to a field using SQL Update

Windows 2016 – Windows Cannot Access…

Published on Author JFLeave a comment

Accessing Network Status and other features as Administrator generates this error C:\windows\system32\control.exe Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item. How to solve the problem Run > gpedit.msc Computer Configuration->Windows Settings->Security Settings->Local Policies->Security Options Enable “User Account Control: Admin Approval Mode for the… Continue reading Windows 2016 – Windows Cannot Access…

Add additional SSH user to Amazon Lightsail

Published on Author JFLeave a comment

Configuring Lightsail Network To make sure you can connect, make sure that Port 22 (default) is open. If you have a fixed IP address, make sure to check “Restrict to IP address” and add your address/es. Remotely Connecting Before we set up the server, let’s go over a couple key items: You’ve create the instance… Continue reading Add additional SSH user to Amazon Lightsail

Linux tail -f replacement on Windows

Published on Author JFLeave a comment

Use Get-Content and Get-Item in Powershell Looking for the tail command on Windows? Get-Content will do the trick. Here’s a link to the command page. Open PowerShell: Show the last line/s: Get-Content C:\inetpub\logs\LogFiles\W3SVC1\u_ex200711.log -Tail 1 Or use get-item Get-Item -Path .\LineNumbers.txt | Get-Content -Tail 1 Stream the file like tail -f Get-Content path-to-file -wait Example:… Continue reading Linux tail -f replacement on Windows