Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL Connection issue #3221

Closed
2 tasks done
Bob-emblibrary opened this issue Jun 5, 2023 · 2 comments
Closed
2 tasks done

MySQL Connection issue #3221

Bob-emblibrary opened this issue Jun 5, 2023 · 2 comments
Labels

Comments

@Bob-emblibrary
Copy link

⚠️ Please verify that this bug has NOT been raised before.

  • I checked and didn't find similar issue

🛡️ Security Policy

📝 Describe your problem

So I have a MySQL group that I'm trying to monitor with UptimeKuma. I've tried connecting to the mysql router, and I get 'ClusterDB Query': Failing: Access denied for user 'uptime'@'<ip_address>' (using password: YES) | Interval: 60 seconds | Type: mysql | Down Count: 0 | Resend Interval: 0
I get the same going directly to the Primary node of the group. If I use SQL Workbench, it connects without issue.
Since the password has special characters I have to encode the URL and that definitely changes the error from "improperly formatted url" to Access denied. What am I missing?

📝 Error Message(s) or Log

No response

🐻 Uptime-Kuma Version

1.21.3

💻 Operating System and Arch

Ubuntu 22.04

🌐 Browser

Google Chrome 113.0.5672.127

🐋 Docker Version

23.01

🟩 NodeJS Version

No response

@chakflying
Copy link
Collaborator

I think according to node-mysql2#1621 special characters are not supported yet.

@Bob-emblibrary
Copy link
Author

Thank you, that was it. Disabled special character requirement for user.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants