Getting "DB schema not installed, first install it." After CE upgrade
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
Incorrectly db name passed in config or db not exist.
On Thu, Feb 25, 2016 at 11:53 AM, KA PDE kapde.cat@gmail.com wrote:
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
Oh! my bad. I introduced a typo in the config file.
Thanks Mike for the fast response!
Cheers,
Pau
2016-02-25 10:07 GMT+01:00 Mike Stupalov mike@observium.org:
Incorrectly db name passed in config or db not exist.
On Thu, Feb 25, 2016 at 11:53 AM, KA PDE kapde.cat@gmail.com wrote:
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
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
-- Mike Stupalov http://observium.org/
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
participants (2)
-
KA PDE -
Mike Stupalov