thanks for doing that for me atleast that clears the fact that there is some problem with my installation.
I have been trying to telnet the port 3306 for db connection from public IP...it does not work
Code: Select all
D:\Program Files\MySQL\MySQL Server 5.0\data\mysql>telnet 82.46.70.227 3306
Connecting To 82.46.70.227...Could not open connection to the host, on port 3306: Connect failed
but for local ip:
It basically connects and gets the version information and then exits. I do not know at the first point how to provide username and password when connected through telnet.
Code: Select all
telnet 192.168.0.101 3306
4
5.0.18R^$6"H$vI,ó0☻Jv6F@NGWacK,
Connection to host lost.
D:\Program Files\MySQL\MySQL Server 5.0\data\mysql>
My virtual server settings in the router are (look at enabled entries),
Code: Select all
enabled Virtual Server FTP 192.168.0.101 TCP 21/21 always
enabled Virtual Server HTTP 192.168.0.101 TCP 8080/80 always
Virtual Server HTTPS 0.0.0.0 TCP 443/443 always
Virtual Server DNS 0.0.0.0 UDP 53/53 always
Virtual Server SMTP 0.0.0.0 TCP 25/25 always
Virtual Server POP3 0.0.0.0 TCP 110/110 always
Virtual Server Telnet 0.0.0.0 TCP 23/23 always
IPSec 0.0.0.0 UDP 500/500 always
PPTP 0.0.0.0 TCP 1723/1723 always
NetMeeting 0.0.0.0 TCP 1720/1720 always
DCS-1000 0.0.0.0 TCP 80/80 always
DCS-2000/DCS-5300 0.0.0.0 TCP 800/800 always
i2eye 0.0.0.0 TCP 1720/1720 always
DCS-3120 0.0.0.0 UDP 3120/3120 always
enabled db access 192.168.0.101 TCP 3306/3306 always
resultant firewall rules compiled by D-link
Code: Select all
Allow db access *,* *,* TCP,3306-3307
Deny LAN,192.168.0.102 WAN,* TCP,80
Allow Allow to Ping WAN port WAN,* WAN ICMP,8
Allow Virtual Server HTTP WAN,* LAN,192.168.0.101 TCP,8080-80
Allow Virtual Server FTP WAN,* LAN,192.168.0.101 TCP,21
Allow db access WAN,* LAN,192.168.0.101 *,3306
Deny Default *,* LAN,* *,*
Allow Default LAN,* *,* *,*
I strongly suspect this to be a problem with the router setting, D-link. If anybody has got D-link and made DB access work with public IP, please let me know how you did it.