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
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#
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
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
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/
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%
FreeBSD Problems with transmission-daemon with IPv6 and some other popular issues Remove IPv6 detection Current port version inside net-p2p/transmission-components must be extracted with command FLAVOR=daemon make extract then edit file work-daemon/transmission-4.0.5/libtransmission/net.cc searching for ipv6. Then just reinstall with FLAVOR=daemon make deinstall install clean The problem with net-p2p/transmission-daemon and IPv6 is that
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
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
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
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
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
Personal Featured Промяна След дълги и мъчителни експерименти да продължа да използвам WordPress [https://wordpress.org] като система задвижваща персоналният ми сайт [https://ostreff.info], установих че е просто невъзможно в настоящият момент той да бъде използван като комбинация на plugins [https://wordpress.org/plugins/] и themes [https://wordpress.org/themes/] в комбинация
FreeBSD Enable WDDX extension in PHP 7.4 or 8.0 This extension is DEPRECATED and REMOVED as of PHP 7.4 or 8.x. What is WDDX – WDDX (Web Distributed Data eXchange) is a programming language, platform and transport-neutral data interchange mechanism designed to pass data between different environments and different computers. #cd ~<some_user_home> #git clone
