TROUBLESHOOTING TIPS
Posted by: RiggsFolly (---.as43234.net)
Date: August 17, 2015 10:49PM

Checks to be made if you have a problem after installing Wampserver.

Most of these checks can be done before installing WampServer.

Note : Do not reply to this message. Create a New discussion to describe your problem in a clear and detailed manner (With Versions of your System, Apache, PHP, MySQL, EXACT error message, etc.)

Prerequisites :
--- The Wampmanager icon in the taskbar MUST be GREEN.
--- If the icon is not green, there is no point expecting everything to work as it means that one of both of the Apache/MySQL services has not started.
--- Read ALL this document, do not stop at the first problem you have.
--- In order to be sure you are working on the right file, it is imperative to be able to "see" hidden files and all extensions. To do this, launch Explorer -> Tools -> Folder Options -> View and check:
- Show files, folders and hidden drives is checked
- Hide extensions of known file types is unchecked

- 01
- If you are trying to upgrade your existing version of WAMPServer to a newer version or the latest versions
- - Did you follow this post Installing a new release of Wampserver, If not, it may not be too late to do so!

- 02
- You must install WAMPServer as an Administrator (This is an Absolutely must)
- - Right-click the install *.exe file and select "Run as Administrator" from the menu.

- It is highly recommended to install Wampserver at the root of a partition (C:\Wamp, D:\Wamp, etc) and do not use an installation folder name with spaces or diacritical characters. So do not install in "Program Files".

- 03
- Do you have Skype installed or running?
- - If so, it is imperative to change the Skype configuration to NOT use port 80 or 443.
- - Do this by starting SKYPE and using the menus do - Tools -> Options -> Advanced Settings -> Connection:
- - Uncheck "Use ports 80 and 443 as an alternative."
- The Windows 8/8.1/10 tiled app versions of SKYPE may not allow you to change this, so uninstall the tiled app and install SKYPE from a download, it will work just the same, but it will also allow you to make the above configuration changes.


- 04 - If the Wampserver icon is not green, it means that at least one service is not started.
Note: Since Wampserver 3.0.7, there are three services (apache, mysql and mariadb) and no longer just two (apache and mysql)
They are called: wampapache, wampmysqld and wampmariadb for the 32-bit versions and wampapache64, wampmysqld64 and wampmariadb64 for the 64-bit versions.
What service(s) is(are) not Started?
- To check from the Services Manager: click Start, Run, and type services.msc or Administration Tools->Services and check the status of wampapache, wampmysqld and wampmariadb services (or wampapache64, wampmysqld64 and wampmariadb64with Wampserver 2.5 64 bit)
Even if the Wampmanager icon is not green, there is an integrated tool to check the status of services:
Right-click icon Wampmanager -> Tools -> Check status of services
- 05 - Always check, with the Services Manager that there is no Apache or MySQL services OTHER THAN wampapache(64) and wampmysqld(64) (See Note 1)

- 06 - Do you have other "php.ini" files on your system not contained in the wamp tree? If so, delete them.
- To check it in command line: Start, Run, cmd.exe
-- Go to the root of the disc CD / then Enter
dir /s php.ini
--- See Note 4 for how to use a Command Windows

- 07 - Are there other "my.ini" files on your system not contained in the wamp tree? If so, delete them.
--- The search procedure is similar to php.ini

- 08 - Do you have IIS installed?
Control Panel, Programs and Features, Turn Windows features on or off
(W7/W8/W10) Uncheck :
-- Main Web Internet service instance (IIS)
-- All items of the branch : Internet services(IIS)
-- All items of the branch : Activation Windows service process
(W10/W11) Uncheck :
-- Main instance Web of Internet Information Services (IIS)
-- All items of the branch : Internet Information Services

- 09 -In the file "Windows\System32\drivers\etc\hosts" you MUST have the following lines active that is to say not starting with # comment symbol. Some malware tools place a large number of bad sites in the HOSTS file to stop you ever accessing them. It is OK to leave those in the hosts file, but ensure the entries below are also there.
You are a Systems Administrator now, so it would be a good idea to know something about the use of the host file

127.0.0.1 localhost
and exist only once.
ONLY if your system and your network supports IPv6 you can add a second line:
127.0.0.1 localhost
::1 localhost

