- # ./validate.php
- ====================================
- Component | Version
- --------- | -------
- LibreNMS | 1.51-18-geb8600e
- DB Schema | 2019_02_10_220000_add_dates_to_fdb (132)
- PHP | 7.1.8
- MySQL | 5.7.24
- RRDTool | 1.4.8
- SNMP | NET-SNMP 5.7.2
- ====================================
- [OK] Composer Version: 1.8.5
- [OK] Dependencies up-to-date.
- [OK] Database connection successful
- [FAIL] Database: incorrect column (ports/ifInUcastPkts_delta)
- [FAIL] Database: incorrect column (ports/ifOutUcastPkts_delta)
- [FAIL] Database: incorrect column (ports/ifInOctets_delta)
- [FAIL] Database: incorrect column (ports/ifOutOctets_delta)
- [FAIL] We have detected that your database schema may be wrong, please report the following to us on Discord (https://t.libren.ms/discord) or the community site (https://t.libren.ms/5gscd):
- [FIX]:
- Run the following SQL statements to fix.
- SQL Statements:
- ALTER TABLE `ports` CHANGE `ifInUcastPkts_delta` `ifInUcastPkts_delta` bigint(20) unsigned NULL ;
- ALTER TABLE `ports` CHANGE `ifOutUcastPkts_delta` `ifOutUcastPkts_delta` bigint(20) unsigned NULL ;
- ALTER TABLE `ports` CHANGE `ifInOctets_delta` `ifInOctets_delta` bigint(20) unsigned NULL ;
- ALTER TABLE `ports` CHANGE `ifOutOctets_delta` `ifOutOctets_delta` bigint(20) unsigned NULL ;