Does anyone see any potential issues with updating to the latest Libre release based on the the following info from my current Libre setup?
| Version | 1.55-22-g120e513 - Mon Sep 09 2019 07:57:39 GMT-0500 |
|---|---|
| Database Schema | 2019_07_09_150217_update_users_widgets_settings (140) |
| Web Server | Apache/2.4.6 (CentOS) PHP/7.2.6 |
| PHP | 7.2.6 |
| MySQL | 5.5.56-MariaDB |
| RRDtool | 1.4.8 |
Okay, thanks! Just checking to avoid any issues.
Just did the update, but running into this when doing ./lmns migrate using librenms user (su - librenms) -
| Component | Version |
|---|---|
| LibreNMS | 1.60-55-g5b6a1f7 |
| DB Schema | 2020_02_05_093457_add_inserted_to_devices (157) |
| PHP | 7.2.6 |
| MySQL | 5.5.56-MariaDB |
| RRDTool | 1.4.8 |
| SNMP | NET-SNMP 5.7.2 |
| ==================================== |
[OK] Composer Version: 1.9.3
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
[FAIL] Discovery has not completed in the last 24 hours.
[FIX]:
Check the cron job to make sure it is running and using discovery-wrapper.py
-bash-4.2$ ./lnms migrate
Application In Production! *
Do you really wish to run this command? (yes/no) [no]:
yes
Migrating: 2020_02_05_224042_device_inserted_null
In Connection.php line 664:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00’ for column ‘inserted’ at row 1 (SQL: al
ter table devices change inserted inserted timestamp NULL default CURRENT_TIMESTAMP;)
In PDOStatement.php line 119:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00’ for column ‘inserted’ at row 1
In PDOStatement.php line 117:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00’ for column ‘inserted’ at row 1
-bash-4.2$
Same issue here. Switched to librenms user and issued validate.php with this output.
====================================
| Component | Version |
|---|---|
| LibreNMS | 1.63-62-g7a2424c |
| DB Schema | 2020_02_05_093457_add_inserted_to_devices (158) |
| PHP | 7.2.27 |
| Python | 3.6.8 |
| MySQL | 5.5.65-MariaDB |
| RRDTool | 1.4.8 |
| SNMP | NET-SNMP 5.7.2 |
| ==================================== |
[OK] Composer Version: 1.10.6
[OK] Dependencies up-to-date.
[OK] Database connection successful
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
[WARN] Your local git contains modified files, this could prevent automatic updates.
[FIX]:
You can fix this with ./scripts/github-remove
Modified Files:
bootstrap/cache/.gitignore
logs/.gitignore
rrd/.gitignore
storage/app/.gitignore
storage/app/public/.gitignore
storage/framework/sessions/.gitignore
storage/framework/testing/.gitignore
storage/framework/views/.gitignore
storage/logs/.gitignore
bash-4.2$ ./lnms migrate
Application In Production! *
Do you really wish to run this command? (yes/no) [no]:
yes
Migrating: 2020_02_05_224042_device_inserted_null
In Connection.php line 664:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00’ for column ‘inserted’ at row 1 (SQL: alter table devices change inserted inserted timestamp NULL default
CURRENT_TIMESTAMP;)
In PDOStatement.php line 119:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00’ for column ‘inserted’ at row 1
In PDOStatement.php line 117:
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: ‘0000-00-00’ for column ‘inserted’ at row 1
running on Centos 7.8:
CentOS Linux release 7.8.2003 (Core)
Ok, I ran ./validate as librenms and then ran ./lnms migrate and it succeeded.