MDL-21264 sql_isnotempty fixed. Thanks Tim! Backported from HEAD
[moodle.git] / config-dist.php
blob4e77938b33985d751bea6d7669148350809289e1
1 <?PHP // $Id$
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 //
13 // http://moodle.org //
14 // //
15 // Copyright (C) 1999 onwards Martin Dougiamas http://moodle.com //
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 //
19 // the Free Software Foundation; either version 2 of the License, or //
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 ///////////////////////////////////////////////////////////////////////////
30 unset($CFG); // Ignore this line
32 //=========================================================================
33 // 1. DATABASE SETUP
34 //=========================================================================
35 // First, you need to configure the database where all Moodle data //
36 // will be stored. This database must already have been created //
37 // and a username/password created to access it. //
38 // //
39 // mysql - the prefix is optional, but useful when installing //
40 // into databases that already contain tables. //
42 // postgres7 - the prefix is REQUIRED, regardless of whether the //
43 // database already contains tables. //
44 // //
45 // A special case exists when using PostgreSQL databases via sockets. //
46 // Define dbhost as follows, leaving dbname, dbuser, dbpass BLANK!: //
47 // $CFG->dbhost = " user='muser' password='mpass' dbname='mdata'"; //
50 $CFG->dbtype = 'mysql'; // mysql or postgres7 (for now)
51 $CFG->dbhost = 'localhost'; // eg localhost or db.isp.com
52 $CFG->dbname = 'moodle'; // database name, eg moodle
53 $CFG->dbuser = 'username'; // your database username
54 $CFG->dbpass = 'password'; // your database password
55 $CFG->prefix = 'mdl_'; // Prefix to use for all table names
57 $CFG->dbpersist = false; // Should database connections be reused?
58 // "false" is the most stable setting
59 // "true" can improve performance sometimes
62 //=========================================================================
63 // 1.5. SECRET PASSWORD SALT
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.
69 // $CFG->passwordsaltmain = 'a_very_long_random_string_of_characters#@6&*1';
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.
75 // $CFG->passwordsaltalt1 = '';
76 // $CFG->passwordsaltalt2 = '';
77 // $CFG->passwordsaltalt3 = '';
78 // ....
79 // $CFG->passwordsaltalt19 = '';
80 // $CFG->passwordsaltalt20 = '';
83 //=========================================================================
84 // 2. WEB SITE LOCATION
85 //=========================================================================
86 // Now you need to tell Moodle where it is located. Specify the full
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
89 // that your students would use. Do not include a trailing slash
91 $CFG->wwwroot = 'http://example.com/moodle';
94 //=========================================================================
95 // 3. SERVER FILES LOCATION
96 //=========================================================================
97 // Next, specify the full OS directory path to this same location
98 // Make sure the upper/lower case is correct. Some examples:
100 // $CFG->dirroot = 'C:\program files\easyphp\www\moodle'; // Windows
101 // $CFG->dirroot = '/var/www/html/moodle'; // Redhat Linux
102 // $CFG->dirroot = '/home/example/public_html/moodle'; // Cpanel host
104 $CFG->dirroot = '/home/example/public_html/moodle';
107 //=========================================================================
108 // 4. DATA FILES LOCATION
109 //=========================================================================
110 // Now you need a place where Moodle can save uploaded files. This
111 // directory should be readable AND WRITEABLE by the web server user
112 // (usually 'nobody' or 'apache'), but it should not be accessible
113 // directly via the web.
115 // - On hosting systems you might need to make sure that your "group" has
116 // no permissions at all, but that "others" have full permissions.
118 // - On Windows systems you might specify something like 'c:\moodledata'
120 $CFG->dataroot = '/home/example/moodledata';
123 //=========================================================================
124 // 5. DATA FILES PERMISSIONS
125 //=========================================================================
126 // The following parameter sets the permissions of new directories
127 // created by Moodle within the data directory. The format is in
128 // octal format (as used by the Unix utility chmod, for example).
129 // The default is usually OK, but you may want to change it to 0750
130 // if you are concerned about world-access to the files (you will need
131 // to make sure the web server process (eg Apache) can access the files.
132 // NOTE: the prefixed 0 is important, and don't use quotes.
134 $CFG->directorypermissions = 02777;
137 //=========================================================================
138 // 6. DIRECTORY LOCATION (most people can just ignore this setting)
139 //=========================================================================
140 // A very few webhosts use /admin as a special URL for you to access a
141 // control panel or something. Unfortunately this conflicts with the
142 // standard location for the Moodle admin pages. You can fix this by
143 // renaming the admin directory in your installation, and putting that
144 // new name here. eg "moodleadmin". This will fix admin links in Moodle.
146 $CFG->admin = 'admin';
149 //=========================================================================
150 // 7. OTHER MISCELLANEOUS SETTINGS (ignore these for new installations)
151 //=========================================================================
153 // These are additional tweaks for which no GUI exists in Moodle yet.
155 // Starting in PHP 5.3 administrators should specify default timezone
156 // in PHP.ini, you can also specify it here if needed.
157 // See details at: http://php.net/manual/en/function.date-default-timezone-set.php
158 // List of time zones at: http://php.net/manual/en/timezones.php
159 // date_default_timezone_set('Australia/Perth');
161 // Change the key pair lifetime for Moodle Networking
162 // The default is 28 days. You would only want to change this if the key
163 // was not getting regenerated for any reason. You would probably want
164 // make it much longer. Note that you'll need to delete and manually update
165 // any existing key.
166 // $CFG->mnetkeylifetime = 28;
168 // Prevent scheduled backups from operating (and hide the GUI for them)
169 // Useful for webhost operators who have alternate methods of backups
170 // $CFG->disablescheduledbackups = true;
172 // Allow user passwords to be included in backup files. Very dangerous
173 // setting as far as it publishes password hashes that can be unencrypted
174 // if the backup file is publicy available. Use it only if you can guarantee
175 // that all your backup files remain only privacy available and are never
176 // shared out from your site/institution!
177 // $CFG->includeuserpasswordsinbackup = true;
179 // Completely disable user creation when restoring a course, bypassing any
180 // permissions granted via roles and capabilities. Enabling this setting
181 // results in the restore process stopping when a user attempts to restore a
182 // course requiring users to be created.
183 // $CFG->disableusercreationonrestore = true;
185 // Modify the restore process in order to force the "user checks" to assume
186 // that the backup originated from a different site, so detection of matching
187 // users is performed with different (more "relaxed") rules. Note that this is
188 // only useful if the backup file has been created using Moodle < 1.9.4 and the
189 // site has been rebuilt from scratch using backup files (not the best way btw).
190 // If you obtain user conflicts on restore, rather than enabling this setting
191 // permanently, try restoring the backup on a different site, back it up again
192 // and then restore on the target server.
193 // $CFG->forcedifferentsitecheckingusersonrestore = true;
195 // Prevent stats processing and hide the GUI
196 // $CFG->disablestatsprocessing = true;
198 // Setting this to true will enable admins to edit any post at any time
199 // $CFG->admineditalways = true;
201 // These variables define DEFAULT block variables for new courses
202 // If this one is set it overrides all others and is the only one used.
203 // $CFG->defaultblocks_override = 'participants,activity_modules,search_forums,admin,course_list:news_items,calendar_upcoming,recent_activity';
205 // These variables define the specific settings for defined course formats.
206 // They override any settings defined in the formats own config file.
207 // $CFG->defaultblocks_site = 'site_main_menu,admin,course_list:course_summary,calendar_month';
208 // $CFG->defaultblocks_social = 'participants,search_forums,calendar_month,calendar_upcoming,social_activities,recent_activity,admin,course_list';
209 // $CFG->defaultblocks_topics = 'participants,activity_modules,search_forums,admin,course_list:news_items,calendar_upcoming,recent_activity';
210 // $CFG->defaultblocks_weeks = 'participants,activity_modules,search_forums,admin,course_list:news_items,calendar_upcoming,recent_activity';
212 // These blocks are used when no other default setting is found.
213 // $CFG->defaultblocks = 'participants,activity_modules,search_forums,admin,course_list:news_items,calendar_upcoming,recent_activity';
216 // Allow unicode characters in uploaded files, generated reports, etc.
217 // This setting is new and not much tested, there are known problems
218 // with backup/restore that will not be solved, because native infozip
219 // binaries are doing some weird conversions - use internal PHP zipping instead.
220 // NOT RECOMMENDED FOR PRODUCTION SITES
221 // $CFG->unicodecleanfilename = true;
223 // Seconds for files to remain in caches. Decrease this if you are worried
224 // about students being served outdated versions of uploaded files.
225 // $CFG->filelifetime = 86400;
227 // This setting will prevent the 'My Courses' page being displayed when a student
228 // logs in. The site front page will always show the same (logged-out) view.
229 // $CFG->disablemycourses = true;
231 // Enable this option if you need fully working default frontpage role,
232 // please note it might cause serious memory and performance issues,
233 // also there should not be any negative capabilities in default
234 // frontpage role (MDL-19039).
235 // $CFG->fullusersbycapabilityonfrontpage = true;
237 // If this setting is set to true, then Moodle will track the IP of the
238 // current user to make sure it hasn't changed during a session. This
239 // will prevent the possibility of sessions being hijacked via XSS, but it
240 // may break things for users coming using proxies that change all the time,
241 // like AOL.
242 // $CFG->tracksessionip = true;
245 // The following lines are for handling email bounces.
246 // $CFG->handlebounces = true;
247 // $CFG->minbounces = 10;
248 // $CFG->bounceratio = .20;
249 // The next lines are needed both for bounce handling and any other email to module processing.
250 // mailprefix must be EXACTLY four characters.
251 // Uncomment and customise this block for Postfix
252 // $CFG->mailprefix = 'mdl+'; // + is the separator for Exim and Postfix.
253 // $CFG->mailprefix = 'mdl-'; // - is the separator for qmail
254 // $CFG->maildomain = 'youremaildomain.com';
256 // The following setting will tell Moodle to respect your PHP session
257 // settings. Use this if you want to control session configuration
258 // from php.ini, httpd.conf or .htaccess files.
259 // $CFG->respectsessionsettings = true;
261 // This setting will cause the userdate() function not to fix %d in
262 // date strings, and just let them show with a zero prefix.
263 // $CFG->nofixday = true;
265 // This setting will make some graphs (eg user logs) use lines instead of bars
266 // $CFG->preferlinegraphs = true;
268 // Enabling this will allow custom scripts to replace existing moodle scripts.
269 // For example: if $CFG->customscripts/course/view.php exists then
270 // it will be used instead of $CFG->wwwroot/course/view.php
271 // At present this will only work for files that include config.php and are called
272 // as part of the url (index.php is implied).
273 // Some examples are:
274 // http://my.moodle.site/course/view.php
275 // http://my.moodle.site/index.php
276 // http://my.moodle.site/admin (index.php implied)
277 // Custom scripts should not include config.php
278 // Warning: Replacing standard moodle scripts may pose security risks and/or may not
279 // be compatible with upgrades. Use this option only if you are aware of the risks
280 // involved.
281 // Specify the full directory path to the custom scripts
282 // $CFG->customscripts = '/home/example/customscripts';
284 // Performance profiling
286 // If you set Debug to "Yes" in the Configuration->Variables page some
287 // performance profiling data will show up on your footer (in default theme).
288 // With these settings you get more granular control over the capture
289 // and printout of the data
291 // Capture performance profiling data
292 // define('MDL_PERF' , true);
294 // Capture additional data from DB
295 // define('MDL_PERFDB' , true);
297 // Print to log (for passive profiling of production servers)
298 // define('MDL_PERFTOLOG' , true);
300 // Print to footer (works with the default theme)
301 // define('MDL_PERFTOFOOT', true);
303 // Force displayed usernames
304 // A little hack to anonymise user names for all students. If you set these
305 // then all non-teachers will always see these for every person.
306 // $CFG->forcefirstname = 'Bruce';
307 // $CFG->forcelastname = 'Simpson';
309 // The following setting will turn SQL Error logging on. This will output an
310 // entry in apache error log indicating the position of the error and the statement
311 // called. This option will action disregarding error_reporting setting.
312 // $CFG->dblogerror = true;
314 // The following setting will log every database query to a table called adodb_logsql.
315 // Use this setting on a development server only, the table grows quickly!
316 // $CFG->logsql = true;
317 // By default, only queries that take longer than 0.05 seconds are logged. To change that,
318 // set the following variable. For example, to lot all queries:
319 // $CFG->logsqlmintime = 0.0;
321 // The following setting will turn on username logging into Apache log. For full details regarding setting
322 // up of this function please refer to the install section of the document.
323 // $CFG->apacheloguser = 0; // Turn this feature off. Default value.
324 // $CFG->apacheloguser = 1; // Log user id.
325 // $CFG->apacheloguser = 2; // Log full name in cleaned format. ie, Darth Vader will be displayed as darth_vader.
326 // $CFG->apacheloguser = 3; // Log username.
327 // To get the values logged in Apache's log, add to your httpd.conf
328 // the following statements. In the General part put:
329 // LogFormat "%h %l %{MOODLEUSER}n %t \"%r\" %s %b \"%{Referer}i\" \"%{User-Agent}i\"" moodleformat
330 // And in the part specific to your Moodle install / virtualhost:
331 // CustomLog "/your/path/to/log" moodleformat
332 // CAUTION: Use of this option will expose usernames in the Apache log,
333 // If you are going to publish your log, or the output of your web stats analyzer
334 // this will weaken the security of your website.
336 // Email database connection errors to someone. If Moodle cannot connect to the
337 // database, then email this address with a notice.
339 // $CFG->emailconnectionerrorsto = 'your@emailaddress.com';
341 // NOTE: if you are using custompix in your theme, see /fixpix.php.
343 // special magic evil developer only wanting to edit the xmldb files manually
344 // AND don't use the XMLDBEditor nor the prev/next stuff at all (Mahara and others)
345 // Uncomment these if you're lazy like Penny
346 // $CFG->xmldbdisablecommentchecking = true;
347 // $CFG->xmldbdisablenextprevchecking = true;
349 // special magig evil developer only wanting to edit xmldb files manually
350 // AND allowing the XMLDBEditor to recostruct the prev/next elements every
351 // time one file is loaded and saved (Moodle).
352 // Uncomment this if you're lazy like Petr
353 // $CFG->xmldbreconstructprevnext = true;
355 // Set the priority of themes from highest to lowest. This is useful (for
356 // example) in sites where the user theme should override all other theme
357 // settings for accessibility reasons. You can also disable types of themes
358 // by removing them from the array. The default setting is:
359 // $CFG->themeorder = array('page', 'course', 'category', 'session', 'user', 'site');
360 // NOTE: course, category, session, user themes still require the
361 // respective settings to be enabled
363 // When working with production data on test servers, no emails should ever be send to real users
364 // $CFG->noemailever = true;
367 //=========================================================================
368 // ALL DONE! To continue installation, visit your main page with a browser
369 //=========================================================================
370 if ($CFG->wwwroot == 'http://example.com/moodle') {
371 echo "<p>Error detected in configuration file</p>";
372 echo "<p>Your server address can not be: \$CFG->wwwroot = 'http://example.com/moodle';</p>";
373 die;
376 if (file_exists("$CFG->dirroot/lib/setup.php")) { // Do not edit
377 include_once("$CFG->dirroot/lib/setup.php");
378 } else {
379 if ($CFG->dirroot == dirname(__FILE__)) {
380 echo "<p>Could not find this file: $CFG->dirroot/lib/setup.php</p>";
381 echo "<p>Are you sure all your files have been uploaded?</p>";
382 } else {
383 echo "<p>Error detected in config.php</p>";
384 echo "<p>Error in: \$CFG->dirroot = '$CFG->dirroot';</p>";
385 echo "<p>Try this: \$CFG->dirroot = '".dirname(__FILE__)."';</p>";
387 die;
389 // MAKE SURE WHEN YOU EDIT THIS FILE THAT THERE ARE NO SPACES, BLANK LINES,
390 // RETURNS, OR ANYTHING ELSE AFTER THE TWO CHARACTERS ON THE NEXT LINE.