Adafruit - FT232H - USB to GPIO Interface

Tuesday, March 5th, 2019 | Technology

This is one of my favorite pieces of electronic equipment that I own. Any device that allows me to interface with the real world - and natively to my Mac - is a piece of art. The GPIO interface connects via USB to the computer on one side; two 10-pin SIP connectors provide the power, ground, and I/O pins on the other.

The FT232-H supports many protocols. I don't get into this. I do, however, utilize the digital I/O pins for standard binary entry. This allows integration with simple switch circuits and advanced buttoned matrices ( or a parallel binary connection to any other circuit, i.e. a binary decoder ( 74HC595 ) ).

A Python API exposes all basic services of the chip and allows rapid integration into any programme environment that requires GPIO. This solution provides an affordable, expandable, I/O interface to all popular computing platforms, ultimately controlled via shell scripts and abstracted through a web interface. The design encourages opportunities for remote IOT installations or extending the digital GUI into a unique hands-on physical experience.

Resources:

https://learn.adafruit.com/circuitpython-on-any-computer-with-ft232h/mac-osx


Art of Modern Wizardry

Friday, March 23rd, 2018 | Lifestyle

I've always been fascinated by wizardry and our geophysical relationship with the earth and sky. Ready to get started? Check out this amazing guide on treeing, the method for reupping your wizard energy:

http://www.artofmodernwizardry.org/treeing-how-wizards-connect-to-the-universe/


AWS - SES for Receiving Emails

Wednesday, June 1st, 2022 | System

https://aws.amazon.com/premiumsupport/knowledge-center/ses-receive-inbound-emails/


Bootstrap - 3 to 5 Migration Notes

Tuesday, July 13th, 2021 | Design

Bootstrap 3 -> 5 Migration

Replace btn-block with col-*
Replace hidden-xs hidden-sm -> ?
Replace img-responsive with fluid
Replace sr-only with visually-hidden

Breadcrumbs:

add breadcrumb-item to li class
move into nav tag for background


CentOS 7 - Apache Virtual Host Setup

Tuesday, January 22nd, 2019 | Server

Links:
https://linuxize.com/post/how-to-set-up-apache-virtual-hosts-on-centos-7/
https://www.digitalocean.com/community/tutorials/how-to-set-up-apache-virtual-hosts-on-centos-7

Local Domain:
https://askubuntu.com/questions/52664/how-do-i-set-up-a-local-domain-name-in-apache-and-ubuntu-eg-website-sam


CentOS 7 - Apache | SSL CertBot

Tuesday, January 22nd, 2019 | Server

Live example:

Run Certbot for default Apache configuration, requires listener on port 80:

sudo certbot --apache

sudo certbot --apache certonly

Resources:

LINUX - CentOs 7
https://certbot.eff.org/lets-encrypt/centosrhel7-apache


CentOS 7 - Networking Bridge for KVM

Sunday, February 3rd, 2019 | Server

Virtual Machines required a bridge for access to the local DHCP network.

First:

https://www.tuxfixer.com/install-and-configure-kvm-qemu-on-centos-7-rhel-7-bridge-vhost-network-interface/

Ensure you have added the bridge name to /etc/qemu/bridge.conf.


CentOS 7 - Server Commands - Apache Log Management

Wednesday, September 16th, 2020 | System

View / Clear Logs:

* add new line to end ( backslash n ) inside single quotes

cd /var/www

find . -type f -name requests.log -printf '%s %p'
find . -type f -name error.log -printf '%s %p'

cd /var/www

find . -name 'requests.log' -exec sh -c '> {}' \;
find . -name 'error.log' -exec sh -c '> {}' \;

Sort logs alphabetically:

find . -type f -name access.log -exec du -bh {} \; | sort -k 2
find . -type f -name requests.log -exec du -bh {} \; | sort -k 2
find . -type f -name error.log -exec du -bh {} \; | sort -k 2

CentOS 7 - Virtual Machine | Virsh Common Commands

Wednesday, February 20th, 2019 | Server

Live example:

virsh dumpxml
virsh dumpxml centos7.0

virsh list
virsh list --all

virsh edit centos7.0

CentOS 7 - Virtualization - Network Bridge Setup

Tuesday, January 22nd, 2019 | Server

https://www.techotopia.com/index.php/Creating_a_CentOS_KVM_Networked_Bridge_Interface

https://www.linuxjournal.com/article/8172

https://sandilands.info/sgordon/linux-servers-as-kvm-virtual-machines

 


CentOS 7 - Virtualization - Virtio Bridge Example

Monday, October 12th, 2020 | Server

<interface type='bridge'>

<mac address='52:54:00:32:83:B5'/>
<source bridge='br-em1'/>
<model type='virtio'/>
<address type='pci' domain='0x0000' bus='0x00' slot='0x03' function='0x0'/>

</interface>


CloudFlare - Default / Preferred Settings

Tuesday, June 28th, 2022 | System

SSL/TLS

Full Strict

SSL/TLS

Edge Cert

Always use HTTPS
TLS 1.2

Security

Bots
Bot Fight Mode

Speed

Optimization
Early Hints

 


ColdFusion - CentOS 7 CF 2016 PDF Generation Setup

Tuesday, January 22nd, 2019 | Server

https://helpx.adobe.com/coldfusion/pdf-generation-in-coldfusion.html

Download and Install: font-ibm-type1-1.0.3.zip.

https://helpx.adobe.com/experience-manager/6-3/forms/using/install-configure-pdf-generator.html


ColdFusion - CF11 Mac OS X CLI

Monday, February 12th, 2018 | Coding

#!/bin/bash

clear

echo "Please make yourselves comfortable"
echo "while I go to the door of the Throne Room"
echo "and tell Oz you are here."

# START APACHE SERVER
apachectl start

# START MYSQL SERVER
cd /usr/local/mysql/support-files
./mysql.server start

# START COLDFUSION
cd /Applications/ColdFusion11/cfusion/bin
./coldfusion start

ColdFusion - CF2016 cfdirectory

Tuesday, January 30th, 2018 | Coding

< cfdump var="#htaccess#">
< cfdirectory directory="ram:///" name="files" recurse="true">
< cfdump var="#files#">

ColdFusion - CF9 Ubuntu 9

Monday, February 12th, 2018 | Coding

#!/bin/bash

clear

echo "Please make yourselves comfortable"
echo "while I go to the door of the Throne Room"
echo "and tell Oz you are here."

# START APACHE SERVER
cd /etc/init.d/
./apache2 start

# START MYSQL SERVER cd /etc/init.d mysql start # START COLDFUSION cd /opt/coldfusion9/bin ./coldfusion start

ColdFusion - CFBuilder Regular Expressions for Search

Sunday, January 7th, 2018 | Coding

File name patterns: *, !*.jpg, !*.mp3, !*.ogg, !*.png, !*.wav, !*.zip, !.DS_Store


ColdFusion - CFML Capitalize First Letter / Uppercase

Thursday, February 9th, 2023 | Coding

Uppercase the first character of each word in the string:

Snippet: #reReplace('text string',"(^[a-z]|\s+[a-z])","\U\1","ALL")#

Input: 'text string'
Output: 'Text String'

Uppercase the first character of the first word in the string:

Snippet: #reReplace('text string',"(^[a-z])","\U\1","ALL")#

Input: 'text string'
Output: 'Text string'


http://coldfusionsnippets.blogspot.com/2010/03/uppercase-first.html


ColdFusion - Connector Config for OS X Apache

Wednesday, October 31st, 2018 | Technology

-ws Apache -dir /private/etc/apache2 -bin /usr/sbin/httpd - script /usr/sbin/apachectl

