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:
Continue reading “Phabricator error – Attempting to construct a query using a non-utf8 string when utf8 is expected”Author Archives: Vyacheslav
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.
Continue reading “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.
Continue reading “ABillS. s_detail table grows”Phabricator. Clearing the cache
I will give an example of clearing the cache in Phabricator.
Continue reading “Phabricator. Clearing the cache”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.
Continue reading “Bridge Domain Configuration on Juniper MX”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:
Continue reading “Solution for error 21S01 Column count doesn’t match value count at row 1”Installing Accel-ppp on Ubuntu 20.04 LTS
For example, I will install Accel-ppp on Ubuntu Server 20.04 LTS.
Continue reading “Installing Accel-ppp on Ubuntu 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.
Continue reading “Blacklisting in Asterisk”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.
Continue reading “How to block ONU BDCOM”