Bug #75319 MySQL Notifier 1.1.6 High Severity Error when accessing remote Servers
Submitted: 27 Dec 2014 21:02 Modified: 16 Jan 2018 17:18
Reporter: Joseph Leathlean Email Updates:
Status: Closed Impact on me:
Category:MySQL for Windows: MySQL Notifier Severity:S3 (Non-critical)
Version:1.1.6 OS:Microsoft Windows (x64)
Assigned to: CPU Architecture:Any

[27 Dec 2014 21:02] Joseph Leathlean
Receiving "Object reference not set to an instance of an object errors" when attempting to use Notifier 1.1.6 to monitor a remove Windows service.

Windows Server 2008 R2 x64 Service Pack 1 with all latest Windows Updates
MySQL Community x64 5.6.22 (Local Server)
MySQL Community x64 5.6.19 (Remote Server)

How to repeat:
Manage Monitored Items

Add Windows Service - Remote

Create Connection to Remove Server - Test - Received Message:  Connection Successful:  You are able to monitor services in this remote machine

Click OK

Select MySQL Service

Click OK

Received:  Unhandled Exception:  Object reference not set to an instance of an object

Server was added to the machine list.

Close Notifier

Re-Open Notifier

Received:  High Severity Error: Object reference not set to an instance of an object

   at MySql.Notifier.ServiceMenuGroup.AddToContextMenu(ContextMenuStrip menu)
   at MySql.Notifier.Notifier.machinesList_MachineServiceListChanged(Machine machine, MySQLService service, ChangeType changeType)
   at MySql.Notifier.MachinesList.OnMachineServiceListChanged(Machine machine, MySQLService service, ChangeType changeType)
   at MySql.Notifier.Machine.OnServiceListChanged(MySQLService service, ChangeType changeType)
   at MySql.Notifier.Machine.LoadServiceParameters(MySQLService service, ChangeType changeType)
   at MySql.Notifier.Machine.ChangeService(MySQLService service, ChangeType changeType)
   at MySql.Notifier.Machine.LoadServicesParameters(Boolean setupWmiEventsOnly)
   at MySql.Notifier.MachinesList.LoadMachinesServices()
   at MySql.Notifier.Notifier..ctor()
   at MySql.Notifier.NotifierApplicationContext..ctor()
   at MySql.Notifier.Program.Main(String[] args)
[6 Jul 2016 3:29] Javier TreviƱo
Posted by developer:
Fixed code that checks if a Windows Service to be monitored is actually one for a MySQL Server. Previous checks were relying on the Windows Registry which is only valid for local computers.
For remote computers the information can be queried through WMI.
[16 Jan 2018 17:18] Christine Cole
Noted in the Notifier 1.1.7 changelog:

Attempts to subscribe to a remote Windows service for the first time failed
when the remote service was an instance of MySQL.