ABillS – IT Blog

ABillS. How to run periodic on January 2

Once, one Internet provider asked me that ABillS should not charge the subscription on New Year’s Eve, so that users who forgot to replenish their account do not disconnect at midnight.

Accel-ppp and ABillS session synchronization script

A simple session synchronization script between Accel-ppp and ABillS.

How to install and configure ABillS billing system

On the test, I will install Ubuntu Server 16.04 LTS into a clean system (I chose standart system utilities and OpenSSH server when installing the system).

Switch to root user:

Captive portal. Configuring ncsi redirect

I will give an example of setting up forwarding clients without money to the captive portal when connecting to the network.

How to update ABillS

For example, I will upgrade the commercial version of ABillS 0.78.16 to 0.81.28

Creating a contract template in ABillS

I will give an example of creating and adding a contract template in ABillS.

ABillS Help and Tips

In this article I will write some information about ABillS, which will be useful for operators and system administrators.

Recovering MySQL InnoDB after power failure

Once, after the power was turned off, the UPS was discharged, then the generator automatic start did not work because it turned on and off several times, as a result, the server with MySQL was also started and disconnected from the power supply several times, later the tables of different databases were damaged , including the default database with mysql users, as a result, the MySQL daemon did not start.

Abills. Solving the error Cannot change column ‘id’: used in a foreign key constraint ‘users_contacts_ibfk_2’

Once executed db_check.pl on a server with Abills 0.78.16:

Adding BDCOM OLT on ABillS

In this article I will give an example of adding BDCOM-P3310C and BDCOM-P3310B to the ABillS billing system on the Ubuntu Server 16.04 operating system.