Note: 09-1 : By default, the hosts file is provided with the system attributes: hidden, read-only. It is therefore imperative to remove these attributes before you want to edit. Also some AV/Firewall apps also add protection to the hosts file. You may have to check if you are using one of these, so you can allow access to this file while you are making amendments. (See 10)

Note: 09-2 : Support of Ipv6
To see if your system supports IPv6, open a command window and run in this window the ping
Test for IPv4
C:\Windows\System32>ping 127.0.0.1

Pinging 127.0.0.1 with 32 bytes of data:
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128
Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

Ping statistics for 127.0.0.1:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms
We can see that the four test 127.0.0.1 have been received, without any loss.
Test for IPv6
C:\Windows\System32>ping ::1

Pinging ::1 with 32 bytes of data:
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms
Reply from ::1: time<1ms

Ping statistics for ::1:
    Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
Approximate round trip times in milli-seconds:
    Minimum = 0ms, Maximum = 0ms, Average = 0ms
We can see that the four tests have all been received, without any loss, so the system supports IPv6
If your system or connections (WiFi, Internet, etc.) do not support IPv6 or if you are unsure, disable the Internet Protocol Version 6 (TCP / IPv6) in properties of all your network connections.

- 10 - Make sure your antivirus or protection system does not block access to:
-- file Windows\System32\drivers\etc\hosts
-- wamp\Wampmanager.exe
-- wamp\bin\apache\apache2.2.x\bin\httpd.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysql.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysqlcheck.exe
-- wamp\bin\mysql\mysql5.x.y\bin\mysqld.exe
-- wamp\bin\php\php5.3.x\php.exe
-- 10a - Exclude a file or folder from the Windows Defender virus/threat scan
-- Start menu, Windows Security
-- Protection against viruses and threats
-- Manage parameters
-- Exclusions, Add or remove exclusions
-- Add an exclusion
-- You can add the hosts file and the Wampserver installation folder.

- 11 - Any other installation of a server (EasyPHP, XAMPP, IIS, or other) is incompatible with Wampserver and must be uninstalled completely before installing WAMPServer.

- 12 - Are there any ERRORS in MySQL or Apache log file? (Log files are in the /wamp/logs/ folder)

- 13 - Are there any errors in the Windows Event Viewer?
(Using the Event Viewer: [www.sevenforums.com])

- 14 - Make sure your firewall and your antivirus protection permits (and do not prohibit) the access to ports 80 and 3306

- 15 - If you have previously uninstalled Wampserver, verify that both services wampapache(64) and wampmysqld(64) had been deleted before installing a new version? (See note 1)

- 16 - Install Wampserver 64bit ONLY if you have a Windows 64bit Operating System, in this case, always take the latest version of WampServer.
-- With 64-bit Apache, PHP and MySQL and all extensions and modules must always be compiled 64bit Thread Safe.

- 17 - No more used

- 18 - No more used

- 19 - PhpMyAdmin. After installing Wampserver or a new version of MySQL or MariaDB, the connection to PhpMyAdmin is made with the "root" user and without a password, i.e. with the empty Password box.

- 19-a - Adminer. Adminer does not accept connections without a password. After installing Wampserver or a new version of MySQL or MariaDB, the only user is "root" without a password. To connect to Adminer, you must first set a password for the root user. This can be done:
- or by connecting to PhpMyAdmin and the User Accounts tab, root, Edit privileges, Change password.
- either by connecting to the MySQL or MariaDB console depending on the database manager used by default and the commands :
# Before MySQL 8
# Privileges for `root`@`127.0.0.1`
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'password' WITH GRANT OPTION;
# Privileges for `root`@`::1`
GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' IDENTIFIED BY 'password' WITH GRANT OPTION;
# Privileges for `root`@`localhost`
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;
# MySQL 8 - Privileges for `root`
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER 'root'@'localhost' DEFAULT ROLE ALL;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' WITH GRANT OPTION;
GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION;
CREATE USER IF NOT EXISTS 'root'@'127.0.0.1' IDENTIFIED WITH mysql_native_password BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER IF EXISTS 'root'@'127.0.0.1' DEFAULT ROLE ALL;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' WITH GRANT OPTION;
CREATE USER IF NOT EXISTS 'root'@'::1' IDENTIFIED WITH mysql_native_password BY 'password' PASSWORD EXPIRE NEVER;
ALTER USER IF EXISTS 'root'@'::1' DEFAULT ROLE ALL;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'::1' WITH GRANT OPTION;

