Cannot connect to mysql on remote host #324
mflynn-lanl
started this conversation in
General
Replies: 1 comment
-
I'm not sure what problem I was having with running Cromwell using systemd, but now when I start it with systemd, it cannot connect to the mysql database. I am still able to connect when I start Cromwell from the command line. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
@edwins
I created a new mysql VM. However, when I try to connect from the MC login node I get an error:
No route to host (Host unreachable)
I added mysql-vm-2 to the scratch-cluster-secgroup
I added user 'cromwell'@'login-node-private-ip' to the mysql database (10.0.61.245)
mysql> select host,user from user;
+-------------+------------------+
| host | user |
+-------------+------------------+
| 10.0.61.245 | cromwell |
I modified scratch-cluster-secgroup to allow ingress from port 3306
restarted mysql-vm-2
The connection string is
mysql://10.0.61.4:3306/cromwell
which uses the private ip address of the mysql VM.I have another mysql vm. I tried adding a volume to hold the mysql data but I couldn't access the volume so I created a new VM
Beta Was this translation helpful? Give feedback.
All reactions