Life!

MySQL 8.0.27 upgrade failure

If after the upgrade the mysql doesn't start don't panic! In mysql8 mysql_upgrade command is dummy, and the database upgrades automatic on first restart. In my scenario I was upgrading from 8.0.26 to mysql8.0.27 and I see errors like bellow and the database won't start:

FreeBSD

Upgrade PostgreSQL 13.5 to 14.1 on FreeBSD

Stop your postgresql database daemon on FreeBSD machine: service postgresql stopCreate package containing your old version ( 13.5 ) binaries ( depends are you using postgresql13-contrib package, but command will not fail if it is missing ) pkg create postgresql13-server postgresql13-contribUncompress them somewhere in the filesystem - in our example it is into

FreeBSD

Howto run and update ghost 4.x on node.js 17.x

It looks that there is big inconsistency in FreeBSD ports - related to python 3.10 and node.js. Currently only node.js 17.x can be build if you have such combination of programming languages on your system. And the greatest news is that ghost 4.x runs on

MySQL

Ghost and sqlite3

After many problems and outages of my blog now It is clear for me that it is better to use mysql as database backend in Ghost CMS! It looks that with Node14 it doesn't work with sqlite3 database backend. Migration is easy - just take the latest backup *.json file

Matomo INFILE usage with MySQL8 and PHP8

It looks tricky to cheat matomo INFILE usage when you use PHP8 and MySQL8. My quick hints are: Did you have put in my.cnf file:secure-file-priv = //matomo/tmp/assets/2. Do you have in php-fpm.conf file line like: php_admin_value[mysqli.allow_local_infile] = 1

Триумфът на стадния имунитет ...

Поредния анализ публикуван от Георги К. Маринов работещ в Department of Genetics, Stanford University, Stanford, California 94305, USA. Оригиналният текст е публикуван от г-н Маринов в Google Disk тук: 2021-06-05-herd-immunity.pdfGoogle DocsНаправил съм mirror на публикувания pdf на линкът по-долу: 2021-06-05-herd-immunity.pdfJordan Cloud - Safe home for your data!Jordan

Локдаун за последно или до безкрай?

Поредният много силен материал от Георги К. Маринов работещ в Department of Genetics, Stanford University, Stanford, California 94305, USA 2021-03-18-ZeroCOVID.pdfGoogle DocsИ локално копие: 2021-03-18-ZeroCOVID.pdfNextcloud - a safe home for all your dataNextcloudДруги материали от същият автор тук или тук - с давност почти една година. Има и видео

Cisco

Cisco Live 2021

Cisco Live 2021 | Digital Networking EventIn 2021, Cisco’s premier education and training event for IT professionals is going global. Join us on March 31 - April 1, 2021.Cisco

FreeBSD

Installing [matrix]-bridges on FreeBSD

Here is my example using mautrix-facebook as example‌ $ mkdir bridges/facebook $ cd bridges/facebook $ virtualenv -p /usr/local/bin/python3.7 . $ bash $ source bin/activate $ pip install --global-option=build_ext --global-option="-I/usr/local/include" --upgrade git+https://github.com/tulir/mautrix-facebook.git#egg=mautrix-facebook[all] $ cp example-config.yaml config.

FreeBSD

ELF binary type "0" not known.

Today I've invested some time to bring back to life my personal Cloud storage. The reason for his death was upgrade to PHP8. So after some research I've found that at this moment the only compatible to that php version was NextCloud 21. I have made an quick migration from

FreeBSD

Build graphics/pecl-imagick PHP 8 compatible extension

The version in the ports tree is not working - it shows some errors when installed. But the source on the master brach of the Imagick repo seems to work. Here's how you can use it. Clone the repo somewhere on diskExecute following commands:cd phpize ./configure make make install

FreeBSD

How to build and install Mattermost plugins on FreeBSD

I was unpleasantly surprised to find that all plugins published on Mattermost plugin marketplace are not working on installed server on FreeBSD. They all are failing to start - it doesn't matter did you enabled linux64 emulation inside the OS. After some research I have found that the problematic area

HAProxy

How to made Websocket traffic to go via HAProxy

The solution was simple: Tell HAProxy to tag Websocket traffic, and set up a separate but otherwise identical backend for this specific use case. One of typical applications which is using Websocket traffic is Slack. An excelent opensource alternative of it named Mattermost. The result looks something like this in

QoS

IP QoS

Excelent arcticle explaining IPv4 QoS QoS Values

Telco

How to set DSCP/COS in FreeBSD and use it in Telco environment

Preserving QoS parameters in Telco environment, where part of the equipment is following 3gpp rules and other part is followin ietf rfcs rules is really chalenging. And of course there is allways need to add some additional freeware equipment ... Reference (recomendation) tableIn above table is used information from Ericsson excelent

DNS

Using Hurricane Electric free DNS service to speedup your DNS service

So apart from setting ns[2345].he.net as your DNS servers at your registrar and adding a slave at http://dns.he.net you need to do the following: Allow transfer AXFR to slave.dns.he.net. Server that pulls zones is slave.dns.he.net, not ns1.he.

FreeBSD

Problems with transmission-daemon with IPv6 and some other popular issues

Remove IPv6 detectionThe problem with net-p2p/transmission-daemon and IPv6 is that transmission developers are … not willing to implement such functionality as visible from: https://trac.transmissionbt.com/ticket/4197 So the user who need to use IPv6 but NOT use IPv6 with transmission are left alone. So you can use

FreeBSD

How to grow zfs on FreeBSD running inside VMWare

Live ZFS resizing inside VMWare should be possible, but there are several steps: - First you should resize your virtual disk in VMWare configuration. Recomendation is all virtual disks to be similar size for best performance in VMWare. - Ideally VMWare should notify guest OS that resize happened. You should

Cisco

How to serve multiple search domains from Cisco IOS DHCP server?

Source - https://www.perkin.org.uk/ The expected [code language="plain"]ip dhcp pool host.net.example.com option 119 ascii net.example.com,example.com[/code] doesn't work. So you need to encode search domains in hex using following example script written in Python: [code language="python"]#!/usr/

FreeBSD

MySQL command for finding all MyISAM databases, and convert them to innodb

Today most popular storage engine in latests MySQL databases is InnoDB. But if you have older databases, before the times when InnoDB becomes the king, you must somehow convert your data. You can easy find which tables are using an older storage engine using: SELECT TABLE_SCHEMA as DbName ,TABLE_

FreeBSD

TCP Fast Open (TFO) on FreeBSD

TCP Fast Open (TFO) is an extension to speed up the opening of successive Transmission Control Protocol (TCP) connections between two endpoints. It works by using a TFO cookie (a TCP option), which is a cryptographic cookie stored on the client and set upon the initial connection with the server.

Telco

5G vs 4G

https://youtu.be/_B-otIZEGnQ

FreeBSD

How To Secure HAProxy with Let's Encrypt

Combine fullchain.pem and privkey.pem DOMAIN='example.com' ; sudo -E bash -c 'cat /usr/local/etc/letsencrypt/live/$DOMAIN/fullchain.pem /usr/local/etc/letsencrypt/live/$DOMAIN/privkey.pem > /usr/local/etc/haproxy/$DOMAIN.pem'The first thing we want to add is a frontend to handle incoming HTTP

MySQL

How-to fix Illegal mix of collations errors in mysql

If you have errors like my example bellow into your postfix logs - you can fix them easy : warning: mysql:/usr/local/etc/postfix/mysql_virtual_alias_maps.cf: query failed: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_unicode_ci,COERCIBLE) for operation '=' Get the

FreeBSD

Procedure to replace a zfs on root disk (zroot)

Редактиране на публикацияSwitch to draftПрегледОбновяванеДобавяне на заглавие The procedure, as typed, for replacing ada2 with ada8: # gpart backup ada2 | gpart restore -F ada8 # zpool replace zroot /dev/ada2p3 /dev/ada8p3 (wait for resilver checking via "zpool status") # swapoff /dev/ada2p2 # swapon /dev/ada8p2 ( verify via swapinfo ) If the size of