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
• Status: Closed
• Category: MySQL for Windows: MySQL Notifier
• Severity: S3 (Non-critical)
• Version: 1.1.6
• OS: Windows (x64)
• CPU Architecture: Any

[27 Dec 2014 21:02] Joseph Leathlean

Description:
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.

Environment:  
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.