config: /private/etc/apache2/httpd.conf


ColdFusion - Connector Config for RHEL/CentOS 7 Apache

Wednesday, March 22nd, 2023 | Server

Standard values for a RHEL/CentOS 7 Apache: 

Conf: /etc/httpd/conf
Binary: /usr/sbin/httpd
Script: /usr/sbin/apachectl

CLI Path: /opt/ColdFusion2021/cfusion/runtime/bin
CLI:
./wsconfig -ws Apache -dir /etc/httpd/conf -bin /usr/sbin/httpd -script /usr/sbin/apachectl

Manual Configuration: https://helpx.adobe.com/coldfusion/kb/coldfusion-apache-manual-connector-configuration.html


ColdFusion - DeSerialize JSON

Wednesday, January 31st, 2018 | Coding

record=deserializeJSON( '{ "firstname": "John", "lastname": "Smith", "age": "36", "address":{ "number":"248", "street":"Storer Avenue", "city":"Akron", "state":"OH", "postal":"44302" } }' ); writeOutput(record.firstname & "
"); writeOutput(record.lastname & "
"); writeOutput(record.address.number & "
"); writeOutput(record.address.street & "
");


#record.firstname#


#record.firstname#


ColdFusion - DSN Connection String for MySQL

Tuesday, July 27th, 2021 | Server

Connection String

zeroDateTimeBehavior=convertToNull&serverTimezone=America/New_York


ColdFusion - Emergency Update March 2023

Friday, March 24th, 2023 | Server

The five most helpful links:

Charlie Arehart blog with fixes:
https://www.carehart.org/blog/2023/3/17/coldfusion_march_2023_emergency_update

Adobe Security Release:
https://helpx.adobe.com/security/products/acrobat/apsb23-01.html

CISA Gov updates:
https://www.cisa.gov/news-events/alerts/2023/03/15/cisa-adds-one-known-exploited-vulnerability-catalog

Rapid7 Observed Exploitations
https://www.rapid7.com/blog/post/2023/03/21/etr-rapid7-observed-exploitation-of-adobe-coldfusion/

Hacker News report:
https://thehackernews.com/2023/03/cisa-issues-urgent-warning-adobe.html?m=1


ColdFusion - FW/1 Tips & Tricks

Thursday, July 29th, 2021 | System

https://framework-one.github.io/documentation/4.3/developing-applications/

Reinitialize the framework:

?fwreinit=xxx

?reload ( pulls latest values from config to database )


ColdFusion - General LINUX Setup

Tuesday, January 22nd, 2019 | Server

Disable SeLinux: https://documentation.cpanel.net/display/1150Docs/Installation+Guide+-+Disable+SELinux

cd /etc/selinux
sudo vi config 
setenforce 0

Virsh Edit the VM Config: https://superuser.com/questions/1231348/kvm-error-starting-domain-unsupported-configuration-unable-to-find-security-dr

Connector Configuration: https://helpx.adobe.com/coldfusion/kb/rhel-connector-configuration.html


ColdFusion - Geocoding with Google Maps

Wednesday, November 7th, 2018 | Coding

https://coldfusionexperts.wordpress.com/2013/11/11/geocoding-with-google-map-api-and-coldfusion

https://stackoverflow.com/questions/2234204/find-nearest-latitude-longitude-with-an-sql-query

https://www.w3schools.com/html/html5_geolocation.asp

https://developer.mozilla.org/en-US/docs/Web/API/Geolocation/watchPosition

https://www.w3schools.com/jsref/obj_navigator.asp


ColdFusion - Implementing CORS Upload for S3 in ColdFusion

Monday, June 22nd, 2020 | Technology

https://dyrynda.com.au/blog/uploading-files-to-amazon-s3-from-the-browser-part-one

1) Create Upload User

2) Create IAM Policy and attach it to your new user

3) Create CORS Policy and attach it to Bucket

 


ColdFusion - Install ColdFusion 2021 on MacOS BigSur

Thursday, October 14th, 2021 | Server

Install ColdFusion 2021 on BigSur

Launch the terminal and enter this command    -   xattr -rc <ColdFusion2021_xxxx.dmg>


ColdFusion - Mac Development Setup

Sunday, October 30th, 2022 | Coding

Enable File Sharing, SSH, Remote Desktop
Install ColdFusion ( & Updates )
Install ColdFusion Builder

Install MAMP Pro
Install NAMO

 ColdFusion
Create Apache Connector
Update workers.properties / server.xml
Add mod reference in MAMP Apache conf

* MAMP no longer integrates after Big Sur / CF2021


ColdFusion - QR Code generation via Google Chart API

Wednesday, October 31st, 2018 | Coding

< cfhttp method="Get" url="http://chart.apis.google.com/chart?chs=150x150&cht=qr&chl=hello" getAsBinary = "yes">

< cfcontent variable="#toBinary(toBase64(cfhttp.FileContent))#" type="image/png" reset="true" />


ColdFusion - Websocket Resources

Sunday, August 1st, 2021 | Server

https://wiki.hostek.com/ColdFusion_Tips_%26_Tricks

https://bdking71.wordpress.com/2016/09/22/simple-chat-application-using-coldfusion-2016-web-sockets/#more-966

https://www.sagarganatra.com/2012/03/coldfusion-10-using-filtercriteria-in.html

https://github.com/GiancarloGomez/ColdFusion-Realtime-With-WebSockets/blob/master/listeners/ChatListener.cfc

https://bdking71.wordpress.com/2016/09/22/simple-chat-application-using-coldfusion-2016-web-sockets/


ColdFusion Fusebox - Clear Caches

Wednesday, December 14th, 2022 | System

/index.cfm?fusebox.password=*********&fusebox.load=true&fusebox.loadclean=true&fusebox.parse=true


CommandBox - Common Commands and Cool Things

Tuesday, October 4th, 2022 | Server

 

package list --system

install commandbox-bullet-train install commandbox-hostupdater install commandbox-cfconfig install commandbox-update-check outdated --system
update --system cfconfig datasource save name=<> dbdriver=MSSQL host=127.0.0.1 port=1433 database=<> username=sa password=<> server start [email protected] SSLEnable=true SSLPort=443 host=website.local --rewritesEnable config set adminPassword=commandbox to=.config.json #### server start --debug server start --debug --follow server set web.rewrites.logEnable=true server log --follow --rewrites

CommandBox Headless Instance for Raspberry PI

Monday, January 3rd, 2022 | Server

{

    "JVM":{

        "args":"-Djava.awt.headless=true"

    },

    "name":"sentinel.local",

    "openbrowser":false,

    "web":{

        "host":"sentinel.local",

        "http":{

            "port":"80"

        },

        "rewrites":{

            "enable":true

        }

    }

}


Creating a CampGround Ideas and Inspiration

Monday, June 27th, 2022 | Entrepreneur

https://campgroundsolutions.goodsam.com/blog/how-to-start-a-campground/

https://rvlifestyle.com/private-rv-campsite/

https://www.dwell.com/article/how-to-build-an-outhouse-11faca2d


CSS - 3D cube

Friday, March 23rd, 2018 | Design

Use arrow keys, touch gestures, or click and drag to rotate:

https://paulrhayes.com/experiments/cube-3d/touch.html


CSS - Clean & Simple Prompt

Wednesday, November 21st, 2018 | Design

READY TO SIGN UP?

Register now, it's quick and FREE.

Already registered? Login


CSS - Radio Button Options

Sunday, March 25th, 2018 | Design

Basic Large: https://codepen.io/Zerk/pen/mWNXVy
Circuit: https://codepen.io/lukasoe/pen/BpMNjw

