Search found 1555 matches: 64*bits

Searched query: +64*bits

Return to advanced search

MySQL Portion of my XAMPP Install Stopped Working

This has happened to both my old install of XAMPP and to the new XAMPP install that I just replaced the old install with. The old install has worked just fine for a long time and now it has failed. The new install worked for a day or two and then all of a sudden it failed with the same error notification that came up when the old install failed.
Here is the MySQL failure notice that comes up each time there is a failure:

5:29:45 PM [mysql] Error: MySQL shutdown unexpectedly.
5:29:45 PM [mysql] This may be due to a blocked port, missing dependencies,
5:29:45 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:29:45 PM [mysql] Press the Logs button to view error logs and check
5:29:45 PM [mysql] the Windows Event Viewer for more clues
5:29:45 PM [mysql] If you need more help, copy and post this
5:29:45 PM [mysql] entire log window on the forums

The failures seem to happen when I have XAMPP open and running. It appears that I may or may not be using the program to work on locally hosted websites when the failure occurs. It may be that I could actually be engaged with another program on my computer at the time that the MySQL failure happens.
I am wondering if a “new” program on my computer is providing some sort of interference that keeps MySQL from functioning properly. If that is the case, can I just change the port numbers for MySQL and potentially avoid any new port issues that could be caused by the install of any “new” programs on my computer? If so, is the 3306 port the one I should change, or are there others? Where would I look to make sure the proper changes are made where they should be made?
Any information that can help me solve this problem is appreciated. I am getting to the point where I am afraid to even run XAMPP and work on websites locally.

Thanks,
Thomas Chapo Sr.
tchaposr@gmail.com

See below for various log files and information that I have found after the failures.

XAMPP Control Panel v3.2.4 Log Screen
9:38:25 AM [main] Initializing Control Panel
9:38:25 AM [main] Windows Version: Enterprise 64-bit
9:38:25 AM [main] XAMPP Version: 8.0.0
9:38:25 AM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
9:38:25 AM [main] Running with Administrator rights - good!
9:38:25 AM [main] XAMPP Installation Directory: "c:\xampp\"
9:38:25 AM [main] Checking for prerequisites
9:38:26 AM [main] All prerequisites found
9:38:26 AM [main] Initializing Modules
9:38:26 AM [Tomcat] Problem detected: Tomcat Not Found!
9:38:26 AM [Tomcat] Disabling Tomcat buttons
9:38:26 AM [Tomcat] Run this program from your XAMPP root directory!
9:38:26 AM [main] Starting Check-Timer
9:38:26 AM [main] Control Panel Ready
9:38:31 AM [Apache] Attempting to start Apache app...
9:38:31 AM [Apache] Status change detected: running
9:38:32 AM [mysql] Attempting to start MySQL app...
9:38:32 AM [mysql] Status change detected: running
9:38:33 AM [filezilla] Attempting to start FileZilla app...
9:38:34 AM [filezilla] Status change detected: running
9:38:34 AM [mercury] Attempting to start Mercury app...
9:38:35 AM [mercury] Status change detected: running
5:29:19 PM [mercury] Attempting to stop Mercury (PID: 15576)
5:29:20 PM [mercury] Status change detected: stopped
5:29:21 PM [filezilla] Attempting to stop FileZilla app...
5:29:21 PM [filezilla] Status change detected: stopped
5:29:24 PM [Apache] Attempting to stop Apache (PID: 14652)
5:29:24 PM [Apache] Attempting to stop Apache (PID: 14500)
5:29:24 PM [Apache] Status change detected: stopped
5:29:26 PM [mysql] Attempting to stop MySQL app...
5:29:26 PM [mysql] Status change detected: stopped
5:29:33 PM [mysql] Attempting to start MySQL app...
5:29:33 PM [mysql] Status change detected: running
5:29:35 PM [mysql] Status change detected: stopped
5:29:35 PM [mysql] Error: MySQL shutdown unexpectedly.
5:29:35 PM [mysql] This may be due to a blocked port, missing dependencies,
5:29:35 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:29:35 PM [mysql] Press the Logs button to view error logs and check
5:29:35 PM [mysql] the Windows Event Viewer for more clues
5:29:35 PM [mysql] If you need more help, copy and post this
5:29:35 PM [mysql] entire log window on the forums
5:29:39 PM [Apache] Attempting to start Apache app...
5:29:39 PM [Apache] Status change detected: running
5:29:43 PM [mysql] Attempting to start MySQL app...
5:29:43 PM [mysql] Status change detected: running
5:29:45 PM [mysql] Status change detected: stopped
5:29:45 PM [mysql] Error: MySQL shutdown unexpectedly.
5:29:45 PM [mysql] This may be due to a blocked port, missing dependencies,
5:29:45 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:29:45 PM [mysql] Press the Logs button to view error logs and check
5:29:45 PM [mysql] the Windows Event Viewer for more clues
5:29:45 PM [mysql] If you need more help, copy and post this
5:29:45 PM [mysql] entire log window on the forums
5:29:47 PM [filezilla] Attempting to start FileZilla app...
5:29:47 PM [filezilla] Status change detected: running
5:29:50 PM [mercury] Attempting to start Mercury app...
5:29:51 PM [mercury] Status change detected: running
5:30:31 PM [Apache] Attempting to stop Apache (PID: 15544)
5:30:31 PM [Apache] Attempting to stop Apache (PID: 6452)
5:30:31 PM [Apache] Status change detected: stopped
5:30:35 PM [filezilla] Attempting to stop FileZilla app...
5:30:35 PM [filezilla] Status change detected: stopped
5:30:37 PM [mercury] Attempting to stop Mercury (PID: 14484)
5:30:37 PM [mercury] Status change detected: stopped
5:30:47 PM [Apache] Attempting to start Apache app...
5:30:48 PM [Apache] Status change detected: running
5:30:57 PM [mysql] Attempting to start MySQL app...
5:30:57 PM [mysql] Status change detected: running
5:30:59 PM [mysql] Status change detected: stopped
5:30:59 PM [mysql] Error: MySQL shutdown unexpectedly.
5:30:59 PM [mysql] This may be due to a blocked port, missing dependencies,
5:30:59 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:30:59 PM [mysql] Press the Logs button to view error logs and check
5:30:59 PM [mysql] the Windows Event Viewer for more clues
5:30:59 PM [mysql] If you need more help, copy and post this
5:30:59 PM [mysql] entire log window on the forums
5:31:03 PM [mysql] Attempting to start MySQL app...
5:31:04 PM [mysql] Status change detected: running
5:31:05 PM [mysql] Status change detected: stopped
5:31:05 PM [mysql] Error: MySQL shutdown unexpectedly.
5:31:05 PM [mysql] This may be due to a blocked port, missing dependencies,
5:31:05 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:31:05 PM [mysql] Press the Logs button to view error logs and check
5:31:05 PM [mysql] the Windows Event Viewer for more clues
5:31:05 PM [mysql] If you need more help, copy and post this
5:31:05 PM [mysql] entire log window on the forums
5:31:07 PM [filezilla] Attempting to start FileZilla app...
5:31:08 PM [filezilla] Status change detected: running
5:31:09 PM [mercury] Attempting to start Mercury app...
5:31:09 PM [mercury] Status change detected: running
5:34:12 PM [mysql] Status change detected: running
5:34:14 PM [mysql] Status change detected: stopped
5:34:14 PM [mysql] Error: MySQL shutdown unexpectedly.
5:34:14 PM [mysql] This may be due to a blocked port, missing dependencies,
5:34:14 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:34:14 PM [mysql] Press the Logs button to view error logs and check
5:34:14 PM [mysql] the Windows Event Viewer for more clues
5:34:14 PM [mysql] If you need more help, copy and post this
5:34:14 PM [mysql] entire log window on the forums


XAMPP Control Panel v3.2.4 Log Screen
5:34:04 PM [main] Initializing Control Panel
5:34:04 PM [main] Windows Version: Enterprise 64-bit
5:34:04 PM [main] XAMPP Version: 8.0.0
5:34:04 PM [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
5:34:04 PM [main] Running with Administrator rights - good!
5:34:04 PM [main] XAMPP Installation Directory: "c:\xampp\"
5:34:04 PM [main] Checking for prerequisites
5:34:05 PM [main] All prerequisites found
5:34:05 PM [main] Initializing Modules
5:34:05 PM [Apache] XAMPP Apache is already running on port 80
5:34:05 PM [Apache] XAMPP Apache is already running on port 4443
5:34:05 PM [filezilla] XAMPP FileZilla is already running on port 21
5:34:05 PM [filezilla] XAMPP FileZilla is already running on port 14147
5:34:05 PM [mercury] XAMPP Mercury is already running on port 25
5:34:05 PM [mercury] XAMPP Mercury is already running on port 79
5:34:05 PM [mercury] XAMPP Mercury is already running on port 105
5:34:05 PM [mercury] XAMPP Mercury is already running on port 106
5:34:05 PM [mercury] XAMPP Mercury is already running on port 110
5:34:05 PM [mercury] XAMPP Mercury is already running on port 143
5:34:05 PM [mercury] XAMPP Mercury is already running on port 2224
5:34:05 PM [Tomcat] Problem detected: Tomcat Not Found!
5:34:05 PM [Tomcat] Disabling Tomcat buttons
5:34:05 PM [Tomcat] Run this program from your XAMPP root directory!
5:34:05 PM [main] Starting Check-Timer
5:34:05 PM [main] Control Panel Ready
5:34:12 PM [mysql] Attempting to start MySQL app...
5:34:12 PM [mysql] Status change detected: running
5:34:14 PM [mysql] Status change detected: stopped
5:34:14 PM [mysql] Error: MySQL shutdown unexpectedly.
5:34:14 PM [mysql] This may be due to a blocked port, missing dependencies,
5:34:14 PM [mysql] improper privileges, a crash, or a shutdown by another method.
5:34:14 PM [mysql] Press the Logs button to view error logs and check
5:34:14 PM [mysql] the Windows Event Viewer for more clues
5:34:14 PM [mysql] If you need more help, copy and post this
5:34:14 PM [mysql] entire log window on the forums


MYSQL Error Log
InnoDB: using atomic writes.
2020-12-29 18:33:48 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-29 18:33:48 0 [Note] InnoDB: Uses event mutexes
2020-12-29 18:33:48 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-29 18:33:48 0 [Note] InnoDB: Number of pools: 1
2020-12-29 18:33:48 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-29 18:33:48 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-29 18:33:49 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-29 18:33:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2020-12-29 18:33:49 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-29 18:33:49 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-29 18:33:49 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-29 18:33:49 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-29 18:33:49 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-29 18:33:49 0 [Note] InnoDB: Waiting for purge to start
2020-12-29 18:33:49 0 [Note] InnoDB: 10.4.17 started; log sequence number 300297; transaction id 170
2020-12-29 18:33:49 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-29 18:33:49 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-29 18:33:49 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-29 21:01:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-29 21:01:09 0 [Note] InnoDB: Uses event mutexes
2020-12-29 21:01:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-29 21:01:09 0 [Note] InnoDB: Number of pools: 1
2020-12-29 21:01:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-29 21:01:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-29 21:01:09 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-29 21:01:09 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300638
2020-12-29 21:01:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-29 21:01:09 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-29 21:01:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-29 21:01:09 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-29 21:01:09 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-29 21:01:09 0 [Note] InnoDB: Waiting for purge to start
2020-12-29 21:01:09 0 [Note] InnoDB: 10.4.17 started; log sequence number 300647; transaction id 193
2020-12-29 21:01:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-29 21:01:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-29 21:01:09 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-29 21:21:40 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-29 21:21:40 0 [Note] InnoDB: Uses event mutexes
2020-12-29 21:21:40 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-29 21:21:40 0 [Note] InnoDB: Number of pools: 1
2020-12-29 21:21:40 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-29 21:21:40 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-29 21:21:40 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-29 21:21:40 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300656
2020-12-29 21:21:41 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-29 21:21:41 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-29 21:21:41 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-29 21:21:41 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-29 21:21:41 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-29 21:21:41 0 [Note] InnoDB: 10.4.17 started; log sequence number 300665; transaction id 193
2020-12-29 21:21:41 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-29 21:21:41 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-29 21:21:41 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-29 21:27:55 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-29 21:27:55 0 [Note] InnoDB: Uses event mutexes
2020-12-29 21:27:55 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-29 21:27:55 0 [Note] InnoDB: Number of pools: 1
2020-12-29 21:27:55 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-29 21:27:55 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-29 21:27:55 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-29 21:27:55 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300674
2020-12-29 21:27:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-29 21:27:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-29 21:27:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-29 21:27:55 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-29 21:27:55 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-29 21:27:55 0 [Note] InnoDB: Waiting for purge to start
2020-12-29 21:27:56 0 [Note] InnoDB: 10.4.17 started; log sequence number 300683; transaction id 193
2020-12-29 21:27:56 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-29 21:27:56 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-29 21:27:56 0 [Note] InnoDB: Buffer pool(s) load completed at 201229 21:27:56
2020-12-29 21:27:56 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-30 18:39:02 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-30 18:39:02 0 [Note] InnoDB: Uses event mutexes
2020-12-30 18:39:02 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-30 18:39:02 0 [Note] InnoDB: Number of pools: 1
2020-12-30 18:39:02 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-30 18:39:02 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-30 18:39:02 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-30 18:39:02 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=43397605
2020-12-30 18:39:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-30 18:39:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-30 18:39:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-30 18:39:03 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-30 18:39:03 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-30 18:39:03 0 [Note] InnoDB: Waiting for purge to start
2020-12-30 18:39:03 0 [Note] InnoDB: 10.4.17 started; log sequence number 43397614; transaction id 102009
2020-12-30 18:39:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-30 18:39:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-30 18:39:03 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2020-12-31 23:40:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-12-31 23:40:38 0 [Note] InnoDB: Uses event mutexes
2020-12-31 23:40:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-12-31 23:40:38 0 [Note] InnoDB: Number of pools: 1
2020-12-31 23:40:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-12-31 23:40:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-12-31 23:40:38 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-31 23:40:38 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=51520921
2020-12-31 23:40:39 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-12-31 23:40:39 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-12-31 23:40:39 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-12-31 23:40:39 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-12-31 23:40:39 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-12-31 23:40:39 0 [Note] InnoDB: Waiting for purge to start
2020-12-31 23:40:39 0 [Note] InnoDB: 10.4.17 started; log sequence number 51520930; transaction id 106209
2020-12-31 23:40:39 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-12-31 23:40:39 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-12-31 23:40:39 0 [Note] InnoDB: Buffer pool(s) load completed at 201231 23:40:39
2020-12-31 23:40:39 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-02 16:33:50 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-02 16:33:50 0 [Note] InnoDB: Uses event mutexes
2021-01-02 16:33:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-02 16:33:50 0 [Note] InnoDB: Number of pools: 1
2021-01-02 16:33:50 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-02 16:33:50 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-02 16:33:50 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-02 16:33:50 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58712885
2021-01-02 16:33:51 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-02 16:33:51 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-02 16:33:51 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-02 16:33:51 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-02 16:33:51 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-02 16:33:51 0 [Note] InnoDB: Waiting for purge to start
2021-01-02 16:33:51 0 [Note] InnoDB: 10.4.17 started; log sequence number 58712894; transaction id 109321
2021-01-02 16:33:51 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-02 16:33:51 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-02 16:33:51 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-02 16:34:37 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-02 16:34:37 0 [Note] InnoDB: Uses event mutexes
2021-01-02 16:34:37 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-02 16:34:37 0 [Note] InnoDB: Number of pools: 1
2021-01-02 16:34:37 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-02 16:34:37 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-02 16:34:37 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-02 16:34:37 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58712903
2021-01-02 16:34:37 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-02 16:34:37 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-02 16:34:37 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-02 16:34:37 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-02 16:34:37 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-02 16:34:37 0 [Note] InnoDB: Waiting for purge to start
2021-01-02 16:34:38 0 [Note] InnoDB: 10.4.17 started; log sequence number 58712912; transaction id 109321
2021-01-02 16:34:38 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-02 16:34:38 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-02 16:34:38 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-02 16:36:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-02 16:36:21 0 [Note] InnoDB: Uses event mutexes
2021-01-02 16:36:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-02 16:36:21 0 [Note] InnoDB: Number of pools: 1
2021-01-02 16:36:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-02 16:36:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-02 16:36:21 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-02 16:36:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=58712921
2021-01-02 16:36:21 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-02 16:36:21 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-02 16:36:21 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-02 16:36:21 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-02 16:36:21 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-02 16:36:21 0 [Note] InnoDB: 10.4.17 started; log sequence number 58712930; transaction id 109321
2021-01-02 16:36:21 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-02 16:36:21 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-02 16:36:21 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-03 18:58:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-03 18:58:54 0 [Note] InnoDB: Uses event mutexes
2021-01-03 18:58:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-03 18:58:54 0 [Note] InnoDB: Number of pools: 1
2021-01-03 18:58:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-03 18:58:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-03 18:58:54 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-03 18:58:54 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=111311107
2021-01-03 18:58:55 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-03 18:58:55 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-03 18:58:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-03 18:58:55 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-03 18:58:55 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-03 18:58:55 0 [Note] InnoDB: Waiting for purge to start
2021-01-03 18:58:55 0 [Note] InnoDB: 10.4.17 started; log sequence number 111311116; transaction id 213973
2021-01-03 18:58:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-03 18:58:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-03 18:58:55 0 [Note] InnoDB: Buffer pool(s) load completed at 210103 18:58:55
2021-01-03 18:58:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-04 18:14:27 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-04 18:14:27 0 [Note] InnoDB: Uses event mutexes
2021-01-04 18:14:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-04 18:14:27 0 [Note] InnoDB: Number of pools: 1
2021-01-04 18:14:27 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-04 18:14:27 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-04 18:14:27 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-04 18:14:27 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=111369196
2021-01-04 18:14:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-04 18:14:28 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-04 18:14:28 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-04 18:14:28 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-04 18:14:28 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-04 18:14:28 0 [Note] InnoDB: Waiting for purge to start
2021-01-04 18:14:28 0 [Note] InnoDB: 10.4.17 started; log sequence number 111369205; transaction id 214058
2021-01-04 18:14:28 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-04 18:14:28 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-04 18:14:28 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-05 9:41:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-05 9:41:33 0 [Note] InnoDB: Uses event mutexes
2021-01-05 9:41:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-05 9:41:34 0 [Note] InnoDB: Number of pools: 1
2021-01-05 9:41:34 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-05 9:41:34 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-05 9:41:34 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-05 9:41:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=146666444
2021-01-05 9:41:34 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-05 9:41:34 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-05 9:41:34 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-05 9:41:34 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-05 9:41:34 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-05 9:41:34 0 [Note] InnoDB: Waiting for purge to start
2021-01-05 9:41:34 0 [Note] InnoDB: 10.4.17 started; log sequence number 146666453; transaction id 310233
2021-01-05 9:41:34 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-05 9:41:34 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-05 9:41:34 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-06 13:59:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-06 13:59:35 0 [Note] InnoDB: Uses event mutexes
2021-01-06 13:59:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-06 13:59:35 0 [Note] InnoDB: Number of pools: 1
2021-01-06 13:59:35 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-06 13:59:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-06 13:59:35 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-06 13:59:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=147914547
2021-01-06 13:59:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-06 13:59:36 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-06 13:59:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-06 13:59:36 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-06 13:59:36 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-06 13:59:36 0 [Note] InnoDB: Waiting for purge to start
2021-01-06 13:59:36 0 [Note] InnoDB: 10.4.17 started; log sequence number 147914556; transaction id 311218
2021-01-06 13:59:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-06 13:59:36 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-06 13:59:36 0 [Note] InnoDB: Buffer pool(s) load completed at 210106 13:59:36
2021-01-06 13:59:36 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 9:38:32 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 9:38:32 0 [Note] InnoDB: Uses event mutexes
2021-01-07 9:38:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 9:38:32 0 [Note] InnoDB: Number of pools: 1
2021-01-07 9:38:32 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 9:38:32 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 9:38:32 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 9:38:32 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=148502152
2021-01-07 9:38:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 9:38:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-07 9:38:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 9:38:33 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 9:38:33 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 9:38:33 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 9:38:33 0 [Note] InnoDB: 10.4.17 started; log sequence number 148502161; transaction id 311785
2021-01-07 9:38:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 9:38:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 9:38:33 0 [Note] InnoDB: Buffer pool(s) load completed at 210107 9:38:33
2021-01-07 9:38:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:29:33 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:29:33 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:29:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:29:33 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:29:33 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:29:33 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:29:33 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:29:33 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=150957375
2021-01-07 17:29:33 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:29:33 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2021-01-07 17:29:33 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:29:33 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:29:33 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:29:33 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 17:29:33 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957384; transaction id 313109
2021-01-07 17:29:33 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:29:33 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:29:33 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:29:43 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:29:43 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:29:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:29:43 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:29:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:29:43 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:29:43 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:29:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:29:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:29:43 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:29:43 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:29:43 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957393; transaction id 313109
2021-01-07 17:29:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:29:43 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:29:43 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:30:57 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:30:57 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:30:57 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:30:57 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:30:57 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:30:57 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:30:57 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:30:57 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:30:57 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:30:57 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:30:57 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:30:57 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 17:30:57 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957402; transaction id 313109
2021-01-07 17:30:57 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:30:57 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:30:57 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:31:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:31:03 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:31:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:31:03 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:31:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:31:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:31:03 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:31:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:31:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:31:04 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:31:04 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:31:04 0 [Note] InnoDB: Waiting for purge to start
2021-01-07 17:31:04 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957411; transaction id 313109
2021-01-07 17:31:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:31:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:31:04 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2021-01-07 17:34:12 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2021-01-07 17:34:12 0 [Note] InnoDB: Uses event mutexes
2021-01-07 17:34:12 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2021-01-07 17:34:12 0 [Note] InnoDB: Number of pools: 1
2021-01-07 17:34:12 0 [Note] InnoDB: Using SSE2 crc32 instructions
2021-01-07 17:34:12 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2021-01-07 17:34:12 0 [Note] InnoDB: Completed initialization of buffer pool
2021-01-07 17:34:12 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2021-01-07 17:34:12 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2021-01-07 17:34:12 0 [Note] InnoDB: Setting file '\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2021-01-07 17:34:12 0 [Note] InnoDB: File '\xampp\mysql\data\ibtmp1' size is now 12 MB.
2021-01-07 17:34:12 0 [Note] InnoDB: 10.4.17 started; log sequence number 150957420; transaction id 313109
2021-01-07 17:34:12 0 [Note] Plugin 'FEEDBACK' is disabled.
2021-01-07 17:34:12 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2021-01-07 17:34:12 0 [Note] Server socket created on IP: '::'.





Welcome to phpMyAdmin

Error
MySQL said:
Cannot connect: invalid settings.
mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
Connection for controluser as defined in your configuration failed.
mysqli::real_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.
Retry to connect
by ThomasChapoSr
10. January 2021 00:41
 
Forum: MariaDB - MySQL
Topic: MySQL Portion of my XAMPP Install Stopped Working
Replies: 0
Views: 102

No access to virtual host from LAN - ERR_CONNECTION_REFUSED

Hello,

I am working on issue with XAMPP server configuration. I would like the web server in my LAN to host some develoment versions of my web pages. But the development itself and the checks I would like to do on my PC workstation.
So, I spend quite few hours to set up the server with some settings but without any results :-(.

This is the configuration:

The development server on Windows 10 Pro 64bit version 20H2.
The XAMPP for Windows 7.4.13
The static IP of above server in local LAN is: 192.168.0.7

and another PC workstation with Windows 10 Pro, the dynamic IP is: 192.168.0.105.

I configured virtual host with this settings:

The folder for the web page in htdocs is rok1920.pl, so the configuration of the virtual host looks like that:

Code: Select all
<VirtualHost *:80>
       DocumentRoot "C:/tools/xampp/htdocs/"
       ServerName localhost
</VirtualHost>
<VirtualHost *:80>
       DocumentRoot "C:/tools/xampp/htdocs/rok1920.pl/"
       ServerName rok1920.localhost
       ServerAlias rok1920.localhost
       <Directory "C:/tools/xampp/htdocs/rok1920.pl">
         DirectoryIndex index.php
         AllowOverride All
         Order allow,deny
         Allow from all     
       </Directory>
</VirtualHost>


I've changed everywhere in other xampp configuration files the statement to "Allow from all" or "Require all granted".
The firewall on server is set up to let in any traffic to httpd.exe and to mysql server.
The web server is set up to listen on port 80. The XAMPP Control Panel shows that Apache is working on ports 80 and 443.
The netstat shows that the only software using port 80 is Apache.
I set up the hosts file on the server with this settings:

Code: Select all
127.0.0.1       localhost
::1             localhost
127.0.0.1      rok1920.localhost


I set up the hosts file on the PC workstation with this:
Code: Select all
#
192.168.0.7      rok1920.localhost


Now, the situation looks that from the browser on server I can call the address: rok1920.localhost and I can get the web page - that is the start page of fresh wordpress installation. So, the virtual host is up and running I belive.
But, doing the same from the PC workstation, using address: rok1920.localhost, no matter the web browser I use (Edge, Chrome, Firefox), I can only get the screen with information that the web server refused the connection and the error is ERR_CONNECTION_REFUSED.
At the same PC workstation I can connect to the main XAMPP dashbord using address: 192.168.0.7 without any errors.
I can also ping 192.168.0.7 from the PC workstation as well as ping rok1920.localhost with positive result.
I can also get the response if I put the address: 192.168.0.7/rok1920.pl but the result is without any css formatting, only simple text with links.

In the access log file of the Apache I can not see any traffic from the PC workstation to the virtual host if I try to connect using rok1920.localhost address. The connection is visible if I put the 192.168.0.7/rok1920.pl address.
The error log has no errors at all.

I looked for solution in the Internet, but nothing helped. No any browser cache cleaning, flushdns or winsocket restart staff. The changes to configuration files also seems to be not very helpfull.
I belive that the issue is linked to tiny, stiupid mistake, but I can't see it.

Could somebody help me with my issue?

Best regards,
ZiemoT.
by ziemot
28. December 2020 20:21
 
Forum: XAMPP for Windows
Topic: No access to virtual host from LAN - ERR_CONNECTION_REFUSED
Replies: 3
Views: 308

Error: Apache shutdown unexpectedly.

After install xampp 8.0.0, everything is okay and Apache could open the browser.

But as to host Django with Xampp, the Apache shutdown unexpectedly.

I made several steps to improve it; however the error log do not reported anymore.
I changed the port to 82 and 4433. Apache still shutdown unexpectedly.

Python3.9
Window10 64bit
Apache2.4
Xampp xampp-windows-x64-8.0.0-2-VS16-installer

下午 07:09:57 [main] Initializing Control Panel
下午 07:09:57 [main] Windows Version: Enterprise 64-bit
下午 07:09:57 [main] XAMPP Version: 8.0.0
下午 07:09:57 [main] Control Panel Version: 3.2.4 [ Compiled: Jun 5th 2019 ]
下午 07:09:57 [main] Running with Administrator rights - good!
下午 07:09:57 [main] XAMPP Installation Directory: "c:\users\abigail.lin\xampp\"
下午 07:09:57 [main] Checking for prerequisites
下午 07:09:57 [main] All prerequisites found
下午 07:09:57 [main] Initializing Modules
下午 07:09:57 [mysql] Problem detected!
下午 07:09:57 [mysql] Port 3306 in use by ""C:\Program Files\MariaDB 10.5\bin\mysqld.exe" "--defaults-file=C:\Program Files\MariaDB 10.5\data\my.ini" "MariaDB""!
下午 07:09:57 [mysql] MySQL WILL NOT start without the configured ports free!
下午 07:09:57 [mysql] You need to uninstall/disable/reconfigure the blocking application
下午 07:09:57 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port
下午 07:09:57 [main] Starting Check-Timer
下午 07:09:57 [main] Control Panel Ready
下午 07:10:16 [Apache] Attempting to start Apache app...
下午 07:10:16 [Apache] Status change detected: running
下午 07:10:17 [Apache] Status change detected: stopped
下午 07:10:17 [Apache] Error: Apache shutdown unexpectedly.
下午 07:10:17 [Apache] This may be due to a blocked port, missing dependencies,
下午 07:10:17 [Apache] improper privileges, a crash, or a shutdown by another method.
下午 07:10:17 [Apache] Press the Logs button to view error logs and check
下午 07:10:17 [Apache] the Windows Event Viewer for more clues
下午 07:10:17 [Apache] If you need more help, copy and post this
下午 07:10:17 [Apache] entire log window on the forums

Error log

[Fri Dec 25 10:39:35.467589 2020] [ssl:warn] [pid 12188:tid 656] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Fri Dec 25 10:39:35.504587 2020] [ssl:warn] [pid 12188:tid 656] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Fri Dec 25 10:39:35.832223 2020] [mpm_winnt:notice] [pid 12188:tid 656] AH00455: Apache/2.4.46 (Win64) OpenSSL/1.1.1h PHP/8.0.0 configured -- resuming normal operations
[Fri Dec 25 10:39:35.832223 2020] [mpm_winnt:notice] [pid 12188:tid 656] AH00456: Apache Lounge VS16 Server built: Oct 2 2020 11:45:39
[Fri Dec 25 10:39:35.832223 2020] [core:notice] [pid 12188:tid 656] AH00094: Command line: 'c:\\users\\abigail.lin\\xampp\\apache\\bin\\httpd.exe -d C:/Users/abigail.lin/xampp/apache'
[Fri Dec 25 10:39:35.836255 2020] [mpm_winnt:notice] [pid 12188:tid 656] AH00418: Parent: Created child process 10800
[Fri Dec 25 10:39:36.126249 2020] [ssl:warn] [pid 10800:tid 652] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Fri Dec 25 10:39:36.158248 2020] [ssl:warn] [pid 10800:tid 652] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Fri Dec 25 10:39:36.177245 2020] [mpm_winnt:notice] [pid 10800:tid 652] AH00354: Child: Starting 150 worker threads.



apache_start.bat.script
Diese Eingabeforderung nicht waehrend des Running beenden
Bitte erst bei einem gewollten Shutdown schliessen
Please close this command only for Shutdown
Apache 2 is starting ...
httpd.exe: Syntax error on line 568 of C:/Users/abigail.lin/xampp/apache/conf/httpd.conf: Cannot load modules/mod_wsgi.so into server: \xa7\xe4\xa4\xa3\xa8\xec\xab\xfc\xa9w\xaa\xba\xbc\xd2\xb2\xd5\xa1C

Apache konnte nicht gestartet werden
Apache could not be started

httpd.exe could not open.
by Abigail
26. December 2020 14:41
 
Forum: XAMPP for Windows
Topic: Error: Apache shutdown unexpectedly.
Replies: 0
Views: 317

Re: osm: multiple nearby Location by coordinates - finding t

Hello dear Altrea,

many many thanks​ -for your reply - and the kind words.


... i found some ideas to do  the job - also like so: 

 
Code: Select all
[out:csv(::id,::type,::lon, ::lat, "name","addr:postcode","addr:city","addr:street","addr:housenumber","contact:website"," contact:email=*")][timeout:600];
rel[boundary=administrative][admin_level=6][name="München"] -> .city;
(nwr[amenity=hospital](around.city:2000);
nwr[amenity=school](around.city:2000);)/>;
out center;


