IT Blog - Page 15 of 153 - Vyacheslav Gapon - personal blog, manuals, articles, notes, development

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.

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.

Phabricator. Clearing the cache

I will give an example of clearing the cache in Phabricator.

Bridge Domain Configuration on Juniper MX

For example, on Cisco switches and other manufacturers, in order for traffic of one or more vlans to go between ports, you just need to specify the necessary VLANs on these ports, on Juniper, in addition to configuring ports, you also need to add these ports to the bridge domain, without this traffic between ports will not go.

Solution for error 21S01 Column count doesn’t match value count at row 1

Once it was necessary to make a record in the table very quickly and I quickly wrote a SQL query, but after executing it I got an error:

Installing Accel-ppp on Ubuntu 20.04 LTS

For example, I will install Accel-ppp on Ubuntu Server 20.04 LTS.

Blacklisting in Asterisk

I will give an example of blocking incoming calls by phone number, or you can perform other actions for the phone numbers specified in the list.

How to block ONU BDCOM

For example, if there is a loop on the ONU or for other reasons, you can add the ONU to the black list, after that the ONU will not be able to automatically register, and “reject” entries will constantly appear in the logs.

How to configure Radius on Juniper

For example, I will configure the Radius on the Juniper MX204.