I setup ODBC to facilitate database monitoring for my applications. If I put the password in the item configuration it works like a champ. I created a global macro for the DB password in this environment. If I leave it as text, all works great. When I set it to Secret Text, it fails with "Access denied for user ',myuser>'@'<my IP>' (using password: YES)".
Now I know this works, I can connect to the Database using mysql command line, I can put the password in clear text in the item and it works, I can put the password in clear text in the Global Macro and it works. When I change it to secret text it fails... I reset the password in the secret text to ensure it is valid... still comes back with the above error message...
What am I missing here?
Now I know this works, I can connect to the Database using mysql command line, I can put the password in clear text in the item and it works, I can put the password in clear text in the Global Macro and it works. When I change it to secret text it fails... I reset the password in the secret text to ensure it is valid... still comes back with the above error message...
What am I missing here?
Comment