WampServer

MS upgrade to Win10 for October 2018 is causing some unknown issue with WAMP. Everything was working until the W10 upgrade. Now some parts of the local test website just stall and never display the page. Some parts still work OK but I haven't determined exactly which is which (very confusing). They all use PHP and MySQL.

At the same time phpMyAdmin has also stopped. It just sits with a blank page no matter how long it it left.

I have now upgraded WAMP to the latest 3.1.4 64bit, Apache 2.4.35, PHP 7.2.10, MySQL 5.7.23 hoping that that would resolve the issue. WAMP Server is running with all 3 services green, but, even on a clean install, phpMyAdmin is still just sitting on a blank page.

I carefully followed the install instructions; IIS was disabled and C++ are all at the latest versions.



Edited 1 time(s). Last edit at 12/21/2018 06:07AM by iamsteph.

Hi,

Windows updates doesn't install VC++ packages :

- Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
Do not use a previously loaded tool. Make a new download to make sure you are using the correct version.
To download missing packages, do not rely on Microsoft links, they are not reliable, download packages on http://wampserver.aviatechno.net in section Visual C++ Redistribuable Packages
Do not forget that if you have a 64 bit Windows, you must install both 32 and 64 bit versions of each package.
You must install each package "as an administrator", so right-click the exe file and then run as Administrator.

- If it is not already done, apply Update 3.1.6 to your version of Wampserver
Wampserver update 3.1.6

Install also PhpMyAdmin 4.8.4

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

After a few glitches I've got all that done but the issue remains - phpMyAdmin sits showing localhost/phpmyadmin/ in the browser address bar but never brings up the login page. phpinfo does the same.

VC++ checker shows everything installed (the 2017 packs weren't there before).

Wampserver v3.1.6 - 64bit; Apache 2.4.35; PHP 7.2.10; MySQL 5.7.23; phpMyAdmin 4.8.4

Hi,

Please READ (and answer) BEFORE YOU ASK A QUESTION

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

I have read Toubleshooting Tips and followed its recommendations
I have read WAMPServer 3 All you need to know and followed its recommendations
check_vcredist shows all required versions of C++ installed

I believe I have answered these questions (maybe indirectly in some instances) ...
1 - Windows version = 10 64 bit fully updated to October release 1809 (last Wednesday - which is where my issues started)
2 - Version WampServer = 3.1.6 - 64bit
3 - Apache Version = 2.4.35
4 - PHP updated to 4.8.4 but WAMP shows Version = 7.2.10
5 - MySQL Version = 5.7.23
5a - MariaDB version = 10.3.9
6 - What color is the WampServer icon = green (all services running)
Services manager shows only wampapache64, wampmariad64 and wampmysqld64 and all running.
There's nothing unexpected in any of the log files
7 - hosts file active lines:
127.0.0.1 localhost
::1 localhost
8 - Do you have access to localhost = Yes
8a - No error messages
9 - Do you have access to phpMyAdmin? = NO! It tries to open in the browser but never displays the login page
10 - N/A
11 - Antivirus and Firewall = native W10 versions with no special settings
12 - WampServer = C:\wamp\
13 - No Virtual Hosts defined

Hi,

> 4 - PHP updated to 4.8.4 but WAMP shows Version = 7.2.10
4.8.4 is PhpMyAdmin version and 7.2.10 is PHP version.

Do you have access to the MySQL console?
Left-click -> MySQL -> MySQL Console
At the "Password" request, just press Enter, as there is no password.

Have you tried to clear the browser cache, for Firefox, it's Ctrl-F5

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

Hi,

> 9 - Do you have access to phpMyAdmin? = NO! It tries to open in the browser but never displays the login page

Have you blocked cookies and/or Javascript in your browser?
It is also possible that an extension or additional module of the browser may block cookies and/or javascript without your knowledge.

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

I have access to MySQL console. The status display is:
mysql> \s
--------------
c:/wamp/bin/mysql/mysql5.7.23/bin/mysql.exe Ver 14.14 Distrib 5.7.23, for Win64 (x86_64)

Connection id: 2
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server version: 5.7.23 MySQL Community Server (GPL)
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: latin1
Db characterset: latin1
Client characterset: cp850
Conn. characterset: cp850
TCP port: 3306
Uptime: 2 min 17 sec

Threads: 1 Questions: 5 Slow queries: 0 Opens: 108 Flush tables: 1 Open tables: 101 Queries per second avg: 0.036
----------------

Both cookies and javascript are enabled (and anyway other parts of the test system work fine).

I have cleared the cache - it made no difference. I have tried turning off Firefox's inbuilt blockers (I don't have any 3rd party plugins). I've also tried using Edge (it's as installed since I don't normally use it).

Just now I had a go with IE (very clean since I have never used it in W10). It opened the login page and threw up a message "There is mismatch between HTTPS indicated on the server and client. This can lead to non working phpMyAdmin or a security risk. Please fix your server configuration to indicate HTTPS properly."

Since this is localhost on my PC, it doesn't have SSL security so shouldn't be expecting https.

It wouldn't login however - when I tried, it timed out waiting for the page.

Hi,
> "There is mismatch between HTTPS indicated on the server and client.
Very strange!
PhpMyAdmin is not launched with https, but by 'http://localhost/phpmyadmin/' this is what you should see in the browser's address bar.


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

Yes that's what I have. Searching for the message reveals this: [github.com]

I haven't tried it yet - I'll see what happens.

It didn't make a difference. It may be a red herring.

Hi,

Clear the logs files :
Right-Click -> Tools -> Empty logs -> Empty all log files

Left-Click -> PhpMyAdmin 4.8.4

Then see apache_error.log to see if there is any error

When all things are OK and PhpMyAdmin works, the first lines of access.log are :

::1 - - [18/Dec/2018:12:48:12 +0100] "GET /phpmyadmin/ HTTP/1.1" 200 3528
::1 - - [18/Dec/2018:12:48:14 +0100] "GET /phpmyadmin/themes/original/jquery/jquery-ui.css HTTP/1.1" 200 36566
::1 - - [18/Dec/2018:12:48:14 +0100] "GET /phpmyadmin/themes/original/css/printview.css?v=4.8.4 HTTP/1.1" 200 2746
::1 - - [18/Dec/2018:12:48:14 +0100] "GET /phpmyadmin/js/vendor/codemirror/addon/hint/show-hint.css?v=4.8.4 HTTP/1.1" 200 623
::1 - - [18/Dec/2018:12:48:14 +0100] "GET /phpmyadmin/js/vendor/codemirror/addon/lint/lint.css?v=4.8.4 HTTP/1.1" 200 2999
::1 - - [18/Dec/2018:12:48:14 +0100] "GET /phpmyadmin/js/vendor/sprintf.js?v=4.8.4 HTTP/1.1" 200 7387
::1 - - [18/Dec/2018:12:48:14 +0100] "GET /phpmyadmin/js/keyhandler.js?v=4.8.4 HTTP/1.1" 200 3333
::1 - - [18/Dec/2018:12:48:14 +0100] "GET /phpmyadmin/js/vendor/codemirror/lib/codemirror.css?v=4.8.4 HTTP/1.1" 200 8542
::1 - - [18/Dec/2018:12:48:14 +0100] "GET /phpmyadmin/js/ajax.js?v=4.8.4 HTTP/1.1" 200 31246

HTTP/1.1 200 is an HTTP status code :
- 2xx (Successful): The request was successfully received, understood, and accepted
See [en.wikipedia.org]

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

The apache_error log is empty.
The access log contains lines like those you show...
::1 - - [18/Dec/2018:14:14:17 +0000] "GET /phpmyadmin/ HTTP/1.1" 200 3488
::1 - - [18/Dec/2018:14:14:30 +0000] "GET /phpmyadmin/themes/pmahomme/jquery/jquery-ui.css HTTP/1.1" 200 36566
::1 - - [18/Dec/2018:14:14:30 +0000] "GET /phpmyadmin/js/vendor/codemirror/addon/hint/show-hint.css?v=4.8.4 HTTP/1.1" 200 623
::1 - - [18/Dec/2018:14:14:30 +0000] "GET /phpmyadmin/js/vendor/codemirror/lib/codemirror.css?v=4.8.4 HTTP/1.1" 200 8542
<lots more GET for /js/ files>
::1 - - [18/Dec/2018:14:15:49 +0000] "GET /phpmyadmin/favicon.ico HTTP/1.1" 200 22486
::1 - - [18/Dec/2018:14:16:26 +0000] "POST /phpmyadmin/index.php HTTP/1.1" 302 25
::1 - - [18/Dec/2018:14:16:28 +0000] "GET /phpmyadmin/index.php HTTP/1.1" 200 12877
::1 - - [18/Dec/2018:14:16:53 +0000] "GET /phpmyadmin/index.php HTTP/1.1" 200 12877
::1 - - [18/Dec/2018:14:17:12 +0000] "GET /phpmyadmin/index.php HTTP/1.1" 200 12877
::1 - - [18/Dec/2018:14:17:31 +0000] "GET /phpmyadmin/index.php HTTP/1.1" 200 12877
::1 - - [18/Dec/2018:14:17:51 +0000] "GET /phpmyadmin/index.php HTTP/1.1" 200 12877
::1 - - [18/Dec/2018:14:18:11 +0000] "GET /phpmyadmin/index.php HTTP/1.1" 200 12877
::1 - - [18/Dec/2018:14:18:30 +0000] "GET /phpmyadmin/index.php HTTP/1.1" 200 12877
::1 - - [18/Dec/2018:14:19:30 +0000] "-" 408 -

