# Changes between Version 1 and Version 2 of TracEnvironment

Ignore:
Timestamp:
05/09/10 05:59:49 (12 years ago)
Comment:

--

### Legend:

Unmodified
 v1 == Creating an Environment == A new Trac environment is created using [wiki:TracAdmin trac-admin]: A new Trac environment is created using  [wiki:TracAdmin trac-admin]: {{{ $trac-admin /path/to/projectenv initenv$ trac-admin /path/to/myproject initenv }}} [wiki:TracAdmin trac-admin] will ask you for the name of the project, the database connection string (explained below), and the type and path to your source code repository. [wiki:TracAdmin trac-admin] will ask you for the name of the project and the database connection string (explained below). ''Note: The web server user will require file system write permission to ''Note: The user under which the web server runs will require file system write permission to the environment directory and all the files inside. Please remember to set the appropriate permissions. The same applies to the Subversion repository Trac is eventually using, although Trac will only require read access as long as you're not using the BDB file system.'' the appropriate permissions. The same applies to the source code repository, 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. Also, it seems that project names with spaces can be problematic for authentication (see [trac:#7163]).'' ''Note: "initenv" when using 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.'' == Database Connection Strings == Since version 0.9, Trac supports both [http://sqlite.org/ SQLite], [http://www.postgresql.org/ PostgreSQL] and [http://mysql.com/ MySQL] as database backends.  The default is to use SQLite, which is probably sufficient for most projects. The database file is then stored in the environment directory, and can easily be [wiki:TracBackup backed up] together with the rest of the environment. Since version 0.9, Trac supports both [http://sqlite.org/ SQLite] and [http://www.postgresql.org/ PostgreSQL] database backends.  Preliminary support for [http://mysql.com/ MySQL] was added in 0.10.  The default is to use SQLite, which is probably sufficient for most projects. The database file is then stored in the environment directory, and can easily be [wiki:TracBackup backed up] together with the rest of the environment. The connection string for an embedded SQLite database is: === SQLite Connection String === The connection string for an SQLite database is: {{{ sqlite:db/trac.db }}} where db/trac.db is the path to the database file within the Trac environment. === PostgreSQL Connection String === If you want to use PostgreSQL or MySQL instead, you'll have to use a different connection string. For example, to connect to a PostgreSQL postgres://johndoe:letmein@localhost/trac }}} ''Note that due to the way the above string is parsed, the "/" and "@" characters cannot be part of the password.'' If PostgreSQL is running on a non-standard port (for example 9342), use: }}} On UNIX, you might want to select a UNIX socket for the transport, either the default socket as defined by the PGHOST environment variable: {{{ postgres://user:password@/database }}} or a specific one: {{{ postgres://user:password@/database?host=/path/to/socket/dir }}} Note that with PostgreSQL you will have to create the database before running trac-admin initenv. And make sure PostgreSQl DB name is "trac". What worked for me: And didn't work uppercase trac-user-name See the [http://www.postgresql.org/docs/ PostgreSQL documentation] for detailed instructions on how to administer [http://postgresql.org PostgreSQL]. Generally, the following is sufficient to create a database user named tracuser, and a database named trac. {{{ sudo su - postgres -c createdb trac sudo su - postgres -c psql trac CREATE USER trac-user-name WITH PASSWORD 'trac-pass-name'; createuser -U postgres -E -P tracuser createdb -U postgres -O tracuser -E UTF8 trac }}} 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. Under some default configurations (debian) one will have run the createuser and createdb scripts as the postgres user.  For example: {{{ sudo su - postgres -c 'createuser -U postgres -S -D -R -E -P tracuser' sudo su - postgres -c 'createdb -U postgres -O tracuser -E UTF8 trac' }}} (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.) Trac uses the public schema by default but you can specify a different schema in the connection string: {{{ postgres://user:pass@server/database?schema=yourschemaname }}} === MySQL Connection String === If you want to use MySQL instead, you'll have to use a different connection string. For example, to connect to a MySQL database on the same machine called trac, that allows access to the user johndoe with the password letmein, the mysql connection string is: {{{ mysql://johndoe:letmein@localhost:3306/trac }}} == Source Code Repository == You'll first have to provide the ''type'' of your repository (e.g. svn for Subversion, which is the default), then the ''path'' where the repository is located. Since version 0.12, a single Trac environment can be connected to more than one repository. There are many different ways to connect repositories to an environment, see TracRepositoryAdmin. This page also details the various attributes that can be set for a repository (like type, url, description). If you don't want to use Trac with a source code repository, simply leave the ''path'' empty (the ''type'' information doesn't matter, then). In Trac 0.12 trac-admin no longer asks questions related to repositories. Therefore, by default Trac is not connected to any source code repository, and the ''Browse Source'' toolbar item will not be displayed. You can also explicitly disable the trac.versioncontrol.* components (which are otherwise still loaded) {{{ [components] trac.versioncontrol.* = disabled }}} For some systems, it is possible to specify not only the path to the repository, For some version control systems, it is possible to specify not only the path to the repository, but also a ''scope'' within the repository. Trac will then only show information related to the files and changesets below that scope. The Subversion backend for Trac supports this; for other types, check the corresponding plugin's documentation. Example of a configuration for a Subversion repository: Example of a configuration for a Subversion repository used as the default repository: {{{ [trac] * db * trac.db - The SQLite database (if you're using SQLite). * plugins - Environment-specific [wiki:TracPlugins plugins] (Python eggs) * templates - Custom environment-specific templates. * site_css.cs - Custom CSS rules. * site_footer.cs - Custom page footer. * site_header.cs - Custom page header. * wiki-macros - Environment-specific [wiki:WikiMacros Wiki macros]. * htdocs - directory containing web resources, which can be referenced in Genshi templates. '''''(since 0.11)''''' * log - default directory for log files, if logging is turned on and a relative path is given. * plugins - Environment-specific [wiki:TracPlugins plugins] (Python eggs or single file plugins, since [trac:milestone:0.10 0.10]) * templates - Custom Genshi environment-specific templates. '''''(since 0.11)''''' * site.html - method to customize header, footer, and style, described in TracInterfaceCustomization#SiteAppearance '''Note: don't confuse a Trac environment directory with the source code repository directory. It happens that the above structure is loosely modelled after the Subversion repository directory structure, but they are not and ''must not'' be located at the same place.''' '''Caveat:''' ''don't confuse a Trac environment directory with the source code repository directory.'' This is a common beginners' mistake. It happens that the structure for a Trac environment is loosely modelled after the Subversion repository directory structure, but those are two disjoint entities and they are not and ''must not'' be located at the same place. ---- See also: TracAdmin, TracBackup, TracIni, TracGuide