root / template / d7-settings-local-template.php @ 469b9d6d
1 |
<?php
|
---|---|
2 |
|
3 |
/**
|
4 |
* Database settings:
|
5 |
*
|
6 |
* The $databases array specifies the database connection or
|
7 |
* connections that Drupal may use. Drupal is able to connect
|
8 |
* to multiple databases, including multiple types of databases,
|
9 |
* during the same request.
|
10 |
*
|
11 |
* Each database connection is specified as an array of settings,
|
12 |
* similar to the following:
|
13 |
* @code
|
14 |
* array(
|
15 |
* 'driver' => 'mysql',
|
16 |
* 'database' => 'databasename',
|
17 |
* 'username' => 'username',
|
18 |
* 'password' => 'password',
|
19 |
* 'host' => 'localhost',
|
20 |
* 'port' => 3306,
|
21 |
* 'prefix' => 'myprefix_',
|
22 |
* 'collation' => 'utf8_general_ci',
|
23 |
* );
|
24 |
* @endcode
|
25 |
*
|
26 |
* The "driver" property indicates what Drupal database driver the
|
27 |
* connection should use. This is usually the same as the name of the
|
28 |
* database type, such as mysql or sqlite, but not always. The other
|
29 |
* properties will vary depending on the driver. For SQLite, you must
|
30 |
* specify a database file name in a directory that is writable by the
|
31 |
* webserver. For most other drivers, you must specify a
|
32 |
* username, password, host, and database name.
|
33 |
*
|
34 |
* Some database engines support transactions. In order to enable
|
35 |
* transaction support for a given database, set the 'transactions' key
|
36 |
* to TRUE. To disable it, set it to FALSE. Note that the default value
|
37 |
* varies by driver. For MySQL, the default is FALSE since MyISAM tables
|
38 |
* do not support transactions.
|
39 |
*
|
40 |
* For each database, you may optionally specify multiple "target" databases.
|
41 |
* A target database allows Drupal to try to send certain queries to a
|
42 |
* different database if it can but fall back to the default connection if not.
|
43 |
* That is useful for master/slave replication, as Drupal may try to connect
|
44 |
* to a slave server when appropriate and if one is not available will simply
|
45 |
* fall back to the single master server.
|
46 |
*
|
47 |
* The general format for the $databases array is as follows:
|
48 |
* @code
|
49 |
* $databases['default']['default'] = $info_array;
|
50 |
* $databases['default']['slave'][] = $info_array;
|
51 |
* $databases['default']['slave'][] = $info_array;
|
52 |
* $databases['extra']['default'] = $info_array;
|
53 |
* @endcode
|
54 |
*
|
55 |
* In the above example, $info_array is an array of settings described above.
|
56 |
* The first line sets a "default" database that has one master database
|
57 |
* (the second level default). The second and third lines create an array
|
58 |
* of potential slave databases. Drupal will select one at random for a given
|
59 |
* request as needed. The fourth line creates a new database with a name of
|
60 |
* "extra".
|
61 |
*
|
62 |
* For a single database configuration, the following is sufficient:
|
63 |
* @code
|
64 |
* $databases['default']['default'] = array(
|
65 |
* 'driver' => 'mysql',
|
66 |
* 'database' => 'databasename',
|
67 |
* 'username' => 'username',
|
68 |
* 'password' => 'password',
|
69 |
* 'host' => 'localhost',
|
70 |
* 'prefix' => 'main_',
|
71 |
* 'collation' => 'utf8_general_ci',
|
72 |
* );
|
73 |
* @endcode
|
74 |
*
|
75 |
* You can optionally set prefixes for some or all database table names
|
76 |
* by using the 'prefix' setting. If a prefix is specified, the table
|
77 |
* name will be prepended with its value. Be sure to use valid database
|
78 |
* characters only, usually alphanumeric and underscore. If no prefixes
|
79 |
* are desired, leave it as an empty string ''.
|
80 |
*
|
81 |
* To have all database names prefixed, set 'prefix' as a string:
|
82 |
* @code
|
83 |
* 'prefix' => 'main_',
|
84 |
* @endcode
|
85 |
* To provide prefixes for specific tables, set 'prefix' as an array.
|
86 |
* The array's keys are the table names and the values are the prefixes.
|
87 |
* The 'default' element is mandatory and holds the prefix for any tables
|
88 |
* not specified elsewhere in the array. Example:
|
89 |
* @code
|
90 |
* 'prefix' => array(
|
91 |
* 'default' => 'main_',
|
92 |
* 'users' => 'shared_',
|
93 |
* 'sessions' => 'shared_',
|
94 |
* 'role' => 'shared_',
|
95 |
* 'authmap' => 'shared_',
|
96 |
* ),
|
97 |
* @endcode
|
98 |
* You can also use a reference to a schema/database as a prefix. This may be
|
99 |
* useful if your Drupal installation exists in a schema that is not the default
|
100 |
* or you want to access several databases from the same code base at the same
|
101 |
* time.
|
102 |
* Example:
|
103 |
* @code
|
104 |
* 'prefix' => array(
|
105 |
* 'default' => 'main.',
|
106 |
* 'users' => 'shared.',
|
107 |
* 'sessions' => 'shared.',
|
108 |
* 'role' => 'shared.',
|
109 |
* 'authmap' => 'shared.',
|
110 |
* );
|
111 |
* @endcode
|
112 |
* NOTE: MySQL and SQLite's definition of a schema is a database.
|
113 |
*
|
114 |
* Advanced users can add or override initial commands to execute when
|
115 |
* connecting to the database server, as well as PDO connection settings. For
|
116 |
* example, to enable MySQL SELECT queries to exceed the max_join_size system
|
117 |
* variable, and to reduce the database connection timeout to 5 seconds:
|
118 |
*
|
119 |
* @code
|
120 |
* $databases['default']['default'] = array(
|
121 |
* 'init_commands' => array(
|
122 |
* 'big_selects' => 'SET SQL_BIG_SELECTS=1',
|
123 |
* ),
|
124 |
* 'pdo' => array(
|
125 |
* PDO::ATTR_TIMEOUT => 5,
|
126 |
* ),
|
127 |
* );
|
128 |
* @endcode
|
129 |
*
|
130 |
* WARNING: These defaults are designed for database portability. Changing them
|
131 |
* may cause unexpected behavior, including potential data loss.
|
132 |
*
|
133 |
* @see DatabaseConnection_mysql::__construct
|
134 |
* @see DatabaseConnection_pgsql::__construct
|
135 |
* @see DatabaseConnection_sqlite::__construct
|
136 |
*
|
137 |
* Database configuration format:
|
138 |
* @code
|
139 |
* $databases['default']['default'] = array(
|
140 |
* 'driver' => 'mysql',
|
141 |
* 'database' => 'databasename',
|
142 |
* 'username' => 'username',
|
143 |
* 'password' => 'password',
|
144 |
* 'host' => 'localhost',
|
145 |
* 'prefix' => '',
|
146 |
* );
|
147 |
* $databases['default']['default'] = array(
|
148 |
* 'driver' => 'pgsql',
|
149 |
* 'database' => 'databasename',
|
150 |
* 'username' => 'username',
|
151 |
* 'password' => 'password',
|
152 |
* 'host' => 'localhost',
|
153 |
* 'prefix' => '',
|
154 |
* );
|
155 |
* $databases['default']['default'] = array(
|
156 |
* 'driver' => 'sqlite',
|
157 |
* 'database' => '/path/to/databasefilename',
|
158 |
* );
|
159 |
* @endcode
|
160 |
*/
|
161 |
$databases = array ( |
162 |
'default' =>
|
163 |
array (
|
164 |
'default' =>
|
165 |
array (
|
166 |
'database' => '%%DBNAME%%', |
167 |
'username' => '%%DBUSER%%', |
168 |
'password' => '%%DBPASS%%', |
169 |
'host' => 'myassos.serv.int', |
170 |
'port' => '', |
171 |
'driver' => 'mysql', |
172 |
'prefix' => '', |
173 |
), |
174 |
), |
175 |
); |
176 |
|
177 |
/**
|
178 |
* Base URL (optional).
|
179 |
*
|
180 |
* If Drupal is generating incorrect URLs on your site, which could
|
181 |
* be in HTML headers (links to CSS and JS files) or visible links on pages
|
182 |
* (such as in menus), uncomment the Base URL statement below (remove the
|
183 |
* leading hash sign) and fill in the absolute URL to your Drupal installation.
|
184 |
*
|
185 |
* You might also want to force users to use a given domain.
|
186 |
* See the .htaccess file for more information.
|
187 |
*
|
188 |
* Examples:
|
189 |
* $base_url = 'http://www.example.com';
|
190 |
* $base_url = 'http://www.example.com:8888';
|
191 |
* $base_url = 'http://www.example.com/drupal';
|
192 |
* $base_url = 'https://www.example.com:8888/drupal';
|
193 |
*
|
194 |
* It is not allowed to have a trailing slash; Drupal will add it
|
195 |
* for you.
|
196 |
*/
|
197 |
$base_url = 'http://assos.centrale-marseille.fr/%%SITE_NAME%%'; |