Changes between Version 1 and Version 2 of TracEnvironment


Ignore:
Timestamp:
Apr 9, 2008, 4:17:47 PM (17 years ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TracEnvironment

    v1 v2  
    1 = Trac Storage - The Environment =
    2 Trac uses a directory structure and an embedded [http://www.sqlite.org/ SQLite] database as storage.
     1= The Trac Environment =
     2
     3Trac uses a directory structure and a database for storing project data. The directory is referred to as the “environment”.
    34
    45== Creating an Environment ==
    5 A new Trac environment is created using [wiki:TracAdmin trac-admin], like:
    66
     7A new Trac environment is created using  [wiki:TracAdmin trac-admin]:
    78{{{
    8 $ trac-admin /path/to/projectenv initenv
     9$ trac-admin /path/to/myproject initenv
    910}}}
    1011
    11 [wiki:TracAdmin trac-admin] will ask you where your subversion repository is located and
    12 where it can find the trac templates directory (the default value should work for a typical install).
     12[wiki:TracAdmin trac-admin] will ask you for the name of the project, the
     13database connection string (explained below), and the type and path to
     14your source code repository.
    1315
    14 '''Note:''' The web server user will require file system write permission to the environment
    15 directory and all the files inside. '''Remember to set the appropriate permissions.''
     16''Note: The web server user will require file system write permission to
     17the environment directory and all the files inside. Please remember to set
     18the appropriate permissions. The same applies to the Subversion repository
     19Trac is eventually using, although Trac will only require read access as long
     20as you're not using the BDB file system.''
    1621
    17 The same applies for the subversion repository files (unless using the [http://svn.collab.net/repos/svn/trunk/notes/fsfs FSFS Subversion backend], something we highly recommend.
     22== Database Connection Strings ==
    1823
     24Since version 0.9, Trac supports both [http://sqlite.org/ SQLite] and
     25[http://www.postgresql.org/ PostgreSQL] database backends.  Preliminary
     26support for [http://mysql.com/ MySQL] was added in 0.10.  The default is
     27to use SQLite, which is probably sufficient for most projects. The database
     28file is then stored in the environment directory, and can easily be
     29[wiki:TracBackup backed up] together with the rest of the environment.
    1930
     31=== Embedded SQLite Connection String ===
     32The connection string for an embedded SQLite database is:
     33{{{
     34sqlite:db/trac.db
     35}}}
     36
     37=== PostgreSQL Connection String ===
     38If you want to use PostgreSQL or MySQL instead, you'll have to use a
     39different connection string. For example, to connect to a PostgreSQL
     40database on the same machine called `trac`, that allows access to the
     41user `johndoe` with the password `letmein`, use:
     42{{{
     43postgres://johndoe:letmein@localhost/trac
     44}}}
     45''Note that due to the way the above string is parsed, the "/" and "@" characters cannot be part of the password.''
     46
     47If PostgreSQL is running on a non-standard port (for example 9342), use:
     48{{{
     49postgres://johndoe:letmein@localhost:9342/trac
     50}}}
     51
     52On UNIX, you might want to select a UNIX socket for the transport,
     53either the default socket as defined by the PGHOST environment variable:
     54{{{
     55postgres://user:password@/database
     56}}}
     57or a specific one:
     58{{{
     59postgres://user:password@/database?host=/path/to/socket/dir
     60}}}
     61
     62Note that with PostgreSQL you will have to create the database before running
     63`trac-admin initenv`.
     64
     65See the [http://www.postgresql.org/docs/ PostgreSQL documentation] for detailed instructions on how to administer [http://postgresql.org PostgreSQL].
     66Generally, the following is sufficient to create a database user named `tracuser`, and a database named `trac`.
     67{{{
     68createuser -U postgres -E -P tracuser
     69createdb -U postgres -O tracuser -E UTF8 trac
     70}}}
     71When 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.
     72
     73Under some default configurations (debian) one will have run the `createuser` and `createdb` scripts as the `postgres` user.  For example:
     74{{{
     75sudo su - postgres -c 'createuser -U postgres -S -D -R -E -P tracuser'
     76sudo su - postgres -c 'createdb -U postgres -O tracuser -E UTF8 trac'
     77}}}
     78
     79Trac uses the `public` schema by default but you can specify a different schema in the connection string:
     80{{{
     81postgres://user:pass@server/database?schema=yourschemaname
     82}}}
     83
     84=== MySQL Connection String ===
     85
     86If you want to use MySQL instead, you'll have to use a
     87different connection string. For example, to connect to a MySQL
     88database on the same machine called `trac`, that allows access to the
     89user `johndoe` with the password `letmein`, the mysql connection string is:
     90{{{
     91mysql://johndoe:letmein@localhost:3306/trac
     92}}}
     93
     94== Source Code Repository ==
     95
     96You'll first have to provide the ''type'' of your repository (e.g. `svn` for Subversion,
     97which is the default), then the ''path'' where the repository is located.
     98
     99If you don't want to use Trac with a source code repository, simply leave the ''path'' empty
     100(the ''type'' information doesn't matter, then).
     101
     102For some systems, it is possible to specify not only the path to the repository,
     103but also a ''scope'' within the repository. Trac will then only show information
     104related to the files and changesets below that scope. The Subversion backend for
     105Trac supports this; for other types, check the corresponding plugin's documentation.
     106
     107Example of a configuration for a Subversion repository:
     108{{{
     109[trac]
     110repository_type = svn
     111repository_dir = /path/to/your/repository
     112}}}
     113
     114The configuration for a scoped Subversion repository would be:
     115{{{
     116[trac]
     117repository_type = svn
     118repository_dir = /path/to/your/repository/scope/within/repos
     119}}}
    20120
    21121== Directory Structure ==
    22 {{{
    23  EnvDir
    24    |-- README
    25    |-- VERSION
    26    |-- attachments
    27    |   |-- ticket
    28    |   `-- wiki
    29    |-- conf
    30    |   `-- trac.ini
    31    |-- db
    32    |   `-- trac.db
    33    |-- log
    34    |   `-- trac.log
    35    |-- templates
    36    |   |-- site_css.cs
    37    |   |-- site_footer.cs
    38    |   `-- site_header.cs
    39    `-- wiki-macros
    40 }}}
    41122
    42  * '''README''' - Brief description of the environment.
    43  * '''VERSION''' - Contains the environment version identifier.
    44  * '''attachments''' - All attached files go in here.
    45    * '''ticket''' - Ticket attachments.
    46    * '''wiki''' - Wiki attachments.
    47  * '''conf'''
    48    * '''trac.ini''' - Main configuration file. See TracIni.
    49  * '''db'''
    50    * '''trac.db''' - SQLite database.
    51  * '''templates''' - Custom (environment-specific) templates.
    52    * '''site_css.cs''' - Custom CSS stylesheet.
    53    * '''site_footer.cs''' - Custom footer.
    54    * '''site_header.cs''' - Custom header.
    55  * '''wiki-macros''' - Environment-specific WikiMacros.
     123An environment directory will usually consist of the following files and directories:
     124
     125 * `README` - Brief description of the environment.
     126 * `VERSION` - Contains the environment version identifier.
     127 * `attachments` - Attachments to wiki pages and tickets are stored here.
     128 * `conf`
     129   * `trac.ini` - Main configuration file. See TracIni.
     130 * `db`
     131   * `trac.db` - The SQLite database (if you're using SQLite).
     132 * `plugins` - Environment-specific [wiki:TracPlugins plugins] (Python eggs, since [milestone:0.10])
     133 * `templates` - Custom environment-specific templates.
     134   * `site_css.cs` - Custom CSS rules.
     135   * `site_footer.cs` - Custom page footer.
     136   * `site_header.cs` - Custom page header.
     137 * `wiki-macros` - Environment-specific [wiki:TracWikiMacros Wiki macros].
     138
     139  '''Note: don't confuse a Trac environment directory with the source code repository directory.
     140It happens that the above structure is loosely modelled after the Subversion repository directory
     141structure, but they are not and ''must not'' be located at the same place.'''
    56142
    57143----
    58 See also: TracBackup, TracIni, TracGuide
     144See also: TracAdmin, TracBackup, TracIni, TracGuide