librenms@sclibrenms:~$ ls addhost.php composer.lock delhost.php LICENSE.txt poller-wrapper.py snmptrap.php adduser.php composer.phar discovery.php lnms README.md sql-schema alerts.php config discovery-wrapper.py logs renamehost.php storage app config.php dist-pollers.php mibs requirements.txt syslog.php artisan config.php.default doc misc resources tests AUTHORS.md config.php.save html mkdocs.yml routes validate.php billing-calculate.php config_to_json.php includes package.json rrd vendor bootstrap contrib irc.php package-lock.json scripts webpack.mix.js cache CONTRIBUTING.md LibreNMS pbin.sh server.php CHANGELOG.md cronic librenms.cron phpunit.xml services-wrapper.py check-services.php daily.php librenms.nonroot.cron ping.php snmpd.conf.example CODE_OF_CONDUCT.md daily.sh librenms-service.py poll-billing.php snmplibre.txt composer.json database licenses poller.php snmp-scan.py librenms@sclibrenms:~$ sql-schema sql-schema: command not found librenms@sclibrenms:~$ cd sql-schema librenms@sclibrenms:~/sql-schema$ ls 001.sql 023.sql 045.sql 067.sql 089.sql 110.sql 132.sql 154.sql 176.sql 198.sql 220.sql 242.sql 264.sql 002.sql 024.sql 046.sql 068.sql 090.sql 111.sql 133.sql 155.sql 177.sql 199.sql 221.sql 243.sql 265.sql 003.sql 025.sql 047.sql 069.sql 091.sql 112.sql 134.sql 156.sql 178.sql 200.sql 222.sql 244.sql 266.sql 004.sql 026.sql 048.sql 070.sql 092.sql 113.sql 135.sql 157.sql 179.sql 201.sql 223.sql 245.sql 267.sql 005.sql 027.sql 049.sql 071.sql 093.sql 114.sql 136.sql 158.sql 180.sql 202.sql 224.sql 246.sql 268.sql 006.sql 028.sql 050.sql 072.sql 094.sql 115.sql 137.sql 159.sql 181.sql 203.sql 225.sql 247.sql 269.sql 007.sql 029.sql 051.sql 073.sql 095.sql 116.sql 138.sql 160.sql 182.sql 204.sql 226.sql 248.sql 270.sql 008.sql 030.sql 052.sql 074.sql 096.sql 117.sql 139.sql 161.sql 183.sql 205.sql 227.sql 249.sql 271.sql 009.sql 031.sql 053.sql 075.sql 097.sql 118.sql 140.sql 162.sql 184.sql 206.sql 228.sql 250.sql 272.sql 010.sql 032.sql 054.sql 076.sql 098.sql 119.sql 141.sql 163.sql 185.sql 207.sql 229.sql 251.sql 273.sql 011.sql 033.sql 055.sql 077.sql 099.sql 120.sql 142.sql 164.sql 186.sql 208.sql 230.sql 252.sql 274.sql 012.sql 034.sql 056.sql 078.sql 1000.sql 121.sql 143.sql 165.sql 187.sql 209.sql 231.sql 253.sql 275.sql 013.sql 035.sql 057.sql 079.sql 100.sql 122.sql 144.sql 166.sql 188.sql 210.sql 232.sql 254.sql 276.sql 014.sql 036.sql 058.sql 080.sql 101.sql 123.sql 145.sql 167.sql 189.sql 211.sql 233.sql 255.sql 277.sql 015.sql 037.sql 059.sql 081.sql 102.sql 124.sql 146.sql 168.sql 190.sql 212.sql 234.sql 256.sql 278.sql 016.sql 038.sql 060.sql 082.sql 103.sql 125.sql 147.sql 169.sql 191.sql 213.sql 235.sql 257.sql 279.sql 017.sql 039.sql 061.sql 083.sql 104.sql 126.sql 148.sql 170.sql 192.sql 214.sql 236.sql 258.sql 280.sql 018.sql 040.sql 062.sql 084.sql 105.sql 127.sql 149.sql 171.sql 193.sql 215.sql 237.sql 259.sql 281.sql 019.sql 041.sql 063.sql 085.sql 106.sql 128.sql 150.sql 172.sql 194.sql 216.sql 238.sql 260.sql 020.sql 042.sql 064.sql 086.sql 107.sql 129.sql 151.sql 173.sql 195.sql 217.sql 239.sql 261.sql 021.sql 043.sql 065.sql 087.sql 108.sql 130.sql 152.sql 174.sql 196.sql 218.sql 240.sql 262.sql 022.sql 044.sql 066.sql 088.sql 109.sql 131.sql 153.sql 175.sql 197.sql 219.sql 241.sql 263.sql librenms@sclibrenms:~/sql-schema$ cd.. cd..: command not found librenms@sclibrenms:~/sql-schema$ cd .. librenms@sclibrenms:~$ nano syslog.php librenms@sclibrenms:~$ librenms@sclibrenms:~$ librenms@sclibrenms:~$ librenms@sclibrenms:~$ librenms@sclibrenms:~$ librenms@sclibrenms:~$ ls addhost.php composer.lock delhost.php LICENSE.txt poller-wrapper.py snmptrap.php adduser.php composer.phar discovery.php lnms README.md sql-schema alerts.php config discovery-wrapper.py logs renamehost.php storage app config.php dist-pollers.php mibs requirements.txt syslog.php artisan config.php.default doc misc resources tests AUTHORS.md config.php.save html mkdocs.yml routes validate.php billing-calculate.php config_to_json.php includes package.json rrd vendor bootstrap contrib irc.php package-lock.json scripts webpack.mix.js cache CONTRIBUTING.md LibreNMS pbin.sh server.php CHANGELOG.md cronic librenms.cron phpunit.xml services-wrapper.py check-services.php daily.php librenms.nonroot.cron ping.php snmpd.conf.example CODE_OF_CONDUCT.md daily.sh librenms-service.py poll-billing.php snmplibre.txt composer.json database licenses poller.php snmp-scan.py librenms@sclibrenms:~$ ./validate.php ==================================== Component | Version --------- | ------- LibreNMS | 21.3.0-57-g6616727a9 DB Schema | 2021_03_11_003713_rename_printer_columns (204) PHP | 7.4.3 Python | 3.8.5 MySQL | 10.3.25-MariaDB-0ubuntu0.20.04.1 RRDTool | 1.7.2 SNMP | NET-SNMP 5.8 ==================================== [OK] Composer Version: 2.0.11 [OK] Dependencies up-to-date. [OK] Database connection successful [FAIL] Your database is out of date! [FIX]: ./lnms migrate librenms@sclibrenms:~$ ./lnms migrate ************************************** * Application In Production! * ************************************** Do you really wish to run this command? (yes/no) [no]: > yes Migrating: 2021_02_09_122930_migrate_to_utf8mb4 In Connection.php line 678: SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size (SQL: ALTER TABLE `syslog` MODIFY `facility` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL ;) In Exception.php line 18: SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size In PDOConnection.php line 52: SQLSTATE[HY000]: General error: 1206 The total number of locks exceeds the lock table size librenms@sclibrenms:~$