Changes between Version 1 and Version 2 of TracModWSGI


Ignore:
Timestamp:
04/26/23 13:59:59 (12 months ago)
Author:
trac
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • TracModWSGI

    v1 v2  
    1 = Trac and mod_wsgi =
    2 
    3 [http://code.google.com/p/modwsgi/ mod_wsgi] is an Apache module for running WSGI-compatible Python applications directly on top of the Apache webserver. The mod_wsgi adapter is written completely in C and provides very good performance.
     1= Trac and mod_wsgi
     2
     3[https://github.com/GrahamDumpleton/mod_wsgi mod_wsgi] is an Apache module for running WSGI-compatible Python applications directly on top of the Apache webserver. The mod_wsgi adapter is written completely in C and provides very good performance.
    44
    55[[PageOutline(2-3,Overview,inline)]]
     
    77== The `trac.wsgi` script
    88
    9 Trac can be run on top of mod_wsgi with the help of the following application script, which is just a Python file, though usually saved with a `.wsgi` extension.
     9Trac can be run on top of mod_wsgi with the help of an application script, which is a Python file saved with a `.wsgi` extension.
     10
     11A robust and generic version of this file can be created using the `trac-admin <env> deploy <dir>` command which automatically substitutes the required paths, see TracInstall#cgi-bin. The script should be sufficient for most installations and users not wanting more information can proceed to [#Mappingrequeststothescript configuring Apache].
     12
     13If you are using Trac with multiple projects, you can specify their common parent directory in `trac.wsgi`:
     14{{{#!python
     15def application(environ, start_request):
     16    # Add this when you have multiple projects
     17    environ.setdefault('trac.env_parent_dir', '/usr/share/trac/projects')
     18    ..
     19}}}
     20
     21Directories residing in `trac.env_parent_dir` that are not environment directories will display an error message on the [TracInterfaceCustomization#ProjectList project index page]. The directories can be excluded by listing them in a `.tracignore` file residing in `trac.env_parent_dir`. Unix [https://docs.python.org/2/library/fnmatch.html shell-style wildcard patterns] can be used in the newline separated list of directories.
    1022
    1123=== A very basic script
     24
    1225In its simplest form, the script could be:
    1326
     
    3649=== A more elaborate script
    3750
    38 If you are using multiple `.wsgi` files (for example one per Trac environment) you must ''not'' use `os.environ['TRAC_ENV']` to set the path to the Trac environment. Using this method may lead to Trac delivering the content of another Trac environment, as the variable may be filled with the path of a previously viewed Trac environment. 
     51If you are using multiple `.wsgi` files (for example one per Trac environment) you must ''not'' use `os.environ['TRAC_ENV']` to set the path to the Trac environment. Using this method may lead to Trac delivering the content of another Trac environment, as the variable may be filled with the path of a previously viewed Trac environment.
    3952
    4053To solve this problem, use the following `.wsgi` file instead:
     
    4659import trac.web.main
    4760def application(environ, start_response):
    48   environ['trac.env_path'] = '/usr/local/trac/mysite' 
     61  environ['trac.env_path'] = '/usr/local/trac/mysite'
    4962  return trac.web.main.dispatch_request(environ, start_response)
    5063}}}
    5164
    52 For clarity, you should give this file a `.wsgi` extension. You should probably put the file in its own directory, since you will expose it to Apache. 
     65For clarity, you should give this file a `.wsgi` extension. You should probably put the file in its own directory, since you will expose it to Apache.
    5366
    5467If you have installed Trac and Python eggs in a path different from the standard one, you should add that path by adding the following code at the top of the wsgi script:
     
    6174Change it according to the path you installed the Trac libs at.
    6275
    63 === Recommended `trac.wsgi` script
    64 
    65 A somewhat robust and generic version of this file can be created using the `trac-admin <env> deploy <dir>` command which automatically substitutes the required paths, see TracInstall#cgi-bin.
    66 
    67 If you are using Trac with multiple projects, you can specify their common parent directory using the `TRAC_ENV_PARENT_DIR` in the trac.wsgi in trac.wsgi: ''
    68 
    69 {{{#!python
    70   def application(environ, start_request):
    71       Add this to config when you have multiple projects                                             
    72       environ.setdefault('trac.env_parent_dir', '/usr/share/trac/projects') 
    73       ..
    74       ..
    75 }}}
    76 
    7776== Mapping requests to the script
    7877
    7978After preparing your .wsgi script, add the following to your Apache configuration file, typically `httpd.conf`:
    8079
    81 {{{
     80{{{#!apache
    8281WSGIScriptAlias /trac /usr/local/trac/mysite/apache/mysite.wsgi
    8382
    8483<Directory /usr/local/trac/mysite/apache>
    8584    WSGIApplicationGroup %{GLOBAL}
    86     Order deny,allow
    87     Allow from all
     85    # For Apache 2.2
     86    <IfModule !mod_authz_core.c>
     87        Order deny,allow
     88        Allow from all
     89    </IfModule>
     90    # For Apache 2.4
     91    <IfModule mod_authz_core.c>
     92        Require all granted
     93    </IfModule>
    8894</Directory>
    8995}}}
     
    9399If you followed the directions [TracInstall#cgi-bin Generating the Trac cgi-bin directory], your Apache configuration file should look like following:
    94100
    95 {{{
     101{{{#!apache
    96102WSGIScriptAlias /trac /usr/share/trac/cgi-bin/trac.wsgi
    97103
    98104<Directory /usr/share/trac/cgi-bin>
    99105    WSGIApplicationGroup %{GLOBAL}
    100     Order deny,allow
    101     Allow from all
     106    # For Apache 2.2
     107    <IfModule !mod_authz_core.c>
     108        Order deny,allow
     109        Allow from all
     110    </IfModule>
     111    # For Apache 2.4
     112    <IfModule mod_authz_core.c>
     113        Require all granted
     114    </IfModule>
    102115</Directory>
    103116}}}
     
    105118In order to let Apache run the script, access to the directory in which the script resides is opened up to all of Apache. Additionally, the `WSGIApplicationGroup` directive ensures that Trac is always run in the first Python interpreter created by mod_wsgi. This is necessary because the Subversion Python bindings, which are used by Trac, don't always work in other sub-interpreters and may cause requests to hang or cause Apache to crash. After adding this configuration, restart Apache, and then it should work.
    106119
    107 To test the setup of Apache, mod_wsgi and Python itself (ie. without involving Trac and dependencies), this simple wsgi application can be used to make sure that requests gets served (use as only content in your `.wsgi` script):
     120To test the setup of Apache, mod_wsgi and Python itself (ie without involving Trac and dependencies), this simple wsgi application can be used to make sure that requests gets served (use as only content in your `.wsgi` script):
    108121
    109122{{{#!python
     
    113126}}}
    114127
    115 For more information about using the mod_wsgi specific directives, see the [http://code.google.com/p/modwsgi/wiki/ mod_wsgi's wiki] and more specifically the [http://code.google.com/p/modwsgi/wiki/IntegrationWithTrac IntegrationWithTrac] page.
     128For more information about using the mod_wsgi specific directives, see the [https://code.google.com/archive/p/modwsgi/wikis mod_wsgi's wiki] and more specifically the [https://code.google.com/archive/p/modwsgi/wikis/IntegrationWithTrac.wiki IntegrationWithTrac] page.
    116129
    117130== Configuring Authentication
    118131
    119 The following sections describe different methods for setting up authentication. See also [http://httpd.apache.org/docs/2.2/howto/auth.html Authentication, Authorization and Access Control] in the Apache guide.
    120 
    121 === Using Basic Authentication ===
     132The following sections describe different methods for setting up authentication. See also [https://httpd.apache.org/docs/2.4/howto/auth.html Authentication, Authorization and Access Control] in the Apache guide.
     133
     134=== Using Basic Authentication
    122135
    123136The simplest way to enable authentication with Apache is to create a password file. Use the `htpasswd` program as follows:
    124 {{{
     137{{{#!sh
    125138$ htpasswd -c /somewhere/trac.htpasswd admin
    126139New password: <type password>
     
    130143
    131144After the first user, you don't need the "-c" option anymore:
    132 {{{
     145{{{#!sh
    133146$ htpasswd /somewhere/trac.htpasswd john
    134147New password: <type password>
     
    137150}}}
    138151
    139   ''See the man page for `htpasswd` for full documentation.''
     152See the man page for `htpasswd` for full documentation.
    140153
    141154After you've created the users, you can set their permissions using TracPermissions.
    142155
    143156Now, you need to enable authentication against the password file in the Apache configuration:
    144 {{{
     157{{{#!apache
    145158<Location "/trac/login">
    146159  AuthType Basic
     
    152165
    153166If you are hosting multiple projects, you can use the same password file for all of them:
    154 {{{
     167{{{#!apache
    155168<LocationMatch "/trac/[^/]+/login">
    156169  AuthType Basic
     
    160173</LocationMatch>
    161174}}}
    162 Note that neither a file nor a directory named 'login' needs to exist.[[BR]]
    163 See also the [http://httpd.apache.org/docs/2.2/mod/mod_auth_basic.html mod_auth_basic] documentation.
    164 
    165 === Using Digest Authentication ===
    166 
    167 For better security, it is recommended that you either enable SSL or at least use the “digest” authentication scheme instead of “Basic”.
     175
     176Note that neither a file nor a directory named 'login' needs to exist. See also the [https://httpd.apache.org/docs/2.4/mod/mod_auth_basic.html mod_auth_basic] documentation.
     177
     178=== Using Digest Authentication
     179
     180For better security, it is recommended that you either enable SSL or at least use the "digest" authentication scheme instead of "Basic".
    168181
    169182You have to create your `.htpasswd` file with the `htdigest` command instead of `htpasswd`, as follows:
    170 {{{
    171 # htdigest -c /somewhere/trac.htpasswd trac admin
     183{{{#!sh
     184$ htdigest -c /somewhere/trac.htpasswd trac admin
    172185}}}
    173186
    174187The "trac" parameter above is the "realm", and will have to be reused in the Apache configuration in the !AuthName directive:
    175188
    176 {{{
     189{{{#!apache
    177190<Location "/trac/login">
    178 
    179     AuthType Digest
    180     AuthName "trac"
    181     AuthDigestDomain /trac
    182     AuthUserFile /somewhere/trac.htpasswd
    183     Require valid-user
     191  AuthType Digest
     192  AuthName "trac"
     193  AuthDigestDomain /trac
     194  AuthUserFile /somewhere/trac.htpasswd
     195  Require valid-user
    184196</Location>
    185197}}}
     
    187199For multiple environments, you can use the same `LocationMatch` as described with the previous method.
    188200
    189 '''Note: `Location` cannot be used inside .htaccess files, but must instead live within the main httpd.conf file. If you are on a shared server, you therefore will not be able to provide this level of granularity. '''
     201'''Note''': `Location` cannot be used inside .htaccess files, but must instead live within the main httpd.conf file. If you are on a shared server, you therefore will not be able to provide this level of granularity.
    190202
    191203Don't forget to activate the mod_auth_digest. For example, on a Debian 4.0r1 (etch) system:
    192 {{{
    193     LoadModule auth_digest_module /usr/lib/apache2/modules/mod_auth_digest.so
    194 }}}
    195 
    196 See also the [http://httpd.apache.org/docs/2.2/mod/mod_auth_digest.html mod_auth_digest] documentation.
    197 
    198 === Using LDAP Authentication 
    199 
    200 Configuration for [http://httpd.apache.org/docs/2.2/mod/mod_ldap.html mod_ldap] authentication in Apache is more involved (httpd 2.2.x and OpenLDAP: slapd 2.3.19).
     204{{{#!apache
     205  LoadModule auth_digest_module /usr/lib/apache2/modules/mod_auth_digest.so
     206}}}
     207
     208See also the [https://httpd.apache.org/docs/2.4/mod/mod_auth_basic.html mod_auth_digest] documentation.
     209
     210=== Using LDAP Authentication
     211
     212Configuration for [https://httpd.apache.org/docs/2.4/mod/mod_ldap.html mod_ldap] authentication in Apache is more involved (httpd 2.2+ and OpenLDAP: slapd 2.3.19).
    201213
    2022141. You need to load the following modules in Apache httpd.conf:
    203 {{{
    204 LoadModule ldap_module modules/mod_ldap.so
    205 LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
    206 }}}
    207 
    208 2. Your httpd.conf also needs to look something like:
    209 
    210 {{{
     215{{{#!apache
     216  LoadModule ldap_module modules/mod_ldap.so
     217  LoadModule authnz_ldap_module modules/mod_authnz_ldap.so
     218}}}
     2191. Your httpd.conf also needs to look something like:
     220{{{#!apache
    211221<Location /trac/>
    212222  # (if you're using it, mod_python specific settings go here)
     
    222232</Location>
    223233}}}
    224 
    225 3. You can use the LDAP interface as a way to authenticate to a Microsoft Active Directory:
    226 
    227 Use the following as your LDAP URL:
    228 {{{
    229     AuthLDAPURL "ldap://directory.example.com:3268/DC=example,DC=com?sAMAccountName?sub?(objectClass=user)"
    230 }}}
    231 
    232 You will also need to provide an account for Apache to use when checking credentials. As this password will be listed in plaintext in the config, you need to use an account specifically for this task:
    233 {{{
    234     AuthLDAPBindDN [email protected]
    235     AuthLDAPBindPassword "password"
    236 }}}
    237 
    238 The whole section looks like:
    239 {{{
     2341. You can use the LDAP interface as a way to authenticate to a Microsoft Active Directory. Use the following as your LDAP URL:
     235{{{#!apache
     236  AuthLDAPURL "ldap://directory.example.com:3268/DC=example,DC=com?sAMAccountName?sub?(objectClass=user)"
     237}}}
     238 You will also need to provide an account for Apache to use when checking credentials. As this password will be listed in plain text in the configuration, you need to use an account specifically for this task:
     239{{{#!apache
     240  AuthLDAPBindDN [email protected]
     241  AuthLDAPBindPassword "password"
     242}}}
     243 The whole section looks like:
     244{{{#!apache
    240245<Location /trac/>
    241246  # (if you're using it, mod_python specific settings go here)
     
    251256  authzldapauthoritative Off
    252257  # require valid-user
    253   require ldap-group CN=Trac Users,CN=Users,DC=company,DC=com
     258  Require ldap-group CN=Trac Users,CN=Users,DC=company,DC=com
    254259</Location>
    255260}}}
     
    258263
    259264Note 2: You can also require the user be a member of a certain LDAP group, instead of just having a valid login:
    260 {{{
    261     Require ldap-group CN=Trac Users,CN=Users,DC=example,DC=com
     265{{{#!apache
     266  Require ldap-group CN=Trac Users,CN=Users,DC=example,DC=com
    262267}}}
    263268
    264269See also:
    265  - [http://httpd.apache.org/docs/2.2/mod/mod_authnz_ldap.html mod_authnz_ldap], documentation for mod_authnz_ldap.   
    266  - [http://httpd.apache.org/docs/2.2/mod/mod_ldap.html mod_ldap], documentation for mod_ldap, which provides connection pooling and a shared cache.
    267  - [http://trac-hacks.org/wiki/LdapPlugin TracHacks:LdapPlugin] for storing TracPermissions in LDAP.
     270 - [https://httpd.apache.org/docs/2.4/mod/mod_authnz_ldap.html mod_authnz_ldap], documentation for mod_authnz_ldap.
     271 - [https://httpd.apache.org/docs/2.4/mod/mod_ldap.html mod_ldap], documentation for mod_ldap, which provides connection pooling and a shared cache.
     272 - [https://trac-hacks.org/wiki/LdapPlugin TracHacks:LdapPlugin] for storing TracPermissions in LDAP.
    268273
    269274=== Using SSPI Authentication
    270275
    271 If you are using Apache on Windows, you can use mod_auth_sspi to provide single-sign-on. Download the module from the !SourceForge [http://sourceforge.net/projects/mod-auth-sspi/ mod-auth-sspi project] and then add the following to your !VirtualHost:
    272 {{{
    273     <Location /trac/login>
    274         AuthType SSPI
    275         AuthName "Trac Login"
    276         SSPIAuth On
    277         SSPIAuthoritative On
    278         SSPIDomain MyLocalDomain
    279         SSPIOfferBasic On
    280         SSPIOmitDomain Off
    281         SSPIBasicPreferred On
    282         Require valid-user
    283     </Location>
     276If you are using Apache on Windows, you can use mod_auth_sspi to provide single-sign-on. Download the module from the !SourceForge [https://sourceforge.net/projects/mod-auth-sspi/ mod-auth-sspi project] and then add the following to your !VirtualHost:
     277{{{#!apache
     278<Location /trac/login>
     279  AuthType SSPI
     280  AuthName "Trac Login"
     281  SSPIAuth On
     282  SSPIAuthoritative On
     283  SSPIDomain MyLocalDomain
     284  SSPIOfferBasic On
     285  SSPIOmitDomain Off
     286  SSPIBasicPreferred On
     287  Require valid-user
     288</Location>
    284289}}}
    285290
     
    290295See also [trac:TracOnWindows/Advanced].
    291296
    292 === Using Apache authentication with the Account Manager plugin's Login form ===
    293 
    294 To begin with, see the basic instructions for using the Account Manager plugin's [http://trac-hacks.org/wiki/AccountManagerPlugin/Modules#LoginModule Login module] and its [http://trac-hacks.org/wiki/AccountManagerPlugin/AuthStores#HttpAuthStore HttpAuthStore authentication module].
    295 
    296 '''Note:''' If is difficult to get !HttpAuthStore to work with WSGI when using any Account Manager version prior to acct_mgr-0.4. Upgrading is recommended.
    297 
    298 Here is an example (from the !HttpAuthStore link) using acct_mgr-0.4 for hosting a single project:
    299 {{{
    300 [components]
    301 ; be sure to enable the component
    302 acct_mgr.http.HttpAuthStore = enabled
    303 
    304 [account-manager]
    305 ; configure the plugin to use a page that is secured with http authentication
    306 authentication_url = /authFile
    307 password_store = HttpAuthStore
    308 }}}
    309 This will generally be matched with an Apache config like:
    310 {{{
    311 <Location /authFile>
    312    …HTTP authentication configuration…
    313    Require valid-user
    314 </Location>
    315 }}}
    316 Note that '''authFile''' need not exist (unless you are using Account Manager older than 0.4). See the !HttpAuthStore link above for examples where multiple Trac projects are hosted on a server.
     297=== Using CA !SiteMinder Authentication
     298
     299Setup CA !SiteMinder to protect your Trac login URL, for example `/trac/login`. Also, make sure the policy is set to include the HTTP_REMOTE_USER variable. If your site allows it, you can set this in `LocalConfig.conf`:
     300{{{#!apache
     301RemoteUserVar="WHATEVER_IT_SHOULD_BE"
     302SetRemoteUser="YES"
     303}}}
     304
     305The specific variable is site-dependent. Ask your site administrator. If your site does not allow the use of `LocalConfig.conf` for security reasons, have your site administrator set the policy on the server to set REMOTE_USER.
     306
     307Also add a !LogOffUri parameter to the agent configuration, for example `/trac/logout`.
     308
     309Then modify the trac.wsgi script generated using `trac-admin <env> deploy <dir>` to add the following lines, which extract the `HTTP_REMOTE_USER` variable and set it to `REMOTE_USER`:
     310
     311{{{#!python
     312def application(environ, start_request):
     313    # Set authenticated username on CA SiteMinder to REMOTE_USER variable
     314    # strip() is used to remove any spaces on the end of the string
     315    if 'HTTP_SM_USER' in environ:
     316        environ['REMOTE_USER'] = environ['HTTP_REMOTE_USER'].strip()
     317    ...
     318}}}
     319
     320You do not need any Apache "Location" directives.
    317321
    318322=== Example: Apache/mod_wsgi with Basic Authentication, Trac being at the root of a virtual host
     
    322326 - uses Apache basic authentication for Trac authentication.
    323327
    324 If you want your Trac to be served from e.g. !http://trac.my-proj.my-site.org, then from the folder e.g. `/home/trac-for-my-proj`, if you used the command `trac-admin the-env initenv` to create a folder `the-env`, and you used `trac-admin the-env deploy the-deploy` to create a folder `the-deploy`, then first:
     328If you want your Trac to be served from eg !http://trac.my-proj.my-site.org, then from the folder eg `/home/trac-for-my-proj`, if you used the command `trac-admin the-env initenv` to create a folder `the-env`, and you used `trac-admin the-env deploy the-deploy` to create a folder `the-deploy`, then first:
    325329
    326330Create the htpasswd file:
    327 {{{
     331{{{#!sh
    328332cd /home/trac-for-my-proj/the-env
    329333htpasswd -c htpasswd firstuser
     
    331335htpasswd htpasswd seconduser
    332336}}}
     337
    333338Keep the file above your document root for security reasons.
    334339
    335 Create this file e.g. (ubuntu) `/etc/apache2/sites-enabled/trac.my-proj.my-site.org.conf` with the following content:
    336 
    337 {{{
     340Create this file for example `/etc/apache2/sites-enabled/trac.my-proj.my-site.org.conf` on Ubuntu with the following content:
     341
     342{{{#!apache
    338343<Directory /home/trac-for-my-proj/the-deploy/cgi-bin/trac.wsgi>
    339344  WSGIApplicationGroup %{GLOBAL}
     
    356361}}}
    357362
    358 Note: for subdomains to work you would probably also need to alter `/etc/hosts` and add A-Records to your host's DNS.
     363For subdomains to work you would probably also need to alter `/etc/hosts` and add A-Records to your host's DNS.
    359364
    360365== Troubleshooting
     
    362367=== Use a recent version
    363368
    364 Please use either version 1.6, 2.4 or later of `mod_wsgi`. Versions prior to 2.4 in the 2.X branch have problems with some Apache configurations that use WSGI file wrapper extension. This extension is used in Trac to serve up attachments and static media files such as style sheets. If you are affected by this problem, attachments will appear to be empty and formatting of HTML pages will appear not to work due to style sheet files not loading properly. Another frequent symptom is that binary attachment downloads are truncated. See mod_wsgi tickets [http://code.google.com/p/modwsgi/issues/detail?id=100 #100] and [http://code.google.com/p/modwsgi/issues/detail?id=132 #132].
    365 
    366 ''Note: using mod_wsgi 2.5 and Python 2.6.1 gave an Internal Server Error on my system (Apache 2.2.11 and Trac 0.11.2.1). Upgrading to Python 2.6.2 (as suggested [http://www.mail-archive.com/[email protected]/msg01917.html here]) solved this for me[[BR]]-- Graham Shanks''
    367 
    368 If you plan to use `mod_wsgi` in embedded mode on Windows or with the MPM worker on Linux, then you will need version 0.3.4 or greater. See [trac:#10675] for details.
    369 
    370 === Getting Trac to work nicely with SSPI and 'Require Group' ===
    371 
    372 If you have set Trac up on Apache, Win32 and configured SSPI, but added a 'Require group' option to your apache configuration, then the SSPIOmitDomain option is probably not working. If it is not working, your usernames in Trac probably look like 'DOMAIN\user' rather than 'user'.
    373 
    374 This WSGI script 'fixes' that:
     369Please use either version 1.6, 2.4 or later of `mod_wsgi`. Versions prior to 2.4 in the 2.X branch have problems with some Apache configurations that use WSGI file wrapper extension. This extension is used in Trac to serve up attachments and static media files such as style sheets. If you are affected by this problem, attachments will appear to be empty and formatting of HTML pages will appear not to work due to style sheet files not loading properly. Another frequent symptom is that binary attachment downloads are truncated. See mod_wsgi tickets [https://code.google.com/archive/p/modwsgi/issues/100 #100] and [https://code.google.com/archive/p/modwsgi/issues/132 #132].
     370
     371'''Note''': using mod_wsgi 2.5 and Python 2.6.1 gave an Internal Server Error on my system (Apache 2.2.11 and Trac 0.11.2.1). Upgrading to Python 2.6.2 (as suggested [https://www.mail-archive.com/[email protected]/msg01917.html here]) solved this for me[[BR]]-- Graham Shanks
     372
     373If you plan to use `mod_wsgi` in embedded mode on Windows or with the MPM worker on Linux, then you will need version 3.4 or greater. See [trac:#10675] for details.
     374
     375=== Getting Trac to work nicely with SSPI and 'Require Group'
     376
     377If you have set Trac up on Apache, Win32 and configured SSPI, but added a 'Require group' option to your Apache configuration, then the SSPIOmitDomain option is probably not working. If it is not working, your usernames in Trac probably look like 'DOMAIN\user' rather than 'user'.
     378
     379This WSGI script fixes that:
    375380{{{#!python
    376381import os
     
    386391}}}
    387392
    388 === Trac with PostgreSQL ===
     393=== Trac with PostgreSQL
    389394
    390395When using the mod_wsgi adapter with multiple Trac instances and PostgreSQL (or MySQL?) as the database, the server ''may'' create a lot of open database connections and thus PostgreSQL processes.
     
    408413Now Trac drops the connection after serving a page and the connection count on the database will be kept low.
    409414
    410 //This is not a recommended approach though. See also the notes at the bottom of the [http://code.google.com/p/modwsgi/wiki/IntegrationWithTrac mod_wsgi's IntegrationWithTrac] wiki page.//
     415//This is not a recommended approach though. See also the notes at the bottom of the [https://code.google.com/archive/p/modwsgi/wikis/IntegrationWithTrac.wiki mod_wsgi's IntegrationWithTrac] wiki page.//
    411416
    412417=== Other resources
    413418
    414 For more troubleshooting tips, see also the [TracModPython#Troubleshooting mod_python troubleshooting] section, as most Apache-related issues are quite similar, plus discussion of potential [http://code.google.com/p/modwsgi/wiki/ApplicationIssues application issues] when using mod_wsgi. The wsgi page also has a [http://code.google.com/p/modwsgi/wiki/IntegrationWithTrac Integration With Trac] document.
     419For more troubleshooting tips, see also the [TracModPython#Troubleshooting mod_python troubleshooting] section, as most Apache-related issues are quite similar, plus discussion of potential [https://code.google.com/archive/p/modwsgi/wikis/ApplicationIssues.wiki application issues] when using mod_wsgi. The wsgi page also has a [https://code.google.com/archive/p/modwsgi/wikis/IntegrationWithTrac.wiki Integration With Trac] document.
    415420
    416421----