MySQL Bugs: #81211: MySQL notifier: Unhandled exception when saving settings

Bug #81211	MySQL notifier: Unhandled exception when saving settings
Submitted:	27 Apr 2016 8:30	Modified:	2 May 2016 19:56
Reporter:	Adam Schon	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL for Windows: MySQL Notifier	Severity:	S3 (Non-critical)
Version:	1.1.6	OS:	Windows (Windows 7 professional)
Assigned to:		CPU Architecture:	Any
Tags:	options exception

Description:
MySQL Notifier throws an exception if I try to apply settings. After this, the application stops.

How to repeat:
Click on the Notifier tray icon.
Click Actions/Options.
Change settings (optional)
Click Apply button.

Hello Adam Schon,

Thank you for the bug report.
Could you please provide exact error message screenshot to confirm this issue at our end?

Thanks,
Chiranjeevi.

Hi Chiranjeevi Battula!

I will add a screenshot of the error message right away. 

Also I probably should have mentioned, that the language of my operating system is english, but the country/currency/time/keyboard settings are hungarian. I don't know if this has anything to do with the bug.

error message screenshot

Attachment: mysql_notifier_bug_screenshot.png (image/png, text), 18.93 KiB.

Hello Adam Schon,

Thank you for your feedback.
Please provide screenshot of the monitored services with out changing setting if notifier works and also attach the "settings.config" file(- please make it as private if you prefer) that would be good and that file can be found in %APPDATA%\Oracle\MySQL Notifier.

Thanks,
Chiranjeevi.

Hi Chiranjeevi Battula!

I've added the files you asked, also, I uploaded the log file, you can see the stacktrace of the exceptions in the bottom of log.

Bye!

Hello Adam Schon,

Thank you for your feedback.
As per your screenshot and MySQLNotifier.log file the service MySQL56 was not found in the Windows Services and it seems MySQL is also not working in your system.
Please do proper installation of MySQL and try to work on MySQL Notifier.

MySQL installation user manual:
http://dev.mysql.com/doc/refman/5.7/en/windows-installation.html

Thank you for your interest in MySQL.

Thanks,
Chiranjeevi.

Screenshot.

Attachment: 81211.JPG (image/jpeg, text), 70.94 KiB.

Hi!

MySql is working on my system. I can create tables, and make connections to them with jdbc and hibernate. I can view them with MySql workbench and phpmyadmin. 
Also, the notifier can start and stop them properly.
Both show up in the windows services list.

In the log file the first few exceptions are for a different error ("The service mysql56 was not found in the Windows Services"). When I added a new mysql service, the notifier recognized it, but saved it with wrong name, all lowercase. I had to manually edit the settings.config file.
Other people solve this the same way: http://stackoverflow.com/questions/27092040/mysql-notifier-not-able-to-start-stop-restart-...

The exceptions later in the log (MySqlNotifier Critical: 1 : Unhandled Exception
Input string was not in a correct format.) relate to the bug I was reporting.
That is why I said in my previous comment, the relevant exceptions are at the bottom of the log. Sorry if I didn't emphasize it enough.

Bye, Adam