Custom dropdown arrow: https://codepen.io/danield770/pen/bgJOyV
Custom dropdown arrow 2: https://codepen.io/vkjgr/pen/VYMeXp
Custom dropdown arrow 3: https://fabriceleven.com/design/clever-way-to-change-the-drop-down-selector-arrow-icon/

Subscription: https://codepen.io/RRoberts/pen/kXvVrR
Large Jumper: https://codepen.io/web-tiki/pen/JXwLGQ
Terminal / Transit: https://codepen.io/yunntan/pen/rayKjK

Not loading:
https://codepen.io/morten-olsen/pen/QbvBYy
https://codepen.io/chrissimari/pen/shyDC


Deconstructing Your Vision

Saturday, January 13th, 2018 | Entrepreneur

Now

Failure to plan is planning to fail. Answer these 3 lines to achieve clarity and direction:

Things we did well and should do more of:
Things we are doing that need improvement:
Completely new things we want to try:


DELL - iDrac6 vFlash Usage

Monday, March 15th, 2021 | Server

https://medium.com/techbeatly/boot-from-image-using-vflash-in-dell-poweredge-servers-2e661768fdf8


DirectAdmin - Let's Encrypt LEGO SSL Error - Incorrect Usage

Sunday, April 24th, 2022 | Server

The fix, just rebuild LEGO:

https://forum.directadmin.com/threads/lets-encrypt-error.64712/


DreamWeaver - Cloaking Settings for Files and Folders

Wednesday, June 22nd, 2022 | Technology

.rtf .txt .ppt .ttf .doc .docx .fla .psd .less .sass .scss .map .jpg .pdf .png .gif .jpeg .xls .ds_store .project .settings settings.xml cache server.json server-rewrites.xml .swf .svg


E19 | Marketing - Work ON your business vs IN your business

Tuesday, November 6th, 2018 | Business

https://trainingtilt.com/working-in-vs-on-your-business-what-does-that-even-mean


Export an SVG for web using Adobe Illustrator

Saturday, October 15th, 2022 | Design

This works perfect:

https://webdogs.com/blog/export-svg-web-using-adobe-illustrator/

####

Note: BOYD


FT232H - Python ( Basic GPIO )

Saturday, January 27th, 2018 | Technology

# Import standard Python time library.
import time

# Import GPIO and FT232H modules.
import Adafruit_GPIO as GPIO
import Adafruit_GPIO.FT232H as FT232H

# Temporarily disable the built-in FTDI serial driver on Mac & Linux platforms.
FT232H.use_FT232H()

# Create an FT232H object that grabs the first available FT232H device found.
ft232h = FT232H.FT232H()

# Configure digital inputs and outputs using the setup function.
# Note that pin numbers 0 to 15 map to pins D0 to D7 then C0 to C7 on the board.
ft232h.setup(7, GPIO.IN)   # Make pin D7 a digital input.
ft232h.setup(8, GPIO.OUT)  # Make pin C0 a digital output.

# Loop turning the LED on and off and reading the input state.
print 'Press Ctrl-C to quit.'
while True:
	# Set pin C0 to a high level so the LED turns on.
	ft232h.output(8, GPIO.HIGH)
	# Sleep for 1 second.
	time.sleep(1)
	# Set pin C0 to a low level so the LED turns off.
	ft232h.output(8, GPIO.LOW)
	# Sleep for 1 second.
	time.sleep(1)
	# Read the input on pin D7 and print out if it's high or low.
	level = ft232h.input(7)
	if level == GPIO.LOW:
		print 'Pin D7 is LOW!'
	else:
		print 'Pin D7 is HIGH!'

Get original remote IP address with CloudFlare and Apache / NGINX

Sunday, April 17th, 2022 | Server

https://devanswers.co/get-real-client-ip-address-cloudflare-apache-php/
https://netslovers.com/post/real-ip-cloudflare-nginx-apache-wordpress/
https://github.com/ergin/nginx-cloudflare-real-ip


HTML - Favicon Generator for Websites

Friday, March 10th, 2023 | Design

https://favicon.io works the best. 


HTML5 - Audio Waveform Visualizer

Friday, March 23rd, 2018 | Coding

https://wavesurfer-js.org


HTML5 - Pre/Code line numbering, no copy

Wednesday, January 31st, 2018 | Coding

View Source:

 line 1
 line 2
 line 3
 line 4
 line 5

IIS ISAPI Rewrites

Thursday, February 9th, 2023 | Server

Filter name: ISAPI_Rewrite_32
Executable: C:\Program Files\Helicon\ISAPI_Rewrite3\ISAPI_Rewrite.dll

Filter name: ISAPI_Rewrite_x64
Executable: C:\Program Files\Helicon\ISAPI_Rewrite3\ISAPI_Rewrite_x64.dll


Implementing WebP into your Website

Tuesday, October 4th, 2022 | Design

You'll have to view the source code. The gist is to use the HTML5 picture tag.




Alt text
	
/* Note that all additional attributes,
such as class and alt, 
added to the img element,
will apply to the source image. */
	


Install NGINX on AlmaLinux 9

Thursday, September 29th, 2022 | System

https://www.digitalocean.com/community/tutorials/how-to-install-nginx-on-rocky-linux-9

https://www.linuxcapable.com/how-to-install-nginx-on-almalinux-9/

https://timothy-quinn.com/using-nginx-as-a-reverse-proxy-for-multiple-sites/

https://www.digitalocean.com/community/tutorials/how-to-install-nginx-on-centos-8

####

Run Multiple Site from one IP with reverse proxy Nginx

https://www.youtube.com/watch?app=desktop&v=x1fnOJsX6wE

*** Reverse proxy nginx letsencrypt tutorial ***

https://www.youtube.com/watch?app=desktop&v=DyXl4c2XN-o

https://github.com/xcad2k/videos/tree/main/nginx-reverseproxy

####

Allow Access To Port SELinux, Firewall

https://paritoshbh.me/blog/allow-access-port-selinux-firewall

####

How To Secure Nginx with Let's Encrypt on Rocky Linux 9

https://www.digitalocean.com/community/tutorials/how-to-secure-nginx-with-let-s-encrypt-on-rocky-linux-9


Install VirtualBox on Alma9

Thursday, October 6th, 2022 | System

We are starting here:

https://idroot.us/install-virtualbox-almalinux-9/


IP2Location | Map

Sunday, June 10th, 2018 | Technology

https://lite.ip2location.com/database/ip-country-region-city-latitude-longitude-zipcode


IPv6 Considerations

Tuesday, July 13th, 2021 | Technology

https://www.varonis.com/blog/ipv6-security/


ISRC Code Format

Saturday, January 13th, 2018 | Music Business

Sample: US-MX2-11-10300

[ US ] :: COUNTRY
[ MX2 ] :: LABEL CODE
[ 11 ] :: YEAR
[ 1 ] :: RELEASE CODE
    [ 1 = ALBUM, 2 = SINGLE, 3=COMPILATION ]
[ 03 ] :: ALBUM RELEASE SEQUENTIAL
[ 00 ] :: SONG RELEASE SEQUENTIAL

FRONTLINE MILITIA: US-MX2-14-10400


Javascript | Google Driving Directions

Monday, April 2nd, 2018 | Marketing

https://developers.google.com/maps/documentation/javascript/examples/directions-simple


Javascript | HTML Tag | Confirmation

Thursday, January 25th, 2018 | Coding

onclick="return confirm('Are you sure you want to delete?');"

JavaScript | jQuery - Popup Overlay

