omega8cc
commented
5 years ago Hello, you should use SSH tunnelling over port 22 and not a direct SQL access, and specify for connections 127.0.0.1 not the server IP with the other credentials, because via SSH tunnel you are connecting to the DB server locally on the server, not via public host and port 3306.
Again, for database host via SSH tunnel you should use "127.0.0.1" and not the Aegir instance hostname, not a "localhost", nor the public IP address.
Use the instance hostname or IP only for SSH access fields.
Then it should work.
Hello My boa info can be found here : https://gist.github.com/yazzou/353dc0c18dd5480373ecc5de7082c28b
I am using HeidiSQL, a desktop sql application which supports ssh tunneling.
I have red here : https://learn.omega8.cc/how-to-use-chive-manager-323 that it is possible to do so so i followed this video : https://www.youtube.com/watch?v=KLXFOR6-hFk
I decided to give it a try by doing the following :
I have picked up the octopus ssh connection details adn filled HediSQL form as indicated in this image https://ibb.co/h2hsjKY
I have then indicated all the database information i picked up from
/data/disk/octopus/config/server_master/nginx/vhost.d
And the setting looks like this https://ibb.co/8gf5pNX
I end up with that error https://ibb.co/hYwRYPJ
I am trying to work on migrating a site from D7 to D8, so accessing databases to export data is important. I have open previously another issue as i am also unable to have chive working (https://github.com/omega8cc/boa/issues/1412)