wamp
Posted by: mohdfayeem (157.43.47.---)
Date: December 21, 2019 03:23PM

1: Windows 10 (64 Bit)
2: Wampserver3.2.0 (64 Bit)
3: Apache 2.4.41
4: PHP 7.3.12
5: MySql 8.0.18
6: Orange Color
6a: - Wampserver trace report -
File created by Wampserver install
6b: - Wampserver trace report -
File created by Wampserver install
6b1: - Wampserver trace report -
File created by Wampserver install
InnoDB: using atomic writes.
2019-12-21 16:31:59 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-21 16:31:59 0 [Note] InnoDB: Uses event mutexes
2019-12-21 16:31:59 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-21 16:31:59 0 [Note] InnoDB: Number of pools: 1
2019-12-21 16:31:59 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-12-21 16:31:59 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-12-21 16:31:59 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-21 16:31:59 0 [Note] InnoDB: Resizing redo log from 2*50331648 to 2*67108864 bytes; LSN=139845
2019-12-21 16:31:59 0 [Note] InnoDB: Starting to delete and rewrite log files.
2019-12-21 16:31:59 0 [Note] InnoDB: Setting log file .\ib_logfile101 size to 67108864 bytes
2019-12-21 16:31:59 0 [Note] InnoDB: Setting log file .\ib_logfile1 size to 67108864 bytes
2019-12-21 16:31:59 0 [Note] InnoDB: Renaming log file .\ib_logfile101 to .\ib_logfile0
2019-12-21 16:31:59 0 [Note] InnoDB: New log files created, LSN=139845
2019-12-21 16:31:59 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-21 16:31:59 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-21 16:31:59 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-21 16:31:59 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2019-12-21 16:31:59 0 [Note] InnoDB: Waiting for purge to start
2019-12-21 16:32:00 0 [Note] InnoDB: 10.4.10 started; log sequence number 139845; transaction id 21
2019-12-21 16:32:00 0 [Note] InnoDB: Loading buffer pool(s) from c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool
2019-12-21 16:32:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-21 16:32:00 0 [Note] Server socket created on IP: '::'.
2019-12-21 16:32:00 0 [Note] InnoDB: Buffer pool(s) load completed at 191221 16:32:00
2019-12-21 16:32:00 0 [Note] Reading of all Master_info entries succeeded
2019-12-21 16:32:00 0 [Note] Added new Master_info '' to hash table
2019-12-21 16:32:00 0 [Note] wampmariadb64: ready for connections.
Version: '10.4.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2019-12-21 17:09:32 0 [Note] wampmariadb64 (initiated by: unknown): Normal shutdown
2019-12-21 17:09:32 0 [Note] Event Scheduler: Purging the queue. 0 events
2019-12-21 17:09:32 0 [Note] InnoDB: FTS optimize thread exiting.
2019-12-21 17:09:32 0 [Note] InnoDB: Starting shutdown...
2019-12-21 17:09:32 0 [Note] InnoDB: Dumping buffer pool(s) to c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool
2019-12-21 17:09:32 0 [Note] InnoDB: Buffer pool(s) dump completed at 191221 17:09:32
2019-12-21 17:09:33 0 [Note] InnoDB: Shutdown completed; log sequence number 140309; transaction id 22
2019-12-21 17:09:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2019-12-21 17:09:33 0 [Note] wampmariadb64: Shutdown complete