see the output

 
Code: Select all
@id    @type    @lon    @lat    name    addr:postcode    addr:city    addr:street    addr:housenumber    contact:website     contact:email=*
60234799    node    11.5618175    48.1322485    Medizinische Klinik    80336    München    Ziemssenstraße    1        
60235532    node    11.5605247    48.1310014    "Mund-, Kiefer-, Gesichtschirurgie"    80337    München    Lindwurmstraße    2a        
60235905    node    11.5592053    48.1302821    Dr. von Haunersches Kinderspital    80337    München    Lindwurmstraße    4        
60237053    node    11.5581961    48.1316760    Poliklinik Zahnärztliche Prothetik    80336    München    Goethestraße    70        
60237068    node    11.5581921    48.1313295    Poliklinik Zahnerhaltung und Parodontologie    80336    München    Goethestraße    70        
60237323    node    11.5581778    48.1309824    Poliklinik Kieferorthopädie    80336    München    Goethestraße    70        
60347733    node    11.5919091    48.1313181    Münchner Volkshochschule                        
199521374    node    11.3744767    48.1874144    Bernhard-Rößner-Grundschule Gröbenzell                        
207230074    node    11.3616774    48.1785758    Grundschule am Gerner Platz    82178    Puchheim    Gerner Platz    2        
207231287    node    11.3614999    48.1791463    Mittelschule Puchheim    82178    Puchheim    Lagerstraße    26        
257005653    node    11.5685660    48.2073080    Balthasar-Neumann-Realschule                        
269510209    node    11.4219190    48.1179807    Wolfartklinik    82166    Gräfelfing    Waldstraße    7        
271226325    node    11.5619132    48.1409559    Medizinischer Bereitschaftsdienst            Prielmayerstraße    3        
274617211    node    11.6000672    48.1343476    Schule zur Lernförderung    81675    München    Kirchenstraße    13        
287819214    node    11.4237356    48.1353946    Förderschule und Heilpädagogische Tagesstätte    81249    München    Köferinger Straße    20        
295434645    node    11.6410472    48.1924715    VHS Unterföhring    85774    Unterföhring    Münchner Straße    72        
300673921    node    11.6390371    48.0907877    Volkshochschule München Perlach-Süd    81739    München    Max-Reinhardt-Weg    29        
312793352    node    11.5815046    48.1322045    Schulverbund München    80469    München    Kohlstraße    5        
332544444    node    11.5602074    48.1420984    Münchner Schmink und Kosmetikschule                        
332617267    node    11.5649428    48.1347820    Isar Medizin Zentrum    80331    München    Sonnenstraße    24        
338723406    node    11.4742575    48.2083018    Waldklassenzimmer                        
342309527    node    11.5689469    48.2065680    Grundschule an der Hugo-Wolf-Straße                        
358171049    node    11.3574259    48.1813010    Realschule Puchheim    82178    Puchheim    Bürgermeister-Ertl-Straße    9        
439254427    node    11.5644958    48.1287555    Klinik Thalkirchner Straße    80337    München    Thalkirchner Straße    48        
443898649    node    11.6623555    48.0769996    Volkshochschule                        
539112865    node    11.6693667    48.2184675    Grundschule an der Camerloherstraße    85737    Ismaning    Camerloherstraße    20        
618659788    node    11.5596871    48.1332364    Institut für Rechtsmedizin    80336    München    Nußbaumstraße    26        
619332417    node    11.6639514    48.0764239    Musikschule Neubiberg                        
656248222    node    11.5820112    48.1247064    Grundschule am Mariahilfplatz    81541    München    Mariahilfplatz    18  



 ... and so  forth and so forth..     


