coldascold
ISP
Hey I have installed and had running Apache with MYSQL at a previous time with no problems hosting over 700 sites with it.However I came to the point where I needed Microsoft ASP 2 scripting support ,so new computer ,as PWS 4 will only install with minimal REGISTRY conflicks and shared files.
Any how PWS seems to disturb the network layer and im not quite sure which layer it runs on however MYSQL seems to run on the same layer which is leaving MYSQL unable to connect on through local host to TCP/IP .
MYSQL used to run on 192.168.0.1 but now runs on localhost(127.0.0.1) or when restarted my public IP.I have tryed to bind the address to localhost and 192.168.0.1 and even tryed changing the ports as I have several computers under me ie. network sharing and connection sharing.
As you would know connection sharing assigns DNS IP's to many computers from the main computer giving MSQL my DNS or ISP's name.
This have left me to have to maybee install MYSQL on one of the networked computers but I am reluctant to do so as I am useing high speed processors and networks go up and down and have small delays ie.10ms @10mbs. Which leaves MSQL open for disconnection problems. and timeouts in possibility.
Apache now seems to run on the same network layer as Microsoft PWS4 except on port 70.
TO The Point it seems to be the network DNS that is assinging MYSQL these strange addresses Ie. network address for the same machine is 192.168.0.1.
So in simple terms 192.168.0.1 is a direct link to localhost which is a loopback for the PUBIC IP #
therefore 192.168.0.1= http:// mysite .com
# I cannot connect to MYSQL on my public IP because it wont start and cannot connect.Firewalls are garbage in my world so this isnt a prob.
Any Ideas appeciated
Any how PWS seems to disturb the network layer and im not quite sure which layer it runs on however MYSQL seems to run on the same layer which is leaving MYSQL unable to connect on through local host to TCP/IP .
MYSQL used to run on 192.168.0.1 but now runs on localhost(127.0.0.1) or when restarted my public IP.I have tryed to bind the address to localhost and 192.168.0.1 and even tryed changing the ports as I have several computers under me ie. network sharing and connection sharing.
As you would know connection sharing assigns DNS IP's to many computers from the main computer giving MSQL my DNS or ISP's name.
This have left me to have to maybee install MYSQL on one of the networked computers but I am reluctant to do so as I am useing high speed processors and networks go up and down and have small delays ie.10ms @10mbs. Which leaves MSQL open for disconnection problems. and timeouts in possibility.
Apache now seems to run on the same network layer as Microsoft PWS4 except on port 70.
TO The Point it seems to be the network DNS that is assinging MYSQL these strange addresses Ie. network address for the same machine is 192.168.0.1.
So in simple terms 192.168.0.1 is a direct link to localhost which is a loopback for the PUBIC IP #
therefore 192.168.0.1= http:// mysite .com
# I cannot connect to MYSQL on my public IP because it wont start and cannot connect.Firewalls are garbage in my world so this isnt a prob.
Any Ideas appeciated