InnoDB: using atomic writes.
2019-12-21 19:18:30 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-12-21 19:18:30 0 [Note] InnoDB: Uses event mutexes
2019-12-21 19:18:30 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-12-21 19:18:30 0 [Note] InnoDB: Number of pools: 1
2019-12-21 19:18:30 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-12-21 19:18:30 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2019-12-21 19:18:30 0 [Note] InnoDB: Completed initialization of buffer pool
2019-12-21 19:18:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-12-21 19:18:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-12-21 19:18:33 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-12-21 19:18:33 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
2019-12-21 19:18:33 0 [Note] InnoDB: Waiting for purge to start
2019-12-21 19:18:33 0 [Note] InnoDB: Waiting for purge to start
2019-12-21 19:18:33 0 [Note] InnoDB: Waiting for purge to start
2019-12-21 19:18:34 0 [Note] InnoDB: Waiting for purge to start
2019-12-21 19:18:34 0 [Note] InnoDB: Waiting for purge to start
2019-12-21 19:18:34 0 [Note] InnoDB: Waiting for purge to start
2019-12-21 19:18:34 0 [Note] InnoDB: 10.4.10 started; log sequence number 140309; transaction id 21
2019-12-21 19:18:34 0 [Note] InnoDB: Loading buffer pool(s) from c:\wamp64\bin\mariadb\mariadb10.4.10\data\ib_buffer_pool
2019-12-21 19:18:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-12-21 19:18:34 0 [Note] InnoDB: Buffer pool(s) load completed at 191221 19:18:34
2019-12-21 19:18:35 0 [Note] Server socket created on IP: '::'.
2019-12-21 19:18:37 0 [Note] Reading of all Master_info entries succeeded
2019-12-21 19:18:37 0 [Note] Added new Master_info '' to hash table
2019-12-21 19:18:37 0 [Note] wampmariadb64: ready for connections.
Version: '10.4.10-MariaDB' socket: '' port: 3306 mariadb.org binary distribution



6c: - Wampserver trace report -
File created by Wampserver install
[21-Dec-2019 11:01:48 UTC] ; Unable to find Apache variables.

; There may be a syntax error in httpd.conf.
; To be checked by the tool integrated in Wampserver:
; Right-click -> Tools -> Check httpd.conf syntax.


[21-Dec-2019 11:01:53 UTC] Apache variable '${INSTALL_DIR}' is not defined.
May be there is syntax error in httpd.conf
Check it by right-click Wampmanager tray icon -> Tools -> Check httpd.conf syntax.
May be Apache service 'wampapache64' is not started.
Check it by right-click Wampmanager tray icon -> Tools -> Check state of services

[21-Dec-2019 11:01:53 UTC] Apache variable '${INSTALL_DIR}' is not defined.
May be there is syntax error in httpd.conf
Check it by right-click Wampmanager tray icon -> Tools -> Check httpd.conf syntax.
May be Apache service 'wampapache64' is not started.
Check it by right-click Wampmanager tray icon -> Tools -> Check state of services

[21-Dec-2019 13:48:21 UTC] Apache variable '${INSTALL_DIR}' is not defined.
May be there is syntax error in httpd.conf
Check it by right-click Wampmanager tray icon -> Tools -> Check httpd.conf syntax.
May be Apache service 'wampapache64' is not started.
Check it by right-click Wampmanager tray icon -> Tools -> Check state of services

[21-Dec-2019 13:48:21 UTC] Apache variable '${INSTALL_DIR}' is not defined.
May be there is syntax error in httpd.conf
Check it by right-click Wampmanager tray icon -> Tools -> Check httpd.conf syntax.
May be Apache service 'wampapache64' is not started.
Check it by right-click Wampmanager tray icon -> Tools -> Check state of services

[21-Dec-2019 13:49:06 UTC] Apache variable '${INSTALL_DIR}' is not defined.
May be there is syntax error in httpd.conf
Check it by right-click Wampmanager tray icon -> Tools -> Check httpd.conf syntax.
May be Apache service 'wampapache64' is not started.
Check it by right-click Wampmanager tray icon -> Tools -> Check state of services

[21-Dec-2019 13:49:06 UTC] Apache variable '${INSTALL_DIR}' is not defined.
May be there is syntax error in httpd.conf
Check it by right-click Wampmanager tray icon -> Tools -> Check httpd.conf syntax.
May be Apache service 'wampapache64' is not started.
Check it by right-click Wampmanager tray icon -> Tools -> Check state of services

6d: The description for Event ID 100 from source MySQL cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

7: #
127.0.0.1 localhost
::1 localhost

8a: No access localhost homepage
8b: •Make sure the web address [localhost] is correct
•Search for this site on Bing
•Refresh the page
More information More information
There was a temporary DNS error. Try refreshing the page.
Error Code: INET_E_RESOURCE_NOT_FOUND

9: No access to phpmyadmin and same error msg as 8b
10: httpd.exe - Application error
the application was unable to start correctly (0xc000007b). Click OK to close the application
11: No Antivirus and default windows Defender firewall
12: C:\wamp64
13: No VirtualHost

Options: ReplyQuote
Re: wamp
Posted by: Otomatic (Moderator)
Date: December 21, 2019 03:44PM

