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

Failed to connect to database: Error: Can't connect to MySQL server on 'locuscompare-us-west-2a.cvocub39nnri.us-west-2.rds.amazonaws.com' (111) #21

Open
7JVST opened this issue Sep 9, 2022 · 0 comments

Comments

@7JVST
Copy link

7JVST commented Sep 9, 2022

Hi, I am trying to run this command locuscompare(in_fn1 = gwas_fn, in_fn2 = eqtl_fn, title1 = 'CAD GWAS', title2 = 'Coronary Artery eQTL')

but having the persistent issue for three days.

Error in .local(drv, ...) :
Failed to connect to database: Error: Can't connect to MySQL server on 'locuscompare-us-west-2a.cvocub39nnri.us-west-2.rds.amazonaws.com' (111)
Warning message:
In rm(config) : object 'config' not found

I have already tried my best but still do not know how to run it smoothly.

I am working on ubuntu behind a corporate proxy. So, I thought at first it was a proxy issue due to the lacking of MySQL server and AWS account on my device. But, when I use it on my mac, it is working like a charm without any installation and creation of MySQL server and AWS account. However, I still need to use this tool on my work PC because of input data privacy issue.

Does it mean I need to create an AWS account and adjust the network setting in it to access MySQL server on this URL 'locuscompare-us-west-2a.cvocub39nnri.us-west-2.rds.amazonaws.com'?

Please let me know how to run this tool behind a corporate proxy.

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

No branches or pull requests

1 participant