Friday, March 23rd, 2018 | Coding

Stand Alone - http://dev.vast.com/jquery-popup-overlay/


JavaScript | Random Key

Tuesday, October 30th, 2018 | Coding

var order_id = "";
var possible = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
		
for( var i=0; i < 8; i++ )
order_id += possible.charAt(Math.floor(Math.random() * possible.length));


Javascript | Send OS X Notifications

Wednesday, October 31st, 2018 | Coding

< script>
	
	var notify = function () {
	    // Check for notification compatibility.
	    if (!'Notification' in window) {
	        // If the browser version is unsupported, remain silent.
	        return;
	    }
	    // Log current permission level
	    console.log(Notification.permission);
	    // If the user has not been asked to grant or deny notifications
	    // from this domain...
	    if (Notification.permission === 'default') {
	        Notification.requestPermission(function () {
	            // ...callback this function once a permission level has been set.
	            notify();
	        });
	    }
	    // If the user has granted permission for this domain to send notifications...
	    else if (Notification.permission === 'granted') {
	        var n = new Notification(
	                    'New message from Liz',
	                    {
	                      'body': 'Liz: "Hi there!"',
	                      // ...prevent duplicate notifications
	                      'tag' : 'unique string'
	                    }
	                );
	        // Remove the notification from Notification Center when clicked.
	        n.onclick = function () {
	            this.close();
	        };
	        // Callback function when the notification is closed.
	        n.onclose = function () {
	            console.log('Notification closed');
	        };
	    }
	    // If the user does not want notifications to come from this domain...
	    else if (Notification.permission === 'denied') {
	        // ...remain silent.
	        return;
	    }
	};
	    
    notify();
	
< /script>


LEGO NXT RoboGlove

Wednesday, November 7th, 2018 | Robotics


LINUX CloneZilla - Disk Image Backup and Restoration

Sunday, October 30th, 2022 | Server

Create Backup Image and Restore ( CentOS 7 ):

https://success.trendmicro.com/dcx/s/solution/1105066-full-disk-backup-and-restoration-by-clonezilla?language=en_US


LINUX Create User and add to Wheel / Sudoers

Tuesday, October 4th, 2022 | System

Create a LINUX user and add them to the Sudoers file:

sudo adduser asdf1234
sudo passwd asdf1234
sudo groups asdf1234
sudo visudo << verify wheel is enabled >>
sudo usermod -aG wheel asdf1234
su - asdf1234
sudo cd /root

https://phoenixnap.com/kb/how-to-create-add-sudo-user-centos


Linux Server Installation Resources - CentOS

Tuesday, August 18th, 2020 | Server

https://www.digitalocean.com/community/tutorials/how-to-install-the-apache-web-server-on-centos-7
https://linuxize.com/post/how-to-stop-and-disable-firewalld-on-centos-7


LINUX | CentOS | Add User and allow Sudoers

Friday, September 30th, 2022 | Server

https://phoenixnap.com/kb/how-to-create-add-sudo-user-centos


LINUX | Crontab Basics

Tuesday, January 30th, 2018 | Coding

CRON exists for Sudo and User. I recommend Nano as your default Editor ( if you receive a prompt )

crontab -l
crontab -e

sudo crontab -l sudo crontab -e

LINUX | Crontab Expressions

Wednesday, January 17th, 2018 | Coding

This is a great starting point when you're working with scheduled tasks or repeating events:

Oracle-defined CRON Expressions


LINUX | Install ExFat Utilities

Wednesday, January 9th, 2019 | Server

yum install exfat-utils fuse-exfat
mkdir /media/USB
ls /dev/sd*
mount -t exfat /dev/sda1 /media/USB/

LINUX | Show active listening tcp ports with process

Tuesday, October 4th, 2022 | Server

ss -ltup

LUCEE - Clear all failed Tasks

Tuesday, March 21st, 2023 | Server

< cfscript>
    // Access the Task Scheduler
    taskService = createObject("component", "lucee.runtime.schedule.TaskService");

    // Get all tasks
    tasks = taskService.listAll();

    // Loop through tasks and delete failed tasks
    for (task in tasks) {
        if (task.status == "failed") {
            taskService.remove(task.id);
        }
    }
< /cfscript>

Mac - Adobe DreamWeaver Regular Expressions for Search

Sunday, January 7th, 2018 | Coding

< cflocation [^>]*>
< cffunction [^>]*>

://[^w]*.patentawards

Mac - Docker SQL Server Setup / Azure Data Studio Restore

Wednesday, October 27th, 2021 | System

This is old. Install Docker/SQL per Microsoft instructions and use VS Code to mount the file structure. VERY EASY.

https://setapp.com/how-to/install-sql-server ( Untested )

Docker SQL Setup:

docker run -e "ACCEPT_EULA=Y" -e "MSSQL_SA_PASSWORD=asdf1234" -p 1433:1433 -d mcr.microsoft.com/mssql/server:2017-latest

sudo docker exec -it goofy_pare mkdir /var/opt/mssql/backup

sudo docker cp Township_backup_2021_10_19_020002_4020622.bak goofy_pare:/var/opt/mssql/backup

Azure Restore:

https://www.quackit.com/sql_server/mac/how_to_restore_a_bak_file_using_azure_data_studio.cfm

https://www.quackit.com/sql_server/mac/how_to_copy_a_file_from_the_host_to_a_docker_container.cfm


Mac - Hide Hidden Files

Wednesday, February 20th, 2019 | Technology

Show hidden files:

# defaults write com.apple.finder AppleShowAllFiles true
# killall Finder

Hide hidden files:

# defaults write com.apple.finder AppleShowAllFiles false
# killall Finder

Mac - Homebrew | Install FFMPEG

Friday, March 23rd, 2018 | Technology

http://www.renevolution.com/ffmpeg/2013/03/16/how-to-install-ffmpeg-on-mac-os-x.html

brew install ffmpeg --with-chromaprint --with-fdk-aac --with-fontconfig --with-freetype --with-frei0r --with-game-music-emu --with-libass --with-libbluray --with-libbs2b --with-libcaca --with-libgsm --with-libmodplug --with-librsvg --with-libsoxr --with-libssh --with-libvidstab --with-libvorbis --with-libvpx --with-opencore-amr --with-openh264 --with-openjpeg --with-openssl
--with-opus --with-rtmpdump --with-rubberband --with-sdl2 --with-snappy --with-speex --with-tesseract --with-theora --with-tools --with-two-lame --with-wavpack --with-webp --with-x265 --with-xz --with-zeromq --with-zimg

Mac - MAMP Path Migrations and MySQL Fixes

Friday, October 29th, 2021 | System

MAMP Migration

 

sudo apachectl stop

 

  1. Convert ALL DateModified values to CURRENT_TIMESTAMP and NOT NULL
  2. Update ALL system paths from htdocs -> Sites

 

PATH Updates:

 

Applications/MAMP/htdocs

Users/*username*/Sites

 

####

 

 

MySQL ZERO DATE issue:

 

SELECT @@GLOBAL.sql_mode global, @@SESSION.sql_mode session;
SET sql_mode = '';
SET GLOBAL sql_mode = '';

 

MySQL GROUP BY ISSUE:

 

SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY','));

 

NOTE: Removed ‘ONLY_FULL_GROUP_BY,’ from the SQL MODE variable

 

https://stackoverflow.com/questions/41887460/select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-inc


Mac - MAMP PRO & ColdFusion 2021 Setup / Development

Sunday, October 30th, 2022 | Server

sudo ./wsconfig -ws Apache -bin /usr/sbin/httpd -script /usr/sbin/apachectl -dir /etc/apache2/ -v

 

