0

I have a local server running Redis, Mongo, and MySQL servers. I can access it with its LAN IP address (192.168.*. *), but I can't access it by its CNAME. I have the server set up in the DMZ of our local router. If I run a Rails server at port 3000 I am able to see it at the CNAME (cname.domain.com:3000). For the mysql server when I try to login using the CNAME I get an error:

ERROR 1130 (HY000): Host '**************.rr.com' is not allowed to connect to this MySQL server

I am running Ubuntu and have configured ufw (front end for IP tables) to allow all on 192.168.0.0/24

Do I need to make sure each of the ports are port forwarded on the router?

2 Answers 2

1

This does not sound like a firewall issue, since you get the error from MySQL already.
More likely, since you are accessing the MySQL server now via the CNAME you are not coming from a allowed IP anymore but from your gateway IP (or similar, hard to say without knowing your network layout).
Check MySQL privileges.

1
  • Thanks, but I can fix the MySQL problem. Redis and Mongo were the main concerns. I enabled "virtual servers" for the Redis and Mongo ports on the router and it worked. Jun 14, 2011 at 20:09
1

Lookup the record for the hostname, it could point to a public IP address in which case you'll likely be routed out your LAN's public interface rather than going internally, in which case you'd need to update your mysql.user table to allow access to the user from your public IP.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .