MySQL 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 14.5 to 15.x on FreeBSD New version of postgresql 15 database have arrived. I have updated the manual to newest possible upgraded version on 14 october 2022. Stop your postgresql database daemon on FreeBSD machine: service postgresql stop Create package containing your old version ( 14.5 ) binaries ( depends are you using postgresql14-contrib package, but command
FreeBSD Howto run and update ghost 4.x on node.js 17.x It looks that there is big inconsistency in FreeBSD ports [https://www.freebsd.org/ports/] - related to python 3.10 [https://www.python.org] and node.js [https://nodejs.org/en/]. Currently only node.js 17.x can be build if you have such combination of programming languages 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
WEB Matomo INFILE usage with MySQL8 and PHP8 It looks tricky to cheat matomo [https://matomo.org] INFILE usage when you use PHP8 [https://www.php.net/releases/8.0/en.php] and MySQL8 [https://www.mysql.com]. My quick hints are: 1. Did you have put in my.cnf file: secure-file-priv = //matomo/tmp/assets/ 2. Do you
Personal Триумфът на стадния имунитет ... Поредния анализ публикуван от Георги К. Маринов работещ в Department of Genetics, Stanford University, Stanford, California 94305, USA. Оригиналният текст е публикуван от г-н Маринов в Google Disk тук: 2021-06-05-herd-immunity.pdfGoogle Docs
Personal Локдаун за последно или до безкрай? Поредният много силен материал от Георги К. Маринов [https://www.facebook.com/gkmarinov] работещ в Department of Genetics, Stanford University, Stanford, California 94305, USA 2021-03-18-ZeroCOVID.pdfGoogle Docs [https://drive.google.com/file/d/1eOHEejDD77sCWQk6nkazAejgi2fbhjWQ/view]И локално копие: 2021-03-18-ZeroCOVID.pdfNextcloud - a safe home for all your dataNextcloud [https://cloud.
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 [https://www.ciscolive.com/emea.html]
FreeBSD Installing [matrix]-bridges on FreeBSD Here is my example using mautrix-facebook [https://github.com/tulir/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[
FreeBSD ELF binary type "0" not known. Today I've invested some time to bring back to life my personal Cloud storage [https://cloud.ostreff.info/]. The reason for his death was upgrade to PHP8 [https://www.php.net/releases/8.0/en.php]. So after some research I've found that at this moment the only compatible to
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 [https://github.com/Imagick/imagick] seems to work. Here's how you can use it. 1. Clone the repo somewhere on disk 2. Execute
FreeBSD How to build and install Mattermost plugins on FreeBSD I was unpleasantly surprised to find that all plugins published on Mattermost plugin marketplace [https://integrations.mattermost.com] are not working on installed server on FreeBSD. They all are failing to start - it doesn't matter did you enabled linux64 emulation [https://docs.freebsd.org/en/books/handbook/linuxemu/] inside
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 [https://slack.com/]. An excelent opensource alternative of it named Mattermost [https://mattermost.com]. The
QoS Featured IP QoS Excelent arcticle [http://www.netcontractor.pl/blog/?p=1161] explaining IPv4 QoS QoS Values
Telco How to set DSCP/COS in FreeBSD and use it in Telco environment Preserving QoS [https://en.wikipedia.org/wiki/Quality_of_service] parameters in Telco environment, where part of the equipment is following 3gpp [https://www.3gpp.org] rules and other part is followin ietf [https://www.ietf.org] rfcs rules is really chalenging. And of course there is allways need to
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 [http://t.umblr.com/redirect?z=http%3A%2F%2Fdns.he.net&t=ODAzYzgyYzgyYjc4Nzc3MWYzMGU5ODcxZmU0M2Q2YzA2ZDc5MTQ3NCxjRmFOU21PWA%3D%3D&b=t%3AyC21hTB-EApArzTh4CNbnA&p=http%3A%2F%2Fstuff.baturin.org%
FreeBSD Problems with transmission-daemon with IPv6 and some other popular issues Remove IPv6 detection The 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
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. Then check what is disk configuration using: # gpart show => 34 629145526 da0 GPT
Cisco How to serve multiple search domains from Cisco IOS DHCP server? Source - https://www.perkin.org.uk/ [https://www.perkin.org.uk/posts/serving-multiple-dns-search-domains-in-ios-dhcp.html] 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
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.
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