Problem using SSH tunnel

[chrisheadford]

Hi

I have a mysql db on AWS server in a private network.

I have set up redash on an EC2 server and upgraded it to V10.

I have set up an ssh tunnel on the EC2 server, and installed the mysql client tools to confirm the tunnel is working. I can query the db successfully from that. As I don't have mysql installed on the EC2 server I have mapped port 3306 through to the private db server.

If I set up the datasource in redash using 127.0.0.1 as the host and post 3306, using the same credentials as in mysql client, I get:

"(2006, "Can't connect to MySQL server on '127.0.0.1' (115)"

I've read the article here: https://discuss.redash.io/t/connect-to-amazon-rds-via-ssh-tunnel-for-self-hosted-redash/8082 but don't seem to be able to get to the second page, which I feel may be where the answer lies! And I can't sign up while the page is in read only mode.

I feel I'm missing something obvious as this is the likely scenario for most users.

Thanks in advance

Christine

[chrisheadford]

I've gone through the steps in the above article, setting up the keys directory and the dynamic_settings as suggested, but I am getting this error message as I force_build docker:

worker_1 | File "./manage.py", line 6, in
worker_1 | from redash.cli import manager
worker_1 | File "/app/redash/init.py", line 56, in
worker_1 | import_query_runners(settings.QUERY_RUNNERS)
worker_1 | File "/app/redash/query_runner/init.py", line 358, in import_query_runners
worker_1 | import(runner_import)
worker_1 | File "/app/redash/query_runner/query_results.py", line 5, in
worker_1 | from redash import models
worker_1 | File "/app/redash/models/init.py", line 45, in
worker_1 | from .base import db, gfk_type, Column, GFKBase, SearchBaseQuery, key_type, primary_key
worker_1 | File "/app/redash/models/base.py", line 101, in
worker_1 | key_definitions = settings.dynamic_settings.database_key_definitions((db.Integer, {}))
worker_1 | AttributeError: module 'redash.settings.dynamic_settings' has no attribute 'database_key_definition

[GFoley83]

@chrisheadford Did you ever figure this out? I'm in the same boat.