16 | | ''Note: The web server user will require file system write permission to |
17 | | the environment directory and all the files inside. Please remember to set |
18 | | the appropriate permissions. The same applies to the Subversion repository |
19 | | Trac is eventually using, although Trac will only require read access as long |
20 | | as you're not using the BDB file system.'' |
| 15 | === Some Useful Tips |
| 16 | - The user under which the web server runs will require file system write permission to |
| 17 | the environment directory and all the files inside. Please remember to set |
| 18 | the appropriate permissions. The same applies to the source code repository, |
| 19 | 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. |
| 20 | |
| 21 | - `initenv`, when using an svn repository, does not imply that trac-admin will perform `svnadmin create` for the specified repository path. You need to perform the `svnadmin create` prior to `trac-admin initenv` if you're creating a new svn repository altogether with a new trac environment, otherwise you will see a message "Warning: couldn't index the repository" when initializing the environment. |
| 22 | |
| 23 | - Non-ascii environment paths are not supported |
| 24 | |
| 25 | - Also, it seems that project names with spaces can be problematic for authentication (see [trac:#7163]). |
| 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] before being able to use it. |
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. |
| 31 | Since version 0.9, Trac supports both [http://sqlite.org/ SQLite] and |
| 32 | [http://www.postgresql.org/ PostgreSQL] database backends. Preliminary |
| 33 | support for [http://mysql.com/ MySQL] was added in 0.10. The default is |
| 34 | to use SQLite, which is probably sufficient for most projects. The database |
| 35 | file is then stored in the environment directory, and can easily be |
| 36 | [wiki:TracBackup backed up] together with the rest of the environment. |
55 | | sudo su - postgres -c createdb trac |
56 | | sudo su - postgres -c psql trac |
57 | | CREATE USER trac-user-name WITH PASSWORD 'trac-pass-name'; |
| 76 | createuser -U postgres -E -P tracuser |
| 77 | createdb -U postgres -O tracuser -E UTF8 trac |
| 78 | }}} |
| 79 | 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. |
| 80 | |
| 81 | Under some default configurations (debian) one will have run the `createuser` and `createdb` scripts as the `postgres` user. For example: |
| 82 | {{{ |
| 83 | sudo su - postgres -c 'createuser -U postgres -S -D -R -E -P tracuser' |
| 84 | sudo su - postgres -c 'createdb -U postgres -O tracuser -E UTF8 trac' |
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.) |
| 87 | Trac uses the `public` schema by default but you can specify a different schema in the connection string: |
| 88 | {{{ |
| 89 | postgres://user:pass@server/database?schema=yourschemaname |
| 90 | }}} |
| 91 | |
| 92 | === MySQL Connection String === |
| 93 | |
| 94 | If you want to use MySQL instead, you'll have to use a |
| 95 | different connection string. For example, to connect to a MySQL |
| 96 | database on the same machine called `trac`, that allows access to the |
| 97 | user `johndoe` with the password `letmein`, the mysql connection string is: |
| 98 | {{{ |
| 99 | mysql://johndoe:letmein@localhost:3306/trac |
| 100 | }}} |
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]. |
| 143 | * `htdocs` - directory containing web resources, which can be referenced in Genshi templates using `/htdocs/site/...` URLs. ''(since 0.11)'' |
| 144 | * `log` - default directory for log files, if logging is turned on and a relative path is given. |
| 145 | * `plugins` - Environment-specific [wiki:TracPlugins plugins] (Python eggs or single file plugins, since [trac:milestone:0.10 0.10]) |
| 146 | * `templates` - Custom Genshi environment-specific templates. ''(since 0.11)'' |
| 147 | * `site.html` - method to customize header, footer, and style, described in TracInterfaceCustomization#SiteAppearance |
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.''' |
| 149 | '''Caveat:''' ''don't confuse a Trac environment directory with the source code repository directory.'' |
| 150 | |
| 151 | This is a common beginners' mistake. |
| 152 | It happens that the structure for a Trac environment is loosely modelled after the Subversion repository directory |
| 153 | structure, but those are two disjoint entities and they are not and ''must not'' be located at the same place. |