ABillS. SNMP Port Shift

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”

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.

Continue reading “Recovering MySQL InnoDB after power failure”

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:

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