Menu

Николай Николов

About Николай Николов

https://root.bg/blog

Съпруг,Баща,Блогър,IT

Posts by Николай Николов:

Delete systemd journal logs

, , , 0

Hello,

Today on one of my server I saw that the disk space in /var is low, and the reason for that was in /var/log/journal.

In this post I will share how to delete systemd journal logs right, and how to make our server to do this alone.

root@mp-web06:/var/log# du -sh * |grep G
4.1G journal

Delete systemd journal logs older than X days

root@mp-web06:/var/log# journalctl --vacuum-time=5d
Deleted archived journal /var/log/journal/a20c526fbd1ffe2fe0fc6d5056053509/user-1003@55bfa9c91d5944b3a7a133fcec536fb8-000000000042a6ee-00057dd636182198.journal (8.0M).
.....
Vacuuming done, freed 3.8G of archived journals from /var/log/journal/a20c526fbd1ffe2fe0fc6d5056053509.

The idea here is the server will delete the logs older than 5 days.

Още..

Mikrotik Winbox for MacOS

, , 0

Hello,

In this post I will share how to run Winbox for MacOS.

We will need this tools to do it:

  • Wine
  • XQuartz
  • Winbox
  1. First, we need to install XQuartz – version 2.7.9 от тук. XQuartz is needed for wine installing!
  2. After that we need to install wine from their official website – winehq.org
  3. Finally, we need to download the winbox and run in from wine terminal ; wine winbox.exe

Mikrotik Winbox за MacOS

That’s it!

Beard

, 0

Hello,

I want to say that I’ve been bearded for a few months! I decided to try something new because I barely got my hair – the beard was a good option for me for experiments =)

брада

I was provoked by my friend Ivan Zhelev and I decided to try, and I liked it!

The first few weeks were the most difficult and painful, especially for me – I never had a beard until now! Of course, maintenance is very important – I have taken the necessary things and I take care of it regularly! I didn’t go to Bradao yet, but I will try it soon!

I share photos of myself and Borka with 4 months of difference between them – the little one has grown a lot – my beard too! 🙂

WordPress and MySQL 8

, , , 0

Wordpress и MySQL 8Hello,

I’m fan of new technologies and I love updates;))

For this reason, root.bg is now working on MySQL 8!

In this post I will share the special features of releasing version 8 and what we need to do our wordpress – especially if its base is large, old and with different types of charset and collation. To emphasize that I migrated from MariaDB 10.2 and for this purpose I picked up a new MySQL server – I did not do mysql_upgrade, and dump and restore the base!

More details about the new features in MySQL 8 can be found on their official site.

What is important for wordpress is precisely this :

  • Character set support.  The default character set has changed from latin1 to utf8mb4. The utf8mb4 character set has several new collations, including utf8mb4_ja_0900_as_cs, the first Japanese language-specific collation available for Unicode in MySQL. For more information, see Section 10.10.1, “Unicode Character Sets”.

This is the problem I encountered after I poured the root.bg base of the new mysql server. Here are all the publications written in Cyrillic:

mysql 8 wordpress chartset problem

 

The reason for this is the encoding in MySQL.

This problem can be solved in two ways – by setting it on the server itself or in our wordpress configuration file.

Here are two ways:

In MySQL:

character-set-server=latin1

We can test this from mysql console:

SHOW VARIABLES LIKE 'character\_set\_%';

and we should see this result :

+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| character_set_client | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8mb4 |
| character_set_server | latin1 |
| character_set_system | utf8 |
+--------------------------+---------+
7 rows in set (0.00 sec)

In wordpress:

In the wordpress configuration file – wp-config.php, we add the following line:

define('DB_CHARSET', 'latin1');

And now we have a working wordpress on MySQL 8!

P.S.
root.bg lives on :
ubuntu 18.04.1
nginx 1.14.0
php 7.2.11
mysql 8.0.13
memcached 1.5.6

Thats it!

Load More