WampServer

stevenmartin99 Wrote:
-------------------------------------------------------
> disable IPV6. thats all that is wrong here


I did some research regarding this and it appears that it's advised against. Is there another work-around with the Windows 8 issue?

Well im advising you to disable it, When Microsoft learn to implement it correctly, i wll advise you to use it, for now , disable it.


or if you really dont want to , at least force wamp not to use it,

in the httpd.conf

change

listen 80

to

listen 0.0.0.0:80

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

stevenmartin99 Wrote:
-------------------------------------------------------
> Well im advising you to disable it, When
> Microsoft learn to implement it correctly, i wll
> advise you to use it, for now , disable it.
>
>
> or if you really dont want to , at least force
> wamp not to use it,
>
> in the httpd.conf
>
> change
>
> listen 80
>
> to
>
> listen 0.0.0.0:80

I had previously tried disabling IPV6 thinking maybe that was the problem. I just tried it again on a completely separate system and even updated the httpd.conf file to what you said and I am still getting a delay when loading a page which has to access mysql. If I disable my page from connecting to the mysql database the delay goes away.

This does not appear to be related to IPV6 as disabling it and forcing apache to not use it do not solve the problem. This appears to be a problem with mysql being accessed via localhost.

do the same for mysql

in the my.ini

add a line called

bind-address = 0.0.0.0

after the datadir= line

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

stevenmartin99 Wrote:
-------------------------------------------------------
> do the same for mysql
>
> in the my.ini
>
> add a line called
>
> bind-address = 0.0.0.0
>
> after the datadir= line


This did not solve the problem for me. I'm still getting a 1 second delay. Do you have any suggestions to why IE10 will not work with vhosts that direct to 127.0.0.1? They seem to work fine if the vhost points to any other IP address. I wonder if these 2 problems are related somehow...

Thank you for the help and suggestions Steven.

make sure the LMHOSTS is checked on your network adaptor, i think you have to goto properties on your adaptop > hightlight tcp ip ipv4 > properties > wins> lmhosts?

that could be a little wrong as i am not at pc right now

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

stevenmartin99 Wrote:
-------------------------------------------------------
> make sure the LMHOSTS is checked on your network
> adaptor, i think you have to goto properties on
> your adaptop > hightlight tcp ip ipv4 > properties
> > wins> lmhosts?
>
> that could be a little wrong as i am not at pc
> right now


You were close enough for me to find it It was already checked though.

im all out of ideas then except one little hack

in the hosts file

delete everything and just write

127.0.0.1 localhost
127.0.01 127.0.0.1

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

or add these 2 reg keys

open regedit , and navigate to

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings

on the right, right click > create new DWORD32 Key called

MaxConnectionsPer1_0Server

and set it to 10

then restart pc.

( dont worry i dont know this from memory , i copied if from an old post i wrote last month!

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Hello, I have the same problem with win 8, I see that only I have access to 127.0.0.1 [127.0.0.1] but changing the name of my machine I generated:

This error (HTTP 403 Forbidden) means that Internet Explorer was able to connect to the website, but do not have permission to view the website.

musicjerm Wrote:
> .....I am
> still getting a delay when loading a page which
> has to access mysql. If I disable my page from
> connecting to the mysql database the delay goes
> away.

Yes, I just want to emphasize musicjerm's point once again.

On one of my websites, one of the php pages loads instantly when I refresh, and another always has a 1 second delay. The latter page accesses the database via mysql_query(), so I'm pinpointing that as the cause for the whole issue.

In conclusion (for troubleshooters that can help):

1) You have Windows 8 64-bit
2) You have wamp installed
3) You have a php page that makes a query to the database
4) You will have a 1second load time for that page, no matter how simple the page is

This thread will be forever bumped up to the top until a solution allows pages to load instantly once again and all of us can spam F5 to our heart's content when we're coding.

This thread will be binned if you keep writing like that!

Are any of you bothered to troubleshoot the issue... Clear log files . Test etc

Its nothing to do with wamp at all. It's clearly and issue with mysql and win 8.

If your not binding mysql to ipv4 , we are wasting are time Looking at this.

Im all for finding a solution but I will not be switching to wins 8 due to the awful design of it.

So if someone wants to give me 30mins Teamviewer access to a widows 8 machine with wamp installed , I will try to track the issue for you.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

If the time zone is suitable (UTC+10) I'll volunteer my machine, just say when.

My PC is also available... slow loading S**** big time...

ok im free to take a look at someones..

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

can you all cofirm that using 127.0.0.1 instead of localhost speeds up mysql?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

stevenmartin99 Wrote:
-------------------------------------------------------
> can you all cofirm that using 127.0.0.1 instead of
> localhost speeds up mysql?


It doesn't. It's the exact same 1 second delay for me.

i mean in the URL and in the Mysql Connection String , not just one of them

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Using 127.0.0.1 vs localhost does not seem to make a difference other than localhost will note work in IE10.

again i am not taking about the url , im taking about the host varirable in your mysql connection string.

mysql_connect("locahost".......

change to 127.0.0.1 and see if you get the 1 sec delay

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]