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

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/

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

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

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

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

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.

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

Live example:

virsh dumpxml
virsh dumpxml centos7.0

virsh list
virsh list --all

virsh edit centos7.0

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

<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>

SSL/TLS

Full Strict

SSL/TLS

Edge Cert

Always use HTTPS
TLS 1.2

Security

Bots
Bot Fight Mode

Speed

Optimization
Early Hints

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

#!/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

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

#!/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

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

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

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

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

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

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#

Connection String

zeroDateTimeBehavior=convertToNull&serverTimezone=America/New_York

The five most helpful links:

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

Reinitialize the framework:

?fwreinit=xxx

?reload ( pulls latest values from config to database )

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

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

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

Install ColdFusion 2021 on BigSur

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

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

< 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" />

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/

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

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

{

    "JVM":{

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

    },

    "name":"sentinel.local",

    "openbrowser":false,

    "web":{

        "host":"sentinel.local",

        "http":{

            "port":"80"

        },

        "rewrites":{

            "enable":true

        }

    }

}

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

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

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

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

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:

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

The fix, just rebuild LEGO:

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

.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

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

This works perfect:

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

####

Note: BOYD

# 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!'

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

https://favicon.io works the best. 

https://wavesurfer-js.org

View Source:

 line 1
 line 2
 line 3
 line 4
 line 5

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

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

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

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

We are starting here:

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

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

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

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

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

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

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

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

< 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>

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

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

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

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

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

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

Oracle-defined CRON Expressions

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

ss -ltup

< 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>

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

://[^w]*.patentawards

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

Show hidden files:

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

Hide hidden files:

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

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

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

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

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

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

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

html contains 'keyword'
frame contains 'keyword'

Kept these around to inspire new ideas:

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\

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

https://javaminecraft.com/spigot/

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/

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

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

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

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;

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';

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

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)

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.

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

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

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))

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

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

Install lm-sensors:

sudo apt lm-sensors

Basic command for temperature:

sensors

Add -f flag for Fahrenheit:

sensors -f

Display help:

 sensors --help

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

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/

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

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://nodered.org

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

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

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

https://www.freeroms.com

Database ( MariaDB / MySQL ):

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

VNC:

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

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

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

This small chart enables many powerful mantras:

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

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);
	
? >

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'];
			
}

For one user:

chmod u+x script.sh

For all users:

chmod +x script.sh

history > history_for_print.txt

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"

open -a ScreenSaverEngine

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

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

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

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

 sa - enable login

enable pipes / tcp/ip in service manager

enable windows and user authentication

base64 -d campus.base64 > test.zip

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.

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

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

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

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

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

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

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

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

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

Character Set: utf8mb4
Collation: utf8mb4_unicode_ci

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

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

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 {} ;

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;"