- 19-b - Add a MySQL (or MariaDB ) user via the console:
# Before MySQL 8
# Usage privileges for `username`@`127.0.0.1`
GRANT USAGE ON *.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'plaintext password';
# Usage privileges for `username`@`localhost`
GRANT USAGE ON *.* TO 'username'@'localhost' IDENTIFIED BY 'plaintext password';
# Usage privileges for `username`@`::1`
GRANT USAGE ON *.* TO 'username'@'::1' IDENTIFIED BY 'plaintext password';
# Eventual privileges on a database
GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'127.0.0.1';
GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'::1';

# MySQL 8
# Usage privileges for `username`
CREATE USER 'username'@'localhost' IDENTIFIED WITH 'mysql_native_password' BY 'plaintext password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;
GRANT USAGE ON *.* TO 'username'@'localhost';
CREATE USER 'username'@'127.0.0.1' IDENTIFIED WITH 'mysql_native_password' BY 'plaintext password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;
GRANT USAGE ON *.* TO 'username'@'127.0.0.1';
CREATE USER 'username'@'::1' IDENTIFIED WITH 'mysql_native_password' BY 'plaintext password' REQUIRE NONE PASSWORD EXPIRE DEFAULT ACCOUNT UNLOCK;
GRANT USAGE ON *.* TO 'username'@'::1';
# Eventual privileges on a database
GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'127.0.0.1';
GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'localhost';
GRANT SELECT, INSERT, UPDATE, DELETE ON `mabase`.* TO 'username'@'::1';

- 20 - Systematic error "Tray Menu Aestan has encountered a problem and needs to close" when launching Wampserver
Or sometimes white pages (no loaded page) to localhost and/or PhpMyAdmin
It may be that if you were not "up to date" with the redistributable packages VC9, VC10 and VC11 before installing WampServer, it has not been properly installed and that even this update does not resolve your problem. We must therefore uninstall Wampserver and verify that both services wampmysqld and wampapache (wampmysqld64 and wampmyapache64 for Wampserver 64 bit) no longer exist - if necessary remove them, see Note 1.
Restart the machine and install Wampserver.
- 20-b - Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
And you will find all the packages on [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.

- 21 - MYSQL worked yesterday, but today I get an Orange wampmanager icon and MYSQL does not start.
- This applies particularly if you are using INNODB databases rather than MYISAM.
- Check the MySQL log, in "/wamp/logs/" If you see messages in the log saying that MySQL has tried to recover a database or a database table and failed, for whatever reason, then it is likely you have a corrupted database and MYSQL cannot start because it failed to recover the database.

- The simplest solution is to just Restore your last backup. Assuming you have a backup, which of course you do, because you are not stupid!
- If you have made the mistake of not having a backup, you should check the messages in the MYSQL Log as they suggest possible recovery mechanisms, alternatively, read the InnoDB Backup and Recovery

- To reduce the likelyhood of this happening, please make sure that you close down WAMPServer by either using the "Exit" on the wampmanager Menu
- - right click wampmanager -> Exit
- Or stop the MYSQL Service using
- - left click wampmanager -> Stop All services
BEFORE you REBOOT or CLOSE WINDOWS

21-a Why do I need to close Wampserver BEFORE shutting down Windows?
The "normal" closure of Wampserver performs the following actions:
- Stop the Apache service
- Stop the MySQL service
- Stop the mariaDB service

What happens when services are stopped "normally"?
- For Apache:
- Closing the Apache server
- Close all Apache processes
- Close the "child" server of Apache

- For MySQL or MariaDB
-- Purging the queue.
-- Dumping buffer pool(s)
-- Removed temporary tablespace data file
-- Close MySQL server

When Windows is shut down without having previously closed Wampserver, in certain cases, the services are not stopped normally, but the tasks httpd.exe and mysqld.exe are "killed" (TASKKILL).
So, queues and buffers are not run or dumped and this can corrupt databases, which can give symptoms like:
"It worked well yesterday, but it does not work today! "

22 - New version Tray Menu Manager (wampmanager.exe)
Tray Menu Manager updates are performed using the installer available at https://wampserver.aviatechno.net
-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
(Note 1) To remove a service:
Start, Run, Type "SC DELETE <service name>"
Or open a command window As an administrator and type the command above in this window. It is imperative that the commands of deletion of services are performed as Administrator , otherwise the deletions will not occur.
---------------------------------------------------------------
(Note 2) To Edit the hosts file and rights, not only must be in as an administrator, but in addition, you must verify that such administrator is owner of C:\Windows\System32\drivers\etc\hosts.
I know it sounds silly, but the administrator is not necessarily the owner of the file.
(In principle, this file owner is "System"winking smiley
1) To change the permissions of a folder or file, you must:
- Be awarded the "total control" over this folder or file
- Or be the owner (or be a member of the group that owns it), allowing THEN to assign full control of this folder or file.
2) To be the owner of a folder or file, you must:
- Or by the creator
- Or belong to the Administrators group, allowing the change of the owner, therefore, to declare as the owner.
So Explorer, right-click on "C:\Windows\System32\drivers\etc\hosts", Security then Properties, Advanced, Owner.
If you are not the current owner: Edit and select the desired owner then Apply and OK twice. Once the ownership change applied, it must leave (Imperative) the properties window for this to be updated.
Back to file properties "C:\Windows\System32\drivers\etc\hosts" Security tab, select the new owner and verify that Full Control applies, otherwise Modify to choose the new owner and validate Full Control.
It is only from there that you can change permissions on the file and remove the read-only.

