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
Answers:
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.
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.
This didnot work mam.
Same error is popping up.
It is shown that tomcat is not working.
Login to add comment
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
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.
Done all of them above. but still have the same problem
Did you select 'Maria DB' in the step prior to the database configuration page?
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
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
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!
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!
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.
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>
<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>
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.
OR
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.
OR
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.
Login to add comment
Login to add comment