Hi,

There is a 408 Request Timeout - The server timed out waiting for the request.
I don'tknow why.

You never know, there is an old php bug that could resurface.
So, modify the file
wamp(64)\apps\phpmyadmin4.8.4\config.inc.php
to add :

$cfg['Servers'][$i]['ssl_verify'] = false;

under

$cfg['Servers'][$i]['AllowNoPassword'] = true;

You must do it two times as there are two lines

to obtain (Two times)

	// Allow connection without password
	$cfg['Servers'][$i]['AllowNoPassword'] = true;
	$cfg['Servers'][$i]['ssl_verify'] = false;

See explanation for 'ssl_verify' in file wamp(64)\apps\phpmyadmin4.8.4\libraries\config.default.php

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

I already tried that - it's what the GitHub post (https://github.com/phpmyadmin/docker/issues/170) said to do. It made no difference (I stopped and started the services after the config change just in case).

Should have mentioned - the above access log content is from running phpmyadmin in IE and the last bit, starting at POST, is where I tried to log in.

I am trying it in FireFox and two things are weird...

A) it is running (i.e. extending the access log file) but taking a huge amount of time (started 14:39:30 and still going at 15:15:02). Could something (such as W10 anitvirus) be interfering with the file access?

it seems to be doing the same thing ten times each e.g.
::1 - - [18/Dec/2018:15:07:27 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:07:46 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:08:05 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:08:24 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:08:43 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:09:02 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:09:21 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:09:40 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:09:59 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:10:18 +0000] "GET /phpmyadmin/js/vendor/jquery/jquery.ba-hashchange-1.3.js?v=4.8.4 HTTP/1.1" 200 16522
::1 - - [18/Dec/2018:15:10:37 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:10:56 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:11:15 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:11:34 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:11:53 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:12:12 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:12:31 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:12:49 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:13:08 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678
::1 - - [18/Dec/2018:15:13:27 +0000] "GET /phpmyadmin/js/rte.js?v=4.8.4 HTTP/1.1" 200 47678

Hi,

> Could something (such as W10 anitvirus) be interfering with the file access?
Systematically in the settings of anti-virus, Excluded locations, I put:
C:\windows\system32\drivers\etc\hosts
j:\wamp
j:\wamp64

j:\wamp and j:\wamp64 are the two folders of my Wampserver installations.

And I do the same for other protection systems like MalwareBytes or others.

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

That might have made a little difference but it hasn't resolved the issue. I didn't think it would because it isn't generally slow, IE responds in the usual interval but with that error about HTTPS. In FireFox it is slow, never displays a page and appears to be looping, accessing the same resources over and over.

Can I refocus the issue please.

A) This all started with the W10 1809 upgrade. Prior to that everything worked perfectly in WAMP 3.1.3. The same problem happened with that upgrade on both my W10 PCs.

Some pages of my test website stall. I don't have an exhaustive list nor do I know exactly where in the code. One, fairly complex, page stalls the other pages I've looked at don't (they are similar in their use of PHP, JS and MySQL but have less complex code). Then, while trying to pinpoint the issue, I found that phpmyadmin and phpinfo stall completely.

C) The update to WAMP 3.1.6 may be a distraction. I applied it in the hope that the most recent release would resolve the problem, it hasn't.

Hi,

I'm not sure that solves your problem, but, as far as I'm concerned, after each big update of Windows (And 1809 is a very big update), I delete and recreate the services of Wampserver.

- Left-Click -> Stop All Services

- Left-Click -> Apache -> Service administration -> Remove Service
- Left-Click -> MySQL -> Service administration -> Remove Service
- Left-Click -> MariaDB -> Service administration -> Remove Service

- Left-Click -> Apache -> Service administration -> Install Service
- Left-Click -> MySQL -> Service administration -> Install Service
- Left-Click -> MariaDB -> Service administration -> Install Service

- Left-Click -> Start All Services

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

That sounds like a very sensible idea but, since I've removed WAMP and its services and installed the new version from scratch, I have effectively done that already.

Hi,

Since you have access to the MySQL console, we can consider that this is not a problem due to MySQL.
We will try to see if this is a PhpMyAdmin specific problem or more general.

Can you access Adminer?

But, in principle, Adminer does not accept root connections without a password, so we will put a password to root and use the MySQL console to do this.

Left-click -> MySQL -> MySQL Console
At the "Password" request, just press Enter, as there is no password (For the moment)

in this console type :
Be sure that "my_password" is the same in the three cases and remenber it
Do not omit the semicolon ; at the end of each line.

GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'my_password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY 'my_password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'my_password' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;

exit to quit MySQL console.

Now there is a password for root.
MySQL manages passwords and PhpMyAdmin or Adminer uses MySQL users and passwords; these applications do not manage passwords themselves.

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