Apache shutdown unexpectedly, MySQL works.

[Foxsayy]

I'm new to XAMPP, and I am trying to use Rukovoditel on a local PC, but I keep getting errors with Apache. XAMPP runs MySQL, but Apache keeps crashing with: Error: Apache shutdown unexpectedly. This may be due to a blocked port, missing dependencies ...etcetera.

Oddly, vanilla XAMPP runs MySQL and Apache just fine (as far as I can tell); the version that comes with Rukovoditel is the only one having issues. Any ideas on what might be the issue here?

The software in question: https://docs.rukovoditel.net/index.php?p=5/#Installation

Error log: (Also shown here: https://apaste.info/p4HC)

Code: Select all

2023-04-29 13:35:04 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 15684
2023-04-29 13:35:04 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-04-29 13:35:04 0 [Note] InnoDB: Uses event mutexes
2023-04-29 13:35:04 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-04-29 13:35:04 0 [Note] InnoDB: Number of pools: 1
2023-04-29 13:35:04 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-04-29 13:35:04 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-04-29 13:35:04 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-29 13:35:04 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300288
2023-04-29 13:35:04 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-04-29 13:35:04 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-04-29 13:35:04 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-29 13:35:04 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-29 13:35:04 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-04-29 13:35:04 0 [Note] InnoDB: Waiting for purge to start
2023-04-29 13:35:04 0 [Note] InnoDB: 10.4.28 started; log sequence number 300297; transaction id 170
2023-04-29 13:35:04 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-04-29 13:35:04 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-29 13:35:04 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2023-04-29 13:37:21 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-04-29 13:37:21 0 [Note] InnoDB: Uses event mutexes
2023-04-29 13:37:21 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-04-29 13:37:21 0 [Note] InnoDB: Number of pools: 1
2023-04-29 13:37:21 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-04-29 13:37:21 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-04-29 13:37:21 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-29 13:37:21 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300306
2023-04-29 13:37:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-04-29 13:37:22 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-04-29 13:37:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-29 13:37:22 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-29 13:37:22 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-04-29 13:37:22 0 [Note] InnoDB: Waiting for purge to start
2023-04-29 13:37:22 0 [Note] InnoDB: 10.4.17 started; log sequence number 300315; transaction id 170
2023-04-29 13:37:22 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-04-29 13:37:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-29 13:37:22 0 [Note] Server socket created on IP: '::'.
2023-04-29 13:37:22 0 [Note] InnoDB: Buffer pool(s) load completed at 230429 13:37:22
2023-04-29 13:37:22 0 [Note] Reading of all Master_info entries succeeded
2023-04-29 13:37:22 0 [Note] Added new Master_info '' to hash table
2023-04-29 13:37:22 0 [Note] mysql\bin\mysqld.exe: ready for connections.
Version: '10.4.17-MariaDB'  socket: ''  port: 3306  mariadb.org binary distribution
InnoDB: using atomic writes.
2023-04-29 14:07:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-04-29 14:07:17 0 [Note] InnoDB: Uses event mutexes
2023-04-29 14:07:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-04-29 14:07:17 0 [Note] InnoDB: Number of pools: 1
2023-04-29 14:07:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-04-29 14:07:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-04-29 14:07:17 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-29 14:07:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300324
2023-04-29 14:07:17 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-04-29 14:07:17 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-04-29 14:07:17 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-29 14:07:17 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-29 14:07:17 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-04-29 14:07:17 0 [Note] InnoDB: Waiting for purge to start
2023-04-29 14:07:17 0 [Note] InnoDB: 10.4.17 started; log sequence number 300333; transaction id 170
2023-04-29 14:07:17 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-04-29 14:07:17 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-29 14:07:17 0 [Note] InnoDB: Buffer pool(s) load completed at 230429 14:07:17
2023-04-29 14:07:17 0 [Note] Server socket created on IP: '::'.
2023-04-29 14:17:03 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 5452
2023-04-29 14:17:03 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-04-29 14:17:03 0 [Note] InnoDB: Uses event mutexes
2023-04-29 14:17:03 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-04-29 14:17:03 0 [Note] InnoDB: Number of pools: 1
2023-04-29 14:17:03 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-04-29 14:17:03 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-04-29 14:17:03 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-29 14:17:03 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=300342
2023-04-29 14:17:03 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-04-29 14:17:03 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2023-04-29 14:17:03 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-29 14:17:03 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-29 14:17:03 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-04-29 14:17:03 0 [Note] InnoDB: Waiting for purge to start
2023-04-29 14:17:03 0 [Note] InnoDB: 10.4.28 started; log sequence number 300351; transaction id 170
2023-04-29 14:17:03 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-04-29 14:17:03 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-29 14:17:03 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2023-04-29 14:18:00 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2023-04-29 14:18:00 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2023-04-29 14:18:00 0 [ERROR] Plugin 'InnoDB' init function returned error.
2023-04-29 14:18:00 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2023-04-29 14:18:00 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-29 14:18:00 0 [ERROR] Unknown/unsupported storage engine: InnoDB
2023-04-29 14:18:00 0 [ERROR] Aborting


[Altrea]

What i don't understand: You said Apache has problems to start but you added the MariaDB error log instead.

[Nobbie]

Oddly, vanilla XAMPP runs just fine (as far as I can tell), the version that comes with Rukovoditel is the only one having issues.

So why do you ask in a Xampp Forum, when Xampp runs flawlessly? You should ask in a Rukovoditel Forum instead, we cannot support Rukovoditel here.

P.S.: I succeeded to run Rukovoditel to run on a new Xampp installation. If you already have Xampp installed, do NOT(!) install the full Rukovoditel Package instead. Follow these steps instead:

a) open the ZIP File from Rukoviditel. Proceed to xampp/htdocs in the ZIP file. Then copy&paste the whole folder "ruko" to your existing Xampp installation, i.e. copy to c:/xampp/htdocs, which results in c:/xampp/htdocs/ruko
b) Rename the folder c:/xampp/mysql/data to c:/xampp/mysql/data.bak
c) Proceed to xampp/mysql in the ZIP file. Then copy&paste the whole folder "data" to c:/xampp/mysql, which results in c:/xampp/mysql/data. In step b) you backuped the existing data folder, so you dont destroy your Xampp installation and can undo the changes whenever you want.

Thats all. Now start your Xampp Installation normally, Enter http://localhost/ruko into your browser. Enter "admin" and "admin" for login into ruko (a login opens in your browser).
Do NOT start Xampp from Rukovoditel instead. Do NOT start MySQL/MariaDB or Apache from Rukovoditel.

As you replaced the data folder, all your "normal" data from MariaDB is not accessible in that setup. If you want to return to your "normal" Xampp, start PhpMyAdmin http://localhost/phpmyadmin and make a backup from the 2 databases rukovoditel_en and rukovoditel_ru. Store these into *.sql files.
Then stop Xampp. Rename c:/xampp/mysql/data to c:/xampp/mysql/data.ruk and rename c:/xampp/mysql/data.bak to c:/xampp/mysql/data.
Then start Xampp (Apache/MariaDB).
Then again open PhpMyAdmin, create databases rukovoditel_en and rukovoditel_ru and finally import the corresponding *.sql which you created above.
Finally proceed to http://localhost/ruko, it *should* show up Rukovoditel!