mani.  as allways i- love this great place here - a place for idea-sharing and knowlege exchange. it is a great place here.
this forum is so greta: i love it.

have a great day 

greetings :bigsmile:/>

​unleash
by unleash_it
26. December 2020 01:08
 
Forum: Allerlei
Topic: osm: multiple nearby Location by coordinates - finding them!
Replies: 2
Views: 72

Cannot install xampp-linux-x64-8.0.0-2-installer.run on Ubun

Cannot install xampp-linux-x64-8.0.0-2-installer.run on Ubuntu 20.04.1 LTS 64bit under VMware Workstation 15 Player

sudo chmod 755 xampp-linux-x64-8.0.0-2-installer.run
sudo sh xampp-linux-x64-8.0.0-2-installer.run
xampp-linux-x64-8.0.0-2-installer.run: 1: ELF: not found
xampp-linux-x64-8.0.0-2-installer.run: 5: Syntax error: "(" unexpected
by developersk
13. December 2020 17:12
 
Forum: XAMPP for Linux
Topic: Cannot install xampp-linux-x64-8.0.0-2-installer.run on Ubun
Replies: 0
Views: 232

Re: XAMPP - localhost

Hallo,
nach Installation auf Laufwerk c:\Programme\XAMPP läßt sich der Apache nicht starten. MySQL startet problemlos.
Beim Apache steht in der Datei error.log (Apache)

