[[PageOutline(2-3)]]
= Advanced options for Installing Trac on Windows =

== Optional Packages ==

In addition to the base packages listed in TracOnWindows, here are a few additional packages (Python or external tools) that can be used to improve the functionality offered on your Trac installation:
|| Docutils    || [http://belnet.dl.sourceforge.net/sourceforge/docutils/docutils-0.4.tar.gz docutils-0.4.tar.gz] ||
|| SilverCity  || [http://downloads.sourceforge.net/silvercity/SilverCity-0.9.7.win32-py2.4.exe SilverCity-0.9.7.win32-py2.4.exe] (or the [http://downloads.sourceforge.net/silvercity/SilverCity-0.9.7.win32-py2.3.exe Python 2.3 version]) ||
|| Enscript on Windows || [http://gnuwin32.sourceforge.net/packages/enscript.htm gnuwin32 Enscript 1.6.3] ||


== Using Other Databases ==

=== PostgreSQL for Windows ===

Trac can work equally well with two different Python bindings for the PostgreSQL (8.1.4) database:
|| [http://initd.org/tracker/psycopg PsycoPg2] || [http://stickpeople.com/projects/python/win-psycopg/psycopg2-2.0.5.1.win32-py2.4-pg8.1.4-release.exe psycopg2-2.0.5.1.win32-py2.4-pg8.1.4-release.exe] (or the [http://stickpeople.com/projects/python/win-psycopg/psycopg2-2.0.5.1.win32-py2.3-pg8.1.4-release.exe Python 2.3 version]) [http://stickpeople.com/projects/python/win-psycopg/ more...] ||
|| [http://pypgsql.sourceforge.net/ pyPgSQL] || [http://downloads.sourceforge.net/pypgsql/pyPgSQL-2.5.1.win32-py2.4.exe pyPgSQL-2.5.1.win32-py2.4.exe] (or the [http://downloads.sourceforge.net/pypgsql/pyPgSQL-2.5.1.win32-py2.3.exe Python 2.3 version]) [http://sourceforge.net/project/showfiles.php?group_id=16528&package_id=20458 more...] ||

=== mySQLDb for Windows ===

The recommended package for the MySqlDb Python bindings for the MySQL database is: 
 - [http://puzzle.dl.sourceforge.net/sourceforge/mysql-python/MySQL-python.exe-1.2.1_p2.win32-py2.4.exe MySQL-python.exe-1.2.1_p2.win32-py2.4.exe].

Please note that working with MySQL is ''not'' recommended in general, as there are still a lot of rough edges. However, on Windows the main issues we have with MySQL tend to be less apparent: the default setup for recent installations is UTF8, Windows users are unlikely to have case-sensitivity pathname issues in their repositories (as Subversion won't let them create such paths in the first place), etc. So MySQL on Windows might well be a more viable solution than on Unix, for the time being. See the MySqlDb page for more details.


== Using Other Web front-end ==

TracStandalone is not the only option on Windows.

=== Apache and `mod_python` ===

First you need to install the `mod_python` package.
Pick the version that is appropriate for your version of Python and your version of Apache.
 - [http://www.apache.org/dist/httpd/modpython/win/3.2.10/mod_python-3.2.10.win32-py2.3-apache2.0.exe  mod_python-3.2.10.win32-py2.3-apache2.0.exe]
 - [http://www.apache.org/dist/httpd/modpython/win/3.2.10/mod_python-3.2.10.win32-py2.4-apache2.0.exe mod_python-3.2.10.win32-py2.4-apache2.0.exe]
 - [http://www.apache.org/dist/httpd/modpython/win/3.2.10/mod_python-3.2.10.win32-py2.4-apache2.2.exe mod_python-3.2.10.win32-py2.4-apache2.2.exe]

''TODO: check the compatibility between Apache 2.0/2.2 and the Subversion bindings. The latter are using libapr and libaprutil 0.9.12.''

Then, check the regular TracModPython instructions to see how you have to modify your http.conf.

=== Apache and `mod_wsgi` ===

First, you need to integrate [http://code.google.com/p/modwsgi mod_wsgi] in your Apache installation. You can find and download pre-compiled binaries for Windows [http://adal.chiriliuc.com/mod_wsgi/ here]. Choose the right one depending on the version of Apache and Python you're running. Then follow the [http://code.google.com/p/modwsgi/wiki/InstallationOnWindows installation instructions] for this module, and eventually the [wiki:"TracModWSGI"] installations instructions. The resulting configuration (from the words of `mod_wsgi` authors) is supposed to be more efficient than one using `mod_python`.

=== Internet Information Services (IIS) ===

It is also possible to install [wiki:"TracOnWindowsIis6" Trac with IIS 6], though your mileage may vary.

== Authenticating Trac users against MS Windows domain controller ==

Running Trac in Apache, you can let your users login with their existing Windows username/password by using `mod_sspi`. (If you use Subversion as a repository and access it through Apache, you can also do the same with Subversion). Download this module [http://sourceforge.net/projects/mod-auth-sspi here], place it in the Apache modules directory, and add the following line to your `httpd.conf`, with all the `LoadModule` instructions:
{{{
LoadModule sspi_auth_module modules/mod_auth_sspi.so
}}}

Then add the following to the end of `http.conf`, modified according to your settings:

{{{
<LocationMatch /MyTracRootURL/[^/]+/login>
        AuthType SSPI
        AuthName "Trac project management website @ MyLocalMachine"
        SSPIAuth On
        SSPIAuthoritative On
        SSPIDomain MyLocalDomain
        SSPIOfferBasic On
        Require valid-user
</LocationMatch>
}}}

Then, if you change permissions in Trac using `trac-admin.exe`, remember to declare the user `bob` as `MyLocalDomain\bob` (The same remark applies for your Subversion repository accessfile). Alternatively add the parameter `SSPIOmitDomain On` and declare the user as `bob`.