MySQL: authenticate via Unix user OR password

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 …

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

selinux allow httpd access to folder

If, for instance, you are serving the internet stuff at /srv/stuff/TehInternetz instead of (or in addition to) the default /var/www, and selinux is preventing Apache/NGINX from accessing the files, run the following: dnf install policycoreutils-python-utils || yum install policycoreutils-python || apt install semanage-utils semanage fcontext -a -e /var/www /srv/stuff/TehInternetz restorecon -R -v /srv/stuff/TehInternetz