I have a problem setting up remote servers. My setup is as follows:
I have an aegir installation on a development server hidden behind a dyndns setup, and several production servers on various sites. When adding root@xxx.dyndns.biz to privileges on the remote server, the mysql connection fails due to ip address not accepted. I've tried different ways around this, to no avail.

But then it hits me, why can't I just use an ssh connection to do the mysql commands, which also sounds more secure to me? Any ideas?

Comments

steven jones’s picture

steven jones commented
Status: Active » Closed (won't fix)

This is sadly fundamental to the way Aegir works at the moment, we run 'mysql' on the master server, and it must have mysql access to the remote server.

If you have a very complicated setup that means you can't get direct access to port 3306 on the remote server then you could try using an ssh tunnel to connect to the remote server over ssh. But I'm fairly sure that you'll run into issues.

Sorry, Aegir wasn't really designed for servers without a static IP.