[Thu Dec 10 17:07:02.582362 2020] [ssl:warn] [pid 11340:tid 560] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Dec 10 17:07:02.645327 2020] [ssl:warn] [pid 11340:tid 560] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Dec 10 17:07:02.696297 2020] [mpm_winnt:notice] [pid 11340:tid 560] AH00455: Apache/2.4.46 (Win64) OpenSSL/1.1.1g PHP/7.2.34 configured -- resuming normal operations
[Thu Dec 10 17:07:02.696297 2020] [mpm_winnt:notice] [pid 11340:tid 560] AH00456: Apache Lounge VC15 Server built: Aug 4 2020 11:50:23
[Thu Dec 10 17:07:02.696297 2020] [core:notice] [pid 11340:tid 560] AH00094: Command line: 'C:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Thu Dec 10 17:07:02.701293 2020] [mpm_winnt:notice] [pid 11340:tid 560] AH00418: Parent: Created child process 7440
[Thu Dec 10 17:07:03.394742 2020] [ssl:warn] [pid 7440:tid 572] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Dec 10 17:07:03.439443 2020] [ssl:warn] [pid 7440:tid 572] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Thu Dec 10 17:07:03.489415 2020] [mpm_winnt:notice] [pid 7440:tid 572] AH00354: Child: Starting 150 worker threads.

