Connect Aiven for MySQL to Infograph
What it brings in: Every table and view the user can read.
What you need
- An Aiven for MySQL service.
- Access to the service in the Aiven Console.
- Infograph's sync servers connect from 51.222.152.247.
Your connection string
Each part is one thing you fill in, and each can fail on its own.
mysql://avnadminuser: fix for "The username or password was not accepted.":[password]password: fix for "The username or password was not accepted."@[host].aivencloud.comhost: fix for "We couldn't find that host. Check the host name, then try again.":[port]port: fix for "The host refused the connection. Check the port, and that your database accepts connections from Infograph's address."/defaultdbdatabase: fix for "That database does not exist on this server."?ssl-mode=REQUIREDSteps
Allow Infograph's sync servers
If the service has an IP allowlist, open Service settings, then Cloud and network, choose Set IP address allowlist and add the addresses below. If the service is in a VPC, enable public access too.
51.222.152.247/32Create a read-only user (optional)
Add a user named infograph under Users, then connect as avnadmin and give it read access only.
GRANT SELECT, SHOW VIEW ON [database].* TO 'infograph'@'%';Copy the Service URI
On the service Overview, under Connection information, copy the Service URI. Aiven gives each service its own port, so keep the one in the URI. If the service is in a VPC, pick the Public access route first.
mysql://avnadmin:[password]@[host].aivencloud.com:[port]/defaultdb?ssl-mode=REQUIREDPaste it in Infograph and choose your tables
Open Aiven for MySQL in Infograph, paste the string and press Connect. Pick the tables you want and Infograph starts loading them.
Allow 51.222.152.247 through your firewall so Infograph can connect.
Connect
Troubleshooting
Each entry is the message Infograph shows when a connection fails. Open it for the fix.
This host is not reachable from Infograph. Use your database's public address.
This is the service's private address. Enable public access and use the Public access route's URI.
We couldn't find that host. Check the host name, then try again.
Copy the Service URI again from the Overview page rather than typing the host. It ends in aivencloud.com.
The host refused the connection. Check the port, and that your database accepts connections from Infograph's address.
Aiven uses a service port, not 3306. Copy the port from the Service URI.
The server closed the connection. Check that it allows Infograph's address, and whether it requires an encrypted connection.
The server answered, then hung up before Infograph could sign in. Check it allows 51.222.152.247: some hosts close the connection rather than refuse it. If the server accepts only encrypted connections, set SSL Mode to Required under Advanced.
The host did not answer in time. Check the host and port, and that your firewall allows Infograph's address.
If the service has an IP allowlist, add 51.222.152.247. If it runs in a VPC, enable public access and copy the Public access route's URI.
The username or password was not accepted.
Check the user and password. The Service URI includes avnadmin's password. Characters such as @, # or / must be percent-encoded in a string, so @ becomes %40.
Those credentials were not accepted.
Check the user and password, or copy the Service URI again, which includes avnadmin's password.
That database does not exist on this server.
The database name is the part after the last / in the string. A new service's database is defaultdb.
This server does not offer an encrypted connection. Turn on TLS on the server, or set SSL Mode to Preferred.
SSL Mode is set to Required, but the server would not encrypt the connection. Turn on TLS on the server, and check the host is the database's own address rather than a proxy in front of it. Or set SSL Mode to Preferred under Advanced.