|   | 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  |