Moodle-Learning-Management-System - Cannot install moodle on windows 10

saving . . . saved Cannot install moodle on windows 10 has been deleted. Cannot install moodle on windows 10 has been hidden .

Cannot install moodle on windows 10

Title

Question

The following error occured while invoking localhost for installation in Database settings page:

Database settings

MariaDB (native/mariadb)

The database is where most of the Moodle settings and data are stored and must be configured here.

The database name, username, and password are required fields; table prefix is optional.

The database name may contain only alphanumeric characters, dollar ($) and underscore (_).

If the database currently does not exist, and the user you specify has permission, Moodle will attempt to create a new database with the correct permissions and settings.

This driver is not compatible with legacy MyISAM engine.

Database host

localhost

Database name

moodle-st

Database user

moodle-st

Database password

moodle-st

Tables prefix

mdl_

Database port

Error: Database connection failed

It is possible that the database is overloaded or otherwise not running properly.

The site administrator should also check that the database details have been correctly specified in config.php

Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'moodle-st'@'localhost' (using password: YES) in C:\Moodle\server\moodle\lib\dml\mysqli_native_moodle_database.php on line 79

And you answered :

This is because XAMPP was not installed properly on your system. Please reinstall XAMPP and try again.

Please follow the steps given in the below link:(see page 2 for windows installation)

https://spoken-tutorial.org/media/videos/97/Moodle-Learning-Management-System-Installation-Sheet-English.pdf

21-05-20, 11:58 a.m. NirmalaVenkat

I followed all instructions in the installation sheet page 2.

Then kindly explain how to install xampp properly.

Moodle-Learning-Management-System General None min None sec 21-05-20, 4:17 p.m. snccgnr

Answers:

21-05-20, 4:34 p.m. NirmalaVenkat

Go to the given link to download moodle:
This includes xampp installation.

https://download.moodle.org/download.php/windows/MoodleWindowsInstaller-latest-33.zip

Check the step 8 under 2.1 in the installation sheet.

In the xampp control panel, restart the services of Apache and mysql.

21-05-20, 4:37 p.m. NirmalaVenkat

This didnot work mam.

Same error is popping up.

21-05-20, 4:45 p.m. snccgnr

It is shown that tomcat is not working.

21-05-20, 4:47 p.m. snccgnr

Please check the below link:

https://mrtextminer.wordpress.com/2012/11/16/xampp-1-8-1-cannot-start-tomcat-server-using-xampp-control-panel/

https://community.apachefriends.org/viewtopic.php?p=247705&sid=0d2dde193ce778c95cc20b7a94373de6

https://support.eset.com/en/kb5550-apache-tomcat-is-not-running-service-could-not-starthow-do-i-fix-this-issue-era-6x

21-05-20, 5 p.m. NirmalaVenkat

Check this out:

- https://docs.moodle.org/38/en/MariaDB

It says:

There is a dedicated driver for MariaDB. It is recommended to explicitly specify mariadb Moodle driver in config.php:

$CFG->dbtype = 'mariadb';

$CFG->dblibrary = 'native';

You should find this file at C:\Moodle\server\moodle\config.php

Let us know if there are any further queries.

24-05-20, 10:04 p.m. kashmira.n

Done all of them above. but still have the same problem

02-09-20, 10:21 p.m. ujjal.dey@ee.jgec.ac.in

Did you select 'Maria DB' in the step prior to the database configuration page?

03-09-20, 12:09 a.m. kashmira.n

Also, you can create an empty database from either command line or phpmyadmin by following the commands given here: https://docs.moodle.org/39/en/MySQL#Command_line

and then provide db and user details in the db setup page

03-09-20, 12:16 a.m. kashmira.n

I am installing in Windows 10 64 bit

Done this, before database configuration

$CFG->dbtype = 'mariadb';

$CFG->dblibrary = 'native';