Hi,

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.

BEFORE installing Wampserver did you respect all the prerequisites?

- 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.

> the application was unable to start correctly (0xc000007b).

Error code 0xc00000007d is caused somehow by a misconfigured system file(s) in your operating system and/or by an uninstalled or incorrectly installed dll file.

There is a Windows command that allows you to check certain system files.
Open a "as administrator" command window (The word Administrator must appear in the title bar) and in this window type :
sfc /verifyonly
at the end of the verification operation, which may take "some time", any errors will be displayed or, if no errors: "The Windows resource protection program found no integrity violations."

If there are any errors displayed, to try to correct them, type:
sfc /scannow

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.0 32 bit - Apache 2.4.41 - PHP 7.4.4/7.3.16/..../5.6.40 - MySQL 5.7.29 - MariaDB 10.4.12
Wampserver 3.2.0 64 bit - Apache 2.4.41 - PHP 7.4.4/7.3.16/..../5.6.40 - MySQL 5.7.29/8.0.19 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: wamp
Posted by: mohdfayeem (157.43.47.---)
Date: December 21, 2019 04:36PM

All goods apache started,marinedb started but now only the mysql is not started showing the error msg

"mysqli_real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it. "

when i am trying to login into phpmyadmin

and mysql log file contains

- Wampserver trace report -
File created by Wampserver install
2019-12-21T15:28:29.058298Z 0 [System] [MY-010116] [Server] c:\wamp64\bin\mysql\mysql8.0.18\bin\mysqld.exe (mysqld 8.0.18) starting as process 7496
2019-12-21T15:28:29.792876Z 1 [ERROR] [MY-011011] [Server] Failed to find valid data directory.
2019-12-21T15:28:29.829730Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-12-21T15:28:29.846654Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-12-21T15:28:29.904785Z 0 [System] [MY-010910] [Server] c:\wamp64\bin\mysql\mysql8.0.18\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL.



Edited 2 time(s). Last edit at 12/21/2019 04:40PM by mohdfayeem.

Options: ReplyQuote
Re: wamp
Posted by: mohdfayeem (157.43.47.---)
Date: December 21, 2019 05:06PM

All goods
Allof the three services are now started
The wampserver icon is now green

Options: ReplyQuote
Re: wamp
Posted by: Otomatic (Moderator)
Date: December 21, 2019 06:29PM

Hi,

You don't have to keep two database managers, MariaDB and MySQL. You can choose only one.
See Right-click -> Help -> MariaDB - MySQL

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.0 32 bit - Apache 2.4.41 - PHP 7.4.4/7.3.16/..../5.6.40 - MySQL 5.7.29 - MariaDB 10.4.12
Wampserver 3.2.0 64 bit - Apache 2.4.41 - PHP 7.4.4/7.3.16/..../5.6.40 - MySQL 5.7.29/8.0.19 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: wamp
Posted by: mohdfayeem (47.9.191.---)
Date: December 22, 2019 06:37PM

I chose MySql as my default database but when I'm trying to connect it via the default username and password it show the error
" mysqli_real_connect(): (HY000/1045): Access denied for user 'root'@'localhost' (using password: NO) "

When I'm trying to login via wampserver -> MySQL -> MySQL Console with default login it flashes the command screen saying something like " Access denied... "


But MariaDB is working correctly even after making it default but MySQL DB is not login

I want to use MySQL DB as default but having problem

If there is no change in sql queries and access method allare same for MariaDB I can use it too as default



Edited 2 time(s). Last edit at 12/22/2019 06:45PM by mohdfayeem.

Options: ReplyQuote
Re: wamp
Posted by: Otomatic (Moderator)
Date: December 22, 2019 07:33PM

Hi,

Read the help file I gave you in previous message.

------------------------------------------------------------------------------------------------------------
Wampserver 3.2.0 32 bit - Apache 2.4.41 - PHP 7.4.4/7.3.16/..../5.6.40 - MySQL 5.7.29 - MariaDB 10.4.12
Wampserver 3.2.0 64 bit - Apache 2.4.41 - PHP 7.4.4/7.3.16/..../5.6.40 - MySQL 5.7.29/8.0.19 - MariaDB 10.4.12
PhPMyadmin 5.0.2 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote


Sorry, only registered users may post in this forum.