Installation help

Ubuntu 11.10 + Moodle 2.1 failing during install - newbie needs help!

 
 
Picture of Peter Whitehead
Ubuntu 11.10 + Moodle 2.1 failing during install - newbie needs help!
 

I'll try this with a different title!

I've installed Ubuntu 11.10 and have installed 2.1.4+(Build 20120213) on it.

All seems to go ok.  We can get to http://localhost/moodle and the install starts.  It fails on the "Database settings" page with:

Warning: mysqli::close(): Couldn't fetch mysqli in /var/www/moodle/lib/dml/mysqli_native_moodle_database.php on line 336

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::mysqli(): (28000/1045): Access denied for user 'moodleuser@localhost' (using password: YES) in /var/www/moodle/lib/dml/mysqli_native_moodle_database.php on line 75

I'm new to both the OS and Moodle so I'm grasping at straws here.

Not convinced the database is set up properly but how can I check?  Also, some of the instructions seem to be mysql, some mysqli.  Is this important?

No config.php has been created yet, so I can't say what's in it.

Cheers

Peter

 
Average of ratings: -
Picture of Visvanath Ratnaweera
Re: Ubuntu 11.10 + Moodle 2.1 failing during install - newbie needs help!
Group Particularly helpful Moodlers
> Also, some of the instructions seem to be mysql, some mysqli. Is this important?

Sure! Did you try the mysql driver (appears as a line $CFG->dbtype = 'mysqli'; in the file config.php)?

> Not convinced the database is set up properly but how can I check?

You should be able to change to the moodle database as the corr. database user, as in this "screen shot":

$ mysql -u dbuser -p
Enter password: [dbpass]
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| moodle |
+--------------------+
2 rows in set (0.00 sec)
mysql> use moodle;
...
Database changed
mysql>

I'm documenting the Debian/Ubuntu way here http://docs.moodle.org/22/en/Installing_Moodle_on_Debian_based_distributions#Install_the_Database_Management_System, still under construction, but might help.

Also check http://moodle.org/mod/forum/discuss.php?d=167372.
 
Average of ratings: -
Picture of Peter Whitehead
Re: Ubuntu 11.10 + Moodle 2.1 failing during install - newbie needs help!
 

Great help thanks.  Well I have it working now.  I'm afraid it was really quite simple - essentially not putting a ";" at the end of my mysql commands!

So once I got that straight I have it working locally.  Not working across the network yet (although the Apache is) but I'll have a fiddle on that today.

Kind regards

Peter

 

 
Average of ratings: -