Kann mir jemand sagen wo nun das Problem liegt?
Wäre über Info's sehr dankbar.
by rtb-biker
10. December 2020 17:20
 
Forum: XAMPP für Windows
Topic: XAMPP - localhost
Replies: 11
Views: 824

latest version does not work

Hi,
I was use Xampp control Panel v.3.2.1 which was php 5.6 but recently i download the latest version from xampp. When i install it show apache HTTP has stopped and last PHP CLI has stopped working. In this problem when i am click on close program. It automatically uninstall. In this problem how can i fix it. Please help some one.

My OS is : Win 7; 64Bit.

Regards
Kazi Riaz
Bangladesh
by kaziriaj
30. November 2020 21:58
 
Forum: XAMPP for Windows
Topic: latest version does not work
Replies: 0
Views: 303

Re: Needs Strong(er) Authentication When Using LDAP

Altrea wrote:Crossposting without referencing the communities: https://stackoverflow.com/questions/64972504/xampp-needs-stronger-authentication-when-using-ldap


Whoops. Sorry forgot about the link :P https://stackoverflow.com/questions/64972504/xampp-needs-stronger-authentication-when-using-ldap

Still there isn't much information on this issue.
by MurrayISO
30. November 2020 13:48
 
Forum: XAMPP for Windows
Topic: Needs Strong(er) Authentication When Using LDAP
Replies: 2
Views: 467

