Since some ABillS log files gradually increased in size, I wrote a script to rotate these logs.Continue reading “ABillS 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.Continue reading “ABillS. s_detail table grows”
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”
In this article, I will give an example of how you can massively reduce the speed of users in the ABillS billing system.Continue reading “ABillS. Mass shaping of speed in case of accidents”
I will give an example of setting up a software PPO Checkbox in the ABillS billing system.Continue reading “Checkbox setup (software PPO) in ABillS”
Once I installed FreeRadius 3.0.23, by the way I described the process in the article: ABillS. Installing Freeradius, and optimized some parameters of the MySQL server, after which FreeRadius stopped starting and I saw errors in the logs:Continue reading “FreeRadius. error solution rlm_sql_mysql: Couldn’t connect to MySQL server”
Once in one company, in order to simplify the search for callers in ABillS, it was necessary to install the Callcenter module, which has different capabilities, but what we needed was pop-up notifications in the browser with a link to the caller’s page.Continue reading “ABillS. Installing and configuring Callcenter”
In 2018, I ran into a problem when the user ran out of money on the account, at midnight he turned off the billing, the user immediately made a payment, the money was debited and the service turned on, and at 1 am it was turned off again, because the billing system tried to withdraw the monthly fee again. I’ll just post a simple script here that allows you to receive email notifications with a list of users who made a payment at night between 00:00 and 01:01, so that later you can manually correct it.Continue reading “ABillS. Problem with payments between 00:00 and 01:00”
I will give an example of updating or installing Freeradius 3.0.23 from the source codes.
ABillS and Freeradius will work for me in the same operating system Ubuntu Server 18.04.
I noticed once that on Huawei switches SNMP port indices can be shifted, for example, on Huawei s2326 VLANs are considered first, for example ifIndex.1 is vlan1, ifIndex.2, ifIndex.3, ifIndex.4 are user VLANs, and then ifIndex5 is the port Ethernet1. Because of this, when binding client services to switch ports in ABillS, the ports will not be displayed correctly.Continue reading “ABillS. SNMP Port Shift”