Traccar: Fix “The write format 1 is smaller than the supported format 2”

systemctl stop traccar
mkdir /opt/FIXH2
cd /opt/FIXH2
mv h2 ./h2.2019
mv h2 ./h2.2022
find ./ -name "*.jar"
cp -p /opt/traccar.4.13/data/ /opt/FIXH2
java -cp ./h2.2019/bin/h2-1.4.200.jar -url jdbc:h2:./database -user sa -script -options compression zip
java -cp ./h2.2022/bin/h2-2.0.206.jar -url jdbc:h2:./database_new -user sa -script -options compression zip
cp ./ /opt/traccar/data/
systemctl start traccar

HOWTO extract Nginx logs for the past hour/s

Here’s a quick and handy “awk” snippet to extract data from Nginx’s access or error log file for the past hour/s.

# awk -v d1="$(date --date '-60 min' '+%d/%b/%Y:%T')" '{gsub(/^[\[\t]+/, "", $4);}; $4 > d1' /var/log/nginx/access.log

This example shows how to extract data from /var/log/nginx/access.log for the past 60 minutes – ‘-60 min’.

HOWTO exclude specific packages from being updated via yum or dnf

Here are a few examples on how to exclude some packages from being updated during yum/dnf update:

# yum update --exclude=PACKAGENAME 

Exclude all kernel related packages during update:

# yum update --exclude=kernel*

Exclude gcc and java:

# yum update --exclude=gcc,java

Exclude all gcc and php related packages:

# yum update --exclude=gcc* --exclude=php*

In order to permanently exclude/disable updating of some specific packages you might want to update your dnf.conf or yum.conf eg:

exclude=kernel* php*             <---