No idea if settings.py, and settings_local.py will help. :)
在 2014年9月9日星期二UTC+8上午9时55分10秒，Magic Chen写道：
>
>
> Hi, David,
>
> the nginx conf file was attached.
> we start the reviewboard using the command below:
> rb-site manage /opt/reviewboard runfcgi port=3033 host=127.0.0.1
> protocol=fcgi daemonize=true pidfile=/opt/reviewboard/rb.pid maxspare=20
> anything else?
>
> thx a lot for ur kindly help.
>
> 在 2014年9月6日星期六UTC+8上午7时51分05秒，David Trowbridge写道：
>>
>> Can you give us some information about your web server configuration?
>>
>> -David
>>
>>
>> On Thu, Sep 4, 2014 at 2:28 AM, Magic Chen <[email protected]> wrote:
>>
>>> Dear all,
>>>
>>> I've install the latest 2.0.6 version in a CentOS (4G, 4Core), and the
>>> functions is working correctly,
>>> but we noticed that the response time of RB is too slow to be accepted,
>>> the response time for default dashboard page will cost almost 3s...
>>> We use the Postgre and nginx. python version is Python 2.6.6
>>> (r266:84292, Jan 22 2014, 09:42:36) [GCC 4.4.7 20120313 (Red Hat 4.4.7-4)]
>>> on linux2
>>> any advice on how to tuning the performance? thx a lot.
>>>
>>> 172.31.125.51 - - [04/Sep/2014:17:16:18 +0800] "GET
>>> /reviewboard/dashboard/ HTTP/1.1" 200 3161 "
>>> http://172.31.159.45/reviewboard/dashboard/"; "Mozilla/5.0 (Windows NT
>>> 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143
>>> Safari/537.36"
>>> 172.31.125.51 - - [04/Sep/2014:17:16:22 +0800] "GET /reviewboard/jsi18n/
>>> HTTP/1.1" 200 773 "http://172.31.159.45/reviewboard/dashboard/";
>>> "Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)
>>> Chrome/36.0.1985.143 Safari/537.36"
>>> 172.31.125.51 - - [04/Sep/2014:17:21:25 +0800] "GET
>>> /reviewboard/dashboard/ HTTP/1.1" 200 3161 "
>>> http://172.31.159.45/reviewboard/dashboard/"; "Mozilla/5.0 (Windows NT
>>> 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.143
>>> Safari/537.36"
>>>
>>>
>>> --
>>> Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
>>> ---
>>> Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
>>> ---
>>> Happy user? Let us know at http://www.reviewboard.org/users/
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "reviewboard" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
--
Get the Review Board Power Pack at http://www.reviewboard.org/powerpack/
---
Sign up for Review Board hosting at RBCommons: https://rbcommons.com/
---
Happy user? Let us know at http://www.reviewboard.org/users/
---
You received this message because you are subscribed to the Google Groups
"reviewboard" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
# Django settings for reviewboard project.
from __future__ import unicode_literals
import os
import re
import sys
import djblets
from django.core.urlresolvers import reverse
# Can't import django.utils.translation yet
_ = lambda s: s
DEBUG = True
ADMINS = (
('Example Joe', '[email protected]')
)
MANAGERS = ADMINS
# Time zone support. If enabled, Django stores date and time information as
# UTC in the database, uses time zone-aware datetime objects, and translates
# them to the user's time zone in templates and forms.
USE_TZ = True
# Local time zone for this installation. All choices can be found here:
# http://www.postgresql.org/docs/8.1/static/datetime-keywords.html#DATETIME-TIMEZONE-SET-TABLE
# When USE_TZ is enabled, this is used as the default time zone for datetime
# objects
TIME_ZONE = 'UTC'
# Language code for this installation. All choices can be found here:
# http://www.w3.org/TR/REC-html40/struct/dirlang.html#langcodes
# http://blogs.law.harvard.edu/tech/stories/storyReader$15
LANGUAGE_CODE = 'en-us'
# This should match the ID of the Site object in the database. This is used to
# figure out URLs to stick in e-mails and related pages.
SITE_ID = 1
# The prefix for e-mail subjects sent to administrators.
EMAIL_SUBJECT_PREFIX = "[Review Board] "
# If you set this to False, Django will make some optimizations so as not
# to load the internationalization machinery.
USE_I18N = False
# List of callables that know how to import templates from various sources.
TEMPLATE_LOADERS = (
('djblets.template.loaders.conditional_cached.Loader', (
'django.template.loaders.filesystem.Loader',
'djblets.template.loaders.namespaced_app_dirs.Loader',
'djblets.extensions.loaders.load_template_source',
)),
)
MIDDLEWARE_CLASSES = [
# Keep these first, in order
'django.middleware.gzip.GZipMiddleware',
'reviewboard.admin.middleware.InitReviewBoardMiddleware',
'django.middleware.clickjacking.XFrameOptionsMiddleware',
'django.middleware.common.CommonMiddleware',
'django.middleware.doc.XViewMiddleware',
'django.middleware.http.ConditionalGetMiddleware',
'django.middleware.locale.LocaleMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
# These must go before anything that deals with settings.
'djblets.siteconfig.middleware.SettingsMiddleware',
'reviewboard.admin.middleware.LoadSettingsMiddleware',
'djblets.extensions.middleware.ExtensionsMiddleware',
'djblets.log.middleware.LoggingMiddleware',
'reviewboard.accounts.middleware.TimezoneMiddleware',
'reviewboard.admin.middleware.CheckUpdatesRequiredMiddleware',
'reviewboard.admin.middleware.X509AuthMiddleware',
'reviewboard.site.middleware.LocalSiteMiddleware',
# Keep this last so that everything is initialized before middleware
# from extensions are run.
'djblets.extensions.middleware.ExtensionsMiddlewareRunner',
]
RB_EXTRA_MIDDLEWARE_CLASSES = []
TEMPLATE_CONTEXT_PROCESSORS = (
'django.contrib.auth.context_processors.auth',
'django.contrib.messages.context_processors.messages',
'django.core.context_processors.debug',
'django.core.context_processors.i18n',
'django.core.context_processors.media',
'django.core.context_processors.request',
'django.core.context_processors.static',
'djblets.cache.context_processors.ajax_serial',
'djblets.cache.context_processors.media_serial',
'djblets.siteconfig.context_processors.siteconfig',
'djblets.siteconfig.context_processors.settings_vars',
'djblets.urls.context_processors.site_root',
'reviewboard.accounts.context_processors.auth_backends',
'reviewboard.accounts.context_processors.profile',
'reviewboard.admin.context_processors.version',
'reviewboard.site.context_processors.localsite',
)
SITE_ROOT_URLCONF = 'reviewboard.urls'
ROOT_URLCONF = 'djblets.urls.root'
REVIEWBOARD_ROOT = os.path.abspath(os.path.split(__file__)[0])
# where is the site on your server ? - add the trailing slash.
SITE_ROOT = '/'
TEMPLATE_DIRS = (
# Don't forget to use absolute paths, not relative paths.
os.path.join(REVIEWBOARD_ROOT, 'templates'),
)
STATICFILES_DIRS = (
('lib', os.path.join(REVIEWBOARD_ROOT, 'static', 'lib')),
('rb', os.path.join(REVIEWBOARD_ROOT, 'static', 'rb')),
('djblets', os.path.join(os.path.dirname(djblets.__file__),
'static', 'djblets')),
)
STATICFILES_FINDERS = (
'django.contrib.staticfiles.finders.FileSystemFinder',
'django.contrib.staticfiles.finders.AppDirectoriesFinder',
'djblets.extensions.staticfiles.ExtensionFinder',
)
STATICFILES_STORAGE = 'pipeline.storage.PipelineCachedStorage'
RB_BUILTIN_APPS = [
'django.contrib.admin',
'django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sites',
'django.contrib.sessions',
'django.contrib.staticfiles',
'djblets',
'djblets.configforms',
'djblets.datagrid',
'djblets.extensions',
'djblets.feedview',
'djblets.gravatars',
'djblets.log',
'djblets.pipeline',
'djblets.siteconfig',
'djblets.util',
'djblets.webapi',
'haystack',
'pipeline', # Must be after djblets.pipeline
'reviewboard',
'reviewboard.accounts',
'reviewboard.admin',
'reviewboard.attachments',
'reviewboard.changedescs',
'reviewboard.datagrids',
'reviewboard.diffviewer',
'reviewboard.extensions',
'reviewboard.hostingsvcs',
'reviewboard.notifications',
'reviewboard.reviews',
'reviewboard.reviews.ui',
'reviewboard.scmtools',
'reviewboard.site',
'reviewboard.ssh',
'reviewboard.webapi',
]
# If installed, add django_reset to INSTALLED_APPS. This is used for the
# 'manage.py reset' command, which is very useful during development.
try:
import django_reset
RB_BUILTIN_APPS.append('django_reset')
except ImportError:
pass
RB_EXTRA_APPS = []
WEB_API_ENCODERS = (
'djblets.webapi.encoders.ResourceAPIEncoder',
)
SESSION_ENGINE = 'django.contrib.sessions.backends.cached_db'
# Set up a default cache backend. This will mostly be useful for
# local development, as sites will override this.
CACHES = {
'default': {
'BACKEND': 'django.core.cache.backends.locmem.LocMemCache',
'LOCATION': 'reviewboard',
},
}
LOGGING_NAME = "reviewboard"
LOGGING_REQUEST_FORMAT = "%(_local_site_name)s - %(user)s - %(path)s"
AUTH_PROFILE_MODULE = "accounts.Profile"
# Default expiration time for the cache. Note that this has no effect unless
# CACHE_BACKEND is specified in settings_local.py
CACHE_EXPIRATION_TIME = 60 * 60 * 24 * 30 # 1 month
# Custom test runner, which uses nose to find tests and execute them. This
# gives us a somewhat more comprehensive test execution than django's built-in
# runner, as well as some special features like a code coverage report.
TEST_RUNNER = 'reviewboard.test.RBTestRunner'
# Dependency checker functionality. Gives our users nice errors when they
# start out, instead of encountering them later on. Most of the magic for this
# happens in manage.py, not here.
install_help = '''
Please see https://www.reviewboard.org/docs/manual/dev/admin/
for help setting up Review Board.
'''
def dependency_error(string):
sys.stderr.write('%s\n' % string)
sys.stderr.write(install_help)
sys.exit(1)
if os.path.split(os.path.dirname(__file__))[1] != 'reviewboard':
dependency_error('The directory containing manage.py must be named '
'"reviewboard"')
LOCAL_ROOT = None
PRODUCTION = True
# Default ALLOWED_HOSTS to allow everything. This should be overridden in
# settings_local.py
ALLOWED_HOSTS = ['*']
# Cookie settings
LANGUAGE_COOKIE_NAME = "rblanguage"
SESSION_COOKIE_NAME = "rbsessionid"
SESSION_COOKIE_AGE = 365 * 24 * 60 * 60 # 1 year
# Default support settings
SUPPORT_URL_BASE = 'https://www.beanbaginc.com/support/reviewboard/'
DEFAULT_SUPPORT_URL = SUPPORT_URL_BASE + '?support-data=%(support_data)s'
REGISTER_SUPPORT_URL = (SUPPORT_URL_BASE +
'register/?support-data=%(support_data)s')
# Regular expression and flags used to match review request IDs in commit
# messages for hosting service webhooks. These can be overriden in
# settings_local.py.
HOSTINGSVCS_HOOK_REGEX = (r'(?:Reviewed at %(server_url)sr/|Review request #)'
'(?P<id>\d+)')
HOSTINGSVCS_HOOK_REGEX_FLAGS = re.IGNORECASE
# The SVN backends to attempt to load, in order. This is useful if more than
# one type of backend is installed on a server, and you need to force usage
# of a specific one.
SVNTOOL_BACKENDS = [
'reviewboard.scmtools.svn.pysvn',
'reviewboard.scmtools.svn.subvertpy',
]
# Load local settings. This can override anything in here, but at the very
# least it needs to define database connectivity.
try:
import settings_local
from settings_local import *
except ImportError as exc:
dependency_error('Unable to import settings_local.py: %s' % exc)
SESSION_COOKIE_PATH = SITE_ROOT
INSTALLED_APPS = RB_BUILTIN_APPS + RB_EXTRA_APPS + ['django_evolution']
MIDDLEWARE_CLASSES += RB_EXTRA_MIDDLEWARE_CLASSES
TEMPLATE_DEBUG = DEBUG
if not LOCAL_ROOT:
local_dir = os.path.dirname(settings_local.__file__)
if os.path.exists(os.path.join(local_dir, 'reviewboard')):
# reviewboard/ is in the same directory as settings_local.py.
# This is probably a Git checkout.
LOCAL_ROOT = os.path.join(local_dir, 'reviewboard')
PRODUCTION = False
else:
# This is likely a site install. Get the parent directory.
LOCAL_ROOT = os.path.dirname(local_dir)
if PRODUCTION:
SITE_DATA_DIR = os.path.join(LOCAL_ROOT, 'data')
else:
SITE_DATA_DIR = os.path.dirname(LOCAL_ROOT)
HTDOCS_ROOT = os.path.join(LOCAL_ROOT, 'htdocs')
STATIC_ROOT = os.path.join(HTDOCS_ROOT, 'static')
MEDIA_ROOT = os.path.join(HTDOCS_ROOT, 'media')
ADMIN_MEDIA_ROOT = STATIC_ROOT + 'admin/'
# XXX This is deprecated, but kept around for compatibility, in case any
# old extensions reference it. We'll want to deprecate it.
EXTENSIONS_STATIC_ROOT = os.path.join(MEDIA_ROOT, 'ext')
# Haystack requires this to be defined here, otherwise it will throw errors.
# The actual PATH will be loaded through load_site_config()
HAYSTACK_CONNECTIONS = {
'default': {
'ENGINE': 'haystack.backends.whoosh_backend.WhooshEngine',
'PATH': os.path.join(SITE_DATA_DIR, 'search-index'),
},
}
# Make sure that we have a staticfiles cache set up for media generation.
# By default, we want to store this in local memory and not memcached or
# some other backend, since that will cause stale media problems.
if 'staticfiles' not in CACHES:
CACHES['staticfiles'] = {
'BACKEND': 'django.core.cache.backends.locmem.LocMemCache',
'LOCATION': 'staticfiles-filehashes',
}
# URL prefix for media -- CSS, JavaScript and images. Make sure to use a
# trailing slash.
#
# Examples: "http://foo.com/media/";, "/media/".
STATIC_DIRECTORY = 'static/'
STATIC_URL = getattr(settings_local, 'STATIC_URL',
SITE_ROOT + STATIC_DIRECTORY)
MEDIA_DIRECTORY = 'media/'
MEDIA_URL = getattr(settings_local, 'MEDIA_URL', SITE_ROOT + MEDIA_DIRECTORY)
# Base these on the user's SITE_ROOT.
LOGIN_URL = SITE_ROOT + 'account/login/'
LOGIN_REDIRECT_URL = SITE_ROOT + 'dashboard/'
# Static media setup
from reviewboard.staticbundles import PIPELINE_CSS, PIPELINE_JS
PIPELINE_CSS_COMPRESSOR = None
PIPELINE_JS_COMPRESSOR = 'pipeline.compressors.uglifyjs.UglifyJSCompressor'
# On production (site-installed) builds, we always want to use the pre-compiled
# versions. We want this regardless of the DEBUG setting (since they may
# turn DEBUG on in order to get better error output).
#
# On a build running out of a source tree, for testing purposes, we want to
# use the raw .less and JavaScript files when DEBUG is set. When DEBUG is
# turned off in a non-production build, though, we want to be able to play
# with the built output, so treat it like a production install.
if PRODUCTION or not DEBUG or os.getenv('FORCE_BUILD_MEDIA', ''):
PIPELINE_COMPILERS = ['pipeline.compilers.less.LessCompiler']
PIPELINE_ENABLED = True
elif DEBUG:
PIPELINE_COMPILERS = []
PIPELINE_ENABLED = False
# Packages to unit test
TEST_PACKAGES = ['reviewboard']
# URL Overrides
ABSOLUTE_URL_OVERRIDES = {
'auth.user': lambda u: reverse('user', kwargs={'username': u.username})
}
# Site-specific configuration settings for Review Board
# Definitions of these settings can be found at
# http://docs.djangoproject.com/en/dev/ref/settings/
# Database configuration
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'NAME': 'reviewboard',
'USER': 'reviewboard',
'PASSWORD': 'reviewboard',
'HOST': '172.31.159.40',
'PORT': '',
},
}
# Unique secret key. Don't share this with anybody.
SECRET_KEY = 'n&4tbb*bu!_15lm2jx2a=&n--+$*17vvh+hl+rw%i56fm53np)'
# Cache backend settings.
CACHES = {
'default': {
'BACKEND': 'django.core.cache.backends.memcached.MemcachedCache',
'LOCATION': '172.1.159.40:11211',
},
}
# Extra site information.
SITE_ID = 1
SITE_ROOT = '/reviewboard/'
FORCE_SCRIPT_NAME = ''
DEBUG = True
ALLOWED_HOSTS = ['172.31.159.45']
