ABillS – IT Blog

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.

Backup ABillS

I will describe an example of backup ABillS billing system.

Preparing a Linux server before installing Accel-ppp

Here are some recommendations for setting up a server on which Accel-ppp will work.

IPTables rules for Accel-ppp

In this article I will give an example of IPTables rules for Accel-ppp.

Moving ABillS to another server

On the test I will transfer the ABillS billing system from one server to another.

Configuring L4-Redirect-ipset for Accel-ipoe and ABillS

In order to authorize clients with a negative balance Accel-ppp to add IP addresses to the ipset list, add the following to its configuration, in the ipoe section: