Changes between Version 2 and Version 3 of TracModWSGI
- Timestamp:
- Mar 31, 2016, 8:51:02 AM (9 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracModWSGI
v2 v3 1 = Trac and mod_wsgi = 2 3 4 [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 performances. 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. 5 4 6 5 [[PageOutline(2-3,Overview,inline)]] … … 8 7 == The `trac.wsgi` script 9 8 10 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). 9 Trac can be run on top of mod_wsgi with the help of an application script, which is just a Python file saved with a `.wsgi` extension. 10 11 A 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 13 If you are using Trac with multiple projects, you can specify their common parent directory using the `TRAC_ENV_PARENT_DIR` in trac.wsgi: 14 {{{#!python 15 def application(environ, start_request): 16 # Add this to config when you have multiple projects 17 environ.setdefault('trac.env_parent_dir', '/usr/share/trac/projects') 18 .. 19 }}} 11 20 12 21 === A very basic script … … 23 32 }}} 24 33 25 The `TRAC_ENV` variable should naturally be the directory for your Trac environment (if you have several Trac environments in a directory, you can also use `TRAC_ENV_PARENT_DIR` instead), while the `PYTHON_EGG_CACHE` should be a directory where Python can temporarily extract Python eggs. 34 The `TRAC_ENV` variable should naturally be the directory for your Trac environment, and the `PYTHON_EGG_CACHE` should be a directory where Python can temporarily extract Python eggs. If you have several Trac environments in a directory, you can also use `TRAC_ENV_PARENT_DIR` instead of `TRAC_ENV`. 35 36 On Windows: 37 - If run under the user's session, the Python Egg cache can be found in `%AppData%\Roaming`, for example: 38 {{{#!python 39 os.environ['PYTHON_EGG_CACHE'] = r'C:\Users\Administrator\AppData\Roaming\Python-Eggs' 40 }}} 41 - If run under a Window service, you should create a directory for Python Egg cache: 42 {{{#!python 43 os.environ['PYTHON_EGG_CACHE'] = r'C:\Trac-Python-Eggs' 44 }}} 26 45 27 46 === A more elaborate script 28 47 29 If you 're 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.48 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. 30 49 31 50 To solve this problem, use the following `.wsgi` file instead: … … 43 62 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. 44 63 45 If you have installed Trac and eggs in a path different from the standard oneyou should add that path by adding the following code at the top of the wsgi script:64 If 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: 46 65 47 66 {{{#!python … … 52 71 Change it according to the path you installed the Trac libs at. 53 72 54 === Recommended `trac.wsgi` script55 56 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).57 58 59 73 == Mapping requests to the script 60 74 61 After you've done preparing your .wsgi script, add the following to your Apache configuration file (`httpd.conf` for example).62 63 {{{ 75 After preparing your .wsgi script, add the following to your Apache configuration file, typically `httpd.conf`: 76 77 {{{#!apache 64 78 WSGIScriptAlias /trac /usr/local/trac/mysite/apache/mysite.wsgi 65 79 66 80 <Directory /usr/local/trac/mysite/apache> 67 81 WSGIApplicationGroup %{GLOBAL} 68 Order deny,allow 69 Allow from all 82 # For Apache 2.2 83 <IfModule !mod_authz_core.c> 84 Order deny,allow 85 Allow from all 86 </IfModule> 87 # For Apache 2.4 88 <IfModule mod_authz_core.c> 89 Require all granted 90 </IfModule> 70 91 </Directory> 71 92 }}} … … 73 94 Here, the script is in a subdirectory of the Trac environment. 74 95 75 If you followed the directions [ http://trac.edgewall.org/wiki/TracInstall#cgi-bin Generating the Trac cgi-bin directory], your Apache configuration file should look like following:76 77 {{{ 96 If you followed the directions [TracInstall#cgi-bin Generating the Trac cgi-bin directory], your Apache configuration file should look like following: 97 98 {{{#!apache 78 99 WSGIScriptAlias /trac /usr/share/trac/cgi-bin/trac.wsgi 79 100 80 101 <Directory /usr/share/trac/cgi-bin> 81 102 WSGIApplicationGroup %{GLOBAL} 82 Order deny,allow 83 Allow from all 103 # For Apache 2.2 104 <IfModule !mod_authz_core.c> 105 Order deny,allow 106 Allow from all 107 </IfModule> 108 # For Apache 2.4 109 <IfModule mod_authz_core.c> 110 Require all granted 111 </IfModule> 84 112 </Directory> 85 113 }}} 86 114 87 In 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 as a result. After adding this configuration, restart Apache, and then it should work.115 In 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. 88 116 89 117 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): … … 97 125 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. 98 126 99 100 127 == Configuring Authentication 101 128 102 We describe in the the following sections different methods for setting up authentication. 103 104 See also [http://httpd.apache.org/docs/2.2/howto/auth.html Authentication, Authorization and Access Control] in the Apache guide. 105 106 === Using Basic Authentication === 107 108 The simplest way to enable authentication with Apache is to create a password file. Use the `htpasswd` program to create the password file: 109 {{{ 129 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. 130 131 === Using Basic Authentication 132 133 The simplest way to enable authentication with Apache is to create a password file. Use the `htpasswd` program as follows: 134 {{{#!sh 110 135 $ htpasswd -c /somewhere/trac.htpasswd admin 111 136 New password: <type password> … … 114 139 }}} 115 140 116 After the first user, you don t need the "-c" option anymore:117 {{{ 141 After the first user, you don't need the "-c" option anymore: 142 {{{#!sh 118 143 $ htpasswd /somewhere/trac.htpasswd john 119 144 New password: <type password> … … 126 151 After you've created the users, you can set their permissions using TracPermissions. 127 152 128 Now, you 'llneed to enable authentication against the password file in the Apache configuration:129 {{{ 153 Now, you need to enable authentication against the password file in the Apache configuration: 154 {{{#!apache 130 155 <Location "/trac/login"> 131 156 AuthType Basic … … 136 161 }}} 137 162 138 If you 're hosting multiple projectsyou can use the same password file for all of them:139 {{{ 163 If you are hosting multiple projects, you can use the same password file for all of them: 164 {{{#!apache 140 165 <LocationMatch "/trac/[^/]+/login"> 141 166 AuthType Basic … … 148 173 See also the [http://httpd.apache.org/docs/2.2/mod/mod_auth_basic.html mod_auth_basic] documentation. 149 174 150 === Using Digest Authentication ===175 === Using Digest Authentication 151 176 152 177 For better security, it is recommended that you either enable SSL or at least use the “digest” authentication scheme instead of “Basic”. 153 178 154 You 'llhave to create your `.htpasswd` file with the `htdigest` command instead of `htpasswd`, as follows:155 {{{ 156 #htdigest -c /somewhere/trac.htpasswd trac admin179 You have to create your `.htpasswd` file with the `htdigest` command instead of `htpasswd`, as follows: 180 {{{#!sh 181 $ htdigest -c /somewhere/trac.htpasswd trac admin 157 182 }}} 158 183 159 184 The "trac" parameter above is the "realm", and will have to be reused in the Apache configuration in the !AuthName directive: 160 185 161 {{{ 186 {{{#!apache 162 187 <Location "/trac/login"> 163 164 AuthType Digest 165 AuthName "trac" 166 AuthDigestDomain /trac 167 AuthUserFile /somewhere/trac.htpasswd 168 Require valid-user 188 AuthType Digest 189 AuthName "trac" 190 AuthDigestDomain /trac 191 AuthUserFile /somewhere/trac.htpasswd 192 Require valid-user 169 193 </Location> 170 194 }}} … … 172 196 For multiple environments, you can use the same `LocationMatch` as described with the previous method. 173 197 198 '''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. ''' 199 174 200 Don't forget to activate the mod_auth_digest. For example, on a Debian 4.0r1 (etch) system: 175 {{{ 176 LoadModule auth_digest_module /usr/lib/apache2/modules/mod_auth_digest.so 177 }}} 178 201 {{{#!apache 202 LoadModule auth_digest_module /usr/lib/apache2/modules/mod_auth_digest.so 203 }}} 179 204 180 205 See also the [http://httpd.apache.org/docs/2.2/mod/mod_auth_digest.html mod_auth_digest] documentation. … … 182 207 === Using LDAP Authentication 183 208 184 Configuration for [http://httpd.apache.org/docs/2.2/mod/mod_ldap.html mod_ldap] authentication in Apache is a bit tricky (httpd 2.2.x and OpenLDAP: slapd 2.3.19) 185 186 1. You need to load the following modules in Apache httpd.conf 187 {{{ 188 LoadModule ldap_module modules/mod_ldap.so 189 LoadModule authnz_ldap_module modules/mod_authnz_ldap.so 190 }}} 191 192 2. Your httpd.conf also needs to look something like: 193 194 {{{ 209 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). 210 211 1. You need to load the following modules in Apache httpd.conf: 212 {{{#!apache 213 LoadModule ldap_module modules/mod_ldap.so 214 LoadModule authnz_ldap_module modules/mod_authnz_ldap.so 215 }}} 216 1. Your httpd.conf also needs to look something like: 217 {{{#!apache 195 218 <Location /trac/> 196 219 # (if you're using it, mod_python specific settings go here) … … 206 229 </Location> 207 230 }}} 208 209 210 3. You can use the LDAP interface as a way to authenticate to a Microsoft Active Directory: 211 212 213 Use the following as your LDAP URL: 214 {{{ 215 AuthLDAPURL "ldap://directory.example.com:3268/DC=example,DC=com?sAMAccountName?sub?(objectClass=user)" 216 }}} 217 218 You will also need to provide an account for Apache to use when checking 219 credentials. As this password will be listed in plaintext in the 220 config, you should be sure to use an account specifically for this task: 221 {{{ 222 AuthLDAPBindDN ldap-auth-user@example.com 223 AuthLDAPBindPassword "password" 224 }}} 225 226 The whole section looks like: 227 {{{ 231 1. You can use the LDAP interface as a way to authenticate to a Microsoft Active Directory. Use the following as your LDAP URL: 232 {{{#!apache 233 AuthLDAPURL "ldap://directory.example.com:3268/DC=example,DC=com?sAMAccountName?sub?(objectClass=user)" 234 }}} 235 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: 236 {{{#!apache 237 AuthLDAPBindDN ldap-auth-user@example.com 238 AuthLDAPBindPassword "password" 239 }}} 240 The whole section looks like: 241 {{{#!apache 228 242 <Location /trac/> 229 243 # (if you're using it, mod_python specific settings go here) … … 239 253 authzldapauthoritative Off 240 254 # require valid-user 241 require ldap-group CN=Trac Users,CN=Users,DC=company,DC=com 242 </Location> 243 }}} 244 245 Note 1: This is the case where the LDAP search will get around the multiple OUs, conecting to Global Catalog Server portion of AD (Notice the port is 3268, not the normal LDAP 389). The GCS is basically a "flattened" tree which allows searching for a user without knowing to which OU they belong. 246 247 Note 2: You can also require the user be a member of a certain LDAP group, instead of 248 just having a valid login: 249 {{{ 250 Require ldap-group CN=Trac Users,CN=Users,DC=example,DC=com 255 Require ldap-group CN=Trac Users,CN=Users,DC=company,DC=com 256 </Location> 257 }}} 258 259 Note 1: This is the case where the LDAP search will get around the multiple OUs, conecting to the Global Catalog Server portion of AD. Note the port is 3268, not the normal LDAP 389. The GCS is basically a "flattened" tree which allows searching for a user without knowing to which OU they belong. 260 261 Note 2: You can also require the user be a member of a certain LDAP group, instead of just having a valid login: 262 {{{#!apache 263 Require ldap-group CN=Trac Users,CN=Users,DC=example,DC=com 251 264 }}} 252 265 253 266 See also: 254 - [http://httpd.apache.org/docs/2.2/mod/mod_authnz_ldap.html mod_authnz_ldap], documentation for mod_authnz_ldap 255 267 - [http://httpd.apache.org/docs/2.2/mod/mod_authnz_ldap.html mod_authnz_ldap], documentation for mod_authnz_ldap. 256 268 - [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. 257 269 - [http://trac-hacks.org/wiki/LdapPlugin TracHacks:LdapPlugin] for storing TracPermissions in LDAP. … … 259 271 === Using SSPI Authentication 260 272 261 If you are using Apache on Windows, you can use mod_auth_sspi to provide 262 single-sign-on. Download the module from the !SourceForge [http://sourceforge.net/projects/mod-auth-sspi/ mod-auth-sspi project] and then add the 263 following to your !VirtualHost: 264 {{{ 265 <Location /trac/login> 266 AuthType SSPI 267 AuthName "Trac Login" 268 SSPIAuth On 269 SSPIAuthoritative On 270 SSPIDomain MyLocalDomain 271 SSPIOfferBasic On 272 SSPIOmitDomain Off 273 SSPIBasicPreferred On 274 Require valid-user 275 </Location> 276 }}} 277 278 Using the above, usernames in Trac will be of the form `DOMAIN\username`, so 279 you may have to re-add permissions and such. If you do not want the domain to 280 be part of the username, set `SSPIOmitDomain On` instead. 273 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: 274 {{{#!apache 275 <Location /trac/login> 276 AuthType SSPI 277 AuthName "Trac Login" 278 SSPIAuth On 279 SSPIAuthoritative On 280 SSPIDomain MyLocalDomain 281 SSPIOfferBasic On 282 SSPIOmitDomain Off 283 SSPIBasicPreferred On 284 Require valid-user 285 </Location> 286 }}} 287 288 Using the above, usernames in Trac will be of the form `DOMAIN\username`, so you may have to re-add permissions and such. If you do not want the domain to be part of the username, set `SSPIOmitDomain On` instead. 281 289 282 290 Some common problems with SSPI authentication: [trac:#1055], [trac:#1168] and [trac:#3338]. … … 284 292 See also [trac:TracOnWindows/Advanced]. 285 293 294 === Using CA !SiteMinder Authentication 295 Setup CA !SiteMinder to protect your Trac login URL (e.g. `/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: 296 {{{#!apache 297 RemoteUserVar="WHATEVER_IT_SHOULD_BE" 298 SetRemoteUser="YES" 299 }}} 300 The 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. 301 302 Also add a !LogOffUri parameter to the agent configuration (e.g. `/trac/logout`). 303 304 Then 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`: 305 306 {{{#!python 307 def application(environ, start_request): 308 # Set authenticated username on CA SiteMinder to REMOTE_USER variable 309 # strip() is used to remove any spaces on the end of the string 310 if 'HTTP_SM_USER' in environ: 311 environ['REMOTE_USER'] = environ['HTTP_REMOTE_USER'].strip() 312 ... 313 }}} 314 315 Note: you do not need any Apache "Location" directives. 316 286 317 === Using Apache authentication with the Account Manager plugin's Login form === 287 318 … … 291 322 292 323 Here is an example (from the !HttpAuthStore link) using acct_mgr-0.4 for hosting a single project: 293 {{{ 324 {{{#!ini 294 325 [components] 295 326 ; be sure to enable the component … … 302 333 }}} 303 334 This will generally be matched with an Apache config like: 304 {{{ 335 {{{#!apache 305 336 <Location /authFile> 306 …HTTP authentication configuration…337 # HTTP authentication configuration 307 338 Require valid-user 308 339 </Location> 309 340 }}} 310 Note that '''authFile''' need not exist . See the !HttpAuthStore link above for examples where multiple Trac projects are hosted on a server.341 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. 311 342 312 343 === Example: Apache/mod_wsgi with Basic Authentication, Trac being at the root of a virtual host 313 344 314 Per the mod_wsgi documentation linked to above, here is an example Apache configuration that a) serves the Trac instance from a virtualhost subdomain and b) uses Apache basic authentication for Trac authentication. 315 345 Per the mod_wsgi documentation linked to above, here is an example Apache configuration that: 346 - serves the Trac instance from a virtualhost subdomain 347 - uses Apache basic authentication for Trac authentication. 316 348 317 349 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: 318 350 319 351 Create the htpasswd file: 320 {{{ 352 {{{#!sh 321 353 cd /home/trac-for-my-proj/the-env 322 354 htpasswd -c htpasswd firstuser … … 324 356 htpasswd htpasswd seconduser 325 357 }}} 326 (keep the file above your document root for security reasons) 327 328 Create this file e.g. (ubuntu) `/etc/apache2/sites-enabled/trac.my-proj.my-site.org.conf` with the following content s:329 330 {{{ 358 Keep the file above your document root for security reasons. 359 360 Create this file e.g. (ubuntu) `/etc/apache2/sites-enabled/trac.my-proj.my-site.org.conf` with the following content: 361 362 {{{#!apache 331 363 <Directory /home/trac-for-my-proj/the-deploy/cgi-bin/trac.wsgi> 332 364 WSGIApplicationGroup %{GLOBAL} … … 351 383 Note: for subdomains to work you would probably also need to alter `/etc/hosts` and add A-Records to your host's DNS. 352 384 353 354 385 == Troubleshooting 355 386 356 387 === Use a recent version 357 388 358 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].389 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]. 359 390 360 391 ''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/modwsgi@googlegroups.com/msg01917.html here]) solved this for me[[BR]]-- Graham Shanks'' 361 392 362 If you plan to use `mod_wsgi` in embedded mode on Windows or with the MPM worker on Linux, then you'll even need version 0.3.4 or greater (see [trac:#10675] for details). 363 364 === Getting Trac to work nicely with SSPI and 'Require Group' === 365 If like me you've 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 its not working your usernames in trac are probably looking like 'DOMAIN\user' rather than 'user'. 366 367 This WSGI script 'fixes' things, hope it helps: 393 If 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. 394 395 === Getting Trac to work nicely with SSPI and 'Require Group' 396 397 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'. 398 399 This WSGI script 'fixes' that: 368 400 {{{#!python 369 401 import os … … 379 411 }}} 380 412 381 382 === Trac with PostgreSQL === 383 384 When using the mod_wsgi adapter with multiple Trac instances and PostgreSQL (or MySQL?) as a database back-end, the server ''may'' create a lot of open database connections and thus PostgreSQL processes. 385 386 A somewhat brutal workaround is to disabled connection pooling in Trac. This is done by setting `poolable = False` in `trac.db.postgres_backend` on the `PostgreSQLConnection` class. 387 388 But it's not necessary to edit the source of Trac, the following lines in `trac.wsgi` will also work: 389 390 {{{ 413 === Trac with PostgreSQL 414 415 When 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. 416 417 A somewhat brutal workaround is to disable connection pooling in Trac. This is done by setting `poolable = False` in `trac.db.postgres_backend` on the `PostgreSQLConnection` class. 418 419 But it is not necessary to edit the source of Trac. The following lines in `trac.wsgi` will also work: 420 421 {{{#!python 391 422 import trac.db.postgres_backend 392 423 trac.db.postgres_backend.PostgreSQLConnection.poolable = False … … 395 426 or 396 427 397 {{{ 428 {{{#!python 398 429 import trac.db.mysql_backend 399 430 trac.db.mysql_backend.MySQLConnection.poolable = False 400 431 }}} 401 432 402 Now Trac drops the connection after serving a page and the connection count on the database will be kept minimal.433 Now Trac drops the connection after serving a page and the connection count on the database will be kept low. 403 434 404 435 //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.// 405 436 437 === Missing Headers and Footers 438 439 If python optimizations are enabled, then headers and footers will not be rendered. 440 441 In your WSGI configuration file, the `WSGIPythonOptimize` setting must be set to `0` as follows (`1` or `2` will not work): 442 443 {{{#!apache 444 WSGIPythonOptimize 0 445 }}} 446 447 On Ubuntu, the WSGI mod configuration is at `/etc/apache2/mods-enabled/wsgi.conf`. 448 449 NOTE: This is the WSGI equivalent of the same issue that happens with `PythonOptimize On` in [TracModPython#Pagelayoutissues ModPython] (see [trac:#8956]). 450 406 451 === Other resources 407 452 408 453 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. 409 454 410 411 455 ---- 412 See also: 456 See also: TracGuide, TracInstall, [wiki:TracFastCgi FastCGI], [wiki:TracModPython ModPython], [trac:TracNginxRecipe TracNginxRecipe]