MediaWiki internal error

twanvandenbroek 2020-09-25 08:39:50 UTC #21

Yes, in the manager tool, the MySQLDatabase is emntioned with the status 'stopped'. I cannot start thies server, however.
After trying a restart I get the following error emssage:
"Starting MySQL Database...
Exit code: 1
Stdout:

Stderr:
Unknown error starting mysql"

There are a lot of entries in mysql.log.
On August 1th there are two entries en since the problems started then, here they are:
"2020-08-01T11:06:36.300541Z 0 [System] [MY-013105] [Server] D:\MIJNDO~1\BredaWiki\mysql\bin\mysqld.exe: Normal shutdown.
2020-08-01T11:06:37.728110Z 0 [System] [MY-010910] [Server] D:\MIJNDO~1\BredaWiki\mysql\bin\mysqld.exe: Shutdown complete (mysqld 8.0.18) MySQL Community Server - GPL."

After running the command it does not return to the command line, but when I look in the Manager Tool (after a reboot of my computer) the MySQL server is still not running nor can it be started

And I noticed that the IP adress changed again, for whatever reason... I updated LocalSettings.php accordingly

jota 2020-09-25 12:02:04 UTC #22

Hi @twanvandenbroek,

If the command doesn't finish, that means that the server is running properly. You can run the mysqld command in one terminal and try to access the database using a different terminal.

The problem is that the command doesn't modify the Window's service status and that's why it still appears as stopped in the Bitnami manager tool. Can you open the "Services" tool in Windows and ensure you have a service with the name that appears in the "installdir/properties.ini" file?

twanvandenbroek 2020-09-25 13:28:25 UTC #23

I'm running my wiki on a stand-alone computer, so no different terminal available...

What do you mean with 'services tool'?

I'm starting to feel that a complete new installation and rebuild of my wiki is the only option (again)...

michiel 2020-09-28 15:37:46 UTC #24

Hi @twanvandenbroek,

You can open the Services tool in the following way:

In the Menu search bar type Run
Then type services.msc

There you can check for a service with the same name as in the properties.ini as @jota mentioned.

Regards,
Michiel

twanvandenbroek 2020-10-03 07:56:27 UTC #25

And by service you mean 'mediawikiMySQL?
When I look in services, I see that this has stopped.When I try to restart from Services, I get an error: "Cannot start the mediawikiMySQL server on local computer.
Error 1053: The service did not respond to the start or control command correctly." (translated from Dutchby me)

Please find attached my properties.ini file properties.zip (823 Bytes)

jota 2020-10-05 10:28:17 UTC #26

Hi @twanvandenbroek,

Can you open the "Properties" view of that service and see if it matches with the path where the app is installed? D:\Mijn documenten\BredaWiki\mysql\bin\mysqld.exe.

The problem is that if you don't start the database, you won't be able to obtain the data of your Wiki.

The file looks good. You can also try to uninstall and install the service again

Open the Command Prompt and run this command

cd "D:\Mijn documenten\BredaWiki\mysql\scripts"

Ensure you are in the correct directory.

dir

It should show different .bat files.

Run the serviceinstall.bat file

serviceinstall.bat REMOVE

The console will probably exit so open a new one and "cd" to the same directory and run the install command later

serviceinstall.bat INSTALL

Can you start the service now?

twanvandenbroek 2020-10-05 16:30:17 UTC #27

Under properties of mediawikiMySQL in Servuies it shows the following:
"D:\Mijn documenten\BredaWiki\mysql\bin\mysqld.exe --defaults-file=D:\Mijn documenten\BredaWiki\mysql\my.ini mediawikiMySQL". So looks OK?

Afterwards I ran the first commands you suggested.
When I go to the destinatiion folder (D:\Mijn documenten\BredaWiki\mysql\scripts) afterwards, I still see serviceinstall.bat available there.Shouls I delete the file manually? Or can I run the install command even if the file is not removed (apparantly)?

twanvandenbroek 2020-10-05 16:34:32 UTC #28

I ran the last command anyway, just to try if this would solve the problem. And it did! The service is now runnign again, and the data on my wiki is available.

I have no clue on what actions or whatever I executed the last two mondth, but am relieved that my Wiki is up and running again (for now at least).

Thanks guys!

michiel 2020-10-06 10:06:48 UTC #29

Hi @jota,

I'm glad to hear the issue has been solved.

Regards,
Michiel

system 2020-10-20 10:06:58 UTC #30

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Bitnami provides free all-in-one installers, virtual machines and cloud images for popular open source applications. Get them now!