This is a test site. Any changes will be lost!

1and1 MySQL installation: Difference between revisions

From MoodleDocs
No edit summary
Ken Wilson (talk | contribs)
m Nowiki change
 
(7 intermediate revisions by 4 users not shown)
Line 1: Line 1:
There are eamples of Moodle beign successfully installed on 1and1 Apache hosted sites. There are some formalities that you must follow. In the config.php file, yuo must use the following format for the listed database variables:
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->dbtype    = 'mysql';      // mysql or postgres7 (for now)
$CFG->dbhost    = 'db123.yourdomain.net';  // eg localhost or db.isp.com
$CFG->dbname    = 'db123456789';      // database name, eg moodle
$CFG->dbuser    = 'dbo123456789';    // your database username
$CFG->dbpass    = 'yourpassword';    // your database password
$CFG->prefix    = 'mdl_';        // Prefix to use for all table names


$CFG->dbhost    = 'db123.perfora.net';  // eg localhost or db.isp.com
Other variables must be defined as follows:


$CFG->dbname    = 'db123456789';     // database name, eg moodle
$CFG->wwwroot  = <nowiki>'http://www.yourdomain.com';</nowiki>
$CFG->dirroot  = '/homepages/12/d123456789/htdocs/yourdirectory';
$CFG->dataroot  = '/homepages/12/d123456789/htdocs/moodledata';


$CFG->dbuser    = 'dbo123456789';    // your database username
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.


$CFG->dbpass    = 'Gvu8rrqs';    // your database password
----
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 [https://docs.moodle.org/en/Installation_FAQ#Installation_hangs_when_setting-up_database_tables Installation hangs when setting-up database tables]FAQ.
<p>You also need to use a MySQL 5.0 database for moodle 1.8.</p>


$CFG->prefix    = 'mdl_';        // Prefix to use for all table names
----
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.


 
[[Category:Installation]]
other variables must be defined as follows:
 
 
$CFG->wwwroot  = 'http://www.yoururl.com';
 
$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 theserver, 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. Thanks you.

Latest revision as of 12:07, 30 April 2008

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    = 'db123.yourdomain.net';   // eg localhost or db.isp.com
$CFG->dbname    = 'db123456789';      // database name, eg moodle
$CFG->dbuser    = 'dbo123456789';    // your database username
$CFG->dbpass    = 'yourpassword';    // your database password
$CFG->prefix    = 'mdl_';        // Prefix to use for all table names

Other variables must be defined as follows:

$CFG->wwwroot   = 'http://www.yourdomain.com';
$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.