Localhost connection fails after connecting to wireless network

[Hanshi1971]

Hello all,

I have a laptop running XP Pro. Also using web software called Front Accounting to handle my paperwork for small business. I installed by myself all the necessary software and have some experience using Apache / PHP / Mysql.

Brief description of problem:
I installed all the components Apache/php/mysql as per the documentation. Create a phpinfo(); script to test. And install phpmyadmin to configure database for web application. This is where things don't work so well.

Scenario A: If I am working away from internet access, say at a remote site, then the local webserver, mysql, front accounting all work fine. I get access through http://localhost/ ...

Scenario B: As soon as working from home or office where internet is connected (through wireless router) the localhost/phpmyadmin stops responding, I only get a blank page (No Errors). When I sever the connection to my wireless internet, the webpages will again respond properly.

I have a feeling it is hosts related so I check hosts file: file contains:
127.0.0.1 localhost

Current configuration:
Apache/2.2.15
PHP/5.3.2
MYSQL/5.1.46

Router configuration: I have exact same problem on three completely separate routers (Office=linksys, Home=dlink, Parents=dlink). Each router has its own dhcp server and my wireless IP address becomes something like 192.168.0.100 as example. Network settings are basic dhcp settings (no proxy). Windows firewall is completely disabled. I have no firewall or anything unusual running that could interfere.

So I tried to access web through http://192.168.0.100/ ...
Problem persists. Initial phpmyadmin screen comes up, but the as I enter the main database part the screen hangs.

I can work locally without internet and if I need something then turn internet on, but it's a complete pain. Without fail this is the difference: not connected to internet everything works fine, connect to internet it does not.

I need your help, oh experts! :)

[sknake]

>>So I tried to access web through http://192.168.0.100/ ...
>>Problem persists. Initial phpmyadmin screen comes up, but the
>> as I enter the main database part the screen hangs.

When you navigate to http://192.168.0.100/ and click on a subsequent link is are you being redirected to http://192.168.0.100/somePage or http://localhost/somePage . If the webserver is attempting to rewrite the URL with a bad hostname then this may cause issues.

Also can you explain your setup a little more? Do you have an XP laptop with a *nix virtual machine, or are you running windows binaries of apache/etc on XP?

[Hanshi1971]

I am using the Windows binaries on XP.

Some further observances:

Remember, this only happens while connected to the internet. When I go offline this does not occur.

Now, I enter the http://localhost/phpmydamin/index.php or this http://192.168.0.100/phpmyadmin/index.php (Both resolve to their correct domains localhost or 192.168.0.100). The login screen appears correctly which tells me that both Apache and PHP are working. This explains why my phpinfo.php script is also working.

However, when I enter my login info. the status of the browser goes to 'waiting for localhost' in the status bar, this takes quite some time. After which the screen goes blank and no further action can be taken. I am thinking now something to do with MYSQL. The database is not connecting through the ports correctly or something when the server has a valid IP address?

Just thinking aloud any help would be appreciated.

Justin

[Hanshi1971]

So I have solved this on my own!

I was able to repeat this problem on my home PC running Vista 64-bit edition. Installed all the server stuuf, got MySQL configured, and whammo same problem!

So I searche the forums and found out that my Vista uses IPv6, which is not supported in MySQL. Ironically I had the IPv6 protocal installed on my laptop for experimental reasons. On Vista it was a line in the HOSTS file(Comment out ::1 localhost)

After uninsalling the IPv6 protocol, my problem is gone. Thanks for all your efforts