|   | 1 | = Trac Storage - The Environment = | 
                  
                          |   | 2 |  | 
                  
                          |   | 3 | Trac uses a directory structure and a database for storing project data. | 
                  
                          |   | 4 |  | 
                  
                          |   | 5 | == Creating an Environment == | 
                  
                          |   | 6 |  | 
                  
                          |   | 7 | A new Trac environment is created using [wiki:TracAdmin trac-admin]: | 
                  
                          |   | 8 | {{{ | 
                  
                          |   | 9 | $ trac-admin /path/to/projectenv initenv | 
                  
                          |   | 10 | }}} | 
                  
                          |   | 11 |  | 
                  
                          |   | 12 | [wiki:TracAdmin trac-admin] will ask you for the name of the project, the | 
                  
                          |   | 13 | database connection string (explained below), and where your subversion | 
                  
                          |   | 14 | repository is located. | 
                  
                          |   | 15 |  | 
                  
                          |   | 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 | 
                  
                          |   | 19 | repository, although Trac will only require read access as long as you're | 
                  
                          |   | 20 | not using the BDB file system.'' | 
                  
                          |   | 21 |  | 
                  
                          |   | 22 | == Database Connection Strings == | 
                  
                          |   | 23 |  | 
                  
                          |   | 24 | Since version 0.9, Trac supports both [http://sqlite.org/ SQLite] and | 
                  
                          |   | 25 | [http://www.postgresql.org/ PostgreSQL] as database backends.  The default | 
                  
                          |   | 26 | is to use SQLite, which is probably sufficient for most projects. The database file | 
                  
                          |   | 27 | is then stored in the environment directory, and can easily be | 
                  
                          |   | 28 | [wiki:TracBackup backed up] together with the rest of the environment. | 
                  
                          |   | 29 |  | 
                  
                          |   | 30 | The connection string for an embedded SQLite database is: | 
                  
                          |   | 31 | {{{ | 
                  
                          |   | 32 | sqlite:db/trac.db | 
                  
                          |   | 33 | }}} | 
                  
                          |   | 34 |  | 
                  
                          |   | 35 | If you want to use PostgreSQL instead, you'll have to use a different | 
                  
                          |   | 36 | connection string. For example, to connect to a database on the same | 
                  
                          |   | 37 | machine called `trac`, that allows access to the user `johndoe` with | 
                  
                          |   | 38 | the password `letmein`, use: | 
                  
                          |   | 39 | {{{ | 
                  
                          |   | 40 | postgres://johndoe:letmein@localhost/trac | 
                  
                          |   | 41 | }}} | 
                  
                          |   | 42 |  | 
                  
                          |   | 43 | If PostgreSQL is running on a non-standard port (for example 9342), use: | 
                  
                          |   | 44 | {{{ | 
                  
                          |   | 45 | postgres://johndoe:letmein@localhost:9342/trac | 
                  
                          |   | 46 | }}} | 
                  
                          |   | 47 |  | 
                  
                          |   | 48 | Note that with PostgreSQL you will have to create the database before running | 
                  
                          |   | 49 | `trac-admin initenv`. | 
                  
                          |   | 50 |  | 
                  
                          |   | 51 | == Directory Structure == | 
                  
                          |   | 52 |  | 
                  
                          |   | 53 | An environment directory will usually consist of the following files and directories: | 
                  
                          |   | 54 |  | 
                  
                          |   | 55 |  * `README` - Brief description of the environment. | 
                  
                          |   | 56 |  * `VERSION` - Contains the environment version identifier. | 
                  
                          |   | 57 |  * `attachments` - Attachments to wiki pages and tickets are stored here. | 
                  
                          |   | 58 |  * `conf` | 
                  
                          |   | 59 |    * `trac.ini` - Main configuration file. See TracIni. | 
                  
                          |   | 60 |  * `db` | 
                  
                          |   | 61 |    * `trac.db` - The SQLite database (if you're using SQLite). | 
                  
                          |   | 62 |  * `plugins` - Environment-specific [wiki:TracPlugins plugins] (Python eggs) | 
                  
                          |   | 63 |  * `templates` - Custom environment-specific templates. | 
                  
                          |   | 64 |    * `site_css.cs` - Custom CSS rules. | 
                  
                          |   | 65 |    * `site_footer.cs` - Custom page footer. | 
                  
                          |   | 66 |    * `site_header.cs` - Custom page header. | 
                  
                          |   | 67 |  * `wiki-macros` - Environment-specific [wiki:WikiMacros Wiki macros]. | 
                  
                          |   | 68 |  | 
                  
                          |   | 69 | ---- | 
                  
                          |   | 70 | See also: TracAdmin, TracBackup, TracIni, TracGuide |