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