Then according to "Moodle-Learning-Management-System-Installation-Sheet-English" pdf point 2.1.2 , tried to put the Database user : 'moodle-st', but it is already taken 'root' which can't be edited. After clicking 'next' I could edit Database user; but then same error is showing:

Error: Database connection failed

It is possible that the database is overloaded or otherwise not running properly.

The site administrator should also check that the database details have been correctly specified in config.php

Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'moodle-st'@'localhost' (using password: YES) in C:\Moodle\server\moodle\lib\dml\mysqli_native_moodle_database.php on line 79

03-09-20, 10:20 a.m. ujjal.dey@ee.jgec.ac.in

Further, in XAMPP control panel v3.2.2 the following is showing in red color:

9:53:22 AM [Tomcat]     Problem detected: Tomcat Not Found!
9:53:22 AM [Tomcat]     Disabling Tomcat buttons
9:53:22 AM [Tomcat]     Run this program from your XAMPP root directory!
9:53:22 AM [Tomcat]     Problem detected: Required Tool catalina_start.bat Not Found!
9:53:22 AM [Tomcat]     Problem detected: Required Tool catalina_stop.bat Not Found!
9:53:22 AM [Tomcat]     Problem detected: Required Tool catalina_service.bat Not Found!

03-09-20, 10:23 a.m. ujjal.dey@ee.jgec.ac.in

Try the following:

1. Start only 'Apache' and 'Mysql' services from xampp control panel

2. Open any browser and then, open up phpmyadmin

This can be done by visiting: http://localhost/phpmyadmin in the browser

In phpmyadmin, click on SQL tab in the top bar

Enter the following commands one by one, click on 'Go' after each command:

- CREATE USER moodle-st@localhost IDENTIFIED BY 'yourpassword';

- GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES,DROP,INDEX,ALTER ON moodle.* TO moodle-st@localhost;

- FLUSH PRIVILEGES;

(Note: Here, in the command above, the database name is moodle.

You can either keep it as is or put your custom db name.)

And then proceed with the moodle installation.

Let me know how this goes.

03-09-20, 12:46 p.m. kashmira.n

after visiting http://localhost/phpmyadmin

Object not found

Error 404

<a href="http://localhost/" style="color: rgb(0, 0, 204); font-family: "Times New Roman"; font-size: medium; font-style: italic; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255);">localhost</a>
<span style="font-size: smaller; color: rgb(0, 0, 0); font-family: "Times New Roman"; font-style: italic; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); text-decoration-style: initial; text-decoration-color: initial;">Apache/2.4.23 (Win32) OpenSSL/1.0.2h PHP/7.0.9</span>

03-09-20, 4:23 p.m. ujjal.dey@ee.jgec.ac.in

03-09-20, 4:26 p.m. ujjal.dey@ee.jgec.ac.in

Did you start MySQL service from XAMPP control panel?

Also, there are a few more suggestions here based on the error you are getting:

https://stackoverflow.com/questions/21748086/phpmyadmin-not-working-on-localhost

Simplest one among those is:

https://stackoverflow.com/a/39417059

Please check and let me know if this helped or not.

03-09-20, 5:04 p.m. kashmira.n

You can access MySQL via XAMPP Shell as well.

Start XAMPP.

In the XAMPP terminal/shell, type in: mysql -u root

You should get output like "Welcome to MariaDB Monitor..."

OR another way to login to MySQL can be this: https://stackoverflow.com/a/698937

Type in the commands to create 'moodle-st' user and permission granting specified in the previous comment here.

And then after successful execution of this, continue with Moodle installation and provide the DB details there.

Another option can be to proceed with 'root' user itself, i.e, do not change DB user to 'moodle-st' if this installation is for trial purposes.

See if this works.

Also, once the install is successful, then, later on, try fixing phpmyadmin issue.

Let me know how this goes.

03-09-20, 6:56 p.m. kashmira.n

Title

Question

Answers:

Log-in to answer to this question.