#### ### ## #

 

sudo ./wsconfig -ws Apache -bin /Applications/MAMP/bin/apache2/bin/httpd -script /Applications/MAMP/bin/apache2/bin/apachectl -dir /Users/{{username}}/Library/Application Support/appsolute/MAMP Pro -v

 

/Users/{{username}}/Library/Application Support/appsolute/MAMP Pro

/Applications/MAMP/bin/apache2/bin/httpd

/Applications/MAMP/bin/apache2/bin/apachectl


Mac - Network Utility Replacement Commands in Terminal

Monday, December 6th, 2021 | System

Reference: https://www.makeuseof.com/how-to-use-terminal-as-network-utility-replacement/

Using Lookup With Terminal

The Lookup tool in Network Utility allowed you to identify the IP addresses associated with a domain name and vice versa. In Terminal, the nslookup command effectively replicates this feature.

An example Terminal command on a Mac looks like this:

nslookup apple.com

For a reverse lookup, use the IP address of the domain:

nslookup 17.253.144.10

Mac - OS X Mail / Message DUMP Recents

Thursday, January 25th, 2018 | Coding

sqlite3 -csv ~/Library/Containers/com.apple.corerecents.recentsd/Data/Library/Recents/Recents 'select display_name, address from contacts where kind like "email";'>~/Desktop/recent.csv


Mac - Upgrade PHP to 7.3 from 5.x

Thursday, June 20th, 2019 | Server

https://medium.com/zenchef-tech-and-product/how-to-upgrade-your-version-of-php-to-7-0-on-macos-sierra-e1bfdea55a63

https://coolestguidesontheplanet.com/upgrade-php-on-osx
https://jasonmccreary.me/articles/upgrade-php-mac-os-x
https://php-osx.liip.ch

 

curl -s https://php-osx.liip.ch/install.sh | bash -s 7.3

Mac - Wireshark Filter Basics

Thursday, January 25th, 2018 | Coding

html contains 'keyword'
frame contains 'keyword'

Marketing Types

Wednesday, January 17th, 2018 | Marketing

Kept these around to inspire new ideas:

Initiative, Momentum

Invitations, News, Notifications, Messages

Coupons, Specials, Savings, Promos,Promotions, Deals, Discount, Clearance

Surveys - Survey Builder

Events ["New","Past","Recent","Featured"]


Microsoft RDP Remote Desktop - Copy & Paste not working

Monday, March 13th, 2023 | Server

If your RDP session clipboard should be shared, but it's not working:

Kill the rdpclip.exe process and restart it.

The rdpclip.exe file is located in c:\Windows\System32\

 


Minecraft - Java Coding

Saturday, November 21st, 2020 | Coding

https://www.minecraft.net/en-us/download/server
https://minecraft.gamepedia.com/Tutorials/Setting_up_a_server

https://javaminecraft.com/spigot/


Minecraft - Python Coding

Saturday, November 21st, 2020 | Coding

 

Code Samples:

setBlock(x,y,z,x+3,y+3,z+3)

Resources:

https://www.stuffaboutcode.com/p/minecraft-api-reference.html
https://projects.raspberrypi.org/en/projects/getting-started-with-minecraft-pi/4

https://gist.github.com/jonwitts/2ac5b12d7231a95f959f0fabd17cd66b
https://projects.raspberrypi.org/en/projects/getting-started-with-minecraft-pi/5
https://www.raspberrypi-spy.co.uk/2014/06/building-a-castle-in-minecraft-with-python/

https://teachcraft.net

Build A House: https://www.raspberrypi.org/blog/build-minecraft-house-using-python/

Moving the Player: https://arghbox.wordpress.com/2013/12/28/minecraft-pi-api-moving-the-player/


Minecraft - Server Links & Resources

Saturday, July 30th, 2022 | Server

Longer Days: https://www.spigotmc.org/resources/longerdays.80610

Reset the World: https://www.spigotmc.org/threads/reset-the-world.264427/


Mini Home Ideas and Inspiration

Monday, June 27th, 2022 | Lifestyle

https://www.autoevolution.com/news/mitchcraft-tiny-house-with-two-tiered-loft-is-not-your-average-tiny-home-189834.html

https://www.autoevolution.com/news/casa-grande-is-a-tiny-house-with-an-appendage-has-two-lofts-a-fireplace-and-an-office-193075.html

https://www.businessinsider.com/look-inside-tiny-house-couple-build-modern-mountains-sydney-australia-2022-6?amp

https://www.autoevolution.com/news/ayfraym-plus-is-the-modern-adventure-cave-boasts-two-floors-a-loft-and-a-two-car-garage-192501.html

https://www.autoevolution.com/news/yin-yang-rv-tiny-house-is-both-practical-and-visually-appealing-comes-with-dual-lofts-192362.html

https://www.autoevolution.com/news/the-aurora-tiny-home-is-what-happens-when-an-rv-manufacturer-shifts-its-skills-and-focus-193117.html

https://www.facebook.com/groups/360075600869445


MySQL - Delete Duplicate Rows

Tuesday, October 27th, 2020 | Coding

In case you want to delete duplicate rows and keep the lowest id, you can use the following statement:

DELETE
c1
FROM
contacts c1 INNER JOIN contacts c2 WHERE c1.id > c2.id AND c1.email = c2.email;

MySQL - Error 1067 - Invalid default value for

Monday, March 6th, 2023 | Server

The problem is because of sql_modes. Please check your current sql_modes by command:

show variables like 'sql_mode' ; 

And remove the sql_mode "NO_ZERO_IN_DATE,NO_ZERO_DATE" to make it work. This is the default sql_mode in mysql new versions.

You can set sql_mode globally as root by command:

set global sql_mode = 'ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';


MySQL - Getting Started

Tuesday, December 15th, 2020 | Technology

https://www.w3schools.com/sql/sql_stored_procedures.asp
https://www.w3schools.com/sql/sql_isnull.asp
https://www.w3schools.com/sql/sql_case.asp
https://www.w3schools.com/sql/sql_exists.asp


MySQL - Music Code ( Tips & Tricks )

Sunday, January 7th, 2018 | Coding

Raw MySQL for importing MP3's:

UPDATE app_music_songs SET file_path = REPLACE(file_path, '.mp3', ')
UPDATE app_music_songs SET length = SEC_TO_TIME(length_raw)

MySQL - Show Indexes for Database or Tables

Monday, June 20th, 2022 | Server

To see the index for a specific table use SHOW INDEX:

SHOW INDEX FROM yourtable;

To see indexes for all tables within a specific schema you can use the STATISTICS table from INFORMATION_SCHEMA:

SELECT DISTINCT
    TABLE_NAME,
    INDEX_NAME
FROM INFORMATION_SCHEMA.STATISTICS
WHERE TABLE_SCHEMA = 'your_schema';

Removing the where clause will show you all indexes in all schemas.


PayPal - Mass Payment Format

Friday, January 19th, 2018 | Technology

Save as .txt:

[email protected]	100.00	USD	ReferralType+ReferralId	ReferralNotes
[email protected]	100.00	USD	ReferralType+ReferralId	ReferralNotes
[email protected]	100.00	USD	ReferralType+ReferralId	ReferralNotes
[email protected]	100.00	USD	ReferralType+ReferralId	ReferralNotes
[email protected]	100.00	USD	ReferralType+ReferralId	ReferralNotes

Python - Coding Resources

Saturday, November 21st, 2020 | Coding

https://requests.readthedocs.io/en/master/user/quickstart/


Python - Get MAC Address

Thursday, January 18th, 2018 | Coding

from uuid import getnode as get_mac
mac = get_mac()
print mac
print hex(mac)
':'.join(("%012X" % mac)[i:i+2] for i in range(0, 12, 2))

Python - Simulate keyboard events on Linux

Friday, March 23rd, 2018 | Coding

https://pypi.python.org/pypi/keyboard/ http://infohost.nmt.edu/tcc/help/pubs/tkinter/web/key-names.html


Python - speech recognition via Google Speech API

Friday, March 23rd, 2018 | Coding

https://www.geeksforgeeks.org/speech-recognition-in-python-using-google-speech-api/ https://cloud.google.com/speech/quotas


Raspberry Pi - CPU Temperature on Pi 4 / Ubuntu 22

Tuesday, March 7th, 2023 | Technology

Install lm-sensors:

sudo apt lm-sensors

Basic command for temperature:

sensors

Add -f flag for Fahrenheit:

sensors -f

Display help:

 sensors --help

Raspberry Pi | As an OpenVPN Server

Tuesday, July 13th, 2021 | Technology

https://www.pcmag.com/how-to/how-to-create-a-vpn-server-with-raspberry-pi


Raspberry Pi | Full Screen Browser -Raspbian

Friday, March 23rd, 2018 | Technology

From the Desktop:

Simply use the Full Screen icon in the Browser zoom area. F11 or right-click to exit full screen.

From the Terminal:

chromium-browser --start-fullscreen https://e19creative.com

Full Screen at Boot:

https://blog.gordonturner.com/2017/07/22/raspberry-pi-full-screen-browser-raspbian-july-2017/


Raspberry Pi | GPIO - Python Basics

Wednesday, January 24th, 2018 | Technology

import RPi.GPIO as GPIO
GPIO.setmode(GPIO.BOARD)
GPIO.setup(11,GPIO.OUT)	
GPIO.output(11,GPIO.HIGH)
GPIO.cleanup()

Raspberry Pi | GPIO - Python Reference

Friday, March 23rd, 2018 | Technology

https://sourceforge.net/p/raspberry-gpio-python/wiki/Examples/

Raspberry Pi | Minecraft - Get Started

Wednesday, May 16th, 2018 | Technology

https://projects.raspberrypi.org/en/projects/getting-started-with-minecraft-pi/5
https://www.raspberrypi-spy.co.uk/2014/06/building-a-castle-in-minecraft-with-python/


Raspberry Pi | Node-RED

Sunday, June 10th, 2018 | Technology

https://nodered.org

http://10.0.1.12:1880/#flow/8fd6ed2d.cf9d2


Raspberry Pi | RetroPie ROMS

Tuesday, July 13th, 2021 | Technology

https://coolrom.com.au/roms/

https://the-eye.eu/public/rom/NES/

https://www.freeroms.com


Raspberry Pi | Setup Reference

Sunday, September 26th, 2021 | Technology

Database ( MariaDB / MySQL ):

https://raspberrytips.com/install-mariadb-raspberry-pi/

VNC:

https://www.youtube.com/watch?v=LTVtKiz2KGE&t=0s


Raspberry Pi | V4 Speech Synthesis Setup

Wednesday, April 14th, 2021 | Technology

Resources

https://stackoverflow.com/questions/44013933/how-to-use-web-speech-api-at-chromium
https://bbs.archlinux.org/viewtopic.php?id=243537
http://manpages.ubuntu.com/manpages/trusty/man1/spd-conf.1.html
https://linuxreviews.org/Speech-dispatcher


Recipes

Friday, May 7th, 2021 | Food

Oven Roasted Asparagus

https://www.allrecipes.com/recipe/214931/oven-roasted-asparagus/

Pizza Crust

1 package active dry yeast
1 tsp. granulated sugar
1 cup warm water ( 110-115 F )
2 1/2 cups bread flour
2 tbsp. olive oil
1 tsp. salt


Secret to Life

Saturday, August 12th, 2017 | Health

This small chart enables many powerful mantras:

Dynamic

[ Love-based ]

Static

[ Fear-based ]
Trust Mis-trust
Autonomy Shame or doubt
Initiative Guilt
Industry Inferiority
Identity Role Confusion
Intimacy Isolation
Dignity Addiction

Oddly, found this article in 2021: https://www.simplypsychology.org/Erik-Erikson.html


Shell - CLI / PHP | Terminal flags

Wednesday, October 31st, 2018 | Coding

Method for receiving Command Line Interface ( CLI ) variables in a PHP script:

Example: script.php -a 'hello' -b 'yes'

< ?php

	$a = $argv;
	$b = array();
	
	if (count($a) != 0) {
		
		foreach ($a as $arg){
		   list($x,$y) = explode('=', $arg);
		   $b["$x"]    = $y;  
		}
		
		$tweet = $b['tweet'];
		$authorized = $b['authorized'];
	
	}
	
	print_r($tweet);
	
? >


Shell - Command Line PHP Hacking Input

Friday, February 2nd, 2018 | Coding

Argv is default for incoming command line arguments, this applies to Python as well.

$a = $argv;
$b = array();
	
if (count($a) != 0) {
		
	foreach ($a as $arg){
	   list($x,$y) = explode('=', $arg);
	   $b["$x"]    = $y;  
	}
		
	$message = $b['message'];
	$key = $b['key'];
			
}

Shell - Make a LINUX file executable

Sunday, June 10th, 2018 | Technology

For one user:

chmod u+x script.sh

For all users:

chmod +x script.sh

Shell - NIX Save History to Text File

Wednesday, January 9th, 2019 | Server

history > history_for_print.txt

Shell - NIX Tail & Grep | Filter by Text

Tuesday, March 13th, 2018 | Coding

Load and watch access_log in realtime. Exclude lines with the defined IP addresses. * IP pipes may require a preceding backslash.

Live example:

sudo tail -f access_log | grep -v "75.185.171.22|127.0.0.1"

sudo tail -f -n 300 access_log | grep -v "75.185.171.22|127.0.0.1"

sudo tail -f -n 500 access_log | egrep "(e19creative.com)"

Include: tail -f mylogfile.log | grep "error: "
Exclude: tail -f -n 300 access_log | grep -v "string"
Exclude Multiple: tail -f -n 300 access_log | grep -v "string|string2"


Shell - Remote UNIX Command for Screensaver

Tuesday, June 30th, 2020 | System

open -a ScreenSaverEngine

Shell - Terminal NIX Zip Commands

Monday, December 3rd, 2018 | Server

Zip: zip -r source.zip source/

Unzip into target directory without archive folder: bsdtar -xf source.zip -s'|[^/]*/||'
( launch from the directory where you want the files )

Alternative Unzip: yum install p7zip | 7za x wordpress.zip


Shell - UNIX Network Scan ( arp-scan )

Thursday, April 19th, 2018 | Coding

sudo arp-scan --interface=en0 --localnet

Shell | Common GIT Commands

Tuesday, April 2nd, 2019 | Server

View differences:

git diff

View status:

git status

View status in current directory:

git status .

git diff HEAD 'filename'
git diff --cached 'filename'
git diff * git commit -a
git commit -a -m "commit notes"
git remote set-url origin ssh://git-codecommit.us-east-1.amazonaws.com/v1/repos/*reponame*
git remote -v
git pull
git branch

From Project notes:

https://stackoverflow.com/questions/215718/how-can-i-reset-or-revert-a-file-to-a-specific-revision

GIT Status shows all files as changed: https://github.com/microsoft/WSL/issues/184


SQL - Common SQL Server Commands

Friday, October 15th, 2021 | Coding

ALTER TABLE dbo.Employees 
ADD company VARCHAR (255) NULL;

####

Alter existing column:

ALTER TABLE Orders ALTER COLUMN shipToAddress1 VARCHAR (80);

ALTER TABLE Employees ALTER COLUMN address1 VARCHAR (80);

https://javarevisited.blogspot.com/2016/03/how-to-increase-length-of-existing-VARCHAR-column-in-SQL-Server.html#axzz7Lf1U1L2D


SQL - Server Setup Tutorial

Saturday, September 18th, 2021 | Technology

 sa - enable login

enable pipes / tcp/ip in service manager

enable windows and user authentication


Terminal - Decode Base64 File

Monday, July 25th, 2022 | Coding

base64 -d campus.base64 > test.zip


Thoughts - 02192021

Saturday, March 27th, 2021 | Inspiration

What is the purpose of writing? The purpose of writing is to express one’s self, thoughts, and experiences so they may be recollected at a later time. Writing is an excellent way to achieve your self clarity of thought and a traceable history of your own personal evolution.

It’s easier to attempt to be one’s self than it is to truly be. However, with practice and perseverance, we know that all things are possible - even the impossible.


VirtualBox | Install AlmaLinux 9

Thursday, September 29th, 2022 | System

https://www.digitalocean.com/community/tutorials/initial-server-setup-with-rocky-linux-9

https://www.how2shout.com/linux/how-to-install-almalinux-8-on-virtualbox-centos-alternative/

####

Resolving a VirtualBox lockup on Dell systems using the Intel I-219 Network Adapter

Does VirtualBox lockup when in use?

https://www.dell.com/support/kbdoc/en-us/000144673/resolving-a-virtualbox-lockup-on-dell-systems-using-the-intel-i-219-network-adapter

####

Apache / MariaDB:

https://www.linuxcapable.com/how-to-install-apache-httpd-on-almalinux-9/
https://dade2.net/kb/how-to-install-apache-mysql-and-php-on-almalinux-8/

PHP:

https://www.linuxcapable.com/how-to-install-php-8-1-on-almalinux-9/

####

https://computingforgeeks.com/configure-static-ip-on-rocky-almalinux/

####

Allow Access To Port SELinux, Firewall

https://paritoshbh.me/blog/allow-access-port-selinux-firewall


Visual Studio VS Code Regex to Find and Ignore Whitespace

Tuesday, March 7th, 2023 | Coding

Search for all instances of "FROM" + "PATIENTS" while ignoring whitespace:

from(\r\n)*\s+patients(\r\n)*\s+


Windows - Delete Hidden Files for Parallels

Sunday, December 5th, 2021 | System

del /s /q /f /a .DS_STORE
del /s /q /f /a ._.*

https://awesometoast.com/delete-all-instances-of-ds_store-in-windows/


Windows - IIS Setup / Configuration with CommandBox / Lucee

Tuesday, March 16th, 2021 | Server

IIS:

https://computingforgeeks.com/how-to-configure-default-site-in-iis-server
https://tecadmin.net/enable-url-rewrite-iis/

Lucee:

Lucee Lockdown - https://www.youtube.com/watch?v=wt4Y6uAPbc0

https://robertmunn.com/blog/logging-into-lucee-admin-of-a-new-instance
https://docs.lucee.org/guides/Various/TIPS/TIPS-custom-JARs.html

https://commandbox.ortusbooks.com/embedded-server/configuring-your-server/custom-error-pages
https://docs.lucee.org/guides/cookbooks/Exeception-Output.html
https://docs.lucee.org/reference/tags/error.html
https://docs.lucee.org/guides/cookbooks/application-context-basic.html

CommandBox:

https://www.ortussolutions.com/blog/screencast-starting-commandbox-servers-as-a-windows-service

 


Windows - Scheduled Task to call URL

Monday, June 27th, 2022 | System

https://serverfault.com/questions/829326/how-to-schedule-a-task-to-call-a-url

Windows - Server & IIS & CommandBox

Tuesday, May 25th, 2021 | System

https://cheatography.com/garciadev/cheat-sheets/commandbox/

https://commandbox.ortusbooks.com/embedded-server/configuring-your-server/url-rewrites

https://www.tutorialsteacher.com/articles/set-custom-domain-name-for-localhost-website-iis

https://cfconfig.ortusbooks.com/introduction/introduction

CFCONFIG

https://www.ortussolutions.com/blog/introducing-cfconfig-a-new-way-to-manage-your-cf-servers-configuration-from-the-command-line

https://cfconfig.ortusbooks.com/using-the-cli/command-overview/manage-datasources

 


WordPress - Beaver Builder Tips & Tricks

Tuesday, July 13th, 2021 | Technology

https://www.wpbeaverbuilder.com/woocommerce-single-product-page-builder


WordPress - Debug settings for wp-config.php

Wednesday, January 11th, 2023 | System

 

define( 'WP_DEBUG', true );
define( 'WP_DEBUG_LOG', true );
define( 'WP_DEBUG_DISPLAY', true );

WordPress - Default Database Character and Collation

Wednesday, November 16th, 2022 | Server

Character Set: utf8mb4
Collation: utf8mb4_unicode_ci


WordPress - DirectAdmin - Get rid of Imagick Warning

Thursday, October 14th, 2021 | System

https://forum.directadmin.com/threads/exif-and-imagick-installation.57876/


WordPress - Malware Scan

Wednesday, October 6th, 2021 | System

Malware Scan:

find . -name '*.php' -print0 | xargs -0 egrep -in 'wp_cd_code'

Search by Recents: ( add backslash-n after %p )

find . f -printf '%TY-%Tm-%Td %TT %p ' | sort -r

Notes:

https://www.google.com/search?q=lock360.php
https://www.getastra.com/blog/911/how-to-remove-the-backdoor-php-apiword-malware-from-your-wordpress-website
https://securityboulevard.com/2020/09/the-hidden-php-malware-that-reinfects-cleaned-files

Cleaning Scripts:

Search for “pwd163”
Search for 8/8 file creation date ( or other infection date )

Remove all htaccess files

Compare Main Folders
Compare Theme Files

Review Database


WordPress - Permissions Cleanup in LINUX

Thursday, December 27th, 2018 | Server

Common commands to standardize user and group, as well as permissions for directories and files:

Update user/group:
chown -R username public_html/ chgrp -R groupname public_html/
Add a backslash before the semicolon on the following commands:
Change directory permissions rwxr-xr-x: find . -type d -exec chmod 755 {} ;
Change file permissions rw-r--r--: find . -type f -exec chmod 644 {} ;

WordPress - Standard / Default Apache Security Headers

Thursday, May 26th, 2022 | Server

Header set Strict-Transport-Security "max-age=31536000" env=HTTPS
Header set X-XSS-Protection "1; mode=block"
Header set X-Content-Type-Options nosniff
Header always append X-Frame-Options SAMEORIGIN

 #Header add Content-Security-Policy "default-src 'self';
#Header set Feature-Policy "geolocation 'self'; vibrate 'none'"
#Header set Referrer-Policy "same-origin""
#Header Referrer-Policy: no-referrer-when-downgrade 

Header always set Content-Security-Policy "upgrade-insecure-requests;"


Architecture


Business

E19 | Marketing - Work ON your business vs IN your business

Coding

2023-03-08
ColdFusion - CF11 Mac OS X CLI
2023-03-08
ColdFusion - CF2016 cfdirectory
2023-03-08
ColdFusion - CF9 Ubuntu 9
2023-03-08
ColdFusion - CFBuilder Regular Expressions for Search
2023-03-24
ColdFusion - CFML Capitalize First Letter / Uppercase
2023-03-08
ColdFusion - DeSerialize JSON
2023-03-08
ColdFusion - Geocoding with Google Maps
2023-03-24
ColdFusion - Mac Development Setup
2023-03-08
ColdFusion - QR Code generation via Google Chart API
2018-03-23
HTML5 - Audio Waveform Visualizer
2018-01-31
HTML5 - Pre/Code line numbering, no copy
2018-01-25
Javascript | HTML Tag | Confirmation
2018-03-23
JavaScript | jQuery - Popup Overlay
JavaScript | Random Key
Javascript | Send OS X Notifications
2018-01-30
LINUX | Crontab Basics
2018-01-17
LINUX | Crontab Expressions
2018-01-07
Mac - Adobe DreamWeaver Regular Expressions for Search
2023-03-08
Mac - OS X Mail / Message DUMP Recents
2018-01-25
Mac - Wireshark Filter Basics
Minecraft - Java Coding
Minecraft - Python Coding
MySQL - Delete Duplicate Rows
2018-01-07
MySQL - Music Code ( Tips & Tricks )
Python - Coding Resources
2018-01-18
Python - Get MAC Address
2018-03-23
Python - Simulate keyboard events on Linux
2018-03-23
Python - speech recognition via Google Speech API
Shell - CLI / PHP | Terminal flags
2018-02-02
Shell - Command Line PHP Hacking Input
2018-03-13
Shell - NIX Tail & Grep | Filter by Text
2018-04-19
Shell - UNIX Network Scan ( arp-scan )
2022-02-22
SQL - Common SQL Server Commands
Terminal - Decode Base64 File
2023-03-07
Visual Studio VS Code Regex to Find and Ignore Whitespace

Design

2023-03-13
Bootstrap - 3 to 5 Migration Notes
2018-03-23
CSS - 3D cube
CSS - Clean & Simple Prompt
2018-03-25
CSS - Radio Button Options
2022-10-15
Export an SVG for web using Adobe Illustrator
2023-03-10
HTML - Favicon Generator for Websites
2022-10-04
Implementing WebP into your Website

Electronics


Entrepreneur

2022-06-27
Creating a CampGround Ideas and Inspiration
2018-01-13
Deconstructing Your Vision

Family


Financial


Food

Recipes

Gardening


General


Health

2017-08-12
Secret to Life

Inspiration

Thoughts - 02192021

Lifestyle

2018-03-23
Art of Modern Wizardry
2023-03-29
Mini Home Ideas and Inspiration

Lyrics


Marketing

2018-04-02
Javascript | Google Driving Directions
2018-01-17
Marketing Types

Music


Music Business

2018-01-13
ISRC Code Format

Parenting


Robotics

LEGO NXT RoboGlove

Server

CentOS 7 - Apache Virtual Host Setup
CentOS 7 - Apache | SSL CertBot
CentOS 7 - Networking Bridge for KVM
CentOS 7 - Virtual Machine | Virsh Common Commands
CentOS 7 - Virtualization - Network Bridge Setup
CentOS 7 - Virtualization - Virtio Bridge Example
ColdFusion - CentOS 7 CF 2016 PDF Generation Setup
2023-03-22
ColdFusion - Connector Config for RHEL/CentOS 7 Apache
ColdFusion - DSN Connection String for MySQL
2023-03-24
ColdFusion - Emergency Update March 2023
2023-03-08
ColdFusion - General LINUX Setup
2023-03-08
ColdFusion - Install ColdFusion 2021 on MacOS BigSur
2023-03-08
ColdFusion - Websocket Resources
2022-10-04
CommandBox - Common Commands and Cool Things
2022-01-03
CommandBox Headless Instance for Raspberry PI
DELL - iDrac6 vFlash Usage
2022-04-24
DirectAdmin - Let's Encrypt LEGO SSL Error - Incorrect Usage
2023-03-29
Get original remote IP address with CloudFlare and Apache / NGINX
IIS ISAPI Rewrites
2022-10-30
LINUX CloneZilla - Disk Image Backup and Restoration
Linux Server Installation Resources - CentOS
2022-09-30
LINUX | CentOS | Add User and allow Sudoers
LINUX | Install ExFat Utilities
LINUX | Show active listening tcp ports with process
2023-03-21
LUCEE - Clear all failed Tasks
2022-10-30
Mac - MAMP PRO & ColdFusion 2021 Setup / Development
Mac - Upgrade PHP to 7.3 from 5.x
2023-03-13
Microsoft RDP Remote Desktop - Copy & Paste not working
2022-07-30
Minecraft - Server Links & Resources
2023-03-06
MySQL - Error 1067 - Invalid default value for
2022-06-20
MySQL - Show Indexes for Database or Tables
Shell - NIX Save History to Text File
Shell - Terminal NIX Zip Commands
2023-03-29
Shell | Common GIT Commands
Windows - IIS Setup / Configuration with CommandBox / Lucee
2022-11-16
WordPress - Default Database Character and Collation
WordPress - Permissions Cleanup in LINUX
2022-05-26
WordPress - Standard / Default Apache Security Headers

System

AWS - SES for Receiving Emails
2022-12-28
CentOS 7 - Server Commands - Apache Log Management
2022-06-28
CloudFlare - Default / Preferred Settings
2023-03-08
ColdFusion - FW/1 Tips & Tricks
ColdFusion Fusebox - Clear Caches
2022-10-19
Install NGINX on AlmaLinux 9
Install VirtualBox on Alma9
2022-10-04
LINUX Create User and add to Wheel / Sudoers
2022-10-30
Mac - Docker SQL Server Setup / Azure Data Studio Restore
2022-04-08
Mac - MAMP Path Migrations and MySQL Fixes
Mac - Network Utility Replacement Commands in Terminal
Shell - Remote UNIX Command for Screensaver
2022-10-19
VirtualBox | Install AlmaLinux 9
2023-03-13
Windows - Delete Hidden Files for Parallels
Windows - Scheduled Task to call URL
Windows - Server & IIS & CommandBox
2023-01-11
WordPress - Debug settings for wp-config.php
WordPress - DirectAdmin - Get rid of Imagick Warning
WordPress - Malware Scan

Technology

Adafruit - FT232H - USB to GPIO Interface
2023-03-08
ColdFusion - Connector Config for OS X Apache
2023-03-08
ColdFusion - Implementing CORS Upload for S3 in ColdFusion
2022-10-21
DreamWeaver - Cloaking Settings for Files and Folders
2018-01-27
FT232H - Python ( Basic GPIO )
2018-06-10
IP2Location | Map
IPv6 Considerations
Mac - Hide Hidden Files
2018-03-23
Mac - Homebrew | Install FFMPEG
MySQL - Getting Started
2023-03-08
PayPal - Mass Payment Format
2023-03-12
Raspberry Pi - CPU Temperature on Pi 4 / Ubuntu 22
Raspberry Pi | As an OpenVPN Server
2018-03-23
Raspberry Pi | Full Screen Browser -Raspbian
2018-01-24
Raspberry Pi | GPIO - Python Basics
2018-03-23
Raspberry Pi | GPIO - Python Reference
2018-05-16
Raspberry Pi | Minecraft - Get Started
2018-06-10
Raspberry Pi | Node-RED
Raspberry Pi | RetroPie ROMS
Raspberry Pi | Setup Reference
Raspberry Pi | V4 Speech Synthesis Setup
2018-06-10
Shell - Make a LINUX file executable
SQL - Server Setup Tutorial
WordPress - Beaver Builder Tips & Tricks


E19 Creative

Products | Community | Support | About | Contact | Login