Linux – Page 2

How to set up RPZ in Bind9 (site blocking)

In this article, I will give a simple example of setting up RPZ in Bind9.
RPZ (Response Policy Zone) allows you to block access to malicious and prohibited sites by domain name, IP address or network, block DNS servers.

ABillS log rotation

Since some ABillS log files gradually increased in size, I wrote a script to rotate these logs.

Setting up a DNS zone in Bind9

In this article, I will give an example of adding a DNS zone to Bind9.

Phabricator error – Attempting to construct a query using a non-utf8 string when utf8 is expected

I once noticed in Phabricator that one of the repositories is constantly with the Importing status (99.93%) … And I found the following errors in the logs:

Configuring logrotate to rotate logs

Logrotate is used to control the logging system, compress log files, delete old ones, etc.
The configuration is located at /etc/logrotate.d/ and /etc/logrotate.conf.

Phabricator log rotation

In this article, I will give an example of configuring Phabricator log rotation.

ABillS. s_detail table grows

One day in July 2022, Zabbix told me that the size of the ABillS database exceeded 3 gigabytes, I created this trigger after installing Abills in 2018. After looking at the tables in the database, I noticed that the s_detail table began to grow strongly, before that it occupied several tens of megabytes in a month, and in July 2022 it grew by more than 2 GB. to reduce the size of the database, I removed the s_detail tables from the past months. I tried to specify s_detalization=0 in the configuration, but the table continued to grow. For example, 717,082 records (97 MB) were added to it in a day, for a month it turns out an example of 3 GB.

Category Archives: Linux