WampServer

I can get into Adminer (I haven't tried Adminer before so I'm not really sure what to expect) but it seems to be a bit slow to respond.

Using IE it opens the login page and logs in OK. I get a list of tables in the database but all of the details (Data Length, Index Length, Data Free etc.) are empty.

With IE it took quite a long time and the access log shows it accessing the same resources (e.g. functions.js) five times at 20sec intervals before it eventually responded. FireFox takes two to three times longer to open the login page and the access log shows ten or more such duplicate accesses.

Note: I created my test database today from a mySQLdump SQL file I created before I installed the new version of WAMP so it should be fresh and fully compatible with this version.

Hi,

With Firefox, Adminer is going on less than one second after Authentification button.
With Firefox, PhpMyAdmin is going on less than two second after Execute button

And this with Wampserver 32 or 64 bit and under Windows 7 pro 64 bit and Windows 10 Pro 64 bit.

I don't know what it is, but there's a "thing" on your system that slows down and even blocks local http access.

For PhpMyAdmin, we will try the automatic connection with a predefined user and password instead of the "cookie" type connection

Edit the file : wamp(64)\apps\phpmyadmin4.8.4\config.inc.php
Replace (Two times) :

	$cfg['Servers'][$i]['auth_type'] = 'cookie';
	$cfg['Servers'][$i]['user'] = '';
	$cfg['Servers'][$i]['password'] = '';

by

	$cfg['Servers'][$i]['auth_type'] = 'config';
	$cfg['Servers'][$i]['user'] = 'root';
	$cfg['Servers'][$i]['password'] = 'my_password_for_root';

Save the modified file.
Launch PhpMyAdmin

With this, in my system, PhpMyAdmin is going on in less than one second.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons



Edited 1 time(s). Last edit at 12/19/2018 03:30PM by Otomatic.

Hi,

It now times out in IE without displaying anything (shows a message "cannot reach this page"

The access log contains only:
::1 - - [19/Dec/2018:16:10:55 +0000] "GET /phpmyadmin/ HTTP/1.1" 200 13092
::1 - - [19/Dec/2018:16:11:55 +0000] "-" 408 -

All other log files are empty.

In FireFox it just sits with an empty page but is writing that GET line into the access log over and over.

I checked the password I put into the config.inc.php file - it works fine with Adminer.

Hi,

Result of :
Right-Click -> Tools -> Check DNS search order

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

It returns:

*** Checking the DNS search order ***

Values of registry keys for
HKLM\SYSTEM\CurrentControlSet\Services\Tcpip\ServiceProvider
are in correct order

Hi,

The only "trick" that comes to mind would be to perform a network "clean-up".
In a "as administrator" command window, type the following commands:

netsh winsock reset
netsh winsock reset catalog
netsh int ip reset reset.log
netsh int ipv4 reset reset.log
netsh int ipv6 reset reset.log
ipconfig /flushdns

In a way, this resets the IP configuration.
At the end, the system must be restarted.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

That makes no difference.

A couple of graphics on the test web site are not displaying so I tried an experiment. I created a simple web page with two <img> tags. Both for the same gif file that isn't loading. One pointed to the server (src="[server] the other to the hard disc (src="images/picture.gif". The one from the server loads immediately (although it could be coming from the cache). The local one doesn't load at all and the access log shows it as GET over and over.

This gif is about 40Kb. Other smaller jpg files around 4Kb load from the disc OK. I doubt that the file type is an issue but the size might be.

I found a note on the web that this could be caused by interference on the listening port so I tried changing it from 80 to 8080 in httpd.conf (both the Listen and ServerName lines) and stopped/started the services. However that stopped the localhost page from displaying (page not found). I checked the firewall - I think Apache is allowed to use any port it wants.

Would changing the port help (it looks like httpd.exe is listening on 0.0.0.0:80 and [::]:80)? If so what am I doing wrong changing it to 8080?

Also, I assume the ::1 at the start of the access log lines indicates it is using ipv6. Is it possible to force it to ipv4 and would that help?

Hi,

> I tried changing it from 80 to 8080 in httpd.conf (both the Listen and ServerName lines)
To change Apache port, you must use Wampserver integrated tools.
But before using the integrated tool, you must return to the initial state, i.e. delete your manual changes.

Right-Click -> Tools -> Use a port other than 80

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

That's done it - hooray!
phpmyadmin and phpinfo have come back to life and display quickly. So does my test website.

Thanks for all the help, patience and perseverance.

I have a remaining minor question ... the test website doesn't respond on [localhost] and I have to enter [localhost] Is that now normal or is there something I can do to omit the 8080?

Hi,

> the test website doesn't respond on [localhost] and I have to enter [localhost]
> Is that now normal or is there something I can do to omit the 8080?
Port 80 is the port assigned to the http protocol, as is port 443 for https, port 25 for SMTP, port 119 for NNTP, etc.
Because these ports are assigned, the related protocols do not need to specify the port number during transactions, the protocol used "knows" which port it should use if the port number is not specified.
From the moment a protocol uses a port other than the one assigned to it, this port number must always be specified in all transactions.

So, you will still need to specify port 8080 in all your http calls.

And that's why also, the port must be changed by the tools integrated in Wampserver so that it is changed wherever it needs to be done and that this change is known by Wampserver, therefore by Apache.

Just to see, what is the result of:

Right-Click -> Tools -> Test port 80

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Understood - it isn't a problem really, just curious.

Forgot to say "thank you Microsoft!" It seems that uninstalling Skype and IIS is no longer sufficient to release port 80.

***** Test which uses port 80 *****

===== Tested by command netstat filtered on port 80 =====


Test for TCP
Port 80 is not found associated with TCP protocol

Test for TCPv6
Port 80 is not found associated with TCP protocol

===== Tested by attempting to open a socket on port 80 =====

Your port 80 seems not actually used.
Unable to initiate a socket connection
Error number: 10061 - Error string: No connection could be made because the target machine actively refused it.

Hi,

We would still have to find out why, after an update 1809, you have problems, we'll say throughput problems, on port 80, whereas in my case, even after the update 1809 and the subsequent (small) updates I didn't have any problems.
There is another user on the French-speaking forum who has this problem and even worse, since although the Wampmanager icon is green, i. e. with Apache started, localhost and phpmyadmin access via port 80, are a priori prohibited, while, there too, everything works fine on port 8080.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Hi,

For all intents and purposes, you could look at whether there would be a port forwarding without your knowledge.
In a "as administrator" command window, type:

netsh interface portproxy show all

and/or

netsh interface portproxy dump

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

netsh interface portproxy show all == produces no output.

netsh interface portproxy dump:

#========================
# Port Proxy configuration
#========================
pushd interface portproxy

reset


popd

# End of Port Proxy configuration

I have two PC, a desktop and a laptop. They are different manufacturers so different hardware configurations. They are both 64bit chipset with Windows 10 64bit upgraded to 1809 on 12th Dec (plus a few bits that came after). Not much additional software on either (mostly OpenOffice, Firefox, Thunderbird and WAMP)

My laptop took the free upgrade from W7. It is inherently a US version with the language overridden to UK. My desktop has a clean W10 UK version installed about 6 months ago.

Both had the same problem with WAMP, phpmyadmin stopped responding. Both have been fixed by changing to port 8080. There's one other difference, the desktop is running WAMP 3.1.4 32bit (for historic reasons) whereas my laptop is running WAMP 3.1.6 64bit. The above testing was all done on my laptop. I might get round to upgrading the desktop to WAMP 3.1.6 64bit next month.

I'm happy to run diagnostics on either or both PC if you think that might help.

Hi,

There is no port forwarding

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons