WampServer

Well throw it away, it should not be anywhere near WampServer folders

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi there,

I am using wampserver 2.5 on Windows 8.

One fine day, the W icon got stuck in Orange and will not turn Green.

I have tried most of the suggestions stated above but is still does not work.

I could not follow all suggestions as I could not find some files / links stated above.

Can somebody help and tell me what else I can do to resolve this issue?


Cheers
freshbie

Hi freshbie

Lets start at the beginning :-

If the wampmanager icon is not GREEN then one of the services ( Apache(wampapache)/MySQL(wampmysqld) ) has not started properly.

How to tell which service is not running if the wampmanager icon is orange.

Left click the wampmanager icon to reveal the menu-> Apache -> Service
If the Start/Resume service menu is Green then Apache IS NOT running.

Left click the wampmanager icon to reveal the menu-> MySQL -> Service
If the Start/Resume service menu is Green then MySQL IS NOT running.

If Apache is the service that is not running it is normally, but not always, because something else has captured port 80.

Now do,
Left click the wampmanager icon to reveal the menu-> Apache -> Service -> Test port 80
This will launch a command window and display some information about what, if anything is using port 80.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi RiggsFolly,

I have checked and it is showing that MySQL is NOT running.

I tried clicked on the Start/Resume service, but it did not work.

Like to check how can I get it to run?

Cheers
Freshbie

Ok when MySQL wont start it is usually 1 of 2 reasons so we will start with those.

1. Are you running another MySQL Server? Some dev tools sometimes come with one installed in the background.

The MySQL server that comes with WAMPServer has the service name 'wampmysqld' or 'wampmysqld64', check the services snapin to see if you have one that has a service name of 'MYSQL' that means you have another one running.


2. There is a rouge my.ini or my.cnf file on your system. Do a search of C: for any file with either of those names. If you find any that are NOT in the '\wamp\....' folder structure somewhere then delete them.

Then try starting WAMPServers MySQL again.


Please let me know which one it was, or if it was neither we can look a little closer.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi RiggsFolly,

Like to check how can I check the services snapin?

Where do I go to to check for this?

Cheers
Freshbie

Press the start button.

In the filed containing 'Search programs and file' enter 'Services'

The Services snapin should then show in the Programs list with a little cog beside it.

Click it.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi RiggsFolly,

I tried step 2 and found 2 files while searching for my.ini
Both are inside wamp folder.

C:\wamp\bin\mysql\mysql5.6.17

C:\wamp\bin\mysql\mysql5.6.17


No file was found while searching for my.cnf


Cheers
Freshbie

Hi RiggsFolly,

I'm sorry as I'm having a hard time with Windows 8.

There isn't any Search programs and file in Windows 8.


I search under C drive and there are some Services folder,

1. C:\Users\stevenmaxquek\AppData\LocalLow\Microsoft\Internet Explorer

2. C:\Windows\System32\DriverStore\FileRepository\dptf.inf_amd64_8bee0896dde756d2

3. C:\Windows\WinSxS\amd64_microsoft-windows-s..cecontroller-minwin_31bf3856ad364e35_6.2.9200.20521_none_98a9ea2e9f571eb2

4. C:\Windows\WinSxS\amd64_microsoft-windows-s..cecontroller-minwin_31bf3856ad364e35_6.2.9200.16384_none_97e26cd38667756c

5. C:\Windows\System32

6. C:\Windows\WinSxS\amd64_microsoft-windows-s..cecontroller-minwin_31bf3856ad364e35_6.2.9200.16420_none_981f4d19863a6591

7. C:\Windows\System32\en-US

8. C:\Windows\SysWOW64\en-US

9. C:\Windows\WinSxS\amd64_microsoft-windows-s..cessnapin.resources_31bf3856ad364e35_6.2.9200.16384_en-us_fd08be678622fdab

10. C:\Windows\WinSxS\x86_microsoft-windows-s..cessnapin.resources_31bf3856ad364e35_6.2.9200.16384_en-us_a0ea22e3cdc58c75

11. C:\Windows\System32\Drivers\etc

12. C:\Windows\WinSxS\amd64_microsoft-windows-w..ucture-other-minwin_31bf3856ad364e35_6.2.9200.16384_none_8e0944daeed62829

13. C:\Windows\WinSxS\amd64_microsoft-windows-servicessnapin_31bf3856ad364e35_6.2.9200.16384_none_282d8a08cf7f1ada

14. C:\Windows\System32

15. C:\Windows\WinSxS\amd64_microsoft-windows-servicessnapin_31bf3856ad364e35_6.2.9200.16384_none_282d8a08cf7f1ada

16. C:\Windows\SysWOW64

17. C:\Windows\WinSxS\wow64_microsoft-windows-servicessnapin_31bf3856ad364e35_6.2.9200.16384_none_3282345b03dfdcd5



There are some folders like services.h etc
C:\wamp\bin\mysql\mysql5.6.17\include\mysql


What kind of file should I be looking for?

Cheers
Freshbie

Hi RiggsFolly,

I went into the Services, there is only wampmysqld.


Cheers
Freshbie

Hi RiggsFolly,

Based on your previous message



[Ok when MySQL wont start it is usually 1 of 2 reasons so we will start with those.

1. Are you running another MySQL Server? Some dev tools sometimes come with one installed in the background.

The MySQL server that comes with WAMPServer has the service name 'wampmysqld' or 'wampmysqld64', check the services snapin to see if you have one that has a service name of 'MYSQL' that means you have another one running.


2. There is a rouge my.ini or my.cnf file on your system. Do a search of C: for any file with either of those names. If you find any that are NOT in the '\wamp\....' folder structure somewhere then delete them.

Then try starting WAMPServers MySQL again.


Please let me know which one it was, or if it was neither we can look a little closer.]



It is neither.

Like to check how can I proceed from here?

Cheers
Freshbie

Hi RiggsFolly,

I tried starting the wampmysqld service from the Services (Local), but it did not work.

It is showing an Error box;


Windows could not start the wampmysqld service on Local Computer.

Error 1067: The process terminated unexpectedly.


Cheers
Freshbie

I am not sure you are up to Web Development yet.

Hear is how to use search for a file in Windows 8: [windows.microsoft.com]



MySQL writes an error log, you get to it via the wampmanager icon in the system tray

wampmanager -> MySQL -> MySQL log

If that is no use or empty then it also writes errors to the 'Windows Event Viewer' in the left panel select Windows Logs and then below that Application.

Look for messages from MYSQL

How to open windows event viewer in Windows 8 [www.computerperformance.co.uk]

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-



Edited 2 time(s). Last edit at 08/20/2014 05:24PM by RiggsFolly.

Hi RiggsFolly,

You are right. I am primarily using wamp to back up my websites.

I have a very important website backup that I need to retrieve but cannot get wamp to start.

I have checked through the whole log but there isn't any messages from MYSQL.


Cheers
Freshbie

Hi RiggsFolly,

Is there any other way I can get this fixed?


Cheers
Freshbie

Looks like we are going to have to go hands-on with this one.

Install TeamViewer and I will troubleshoot for you.

Install TV, then run it.

Send me a Private Message containing the TV ID and PASSWORD so I can connect.
Leave TV running as it will change the password each time you restart it.

I am on UK time (GMT) and am normally available 09:00 - 16:00 and normally later into the evening.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Hi RiggsFolly,

Thank you for guiding me all the way through.

I managed to delete away 1 of the folder for 1 of the backup site that I have in the local host and managed to get the wampserver to run again.

Really appreciate your patience with me all this while and guiding me step by step to get it fixed.

You are a good adviser.


Cheers
Freshbie.

Hi,

I need your kind help please. I have installed Wampserver2.4-x86 on my 32 bit OS, i have changed port as well in the httpd.conf file to Listen 81. After saving the file wamp server turns green n every thing was working fine. But the moment i am restarting my computer the wamp server doesn't go green, its turning from red to orange but not green. I have done restart all service, still its orange.

Looking for reply.

Thanx and regards,
Ritika

So which service has not started after your reboot and are there any useful error messahes in Apache error log or mysql error log or in the windows event viewer?

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>
Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Apache service is running, Mysql service is not running.

I dont know much about error log file, actually i am new to php.

This is my error log file--


