This might be quite a stupid question but how do you actually access to ESM database server? is ESM running on mysql server and on port 3306? i did a netstat and it is running and listening but when i try to connect using MySQL query browser I was unable to connect tried to telnet from my machine to the ESM server unable as well. then i check the firewall of the ESM machine is already disabled. What am I missing here? By the way I was able to SSH into the server via port 22 no issue.
Thanks in advance for the help
I found out a lot notification pending in the server.log with the notification ID, so I am planning to search for the destination name that is having the issue with the SQL statement to check if the input email address is correct
select destination_name from arc_notification_history where notification_id='<ID shown in message>';
But unfortunately with this SQL statement I was still unable to locate the destination name. Is there any other way to locate which ID belong to which destination name?