[Moodle] Moodle Install on RH9

[Zach Alexakos]

Hello Darrel,

In config.php I had the $CFG->dirroot= "/usr/moodle/moodle";
when it should have been
$CFG->dirroot="/var/www/html/moodle";

This having been sorted I proceeded to the first or second installation page
of moodle however the error is

"1044: Access denied for user: 'root at localhost' to database 'moodle'
Now I've checked the config file and the user name and password is the same
as I had set in mysqladmin.

Any ideas about this?

Zach Alexakos
Nth Geelong SC



----- Original Message ----- 
From: "Darrel Branson" <branson.darrel.l at edumail.vic.gov.au>
To: "The Moodle Users' in Schools Mailing List" <moodle at edulists.com.au>
Sent: Sunday, April 10, 2005 2:57 PM
Subject: Re: [Moodle] Moodle Install on RH9


On 8/4/05 5:47 PM, "Zach Alexakos" <alexakos.zach.z at edumail.vic.gov.au>
wrote:
> Now I've tried to make changes using webmin without much success and I've
also
> checked the config file- The moodle documentation doesn't say much in this
> regard.  The error message I receive from webmin when I try to make
changes to
> the moodle database permissions is
> "Access denied to user root to database".

Make sure you have the config file settings correct in
/pathto/webdocs/moodle/config.php

$CFG->dbtype    = 'mysql';           // mysql or postgres7 (for now)
$CFG->dbhost    = 'localhost';       // eg localhost or db.isp.com
$CFG->dbname    = 'moodle';          // database name, eg moodle
$CFG->dbuser    = 'root';            // your database username
$CFG->dbpass    = 'yourpassword';    // your database password
$CFG->prefix    = 'mdl_';            // Prefix to use for all table names

Just make sure the dbname, dbuser and dbpass are correct.

I assume you have already created the database. If you have done this you
can assume it¹s a mysql user/password problem. If you you are using the root
user it shouldn¹t be a problem accessing any database on mysql (although not
recommended)

If you are not sure you can reset the password for root using mysqladmin
[prompt]$  mysqladmin -u root password 'new-password'

The only other problem I can think of is that mysql support has not been
enabled in php. But if that was the case I doubt you would be getting an
"Access denied error"

Hang in there, Moodle runs great once it's configured :)) And think of all
the other great opensource software you can use once you have your
environment setup.

Cheers
Darrel









Important -
This email and any attachments may be confidential. If received in error,
please contact us and delete all copies. Before opening or using attachments
check them for viruses and defects. Regardless of any loss, damage or
consequence, whether caused by the negligence of the sender or not,
resulting directly or indirectly from the use of any attached files our
liability is limited to resupplying any affected attachments. Any
representations or opinions expressed are those of the individual sender,
and not necessarily those of the Department of Education & Training.

_______________________________________________
moodle mailing list
moodle at edulists.com.au
http://www.edulists.com.au/mailman/listinfo/moodle



Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.