Hi everyone,
Today I've upgraded a CE Observium from 0.15.6 to 0.16.1 and it broke. It only shows DB schema not installed. I've noticed some errors in update-errors.log
[2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `bgpPeers` ADD INDEX `bgp_cache` (`bgpPeer_id`, `device_id`, `bgpPeerState`, `bgpPeerAdminStatus`, `bgpPeerRemoteAs`); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `ospf_instances` ADD INDEX `ospf_cache` (`device_id`, `ospf_instance_id`, `ospfAdminStat`); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `vrfs` ADD INDEX `vrf_cache` (`vrf_id`, `device_id`, `mplsVpnVrfRouteDistinguisher`); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): ====== Schema update 264 -> 265 ============== [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `alerts_maint` ADD INDEX `maint_cache` (`maint_start`, `maint_end`); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): ====== Schema update 265 -> 266 ============== [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `snmp_errors` DROP INDEX `error_index`; [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected [2016/02/25 07:37:08 +0000] discovery.php(29504): Query: ALTER TABLE `snmp_errors` ADD UNIQUE `error_index` (`device_id`, `error_code`, `snmp_cmd`, `mib`(50), `oid`(100)); [2016/02/25 07:37:08 +0000] discovery.php(29504): Error: (1046) No database selected
The strange thing is that I recently upgraded another server with no issues. The only difference is that I added the following config line later as there was an alert in the GUI (and now I'm adding it from start):
$config['db_extension'] = 'mysqli';
Any hint will be greatly appreciated.
Best regards,
Pau