Error when upgrading to latest docker image

imimsri · 11 December 2017 16:51

Hi,
I’ve just upgraded the librenms (1.33 from docker hub jarischaefer/docker-librenms) but I get errors on the DDBB side.
Connection to the DDBB containers (by pinging it) it is fine.

root@61856f137024:/opt/librenms# ./daily.sh 
Re-running /opt/librenms/daily.sh as librenms user
Checking PHP version                               FAIL
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
Updating SQL-Schema                                FAIL
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
Updating submodules                                OK
Cleaning up DB                                    

 FAIL
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
Fetching notifications                             FAIL
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
Caching PeeringDB data                             OK
root@61856f137024:/opt/librenms# 
root@61856f137024:/opt/librenms# 
root@61856f137024:/opt/librenms# ./validate.php 
====================================
Component | Version
--------- | -------
LibreNMS  | 1.34
DB Schema | 217
PHP       | 7.1.12-1+ubuntu16.04.1+deb.sury.org+1
MySQL     | 5.6.38
RRDTool   | 1.5.5
SNMP      | NET-SNMP 5.7.3
====================================

[OK]    Database connection successful
[FAIL]  Database: missing column (perf_times/id)
[FAIL]  Database: missing index (perf_times/PRIMARY)
[FAIL]  Database: extra column (sensors/entity_link_type)
[FAIL]  Database: extra column (sensors/entity_link_index)
[FAIL]  Database: incorrect column (storage/storage_index)
[FAIL]  We have detected that your database schema may be wrong, please report the following to us on IRC or the community site (https://t.libren.ms/5gscd):
	[FIX] Run the following SQL statements to fix.
	SQL Statements:
	 ALTER TABLE `perf_times` ADD `id` int(11) NOT NULL  auto_increment;
	 ALTER TABLE `perf_times` ADD PRIMARY KEY (`id`);
	 ALTER TABLE `sensors` DROP `entity_link_type`;
	 ALTER TABLE `sensors` DROP `entity_link_index`;
	 ALTER TABLE `storage` CHANGE `storage_index` `storage_index` varchar(64) NULL;
[FAIL]  The poller (086b1715629f) has not completed within the last 5 minutes, check the cron job.
[FAIL]  The poller (210e63746d64) has not completed within the last 5 minutes, check the cron job.
[FAIL]  The poller (2b5c37cd47f6) has not completed within the last 5 minutes, check the cron job.
[FAIL]  The poller (34b38039a648) has not completed within the last 5 minutes, check the cron job.
[FAIL]  The poller (5bc7dcf35da9) has not completed within the last 5 minutes, check the cron job.
[FAIL]  The poller (6e6b7fc40095) has not completed within the last 5 minutes, check the cron job.
[FAIL]  The poller (7e48cb3f1613) has not completed within the last 5 minutes, check the cron job.
[FAIL]  The poller (95813b1a2694) has not completed within the last 5 minutes, check the cron job.
[FAIL]  The poller (cd8ed6cb9b7a) has not completed within the last 5 minutes, check the cron job.
[WARN]  IPv6 is disabled on your server, you will not be able to add IPv6 devices.
[WARN]  Your install is over 24 hours out of date, last update: Sat, 25 Nov 2017 11:48:49 +0000
	[FIX] Make sure your daily.sh cron is running and run ./daily.sh by hand to see if there are any errors.
[WARN]  Your local git branch is not master, this will prevent automatic updates.
	[FIX] You can switch back to master with git checkout master

laf · 11 December 2017 20:48

Looks like you don’t have working dns. The rest of those issues need fixing, they all contain the info you need to do so including the mysql queries oyu need to run.

imimsri · 20 December 2017 16:48

Hi,
Thanks for your support, this is what I get when trying to update de DDBB:

mysql> ALTER TABLE `perf_times` ADD `id` int(11) NOT NULL  auto_increment;
ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key
mysql> ALTER TABLE `perf_times` ADD PRIMARY KEY (`id`);
ERROR 1072 (42000): Key column 'id' doesn't exist in table
mysql> ALTER TABLE `sensors` DROP `entity_link_type`;
Query OK, 0 rows affected (0.11 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `sensors` DROP `entity_link_index`;
Query OK, 0 rows affected (0.05 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> ALTER TABLE `storage` CHANGE `storage_index` `storage_index` varchar(64) NULL;
Query OK, 1 row affected (0.07 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql>

laf · 20 December 2017 21:24

Run this:

TRUNCATE `perf_times`;
ALTER TABLE `perf_times` ADD COLUMN `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

imimsri · 21 December 2017 08:24

Right, now I don’t get more problems regarding the MySQL. Thanks

imimsri · 21 December 2017 08:40

But I still get those php_network_getaddresses errors:

root@190949ffd963:/opt/librenms# ./daily.sh 
Re-running /opt/librenms/daily.sh as librenms user
Checking PHP version                               FAIL
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
Updating SQL-Schema                                FAIL
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
Updating submodules                                OK
Cleaning up DB                                     FAIL
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
Fetching notifications                             FAIL
MySQL Error: php_network_getaddresses: getaddrinfo failed: Name or service not known
Caching PeeringDB data                             OK


root@190949ffd963:/opt/librenms# ping google.com
PING google.com (216.58.210.174) 56(84) bytes of data.
^C

root@190949ffd963:/opt/librenms# ping librenms_mysql-nms
PING librenms_mysql-nms (10.0.1.6) 56(84) bytes of data.
64 bytes from 10.0.1.6: icmp_seq=1 ttl=64 time=0.084 ms
64 bytes from 10.0.1.6: icmp_seq=2 ttl=64 time=0.052 ms
^C
--- librenms_mysql-nms ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1001ms
rtt min/avg/max/mdev = 0.052/0.068/0.084/0.016 ms

But it can resolve to google and also to the DDBB server

laf · 21 December 2017 21:47

You’ve definitely got something going on outside of LibreNMS here, I don’t have any suggestions though.