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?