Trac uses a directory structure and a database for storing project data. The directory is referred to as the environment.
Trac uses a directory structure and a database for storing project data. The directory is referred to as the environment.
Trac uses a directory structure and a database for storing project data. The directory is referred to as the '''environment'''.
Trac uses a directory structure and a database for storing project data. The directory is referred to as the **environment**.
Trac supports [http://sqlite.org/ SQLite], [http://www.postgresql.org/ PostgreSQL] and [http://mysql.com/ MySQL] databases. With PostgreSQL and MySQL you have to create the database before running `trac-admin initenv`.
Trac supports [SQLite](http://sqlite.org/), [PostgreSQL](http://www.postgresql.org/) and [MySQL](http://mysql.com/) databases. With PostgreSQL and MySQL you have to create the database before running `trac-admin initenv`.
== Creating an Environment
== Creating an Environment
A new Trac environment is created using the [TracAdmin#initenv initenv] command:
A new Trac environment is created using the [TracAdmin#initenv initenv] command:
{{{#!sh
```
$ trac-admin /path/to/myproject initenv
$ trac-admin /path/to/myproject initenv
}}}
```
`trac-admin` will ask you for the name of the project and the [#DatabaseConnectionStrings database connection string].
`trac-admin` will ask you for the name of the project and the [#DatabaseConnectionStrings database connection string].
- TracPlugins located in a [TracIni#inherit-section shared plugins folder] that is defined in an [TracIni#GlobalConfiguration inherited configuration] are not loaded during creation, and hence, if they need to create extra tables for example, you'll need to [TracUpgrade#UpgradetheTracEnvironment upgrade the environment]. Alternatively you can avoid the need to upgrade the environment by specifying a configuration file at the time the environment is created, using the `--config` option. See TracAdmin#FullCommandReference for more information.
- TracPlugins located in a [TracIni#inherit-section shared plugins folder] that is defined in an [TracIni#GlobalConfiguration inherited configuration] are not loaded during creation, and hence, if they need to create extra tables for example, you'll need to [TracUpgrade#UpgradetheTracEnvironment upgrade the environment]. Alternatively you can avoid the need to upgrade the environment by specifying a configuration file at the time the environment is created, using the `--config` option. See TracAdmin#FullCommandReference for more information.
{{{#!div style="border: 1pt dotted; margin: 1em"
```
**Caveat:** don't confuse the //Trac environment directory// with the //source code repository directory//.
**Caveat:** don't confuse the //Trac environment directory// with the //source code repository directory//.
This is a common beginners' mistake.
This is a common beginners' mistake.
It happens that the structure for a Trac environment is loosely modeled after the Subversion repository directory structure, but those are two disjoint entities and they are not and //must not// be located at the same place.
It happens that the structure for a Trac environment is loosely modeled after the Subversion repository directory structure, but those are two disjoint entities and they are not and //must not// be located at the same place.
}}}
```
== Database Connection Strings
== Database Connection Strings
You will need to specify a database connection string at the time the environment is created. The default is SQLite, which is probably sufficient for most projects. The SQLite database file is stored in the environment directory, and can easily be [wiki:TracBackup backed up] together with the rest of the environment.
You will need to specify a database connection string at the time the environment is created. The default is SQLite, which is probably sufficient for most projects. The SQLite database file is stored in the environment directory, and can easily be [backed up](./TracBackup) together with the rest of the environment.
Note that if the username or password of the connection string (if applicable) contains the `:`, `/` or `@` characters, they need to be URL encoded.
Note that if the username or password of the connection string (if applicable) contains the `:`, `/` or `@` characters, they need to be URL encoded.
=== SQLite Connection String
=== SQLite Connection String
The connection string for an SQLite database is:
The connection string for an SQLite database is:
{{{
```
sqlite:db/trac.db
sqlite:db/trac.db
}}}
```
where `db/trac.db` is the path to the database file within the Trac environment.
where `db/trac.db` is the path to the database file within the Trac environment.
=== PostgreSQL Connection String
=== PostgreSQL Connection String
The connection string for PostgreSQL is a bit more complex. For example, to connect to a PostgreSQL database named `trac` on `localhost` for user `johndoe` and password `letmein`, use:
The connection string for PostgreSQL is a bit more complex. For example, to connect to a PostgreSQL database named `trac` on `localhost` for user `johndoe` and password `letmein`, use:
{{{
```
postgres://johndoe:letmein@localhost/trac
postgres://johndoe:letmein@localhost/trac
}}}
```
If PostgreSQL is running on a non-standard port, for example 9342, use:
If PostgreSQL is running on a non-standard port, for example 9342, use:
{{{
```
postgres://johndoe:letmein@localhost:9342/trac
postgres://johndoe:letmein@localhost:9342/trac
}}}
```
On UNIX, you might want to select a UNIX socket for the transport, either the default socket as defined by the PGHOST environment variable:
On UNIX, you might want to select a UNIX socket for the transport, either the default socket as defined by the PGHOST environment variable:
See the [http://www.postgresql.org/docs/ PostgreSQL documentation] for detailed instructions on how to administer [http://postgresql.org PostgreSQL].
See the [PostgreSQL documentation](http://www.postgresql.org/docs/) for detailed instructions on how to administer [PostgreSQL](http://postgresql.org).
Generally, the following is sufficient to create a database user named `tracuser` and a database named `trac`:
Generally, the following is sufficient to create a database user named `tracuser` and a database named `trac`:
{{{#!sh
```
$ createuser -U postgres -E -P tracuser
$ createuser -U postgres -E -P tracuser
$ createdb -U postgres -O tracuser -E UTF8 trac
$ createdb -U postgres -O tracuser -E UTF8 trac
}}}
```
When running `createuser` you will be prompted for the password for the user 'tracuser'. This new user will not be a superuser, will not be allowed to create other databases and will not be allowed to create other roles. These privileges are not needed to run a Trac instance. If no password is desired for the user, simply remove the `-P` and `-E` options from the `createuser` command. Also note that the database should be created as UTF8. LATIN1 encoding causes errors, because of Trac's use of unicode. SQL_ASCII also seems to work.
When running `createuser` you will be prompted for the password for the user 'tracuser'. This new user will not be a superuser, will not be allowed to create other databases and will not be allowed to create other roles. These privileges are not needed to run a Trac instance. If no password is desired for the user, simply remove the `-P` and `-E` options from the `createuser` command. Also note that the database should be created as UTF8. LATIN1 encoding causes errors, because of Trac's use of unicode. SQL_ASCII also seems to work.
Under some default configurations (Debian), run the `createuser` and `createdb` scripts as the `postgres` user:
Under some default configurations (Debian), run the `createuser` and `createdb` scripts as the `postgres` user:
The format of the MySQL connection string is similar to those for PostgreSQL, with the `postgres` scheme being replaced by `mysql`. For example, to connect to a MySQL database on `localhost` named `trac` for user `johndoe` with password `letmein`:
The format of the MySQL connection string is similar to those for PostgreSQL, with the `postgres` scheme being replaced by `mysql`. For example, to connect to a MySQL database on `localhost` named `trac` for user `johndoe` with password `letmein`:
{{{
```
mysql://johndoe:letmein@localhost:3306/trac
mysql://johndoe:letmein@localhost:3306/trac
}}}
```
== Source Code Repository
== Source Code Repository
A single environment can be connected to more than one repository. However, by default Trac is not connected to any source code repository, and the ''Browse Source'' navigation item will not be displayed.
A single environment can be connected to more than one repository. However, by default Trac is not connected to any source code repository, and the _Browse Source_ navigation item will not be displayed.
There are many different ways to connect repositories to an environment, see TracRepositoryAdmin. A single repository can be specified when the environment is created by passing the optional arguments `repository_type` and `repository_dir` to the `initenv` command.
There are many different ways to connect repositories to an environment, see TracRepositoryAdmin. A single repository can be specified when the environment is created by passing the optional arguments `repository_type` and `repository_dir` to the `initenv` command.
...
@@ -119,7 +119,7 @@ An environment consists of the following files and directories:
...
@@ -119,7 +119,7 @@ An environment consists of the following files and directories:
*`trac.db` - The SQLite database, if you are using SQLite.
*`trac.db` - The SQLite database, if you are using SQLite.
*`htdocs` - Directory containing web resources, which can be referenced in Genshi templates using `/chrome/site/...` URLs.
*`htdocs` - Directory containing web resources, which can be referenced in Genshi templates using `/chrome/site/...` URLs.
*`log` - Default directory for log files, if `file` logging is enabled and a relative path is given.
*`log` - Default directory for log files, if `file` logging is enabled and a relative path is given.