25 | | Since version 0.9, Trac supports both [http://sqlite.org/ SQLite] and |
26 | | [http://www.postgresql.org/ PostgreSQL] database backends. Preliminary |
27 | | support for [http://mysql.com/ MySQL] was added in 0.10. The default is |
28 | | to use SQLite, which is probably sufficient for most projects. The database |
29 | | file is then stored in the environment directory, and can easily be |
30 | | [wiki:TracBackup backed up] together with the rest of the environment. |
| 21 | - 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. |
| 22 | |
| 23 | - `initenv` does not create a version control repository for the specified path. If you wish to specify a default repository using optional the 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//. |
32 | | === Embedded SQLite Connection String === |
33 | | The connection string for an embedded SQLite database is: |
| 25 | - Non-ascii environment paths are not supported. |
| 26 | |
| 27 | - TracPlugins located in a [TracIni#inherit-section shared plugins folder] that is defined in an [TracIni#GlobalConfiguration inherited configuration] are currently not loaded during creation, and hence, if they need to create extra tables for example, you'll need to [TracUpgrade#UpgradetheTracEnvironment upgrade the environment]. |
| 28 | |
| 29 | {{{#!div style="border: 1pt dotted; margin: 1em" |
| 30 | **Caveat:** don't confuse the //Trac environment directory// with the //source code repository directory//. |
| 31 | |
| 32 | This is a common beginners' mistake. |
| 33 | It happens that the structure for a Trac environment is loosely modelled 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. |
| 34 | }}} |
| 35 | |
| 36 | == Database Connection Strings |
| 37 | |
| 38 | Trac supports [http://sqlite.org/ SQLite], [http://www.postgresql.org/ PostgreSQL] and [http://mysql.com/ MySQL] database backends. The default is SQLite, which is probably sufficient for most projects. The database file is then stored in the environment directory, and can easily be [wiki:TracBackup backed up] together with the rest of the environment. |
| 39 | |
| 40 | Note that if the username or password of the connection string (if applicable) contains the `:`, `/` or `@` characters, they need to be URL encoded. |
| 41 | |
| 42 | === SQLite Connection String |
| 43 | |
| 44 | The connection string for an SQLite database is: |
38 | | === PostgreSQL Connection String === |
39 | | If you want to use PostgreSQL or MySQL instead, you'll have to use a |
40 | | different connection string. For example, to connect to a PostgreSQL |
41 | | database on the same machine called `trac`, that allows access to the |
42 | | user `johndoe` with the password `letmein`, use: |
| 50 | === PostgreSQL Connection String |
| 51 | |
| 52 | If you want to use PostgreSQL instead, you'll have to use a different connection string. For example, to connect to a PostgreSQL database on the same machine called `trac` for user `johndoe` with the password `letmein` use: |
67 | | Generally, the following is sufficient to create a database user named `tracuser`, and a database named `trac`. |
68 | | {{{ |
69 | | createuser -U postgres -E -P tracuser |
70 | | createdb -U postgres -O tracuser -E UTF8 trac |
71 | | }}} |
72 | | 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 trac's use of unicode in trac. SQL_ASCII also seems to work. |
73 | | |
74 | | Under some default configurations (debian) one will have run the `createuser` and `createdb` scripts as the `postgres` user. For example: |
75 | | {{{ |
76 | | sudo su - postgres -c 'createuser -U postgres -S -D -R -E -P tracuser' |
77 | | sudo su - postgres -c 'createdb -U postgres -O tracuser -E UTF8 trac' |
| 75 | Generally, the following is sufficient to create a database user named `tracuser` and a database named `trac`: |
| 76 | {{{#!sh |
| 77 | $ createuser -U postgres -E -P tracuser |
| 78 | $ createdb -U postgres -O tracuser -E UTF8 trac |
80 | | Trac uses the `public` schema by default but you can specify a different schema in the connection string: |
| 81 | 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. |
| 82 | |
| 83 | Under some default configurations (Debian), run the `createuser` and `createdb` scripts as the `postgres` user: |
| 84 | {{{#!sh |
| 85 | $ sudo su - postgres -c 'createuser -U postgres -S -D -R -E -P tracuser' |
| 86 | $ sudo su - postgres -c 'createdb -U postgres -O tracuser -E UTF8 trac' |
| 87 | }}} |
| 88 | |
| 89 | Trac uses the `public` schema by default, but you can specify a different schema in the connection string: |
87 | | If you want to use MySQL instead, you'll have to use a |
88 | | different connection string. For example, to connect to a MySQL |
89 | | database on the same machine called `trac`, that allows access to the |
90 | | user `johndoe` with the password `letmein`, the mysql connection string is: |
| 96 | 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 the same machine called `trac` for user `johndoe` with password `letmein`: |
103 | | For some systems, it is possible to specify not only the path to the repository, |
104 | | but also a ''scope'' within the repository. Trac will then only show information |
105 | | related to the files and changesets below that scope. The Subversion backend for |
106 | | Trac supports this; for other types, check the corresponding plugin's documentation. |
| 112 | For some version control systems, it is possible to specify not only the path to the repository, but also a ''scope'' within the repository. Trac will then only show information related to the files and changesets below that scope. The Subversion backend for Trac supports this. For other types, check the corresponding plugin's documentation. |
132 | | * `trac.db` - The SQLite database (if you're using SQLite). |
133 | | * `htdocs` - directory containing web resources, which can be referenced in Genshi templates. '''''(0.11 only)''''' |
134 | | * `log` - default directory for log files, if logging is turned on and a relative path is given. |
135 | | * `plugins` - Environment-specific [wiki:TracPlugins plugins] (Python eggs, since [trac:milestone:0.10 0.10]) |
136 | | * `templates` - Custom [trac:ClearSilver ClearSilver] environment-specific templates. '''''(0.10 only)''''' |
137 | | * `site_css.cs` - Custom CSS rules. |
138 | | * `site_footer.cs` - Custom page footer. |
139 | | * `site_header.cs` - Custom page header. |
140 | | * `templates` - Custom Genshi environment-specific templates. '''''(0.11 only)''''' |
141 | | * `site.html` - method to customize header, footer, and style, described in TracInterfaceCustomization#SiteAppearance |
142 | | * `wiki-macros` - Environment-specific [WikiMacros Wiki macros]. '''''(0.10 only)''''' |
143 | | |
144 | | '''Note: don't confuse a Trac environment directory with the source code repository directory. |
145 | | It happens that the above structure is loosely modelled after the Subversion repository directory |
146 | | structure, but they are not and ''must not'' be located at the same place.''' |
| 139 | * `trac.db` - The SQLite database, if you are using SQLite. |
| 140 | * `htdocs` - Directory containing web resources, which can be referenced in Genshi templates using `/chrome/site/...` URLs. |
| 141 | * `log` - Default directory for log files, if `file` logging is enabled and a relative path is given. |
| 142 | * `plugins` - Environment-specific [wiki:TracPlugins plugins]. |
| 143 | * `templates` - Custom Genshi environment-specific templates. |
| 144 | * `site.html` - Method to customize header, footer, and style, described in TracInterfaceCustomization#SiteAppearance. |