[Thu Aug 28 15:17:53.598695 2014] [mpm_winnt:notice] [pid 7444:tid 432] AH00455: Apache/2.4.4 (Win32) PHP/5.4.16 configured -- resuming normal operations
[Thu Aug 28 15:17:53.598695 2014] [mpm_winnt:notice] [pid 7444:tid 432] AH00456: Server built: Feb 23 2013 13:07:34
[Thu Aug 28 15:17:53.598695 2014] [core:notice] [pid 7444:tid 432] AH00094: Command line: 'c:\\wamp\\bin\\apache\\apache2.4.4\\bin\\httpd.exe -d C:/wamp/bin/apache/Apache2.4.4'
[Thu Aug 28 15:17:53.620696 2014] [mpm_winnt:notice] [pid 7444:tid 432] AH00418: Parent: Created child process 6892
[Thu Aug 28 15:17:54.296735 2014] [mpm_winnt:notice] [pid 6892:tid 336] AH00354: Child: Starting 150 worker threads.
[Thu Aug 28 15:18:41.067410 2014] [mpm_winnt:notice] [pid 7444:tid 432] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Aug 28 15:18:43.070524 2014] [mpm_winnt:notice] [pid 6892:tid 336] AH00364: Child: All worker threads have exited.
[Thu Aug 28 15:18:43.300537 2014] [mpm_winnt:notice] [pid 7444:tid 432] AH00430: Parent: Child process 6892 exited successfully.
[Thu Aug 28 15:18:50.175931 2014] [mpm_winnt:notice] [pid 2840:tid 432] AH00455: Apache/2.4.4 (Win32) PHP/5.4.16 configured -- resuming normal operations
[Thu Aug 28 15:18:50.175931 2014] [mpm_winnt:notice] [pid 2840:tid 432] AH00456: Server built: Feb 23 2013 13:07:34
[Thu Aug 28 15:18:50.175931 2014] [core:notice] [pid 2840:tid 432] AH00094: Command line: 'c:\\wamp\\bin\\apache\\apache2.4.4\\bin\\httpd.exe -d C:/wamp/bin/apache/Apache2.4.4'
[Thu Aug 28 15:18:50.179931 2014] [mpm_winnt:notice] [pid 2840:tid 432] AH00418: Parent: Created child process 7548
[Thu Aug 28 15:18:50.726962 2014] [mpm_winnt:notice] [pid 7548:tid 332] AH00354: Child: Starting 150 worker threads.
[Thu Aug 28 15:23:59.673338 2014] [core:warn] [pid 3828:tid 328] AH00098: pid file C:/wamp/bin/apache/Apache2.4.4/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Thu Aug 28 15:24:00.435382 2014] [mpm_winnt:notice] [pid 3828:tid 328] AH00455: Apache/2.4.4 (Win32) PHP/5.4.16 configured -- resuming normal operations
[Thu Aug 28 15:24:00.452383 2014] [mpm_winnt:notice] [pid 3828:tid 328] AH00456: Server built: Feb 23 2013 13:07:34
[Thu Aug 28 15:24:00.452383 2014] [core:notice] [pid 3828:tid 328] AH00094: Command line: 'c:\\wamp\\bin\\apache\\apache2.4.4\\bin\\httpd.exe -d C:/wamp/bin/apache/Apache2.4.4'
[Thu Aug 28 15:24:00.484385 2014] [mpm_winnt:notice] [pid 3828:tid 328] AH00418: Parent: Created child process 5316
[Thu Aug 28 15:24:00.975413 2014] [mpm_winnt:notice] [pid 5316:tid 336] AH00354: Child: Starting 150 worker threads.
[Thu Aug 28 15:24:16.001272 2014] [mpm_winnt:notice] [pid 3828:tid 328] AH00422: Parent: Received shutdown signal -- Shutting down the server.
[Thu Aug 28 15:24:18.002387 2014] [mpm_winnt:notice] [pid 5316:tid 336] AH00364: Child: All worker threads have exited.
[Thu Aug 28 15:24:18.239400 2014] [mpm_winnt:notice] [pid 3828:tid 328] AH00430: Parent: Child process 5316 exited successfully.
[Thu Aug 28 15:24:18.925440 2014] [mpm_winnt:notice] [pid 5212:tid 432] AH00455: Apache/2.4.4 (Win32) PHP/5.4.16 configured -- resuming normal operations
[Thu Aug 28 15:24:18.925440 2014] [mpm_winnt:notice] [pid 5212:tid 432] AH00456: Server built: Feb 23 2013 13:07:34
[Thu Aug 28 15:24:18.925440 2014] [core:notice] [pid 5212:tid 432] AH00094: Command line: 'c:\\wamp\\bin\\apache\\apache2.4.4\\bin\\httpd.exe -d C:/wamp/bin/apache/Apache2.4.4'
[Thu Aug 28 15:24:18.930440 2014] [mpm_winnt:notice] [pid 5212:tid 432] AH00418: Parent: Created child process 1840
[Thu Aug 28 15:24:19.436469 2014] [mpm_winnt:notice] [pid 1840:tid 332] AH00354: Child: Starting 150 worker threads.