Category: Website Development

Windows Docker – An attempt was made to access a socket in a way forbidden by its access permissions.

Published on Author JFLeave a comment

Running Docker on Windows? You might run into these errors: docker: Error response from daemon: Ports are not available: listen tcp 0.0.0.0:4449: bind: An attempt was made to access a socket in a way forbidden by its access permissions. Error starting userland proxy: listen tcp 0.0.0.0:80: bind: An attempt was made to access a socket… Continue reading Windows Docker – An attempt was made to access a socket in a way forbidden by its access permissions. →

wkhtmltopdf error network status code 4 and http status code 0

Published on Author JFLeave a comment

You might get the following error/s with wkhtmltopdf : Error: Failed to load https://www.yoursite.com/some-pdf-gen-url/, with network status code 4 and http status code 0 – Socket operation timed outWarning: Failed loading page Or exit with code 1 due to network error: timeouterror First, try cURLing your site: If that fails, it is because DNS is… Continue reading wkhtmltopdf error network status code 4 and http status code 0 →

Connect to local MySQL from Docker Container

Published on Author JFLeave a comment

You’re running a docker web app and it connects fine to the IP address you specified on a shared database server, but you can’t connect to MySQL running on your workstation hosting the container. How do you connect to your local machine’s instance of MySQL? Easy. In this example, we’re doing dev coding on our… Continue reading Connect to local MySQL from Docker Container →

Running Docker on a Windows 10 Hyper-V

Published on Author JFLeave a comment

You are running Windows 10/11 on your machine with Hyper-V installed. You are also running a Windows 10 Hyper-V Virtual Machine. When installing Docker you will get a notification that WSL is having issues so you will update it. Run PowerShell as Administrator: And Docker will still fail so you will: It might fail because… Continue reading Running Docker on a Windows 10 Hyper-V →

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 →

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 →