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. |
| 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. |
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' |
| 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'; |
80 | | Trac uses the `public` schema by default but you can specify a different schema in the connection string: |
81 | | {{{ |
82 | | postgres://user:pass@server/database?schema=yourschemaname |
83 | | }}} |
84 | | |
85 | | === MySQL Connection String === |
86 | | |
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: |
91 | | {{{ |
92 | | mysql://johndoe:letmein@localhost:3306/trac |
93 | | }}} |
| 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.) |
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 Genshi environment-specific templates. '''''(0.11 only)''''' |
137 | | * `site.html` - method to customize header, footer, and style, described in TracInterfaceCustomization#SiteAppearance |
138 | | * ''`templates` - Custom [trac:ClearSilver ClearSilver] environment-specific templates. '''(0.10 only)''' '' |
139 | | * ''`site_css.cs` - Custom CSS rules.'' |
140 | | * ''`site_footer.cs` - Custom page footer.'' |
141 | | * ''`site_header.cs` - Custom page header.'' |
142 | | * ''`wiki-macros` - Environment-specific [WikiMacros Wiki macros]. '''(0.10 only)''' '' |
| 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]. |