| 42 | | * '''README''' - Brief description of the environment. |
| 43 | | * '''VERSION''' - Contains the environment version identifier. |
| 44 | | * '''attachments''' - All attached files go in here. |
| 45 | | * '''ticket''' - Ticket attachments. |
| 46 | | * '''wiki''' - Wiki attachments. |
| 47 | | * '''conf''' |
| 48 | | * '''trac.ini''' - Main configuration file. See TracIni. |
| 49 | | * '''db''' |
| 50 | | * '''trac.db''' - SQLite database. |
| 51 | | * '''templates''' - Custom (environment-specific) templates. |
| 52 | | * '''site_css.cs''' - Custom CSS stylesheet. |
| 53 | | * '''site_footer.cs''' - Custom footer. |
| 54 | | * '''site_header.cs''' - Custom header. |
| 55 | | * '''wiki-macros''' - Environment-specific WikiMacros. |
| | 39 | == Database Connection Strings |
| | 40 | |
| | 41 | 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. |
| | 42 | |
| | 43 | Note that if the username or password of the connection string (if applicable) contains the `:`, `/` or `@` characters, they need to be URL encoded. |
| | 44 | |
| | 45 | === SQLite Connection String |
| | 46 | |
| | 47 | The connection string for an SQLite database is: |
| | 48 | {{{ |
| | 49 | sqlite:db/trac.db |
| | 50 | }}} |
| | 51 | where `db/trac.db` is the path to the database file within the Trac environment. |
| | 52 | |
| | 53 | === PostgreSQL Connection String |
| | 54 | |
| | 55 | 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: |
| | 56 | {{{ |
| | 57 | postgres://johndoe:letmein@localhost/trac |
| | 58 | }}} |
| | 59 | |
| | 60 | If PostgreSQL is running on a non-standard port, for example 9342, use: |
| | 61 | {{{ |
| | 62 | postgres://johndoe:letmein@localhost:9342/trac |
| | 63 | }}} |
| | 64 | |
| | 65 | On UNIX, you might want to select a UNIX socket for the transport, either the default socket as defined by the PGHOST environment variable: |
| | 66 | {{{ |
| | 67 | postgres://user:password@/database |
| | 68 | }}} |
| | 69 | |
| | 70 | or a specific one: |
| | 71 | {{{ |
| | 72 | postgres://user:password@/database?host=/path/to/socket/dir |
| | 73 | }}} |
| | 74 | |
| | 75 | See the [http://www.postgresql.org/docs/ PostgreSQL documentation] for detailed instructions on how to administer [http://postgresql.org PostgreSQL]. |
| | 76 | Generally, the following is sufficient to create a database user named `tracuser` and a database named `trac`: |
| | 77 | {{{#!sh |
| | 78 | $ createuser -U postgres -E -P tracuser |
| | 79 | $ createdb -U postgres -O tracuser -E UTF8 trac |
| | 80 | }}} |
| | 81 | |
| | 82 | 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. |
| | 83 | |
| | 84 | Under some default configurations (Debian), run the `createuser` and `createdb` scripts as the `postgres` user: |
| | 85 | {{{#!sh |
| | 86 | $ sudo su - postgres -c 'createuser -U postgres -S -D -R -E -P tracuser' |
| | 87 | $ sudo su - postgres -c 'createdb -U postgres -O tracuser -E UTF8 trac' |
| | 88 | }}} |
| | 89 | |
| | 90 | Trac uses the `public` schema by default, but you can specify a different schema in the connection string: |
| | 91 | {{{ |
| | 92 | postgres://user:pass@server/database?schema=yourschemaname |
| | 93 | }}} |
| | 94 | |
| | 95 | === MySQL Connection String |
| | 96 | |
| | 97 | 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`: |
| | 98 | {{{ |
| | 99 | mysql://johndoe:letmein@localhost:3306/trac |
| | 100 | }}} |
| | 101 | |
| | 102 | == Source Code Repository |
| | 103 | |
| | 104 | 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. |
| | 105 | |
| | 106 | 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. |
| | 107 | |
| | 108 | == Directory Structure |
| | 109 | |
| | 110 | An environment consists of the following files and directories: |
| | 111 | |
| | 112 | * `README` - Brief description of the environment. |
| | 113 | * `VERSION` - Environment version identifier. |
| | 114 | * `files` |
| | 115 | * `attachments` - Attachments to wiki pages and tickets. |
| | 116 | * `conf` |
| | 117 | * `trac.ini` - Main configuration file. See TracIni. |
| | 118 | * `db` |
| | 119 | * `trac.db` - The SQLite database, if you are using SQLite. |
| | 120 | * `htdocs` - Directory containing web resources, which can be referenced in Genshi templates using `/chrome/site/...` URLs. |
| | 121 | * `log` - Default directory for log files, if `file` logging is enabled and a relative path is given. |
| | 122 | * `plugins` - Environment-specific [wiki:TracPlugins plugins]. |
| | 123 | * `templates` - Custom Genshi environment-specific templates. |
| | 124 | * `site.html` - Method to customize header, footer, and style, described in TracInterfaceCustomization#SiteAppearance. |
