- 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:~$