Problem to start MySql

InnoDB: using atomic writes.
2020-11-19 16:13:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-11-19 16:13:31 0 [Note] InnoDB: Uses event mutexes
2020-11-19 16:13:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-11-19 16:13:31 0 [Note] InnoDB: Number of pools: 1
2020-11-19 16:13:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-11-19 16:13:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-11-19 16:13:31 0 [Note] InnoDB: Completed initialization of buffer pool
2020-11-19 16:13:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-11-19 16:13:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-11-19 16:13:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-11-19 16:13:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-11-19 16:13:31 0 [Note] InnoDB: Waiting for purge to start
2020-11-19 16:13:31 0 [Note] InnoDB: 10.4.14 started; log sequence number 640953; transaction id 1068
2020-11-19 16:13:31 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-11-19 16:13:31 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-11-19 16:13:31 0 [Note] Server socket created on IP: '::'.
by AniqqKhaizii
19. November 2020 09:16
 
Forum: XAMPP for Windows
Topic: Problem to start MySql
Replies: 0
Views: 435

Re: PHP Anbindung MSSQL Server 7 und MSSQL Server 2014

Kein aktuelles Xampp, das wird seit geraumer Zeit nur für 64bit angeboten.
by Nobbie
12. November 2020 17:28
 
Forum: XAMPP für Windows
Topic: PHP Anbindung MSSQL Server 7 und MSSQL Server 2014
Replies: 3
Views: 998

Re: PHP Anbindung MSSQL Server 7 und MSSQL Server 2014

Nicht mit nur einer Xampp resp. PHP Installation. Das scheitert bereits daran, dass die alte Xampp Version 32bit war und die neue 64bit hat.

Andererseits kommuniziert PHP als Client wahrscheinlich via TCPIP mit der Datenbank, kann man denn überhaupt beide MSSQL Releases gleichzeitig laufen lassen? Mit MySQL beispielsweise würde das nicht gehen, da der Port 3306 nur für eine Anwendung zur Verfügung steht. Da müßte man einen anderen Port definieren für eine der beiden Datenbanken, das bedeutet aber auch, dass man im Connect einen anderen Port jeweils angeben muss. So könnte es theoretisch auch gehen, dass man auf beide Datenbanken zugreifen kann. Ich habe kein Windows und keine Microsoft Produkte, das kann ich leider nicht testen.
by Nobbie
12. November 2020 12:17
 
Forum: XAMPP für Windows
Topic: PHP Anbindung MSSQL Server 7 und MSSQL Server 2014
Replies: 3
Views: 998

Re: 64bit Version nicht installierbar

Hallo Sana,

Nein, es gibt seit Jahren keine 32 Bit Versionen von XAMPP für Windows mehr. Es gibt wohl auch keine Bestrebungen daran wieder etwas zu ändern.
Dein Problem ist aber weniger die Bit Architektur, sondern der ARM Prozessor des Surface Pro X. ARM Prozessoren werden von XAMPP leider nicht unterstützt.
by Altrea
19. October 2020 21:15
 
Forum: XAMPP für Windows
Topic: 64bit Version nicht installierbar
Replies: 1
Views: 796

64bit Version nicht installierbar

Hallo,
Ich würde gerne XAMPP für Windows installieren, jedoch hab ich das Problem, dass ich 64-bit Versionen mit meinem Surface Pro X nicht installieren kann. Gibt es eine 32bit Version, oder eine andere Möglichkeit dieses Problem zu beheben. Es ist sehr sehr dringend :)

LG Sana
by sana!
19. October 2020 18:58
 
Forum: XAMPP für Windows
Topic: 64bit Version nicht installierbar
Replies: 1
Views: 796

Re: Python can't connect to XAMPP

Nobbie wrote:You are absolutely right, freezing is bad, very bad. Freezing is not a controled behaviour, mostly its a severe addressing error or similar. Is there a problem with 64bit vs. 32bit (only a clue)? If i were you, i would go for a cheap Linux PC and run Xampp there. That does not cost much money, its stable, its Linux (i love Linux). A used PC from Ebay for lets say 50 bugs will do the job. You can keep your MacOS PC as a develoment environment, for testing purpose move your scripts and files to the Linux server and you are done.


My workaround was something like that. I run a Docker image with mysql. For some reason beyond my comprehension, the python code works on the docker container with mysql. But does not on XAMPP. Again, the same code works fine on Windows and Linux. I've tested the same code on two MacOS with same issue.

For future reference, to use Docker as I did, just create a file docker-compose.yml with the code:
Code: Select all
version: '3.3'
volumes:
  data:
services:
  db:
    image: mysql:5.6
    ports:
      - "3306:3306"
    volumes:
      - data:/var/lib/mysql
    environment:
      - MYSQL_ROOT_PASSWORD=password
      - MYSQL_DATABASE=automacao
  app:
    image: phpmyadmin/phpmyadmin:latest
    links:
      - db
    ports:
      - 80:80
    environment:
      - PMA_ARBITRARY=1


And run it by

Code: Select all
sudo docker-compose up app
by robertoneto123
05. October 2020 18:52
 
Forum: XAMPP for macOS
Topic: Python can't connect to XAMPP
Replies: 6
Views: 1128
Next

Return to advanced search