In addition, under 64-bit Windows, if you use a text editor or 32 bit software to open the hosts file, it may be that you are faced with a file open dialog, that will in windows/system32/drivers/ not show you sub folder etc, and therefore no hosts files. This is due to the fact that with a 32-bit software on Windows 64 bit, when you choose the folder system32 you are redirected transparently on the SysWOW64 folder while viewing the system32 folder. To choose the "right" system32 folder, you need to type (or select if visible) Sysnative instead of sytem32.
---------------------------------------------------------------
(Note 3) - Text editor ======
*Important Prerequisites About the text editor being used: To edit the files, you must use a text editor, but not just any one. Some text editors, such as Notepad (notepad.exe) in Windows, are not able to correctly view files with Unix line breaks*, others recode surreptitiously the line of type Unix in type Windows/DOS, others still change the used character sets or add headers ; However, it is imperative that the end-of-line types or the character sets of the Wampserver files are not altered, otherwise it will generate impossibilities and errors when it is used. That's why I strongly recommend to use a free, powerful text editor like Notepad++ that you can find at Notepad++ (If you use a text editor like UtraEdit, it will not be a problem).
* The characters indicating the end of lines are of three types:
- Windows/DOS : CR - LF (Carriage Return - Line Feed) Two bytes 0x0D and 0x0A
- Unix : LF (Line Feed) One byte 0x0A
- Mac : CR (Carriage Return) One byte : 0x0D
---------------------------------------------------------------
(Note 4) - Command windows ======
Note: Under Windows 10 - Command window - To do it in a simple and durable way.
Control Panel, Programs and Features, Enable or Disable Windows Features
(The following option can be found in the Device Lock submenu)
Check : Built-in shell launcher
-- OK
Close Control Panel
Now in the Start menu, you should see a Command Prompt item
Right-click Command Prompt and choose Run as Administrator
In command window should launch, with in the title bar :
[Administrator: Command prompt]
For all commands that must be launched via a Command Window, it is imperative to have Administrator in the title bar.
-- 4.1 Command window via desktop shortcut
Right-click on the desktop then New -> Shortcut
Enter the location of the element -> put "cmd.exe" (Without quotes)
Next Button
Enter a name for this shortcut -> put "Command window" (Without quotes)
Finish button
Right-click on this new shortcut -> Properties
Shortcut tab, Advanced button
Check Run as administrator
OK, Apply, OK
Now all command windows opened by this shortcut will be opened "as administrator".

---------------------------------------------------------------------------------------------
(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 37 time(s). Last edit at 06/23/2024 02:06PM by Otomatic.

Options: ReplyQuote


Sorry, you can't reply to this topic. It has been closed.