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