1and1 MySQL installation

Jump to: navigation, search

Note: You are currently viewing documentation for Moodle 1.9. Up-to-date documentation for the latest stable version is available here: 1and1 MySQL installation.

There are examples of Moodle being successfully installed on 1and1 Apache hosted sites. There are some formalities that you must follow. In the config.php file, you must use the following format for the listed database variables:

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

Other variables must be defined as follows:

$CFG->wwwroot  = 'http://www.';
$CFG->dirroot  = '/homepages/12/d123456789/htdocs/yourdirectory';
$CFG->dataroot = '/homepages/12/d123456789/htdocs/moodledata';

So far, this gets me into the Moodle setup program on the server, but I get errors when trying to install Moodle. It can't seem to correctly set up the database. Please edit this page to provide more information to the many users of 1and1. Thank you.


In my experience you need to add .htaccess file which contains this line AddType x-mapp-php5 .php to your moodle folder as described in Installation hangs when setting-up database tablesFAQ.

You also need to use a MySQL 5.0 database for moodle 1.8.


I can confirm the above. I struggled with a fresh installation of Version 1.9 with a MySQL 5.0 db set up. The addition of AddType x-mapp-php5 .php as a single entry in the .htaccess file of the moodle directory solved the problem - the unattended installation worked well without error.


I also can confirm the above - mostly. I had trouble to start with because I didn't understand how the 1and1 MySql setup worked and because I took the above instructions literally, thinking that I shouldn't fill in the dbhost, dbuser and dbpass.


Here are my settings in config.php - munged a bit for security, but you get the idea:


<config.php>


$CFG->dbtype = 'mysql'; // mysql or postgres7 (for now)

$CFG->dbhost = 'db8954.perfora.net'; // eg localhost or db.isp.com

$CFG->dbname = 'dbXXXXXXX78'; // database name, eg moodle

$CFG->dbuser = 'dboXXXXXXX78'; // your database username

$CFG->dbpass = 'MyPassword'; // your database password

$CFG->prefix = 'mdl_'; // Prefix to use for all table names

$CFG->wwwroot = 'http://basener.org/moodle'; // real site - go take a look


$CFG->dirroot = '/homepages/4/d3XXXXXXXX/htdocs/moodle';

$CFG->dataroot = '/homepages/4/d3XXXXXXXX/htdocs/moodledata';


</config.php>


I can't speak to the necessity of the .htaccess file, I just used it and it worked fine. I never tried without.


Just as a note. After installing Moodle 1.9.11 I tried Moodle 2.0.2 without much success. After messing around with the Unicode settings in the database I got the installation to run to a point where it apparently ran out of RAM (memory allocation error). I just accessed the site after that and it seemed to work, I was able to set up the admin account. But after that I kept trying things that would result in blank pages. So I reverted to 1.9. 2.0 is pretty slick and I run it at work, but I would rather have a working system than 'slick'.