Can't authorize a server for Amazon RDS

Posted by Parris on Server Fault See other posts from Server Fault or by Parris
Published on 2011-02-12T22:44:23Z Indexed on 2012/06/12 22:42 UTC
Read the original article Hit count: 270

We are attempting to slowly migrate a website over to AWS among other things. We decided the first thing to move was the database. We have some dedicated server with a different hosting provider. We only have one IP. I am having trouble authorizing the ip so that the old server can connect to RDS. It simply hangs for a while while using the mysql cli, then responds:

ERROR 2003 (HY000): Can't connect to MySQL server on 'db.address.us-east-1.rds.amazonaws.com' (110)

It did work on my laptop though. I am not quite sure what is wrong. I have a feeling I don't quite understand CIDR/IP. I simply took the ip address and tacked on /32 at the end. Then I gleaned some information that it also has to do with subnet mask? ifconfig reports: 255.255.255.0

I found a calculator and the IP changed a bit and had /24 at the end. That still didn't work.

One other note... perhaps i dont know enough about the differences between OS. The hosting provider is using centOS, while our development machines are all ubuntu.

Any insight would be extremely helpful! THANKS :)

© Server Fault or respective owner

Related posts about ip

Related posts about amazon-web-services