24 | | Since version 0.9, Trac supports both [http://sqlite.org/ SQLite], |
25 | | [http://www.postgresql.org/ PostgreSQL] and [http://mysql.com/ MySQL] as |
26 | | database backends. The default is to use SQLite, which is probably sufficient |
27 | | for most projects. The database file is then stored in the environment |
28 | | directory, and can easily be [wiki:TracBackup backed up] together with the |
29 | | rest of the environment. |
| 23 | - The user under which the web server runs will require file system write permission to the environment directory and all the files inside. Please remember to set the appropriate permissions. The same applies to the source code repository, although the user under which Trac runs will only require write access to a Subversion repository created with the BDB file system; for other repository types, check the corresponding plugin's documentation. |
| 24 | |
| 25 | - `initenv` does not create a version control repository for the specified path. If you wish to specify a default repository using the optional arguments to `initenv` you must create the repository first, otherwise you will see a message when initializing the environment: //Warning: couldn't index the default repository//. |
31 | | The connection string for an embedded SQLite database is: |
| 27 | - Non-ascii environment paths are not supported. |
| 28 | |
| 29 | - TracPlugins located in a [TracIni#inherit-plugins_dir-option shared plugins directory] that is defined in an [TracIni#GlobalConfiguration inherited configuration] are not enabled by default, in contrast to plugins in the environment `plugins` directory. Hence, if they need to create extra tables, for example, the tables will not be created during environment creation and you'll need to [TracUpgrade#UpgradetheTracEnvironment upgrade the environment]. Alternatively you can avoid the need to upgrade the environment by explicitly enabling the plugin in the inherited configuration, or in a configuration file using the `--config` option. See TracAdmin#FullCommandReference for more information. |
| 30 | |
| 31 | {{{#!div style="border: 1pt dotted; margin: 1em;" |
| 32 | **Caveat:** don't confuse the //Trac environment directory// with the //source code repository directory//. |
| 33 | |
| 34 | This is a common beginners' mistake. |
| 35 | 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. |
| 36 | }}} |
| 37 | |
| 38 | == Database Connection Strings |
| 39 | |
| 40 | You will need to specify a database connection string at the time the environment is created. The default is SQLite, which is 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. |
| 41 | |
| 42 | Note that if the username or password of the connection string (if applicable) contains the `:`, `/` or `@` characters, they need to be [http://meyerweb.com/eric/tools/dencoder/ URL encoded]. |
| 43 | {{{#!sh |
| 44 | $ python -c "import urllib; print urllib.quote('password@:/123', '')" |
| 45 | password%40%3A%2F123 |
| 46 | }}} |
| 47 | |
| 48 | === SQLite Connection String |
| 49 | |
| 50 | The connection string for an SQLite database is: |
36 | | If you want to use PostgreSQL or MySQL instead, you'll have to use a |
37 | | different connection string. For example, to connect to a PostgreSQL |
38 | | database on the same machine called `trac`, that allows access to the |
39 | | user `johndoe` with the password `letmein`, use: |
| 56 | See [trac:DatabaseBackend#SQLite] for more information. |
| 57 | |
| 58 | === PostgreSQL Connection String |
| 59 | |
| 60 | 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: |
60 | | (Just to remind you, if you don't have a sudo/su setup, you just need to do the createdb and psql statements. That threw me the first couple of times I read this.) |
61 | | |
62 | | == Source Code Repository == |
63 | | |
64 | | You'll first have to provide the ''type'' of your repository (e.g. `svn` for Subversion, |
65 | | which is the default), then the ''path'' where the repository is located. |
66 | | |
67 | | If you don't want to use Trac with a source code repository, simply leave the ''path'' empty |
68 | | (the ''type'' information doesn't matter, then). |
69 | | |
70 | | For some systems, it is possible to specify not only the path to the repository, |
71 | | but also a ''scope'' within the repository. Trac will then only show information |
72 | | related to the files and changesets below that scope. The Subversion backend for |
73 | | Trac supports this; for other types, check the corresponding plugin's documentation. |
74 | | |
75 | | Example of a configuration for a Subversion repository: |
| 75 | or a specific one: |
91 | | An environment directory will usually consist of the following files and directories: |
| 89 | Under some default configurations (Debian), run the `createuser` and `createdb` scripts as the `postgres` user: |
| 90 | {{{#!sh |
| 91 | $ sudo su - postgres -c 'createuser -U postgres -S -D -R -E -P tracuser' |
| 92 | $ sudo su - postgres -c 'createdb -U postgres -O tracuser -E UTF8 trac' |
| 93 | }}} |
| 94 | |
| 95 | Trac uses the `public` schema by default, but you can specify a different schema in the connection string: |
| 96 | {{{ |
| 97 | postgres://user:pass@server/database?schema=yourschemaname |
| 98 | }}} |
| 99 | |
| 100 | === MySQL Connection String |
| 101 | |
| 102 | The format of the MySQL connection string is similar to 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`: |
| 103 | {{{ |
| 104 | mysql://johndoe:letmein@localhost:3306/trac |
| 105 | }}} |
| 106 | |
| 107 | == Source Code Repository |
| 108 | |
| 109 | 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. |
| 110 | |
| 111 | There are several 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. |
| 112 | |
| 113 | == Directory Structure |
| 114 | |
| 115 | An environment consists of the following files and directories: |
99 | | * `trac.db` - The SQLite database (if you're using SQLite). |
100 | | * `plugins` - Environment-specific [wiki:TracPlugins plugins] (Python eggs) |
101 | | * `templates` - Custom environment-specific templates. |
102 | | * `site_css.cs` - Custom CSS rules. |
103 | | * `site_footer.cs` - Custom page footer. |
104 | | * `site_header.cs` - Custom page header. |
105 | | * `wiki-macros` - Environment-specific [wiki:WikiMacros Wiki macros]. |
106 | | |
107 | | '''Note: don't confuse a Trac environment directory with the source code repository directory. |
108 | | It happens that the above structure is loosely modelled after the Subversion repository directory |
109 | | structure, but they are not and ''must not'' be located at the same place.''' |
| 124 | * `trac.db` - The SQLite database, if you are using SQLite. |
| 125 | * `htdocs` - Directory containing web resources, which can be referenced in templates using the path `/chrome/site/...`. |
| 126 | * `log` - Default directory for log files when `file` logging is enabled and a relative path is given. |
| 127 | * `plugins` - Environment-specific [wiki:TracPlugins plugins]. |
| 128 | * `templates` - Custom Genshi environment-specific templates. |
| 129 | * `site.html` - Method to [TracInterfaceCustomization#SiteAppearance customize] the site header, footer, and style. |