NOMDL workshop: improved SQL execution, use one query instead of loop
[moodle.git] / config-dist.php
CommitLineData
dfede59d 1<?PHP
6077020a 2///////////////////////////////////////////////////////////////////////////
3// //
4// Moodle configuration file //
5// //
6// This file should be renamed "config.php" in the top-level directory //
7// //
8///////////////////////////////////////////////////////////////////////////
9// //
10// NOTICE OF COPYRIGHT //
11// //
12// Moodle - Modular Object-Oriented Dynamic Learning Environment //
c6b456f6 13// http://moodle.org //
6077020a 14// //
3b365361 15// Copyright (C) 1999 onwards Martin Dougiamas http://moodle.com //
6077020a 16// //
17// This program is free software; you can redistribute it and/or modify //
18// it under the terms of the GNU General Public License as published by //
554a3c4c 19// the Free Software Foundation; either version 3 of the License, or //
6077020a 20// (at your option) any later version. //
21// //
22// This program is distributed in the hope that it will be useful, //
23// but WITHOUT ANY WARRANTY; without even the implied warranty of //
24// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
25// GNU General Public License for more details: //
26// //
27// http://www.gnu.org/copyleft/gpl.html //
28// //
29///////////////////////////////////////////////////////////////////////////
30unset($CFG); // Ignore this line
b30fa335 31global $CFG; // This is necessary here for PHPUnit execution
c57e9015 32$CFG = new stdClass();
6077020a 33
34//=========================================================================
35// 1. DATABASE SETUP
36//=========================================================================
37// First, you need to configure the database where all Moodle data //
38// will be stored. This database must already have been created //
39// and a username/password created to access it. //
6077020a 40
d0bf00e0
DM
41$CFG->dbtype = 'pgsql'; // 'pgsql', 'mysqli', 'mssql' or 'oci'
42$CFG->dblibrary = 'native'; // 'native' only at the moment
43$CFG->dbhost = 'localhost'; // eg 'localhost' or 'db.isp.com' or IP
44$CFG->dbname = 'moodle'; // database name, eg moodle
45$CFG->dbuser = 'username'; // your database username
46$CFG->dbpass = 'password'; // your database password
47$CFG->prefix = 'mdl_'; // prefix to use for all table names
48$CFG->dboptions = array(
49 'dbpersist' => false, // should persistent database connections be
50 // used? set to 'false' for the most stable
51 // setting, 'true' can improve performance
52 // sometimes
53 'dbsocket' => false, // should connection via UNIX socket be
54 // used? if you set it to 'true' here,
55 // set dbhost to 'localhost'
56 'dbport' => '', // the TCP port number to use when connecting
57 // to the server. keep empty string for the
58 // default port
59);
1e55ed26 60
6077020a 61
9d975de4 62//=========================================================================
3b5ff37f 63// 2. SECRET PASSWORD SALT
9d975de4
PS
64//=========================================================================
65// User password salt is very important security feature, it is created
66// automatically in installer, you have to uncomment and modify value
67// on the next line if you are creating config.php manually.
68//
5cc1e1eb 69// $CFG->passwordsaltmain = 'a_very_long_random_string_of_characters#@6&*1';
9d975de4
PS
70//
71// After changing the main salt you have to copy old value into one
72// of the following settings - this allows migration to the new salt
73// during the next login of each user.
74//
75// $CFG->passwordsaltalt1 = '';
76// $CFG->passwordsaltalt2 = '';
77// $CFG->passwordsaltalt3 = '';
78// ....
79// $CFG->passwordsaltalt19 = '';
80// $CFG->passwordsaltalt20 = '';
81
82
6077020a 83//=========================================================================
3b5ff37f 84// 3. WEB SITE LOCATION
6077020a 85//=========================================================================
86// Now you need to tell Moodle where it is located. Specify the full
eb2042f6 87// web address to where moodle has been installed. If your web site
88// is accessible via multiple URLs then choose the most natural one
6077020a 89// that your students would use. Do not include a trailing slash
11e7b506 90//
91// If you need both intranet and Internet access please read
92// http://docs.moodle.org/en/masquerading
6077020a 93
94$CFG->wwwroot = 'http://example.com/moodle';
95
96
6077020a 97//=========================================================================
98// 4. DATA FILES LOCATION
99//=========================================================================
100// Now you need a place where Moodle can save uploaded files. This
eb2042f6 101// directory should be readable AND WRITEABLE by the web server user
102// (usually 'nobody' or 'apache'), but it should not be accessible
6077020a 103// directly via the web.
104//
105// - On hosting systems you might need to make sure that your "group" has
106// no permissions at all, but that "others" have full permissions.
107//
108// - On Windows systems you might specify something like 'c:\moodledata'
109
110$CFG->dataroot = '/home/example/moodledata';
111
112
113//=========================================================================
114// 5. DATA FILES PERMISSIONS
115//=========================================================================
116// The following parameter sets the permissions of new directories
eb2042f6 117// created by Moodle within the data directory. The format is in
6077020a 118// octal format (as used by the Unix utility chmod, for example).
eb2042f6 119// The default is usually OK, but you may want to change it to 0750
6077020a 120// if you are concerned about world-access to the files (you will need
121// to make sure the web server process (eg Apache) can access the files.
122// NOTE: the prefixed 0 is important, and don't use quotes.
123
d99bab2d 124$CFG->directorypermissions = 02777;
6077020a 125
126
127//=========================================================================
128// 6. DIRECTORY LOCATION (most people can just ignore this setting)
129//=========================================================================
eb2042f6 130// A very few webhosts use /admin as a special URL for you to access a
131// control panel or something. Unfortunately this conflicts with the
132// standard location for the Moodle admin pages. You can fix this by
133// renaming the admin directory in your installation, and putting that
6077020a 134// new name here. eg "moodleadmin". This will fix admin links in Moodle.
135
136$CFG->admin = 'admin';
137
138
139//=========================================================================
92848614 140// 7. OTHER MISCELLANEOUS SETTINGS (ignore these for new installations)
21d1d077 141//=========================================================================
142//
c9ca1fa5 143// These are additional tweaks for which no GUI exists in Moodle yet.
144//
9c733e86 145// Starting in PHP 5.3 administrators should specify default timezone
146// in PHP.ini, you can also specify it here if needed.
147// See details at: http://php.net/manual/en/function.date-default-timezone-set.php
148// List of time zones at: http://php.net/manual/en/timezones.php
149// date_default_timezone_set('Australia/Perth');
c9ca1fa5 150//
1ed96821 151// Change the key pair lifetime for Moodle Networking
152// The default is 28 days. You would only want to change this if the key
153// was not getting regenerated for any reason. You would probably want
154// make it much longer. Note that you'll need to delete and manually update
155// any existing key.
156// $CFG->mnetkeylifetime = 28;
157//
92848614 158// Prevent scheduled backups from operating (and hide the GUI for them)
159// Useful for webhost operators who have alternate methods of backups
160// $CFG->disablescheduledbackups = true;
21d1d077 161//
29ba20ac
MD
162// Allow user passwords to be included in backup files. Very dangerous
163// setting as far as it publishes password hashes that can be unencrypted
164// if the backup file is publicy available. Use it only if you can guarantee
165// that all your backup files remain only privacy available and are never
166// shared out from your site/institution!
167// $CFG->includeuserpasswordsinbackup = true;
168//
b0ccfc5c
HF
169// Completely disable user creation when restoring a course, bypassing any
170// permissions granted via roles and capabilities. Enabling this setting
171// results in the restore process stopping when a user attempts to restore a
172// course requiring users to be created.
5e934890
EL
173// $CFG->disableusercreationonrestore = true;
174//
2de3539b
EL
175// Keep the temporary directories used by backup and restore without being
176// deleted at the end of the process. Use it if you want to debug / view
177// all the information stored there after the process has ended. Note that
178// those directories may be deleted (after some ttl) both by cron and / or
179// by new backup / restore invocations.
180// $CFG->keeptempdirectoriesonbackup = true;
181//
5e934890 182// Modify the restore process in order to force the "user checks" to assume
b0ccfc5c
HF
183// that the backup originated from a different site, so detection of matching
184// users is performed with different (more "relaxed") rules. Note that this is
185// only useful if the backup file has been created using Moodle < 1.9.4 and the
186// site has been rebuilt from scratch using backup files (not the best way btw).
187// If you obtain user conflicts on restore, rather than enabling this setting
188// permanently, try restoring the backup on a different site, back it up again
189// and then restore on the target server.
5e934890
EL
190// $CFG->forcedifferentsitecheckingusersonrestore = true;
191//
72df7e1e 192// Prevent stats processing and hide the GUI
193// $CFG->disablestatsprocessing = true;
194//
7758d00f 195// Setting this to true will enable admins to edit any post at any time
196// $CFG->admineditalways = true;
cec0a0fc 197//
5fd1a5d8 198// These variables define DEFAULT block variables for new courses
199// If this one is set it overrides all others and is the only one used.
3eecaaf4 200// $CFG->defaultblocks_override = 'participants,activity_modules,search_forums,admin,course_list:news_items,calendar_upcoming,recent_activity';
201//
202// These variables define the specific settings for defined course formats.
5fd1a5d8 203// They override any settings defined in the formats own config file.
204// $CFG->defaultblocks_site = 'site_main_menu,admin,course_list:course_summary,calendar_month';
3eecaaf4 205// $CFG->defaultblocks_social = 'participants,search_forums,calendar_month,calendar_upcoming,social_activities,recent_activity,admin,course_list';
206// $CFG->defaultblocks_topics = 'participants,activity_modules,search_forums,admin,course_list:news_items,calendar_upcoming,recent_activity';
207// $CFG->defaultblocks_weeks = 'participants,activity_modules,search_forums,admin,course_list:news_items,calendar_upcoming,recent_activity';
208//
5fd1a5d8 209// These blocks are used when no other default setting is found.
210// $CFG->defaultblocks = 'participants,activity_modules,search_forums,admin,course_list:news_items,calendar_upcoming,recent_activity';
3eecaaf4 211//
5afbd0e7 212// The blocks in this list will be protected from deletion, and this is primarily
213// used to protect the navigation and settings blocks which can be very hard to
214// get back if accidentally delete.
3406acde 215// $CFG->undeletableblocktypes = 'navigation,settings';
5afbd0e7 216//
86b5ea0f 217// You can specify a different class to be created for the $PAGE global, and to
218// compute which blocks appear on each page. However, I cannot think of any good
219// reason why you would need to change that. It just felt wrong to hard-code the
220// the class name. You are stronly advised not to use these to settings unless
221// you are absolutely sure you know what you are doing.
222// $CFG->moodlepageclass = 'moodle_page';
223// $CFG->blockmanagerclass = 'block_manager';
c81c6d0e 224//
6b29ba60 225// Seconds for files to remain in caches. Decrease this if you are worried
226// about students being served outdated versions of uploaded files.
e55b73fd 227// $CFG->filelifetime = 86400;
88fea1ca 228//
229// This setting will prevent the 'My Courses' page being displayed when a student
230// logs in. The site front page will always show the same (logged-out) view.
e55b73fd 231// $CFG->disablemycourses = true;
c57e9015 232//
233// If this setting is set to true, then Moodle will track the IP of the
234// current user to make sure it hasn't changed during a session. This
235// will prevent the possibility of sessions being hijacked via XSS, but it
366dfa60 236// may break things for users coming using proxies that change all the time,
237// like AOL.
238// $CFG->tracksessionip = true;
bb64b51a 239//
240//
241// The following lines are for handling email bounces.
5fd1a5d8 242// $CFG->handlebounces = true;
243// $CFG->minbounces = 10;
244// $CFG->bounceratio = .20;
bb64b51a 245// The next lines are needed both for bounce handling and any other email to module processing.
246// mailprefix must be EXACTLY four characters.
c57e9015 247// Uncomment and customise this block for Postfix
5fd1a5d8 248// $CFG->mailprefix = 'mdl+'; // + is the separator for Exim and Postfix.
c57e9015 249// $CFG->mailprefix = 'mdl-'; // - is the separator for qmail
5fd1a5d8 250// $CFG->maildomain = 'youremaildomain.com';
f93426cf 251//
f11f8ba2
PS
252// Enable when setting up advanced reverse proxy load balancing configurations,
253// it may be also necessary to enable this when using port forwarding.
11e7b506 254// $CFG->reverseproxy = true;
255//
256// Enable when using external SSL appliance for performance reasons.
257// Please note that site may be accessible via https: or https:, but not both!
258// $CFG->sslproxy = true;
259//
c57e9015 260// This setting will cause the userdate() function not to fix %d in
1ac7ee24 261// date strings, and just let them show with a zero prefix.
262// $CFG->nofixday = true;
ce5e431b 263//
264// This setting will make some graphs (eg user logs) use lines instead of bars
265// $CFG->preferlinegraphs = true;
9d5ef892 266//
18259d4f 267// Enabling this will allow custom scripts to replace existing moodle scripts.
9677eb79 268// For example: if $CFG->customscripts/course/view.php exists then
18259d4f 269// it will be used instead of $CFG->wwwroot/course/view.php
270// At present this will only work for files that include config.php and are called
271// as part of the url (index.php is implied).
272// Some examples are:
273// http://my.moodle.site/course/view.php
274// http://my.moodle.site/index.php
275// http://my.moodle.site/admin (index.php implied)
276// Custom scripts should not include config.php
277// Warning: Replacing standard moodle scripts may pose security risks and/or may not
278// be compatible with upgrades. Use this option only if you are aware of the risks
c57e9015 279// involved.
9677eb79 280// Specify the full directory path to the custom scripts
281// $CFG->customscripts = '/home/example/customscripts';
18259d4f 282//
c57e9015 283// Performance profiling
284//
853df85e 285// If you set Debug to "Yes" in the Configuration->Variables page some
286// performance profiling data will show up on your footer (in default theme).
287// With these settings you get more granular control over the capture
288// and printout of the data
289//
290// Capture performance profiling data
291// define('MDL_PERF' , true);
292//
293// Capture additional data from DB
294// define('MDL_PERFDB' , true);
295//
296// Print to log (for passive profiling of production servers)
297// define('MDL_PERFTOLOG' , true);
298//
299// Print to footer (works with the default theme)
300// define('MDL_PERFTOFOOT', true);
301//
4c202228 302// Force displayed usernames
c57e9015 303// A little hack to anonymise user names for all students. If you set these
4c202228 304// then all non-teachers will always see these for every person.
305// $CFG->forcefirstname = 'Bruce';
306// $CFG->forcelastname = 'Simpson';
acd2279e 307//
308// The following setting will turn SQL Error logging on. This will output an
309// entry in apache error log indicating the position of the error and the statement
310// called. This option will action disregarding error_reporting setting.
311// $CFG->dblogerror = true;
5c5c16bb 312//
13534ef7
ML
313// The following setting will log every database query to a table called adodb_logsql.
314// Use this setting on a development server only, the table grows quickly!
315// $CFG->logsql = true;
316//
5c5c16bb 317// The following setting will turn on username logging into Apache log. For full details regarding setting
318// up of this function please refer to the install section of the document.
319// $CFG->apacheloguser = 0; // Turn this feature off. Default value.
320// $CFG->apacheloguser = 1; // Log user id.
321// $CFG->apacheloguser = 2; // Log full name in cleaned format. ie, Darth Vader will be displayed as darth_vader.
c57e9015 322// $CFG->apacheloguser = 3; // Log username.
bd10cc11 323// To get the values logged in Apache's log, add to your httpd.conf
324// the following statements. In the General part put:
220776ac 325// LogFormat "%h %l %{MOODLEUSER}n %t \"%r\" %s %b \"%{Referer}i\" \"%{User-Agent}i\"" moodleformat
bd10cc11 326// And in the part specific to your Moodle install / virtualhost:
327// CustomLog "/your/path/to/log" moodleformat
328// CAUTION: Use of this option will expose usernames in the Apache log,
329// If you are going to publish your log, or the output of your web stats analyzer
330// this will weaken the security of your website.
c57e9015 331//
332// Email database connection errors to someone. If Moodle cannot connect to the
880a6f6b 333// database, then email this address with a notice.
334//
6b25f553 335// $CFG->emailconnectionerrorsto = 'your@emailaddress.com';
c57e9015 336//
6f93e96c 337// Set the priority of themes from highest to lowest. This is useful (for
338// example) in sites where the user theme should override all other theme
339// settings for accessibility reasons. You can also disable types of themes
b7009474 340// (other than site) by removing them from the array. The default setting is:
341// $CFG->themeorder = array('course', 'category', 'session', 'user', 'site');
6f93e96c 342// NOTE: course, category, session, user themes still require the
343// respective settings to be enabled
344//
73e504bc
PS
345// It is possible to add extra themes directory stored outside of $CFG->dirroot.
346// This local directory does not have to be accessible from internet.
347//
348// $CFG->themedir = '/location/of/extra/themes';
349//
87679063
HF
350// This setting is for localised error messages for database connection problems:
351// $CFG->lang="yourlangcode";
352
84ebf08d 353//=========================================================================
354// 8. SETTINGS FOR DEVELOPMENT SERVERS - not intended for production use!!!
355//=========================================================================
f4fa5a63 356//
91ee8a67
DM
357// Force a debugging mode regardless the settings in the site administration
358// @error_reporting(1023); // NOT FOR PRODUCTION SERVERS!
359// @ini_set('display_errors', '1'); // NOT FOR PRODUCTION SERVERS!
360// $CFG->debug = 38911; // DEBUG_DEVELOPER // NOT FOR PRODUCTION SERVERS!
361// $CFG->debugdisplay = true; // NOT FOR PRODUCTION SERVERS!
362//
363// Prevent theme caching
364// $CFG->themerev = -1; // NOT FOR PRODUCTION SERVERS!
365//
f53fde9f 366// Prevent core_string_manager on-disk cache
e799e819 367// $CFG->langstringcache = false; // NOT FOR PRODUCTION SERVERS!
f53fde9f 368//
1045a007 369// When working with production data on test servers, no emails should ever be send to real users
91ee8a67 370// $CFG->noemailever = true; // NOT FOR PRODUCTION SERVERS!
49da4a5f
DM
371//
372// Divert all outgoing emails to this address to test and debug emailing features
91ee8a67 373// $CFG->divertallemailsto = 'root@localhost.local'; // NOT FOR PRODUCTION SERVERS!
1045a007 374//
84ebf08d 375// Specify prefix for fake unit test tables. If not specified only tests
1045a007 376// that do not need fake tables will be executed.
91ee8a67 377// $CFG->unittestprefix = 'tst_'; // NOT FOR PRODUCTION SERVERS!
84ebf08d 378//
379// special magic evil developer only wanting to edit the xmldb files manually
380// AND don't use the XMLDBEditor nor the prev/next stuff at all (Mahara and others)
381// Uncomment these if you're lazy like Penny
91ee8a67
DM
382// $CFG->xmldbdisablecommentchecking = true; // NOT FOR PRODUCTION SERVERS!
383// $CFG->xmldbdisablenextprevchecking = true; // NOT FOR PRODUCTION SERVERS!
84ebf08d 384//
1045a007 385// Special magic - evil developer only wanting to edit xmldb files manually
b646340f 386// AND allowing the XMLDBEditor to reconstruct the prev/next elements every
84ebf08d 387// time one file is loaded and saved (Moodle).
388// Uncomment this if you're lazy like Petr
91ee8a67 389// $CFG->xmldbreconstructprevnext = true; // NOT FOR PRODUCTION SERVERS!
1045a007 390//
391// Since 2.0 sql queries are not shown during upgrade by default.
392// Please note that this setting may produce very long upgrade page on large sites.
91ee8a67 393// $CFG->upgradeshowsql = true; // NOT FOR PRODUCTION SERVERS!
12bb0c3e
PS
394//
395//=========================================================================
396// 9. FORCED SETTINGS
397//=========================================================================
398// It is possible to specify normal admin settings here, the point is that
399// they can not be changed through the standard admin settings pages any more.
400//
401// Core settings are specified directly via assignment to $CFG variable.
402// Example:
403// $CFG->somecoresetting = 'value';
404//
405// Plugin settings have to be put into a special array.
406// Example:
407// $CFG->forced_plugin_settings = array('pluginname' => array('settingname' => 'value', 'secondsetting' => 'othervalue'),
408// 'otherplugin' => array('mysetting' => 'myvalue', 'thesetting' => 'thevalue'));
1045a007 409
84ebf08d 410
6077020a 411//=========================================================================
412// ALL DONE! To continue installation, visit your main page with a browser
413//=========================================================================
c781942f 414
d440bcfa 415require_once(dirname(__FILE__) . '/lib/setup.php'); // Do not edit
3b5ff37f 416
fa4556c5 417// There is no php closing tag in this file,
418// it is intentional because it prevents trailing whitespace problems!