alainwolf

Nextcloud 31 Database Upgrades

After upgrading from Nextcloud 30.x to 31.x I get the following warning in the admin interface:

Incorrect row format found in your database. ROW_FORMAT=Dynamic offers the best database performances for Nextcloud. Please update row format on the following list: oc_collres_collections, oc_phonetrack_geofences, oc_storages, ...

For more details see the documentation↗.

alainwolf

# This script cross-references IP addresses from a text file with a CSV file
# and outputs the matched IPs to stdout.
# Its purpose was to find IPs from UptimeRobot that are in the Turris greylist.

import csv
import requests

# File URLs
uptimerobot_ips_url = "https://uptimerobot.com/inc/files/ips/IPv4andIPv6.txt"
turris_greylist_url = "https://view.sentinel.turris.cz/greylist-data/greylist-latest.csv"

alainwolf

#!/usr/bin/env bash
# *****************************************************************************
# Override of the default `librespeed` cron job  command as provided by
# Turris Omnia
# See https://forum.turris.cz/t/turris-os-7-1-4-is-out/21639/12?u=milkandhoney
#
# Required packages: coreutils-date, jq
#   opkg update && opkg install coreutils-date jq
#
# *****************************************************************************

alainwolf

#!/usr/bin/env bash
# ****************************************************************************
# Create radom cron job starting times
# for hourly, daily, weekly, monthly or yearly jobs
#
# https://gist.github.com/alainwolf/931316e4f5af0c45b352a1823ec3321c
# Copyright (C) 2024 Alain Wolf
# ****************************************************************************

# What kind of shedule do you want to create?

alainwolf

# ************************************************************************
# SSH Server Configuration for a router be used as SSH jump host
# OpenSSH_9.8p1, OpenSSL 1.1.1w  11 Sep 2023
# ************************************************************************
#
# Updated on Fri, 16. Aug 2024 19:37 by Alain Wolf
#

Include /etc/ssh/sshd_config.d/*.conf

alainwolf

#!/usr/bin/env ash
# shellcheck shell=dash
# ---------------------------------------------------------------------------
#
# Download and update ip blacklist
# for Turris Omnia 7.x or earlier or Openwrt before 22.03 (fw3/iptables)
# See
# - https://www.abuseipdb.com/
# - https://github.com/borestad/blocklist-abuseipdb
#

alainwolf

# /etc/ssh/ssh_config

#
# All my hosts are reachable by IPv6 only. IPv6 addresses don't get spammed with SSH login probes.
# But what if I need to connect from a network which has no IPv6 enabled?
# Setup an SSH jump host which is reachable over IPv4 and use that only if the target host is unreachable by IPv6
# 
Match host *.example.net,!ipv4.example.net !exec "ip route get $(host %h | grep 'IPv6 address' | awk '{print $NF}') &> /dev/null"
    ProxyJump ipv4.example.net

alainwolf

#!/bin/bash
#
# Refresh list of Internet root servers from Internic
# See https://www.iana.org/domains/root/files
#

# Vars
REMOTE_URL="https://www.internic.net/domain/named.cache"
LOCAL_FILE="/var/lib/unbound/root.hints"
FILE_USER="unbound"

alainwolf

#!/usr/bin/env bash
# ******************************************************************************
# MariaDB Backup Scrip to be run on Synology NAS
# (MariaDB 10.3.29-1038 package published by Synology Inc.)
#
# * Full online physical backups with mariabackup:
#  - no databse downtime (as with physical copy or HyperBackup)
#  - database caches are not affected (as with SQL-dumps)
# * Ensure only one single instance is running at same time
# * Ensure at least one successful full backup is present at all times

alainwolf

#!/usr/bin/env bash
#
# Compare Domain Serials of hidden primary server with public servers
#

# Our hidden primary server
_PRIMARY_SERVER="dns0.example.net."

# The domain to query
_domain="$1"