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”How to configure Radius on Juniper
For example, I will configure the Radius on the Juniper MX204.
Continue reading “How to configure Radius on Juniper”llid-admin-down status BDCOM ONU
Once I noticed that on one BDCOM P3310D 4 ONUs with the status llid-admin-down turned off at the same time.
Continue reading “llid-admin-down status BDCOM ONU”Setting up TurboSMS in ABillS
I will give an example of setting up the TurboSMS service in ABillS, which I used to send Ureports reports to clients in Viber, as well as send Checkbox fiscal checks to Viber.
Continue reading “Setting up TurboSMS in ABillS”