Starting with MariaDB 10.4 (released in June 2019), you can use the OR keyword with IDENTIFIED VIA to allow any-of several authentication methods: CREATE OR ALTER USER `minecraft` IDENTIFIED VIA unix_socket OR mysql_native_password USING PASSWORD("s3cr3tpasswvrd"); Even if your OS vendor kinda sucks at providing updates, MariaDB provides an official repository serving at least this version to distributions as old as Ubuntu 14.04, CentOS & RHEL 6, Debian 7, and Fedora 28 …
Is Gab a controlled-opposition operation?
This post will be sort of an "archive" of everything about Gab that gives me the heebie-jeebies.
JS: Tail-call optimized recursive setTimeout
If you're writing some code on a time-delayed-loop in JavaScript, there are 2 main options: setInterval setTimeout, recursively However, each has a potential downside: setInterval schedules the code to run at the given interval, regardless of whether the last invocation has completed. This means that, if the function takes longer than the delay to execute, it'll schedule the next invocation before the current invocation is finished, which can lead …
[DRAFT] Pleroma on Docker Compose
This testing was done with Pleroma 2.4.1, in environment Rocky Linux 8 (Before starting, be sure docker and docker-compose are installed, as well as git, and NGINX.) Fetch and prepare the source code: git clone -b stable –depth=10 "https://git.pleroma.social/pleroma/pleroma.git" && cd pleroma git fetch –depth=20 "https://git.lain.church/squeegily/pleroma.git" "feature/docker-compose":"feature/docker-compose" && git -c "user.name=Anonymous" -c "user.email=nobody@localhost" merge –no-commit "feature/docker-compose" read -p "Enter your domain name: " pleroma_domain Build it: mkdir -vp uploads …
Docker: remove all containers and images
docker rm -f `docker container ls -a -q` && docker rmi -f `docker image ls -a -q`
Garland Favorito bumped from witnessing
“Yeah, so, thank you, John, for, again, letting me tell you this story; it's now become more amazing. Senator Ligon cut me from the testimony yesterday; I was the #7 defense witness for the President, and Senator Ligon cut me out and moved me to the bottom and then cut off the witnesses and ended the hearing without me getting to testify. We were wondering why he did this and then realized that my testimony would have exposed the Secretary of State of Georgia, the Elections Director of Georgia, and the Legal Counsel of Georgia for the Secretary of State, all for wrongdoing…”
Recovering an eBay account permanently suspended for no reason
“We have reviewed the activity we have seen connected to your account. As a result, your account has been suspended because we believe this activity presents a risk to our eBay community. We do not make this decision lightly… there is no appeal for this decision.”
Installing NGINX on CentOS 8
Installing NGINX on RHEL-spectrum systems, from the official repo http://nginx.org/packages/${distro}/${distrorel}/${arch}
Installing Docker+Compose on CentOS 8
How to install Docker + Compose (and also grab Git and Nano while you're in there): This is mostly a tl;dr of the instructions: sudo dnf remove docker\* sudo dnf config-manager –add-repo https://download.docker.com/linux/$(. /etc/os-release;echo $ID)/docker-ce.repo sudo dnf install docker-ce docker-ce-cli git nano sudo curl -fL "https://github.com/docker/compose/releases/download/v2.3.3/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose && sudo chmod +x /usr/local/bin/docker-compose sudo systemctl enable –now docker sudo usermod $(whoami) -a -G docker
[obsolete] Gab Social on CentOS 8 via Docker Compose
This post is not relevant anymore. Gab has permanently removed (and will not be re-enabling) Federation in any capacity, so there's no point to even considering running your own Gab Social-based site. These instructions cover the complete process, “all batteries included”, as I executed this on a VPS. First, install Docker+Compose. Then, grab the Gab source code and build it: git clone -b develop https://code.gab.com/gab/social/gab-social.git (No; they do not …