1. $ ./validate.php
2. ====================================
3. Component | Version
4. --------- | -------
5. LibreNMS  | 1.48.1-27-gc7c1ca2c5
6. DB Schema | 2020_03_25_165300_add_column_to_ports (162)
7. PHP       | 7.4.33
8. Python    | 3.8.10
9. MySQL     | 10.3.39-MariaDB-0ubuntu0.20.04.2
10. RRDTool   | 1.7.2
11. SNMP      | NET-SNMP 5.8
12. ====================================
13.  
14. [OK]    Composer Version: 1.10.27
15. [OK]    Dependencies up-to-date.
16. [OK]    Database connection successful
17. [FAIL]  Time between this server and the mysql database is off
18.  Mysql time 2024-03-25 07:56:11
19.  PHP time 2024-03-25 14:56:11
20.  
21. [FAIL]  Your database is out of date!
22.         [FIX]:
23.         ./lnms migrate
24. [FAIL]  You have no timezone set for php.
25.         [FIX]:
26.         http://php.net/manual/en/datetime.configuration.php#ini.date.timezone
27. [WARN]  Your install is over 24 hours out of date, last update: Thu, 07 Feb 2019 20:58:56 +0000
28.         [FIX]:
29.         Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
30. [WARN]  Your local git contains modified files, this could prevent automatic updates.
31.         [FIX]:
32.         You can fix this with ./scripts/github-remove
33.         Modified Files:
34.          .editorconfig
35.          .github/ISSUE_TEMPLATE.md
36.          .github/ISSUE_TEMPLATE/New-Device.md
37.          .github/PULL_REQUEST_TEMPLATE.md
38.          .gitignore
39.          .travis.yml
40.          AUTHORS.md
41.          CONTRIBUTING.md
42.          LibreNMS/Alert/AlertUtil.php
43.          LibreNMS/Alert/Template.php
44.          LibreNMS/Alert/Transport.php
45.          LibreNMS/Alert/Transport/Alerta.php
46.          LibreNMS/Alert/Transport/Alertmanager.php
47.          LibreNMS/Alert/Transport/Api.php
48.          LibreNMS/Alert/Transport/Boxcar.php
49.           and 3569 more...
50. $ SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `deleted`; check that it exists (SQL: ALTER TABLE access_points DROP INDEX deleted, ADD INDEX access_points_deleted_index(deleted);)
51. > ^C
52. $ ./lnms migrate
53. **************************************
54. *     Application In Production!     *
55. **************************************
56.  
57.  Do you really wish to run this command? (yes/no) [no]:
58.  > yes
59.  
60. Migrating: 2020_04_06_001048_the_great_index_rename
61.  
62. In Connection.php line 671:
63.  
64.   SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `deleted`; check that it exists (SQL: ALTER TABLE access_points DROP INDEX deleted, ADD INDEX access_points_deleted_index(deleted);)
65.  
66.  
67. In PDOStatement.php line 129:
68.  
69.   SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `deleted`; check that it exists
70.  
71.  
72. In PDOStatement.php line 127:
73.  
74.   SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP INDEX `deleted`; check that it exists
75.