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'.
20/10/11 Just tried to install Moodle 2.1.2+ onto 1and1 - following the above insructions will clear up the initial error messages and take you to the auto set up. However, once there the installation fails due to 1and1 running an earlier version of PHP: "version 5.3.2 is required and you are running 5.2.17" I have emailed them to ask if an upgrade is possible and their reply was: "We would like to inform you that the latest PHP version script we offer is 5.2.17. We do not support higher than 5.2.17 version script...Our Administrators are already working with PHP version 6.0 but it is still currently on beta state under testing period and we do not have specific time when would our Admins will implement such feature." (Diane)
