Hi Chris,

Thanks a lot for your help.

I can publish the review request after re-setting site_id in the
database, which might be deleted by my mistake.

Thanks again,

Ray

On Mar 27, 4:07 am, Christian Hammond <chip...@chipx86.com> wrote:
> It sounds like you didn't install Review Board correctly. The database is
> missing a Site entry, or your conf/settings_local.py file has the wrong
> SITE_ID set. Can you go through in detail and explain how you installed
> Review Board?
>
> Christian
>
> --
> Christian Hammond - chip...@chipx86.com
> Review Board -http://www.review-board.org
> VMware, Inc. -http://www.vmware.com
>
> On Thu, Mar 26, 2009 at 5:44 AM, ray.l.hu...@gmail.com <
>
>
>
> ray.l.hu...@gmail.com> wrote:
>
> > Hi,
>
> > When I setup review board for team's review process, I encountered one
> > problem of review board email notification
>
> > 1. First I installed both "Exim4" and review board on the same host.
>
> > 2. The trick is that I only used "Exim4" as one mail client to request
> > the corp exchange server.  After some tests, I confirmed that I can
> > use "Exim4 -v ray.l.hu...@gmail.com" to send the mail through that
> > corp exchange server.
>
> > 3. When I pulish my review request in review board, it was always
> > failed.  The error message is,
>
> > =====================================
> > Environment:
>
> > Request Method: GET
> > Request URL:http://10.32.117.28/r/17/publish/
> > Django Version: 0.97-pre-SVN-unknown
> > Python Version: 2.4.4
> > Installed Applications:
> > ['django.contrib.admin',
> >  'django.contrib.auth',
> >  'django.contrib.contenttypes',
> >  'django.contrib.sites',
> >  'django.contrib.sessions',
> >  'djblets.datagrid',
> >  'djblets.util',
> >  'reviewboard.accounts',
> >  'reviewboard.diffviewer',
> >  'reviewboard.iphone',
> >  'reviewboard.reports',
> >  'reviewboard.reviews',
> >  'reviewboard.scmtools',
> >  'reviewboard.utils',
> >  'reviewboard.webapi']
> > Installed Middleware:
> > ('django.middleware.common.CommonMiddleware',
> >  'django.middleware.doc.XViewMiddleware',
> >  'django.middleware.locale.LocaleMiddleware',
> >  'django.contrib.sessions.middleware.SessionMiddleware',
> >  'django.contrib.auth.middleware.AuthenticationMiddleware')
>
> > Traceback:
> > File "/usr/lib/python2.4/site-packages/django/core/handlers/base.py"
> > in get_response
> >  82.                 response = callback(request, *callback_args,
> > **callback_kwargs)
> > File "/usr/apache2/htdocs/reviewboard/djblets/auth/util.py" in
> > _checklogin
> >  45.             return view_func(request, *args, **kwargs)
> > File "/usr/apache2/htdocs/reviewboard/reviews/views.py" in publish
> >  368.             mail_review_request(request.user, review_request)
> > File "/usr/apache2/htdocs/reviewboard/reviews/email.py" in
> > mail_review_request
> >  150.                          {'changes': changes})
> > File "/usr/apache2/htdocs/reviewboard/reviews/email.py" in
> > send_review_mail
> >  55.     current_site = Site.objects.get(pk=settings.SITE_ID)
> > File "/usr/lib/python2.4/site-packages/django/db/models/manager.py" in
> > get
> >  69.         return self.get_query_set().get(*args, **kwargs)
> > File "/usr/lib/python2.4/site-packages/django/db/models/query.py" in
> > get
> >  263.             raise self.model.DoesNotExist, "%s matching query
> > does not exist." % self.model._meta.object_name
>
> > Exception Type: DoesNotExist at /r/17/publish/
> > Exception Value: Site matching query does not exist.
> > ===============================================================
>
> > ================================================
> > Request information
> > GET
>
> > No GET data
> > POST
>
> > No POST data
> > COOKIES
> > Variable        Value
> > sessionid
> > 'b995f80ec3ef169935ce3cf3822ff398'
> > META
> > Variable        Value
> > AUTH_TYPE
> > None
> > CONTENT_LENGTH
> > 0L
> > CONTENT_TYPE
> > None
> > GATEWAY_INTERFACE
> > 'CGI/1.1'
> > HTTP_ACCEPT
> > 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8'
> > HTTP_ACCEPT_CHARSET
> > 'gb2312,utf-8;q=0.7,*;q=0.7'
> > HTTP_ACCEPT_ENCODING
> > 'gzip,deflate'
> > HTTP_ACCEPT_LANGUAGE
> > 'zh-cn,zh;q=0.5'
> > HTTP_CONNECTION
> > 'keep-alive'
> > HTTP_COOKIE
> > 'sessionid=3f4b587b1b89b632e8f94b6d620de2a6;
> > sessionid=b995f80ec3ef169935ce3cf3822ff398'
> > HTTP_HOST
> > '10.32.117.28'
> > HTTP_KEEP_ALIVE
> > '300'
> > HTTP_REFERER
> > 'http://10.32.117.28/r/17/'
> > HTTP_USER_AGENT
> > 'Mozilla/5.0 (Windows; U; Windows NT 5.1; zh-CN; rv:1.9.0.3) Gecko/
> > 2008092417 Firefox/3.0.3'
> > PATH_INFO
> > '/17/publish/'
> > PATH_TRANSLATED
> > None
> > QUERY_STRING
> > None
> > REMOTE_ADDR
> > '10.32.100.78'
> > REMOTE_HOST
> > None
> > REMOTE_IDENT
> > None
> > REMOTE_USER
> > None
> > REQUEST_METHOD
> > 'GET'
> > SCRIPT_NAME
> > None
> > SERVER_NAME
> > '127.0.0.1'
> > SERVER_PORT
> > 80
> > SERVER_PROTOCOL
> > 'HTTP/1.1'
> > SERVER_SOFTWARE
> > 'mod_python'
> > Settings
> > Using settings module reviewboard.settings
> > Setting         Value
> > ABSOLUTE_URL_OVERRIDES
> > {}
> > ADMINS
> > ('Example Joe', 'ad...@example.com')
> > ADMIN_FOR
> > ()
> > ADMIN_MEDIA_PREFIX
> > '/media/'
> > ALLOWED_INCLUDE_ROOTS
> > ()
> > APPEND_SLASH
> > True
> > AUTHENTICATION_BACKENDS
> > ('django.contrib.auth.backends.ModelBackend',)
> > AUTH_PROFILE_MODULE
> > 'accounts.Profile'
> > BANNED_IPS
> > ()
> > BUILTIN_AUTH
> > True
> > CACHE_BACKEND
> > 'locmem:///'
> > CACHE_EXPIRATION_TIME
> > 2592000
> > CACHE_MIDDLEWARE_KEY_PREFIX
> > ''
> > CACHE_MIDDLEWARE_SECONDS
> > 600
> > COMMENTS_ALLOW_PROFANITIES
> > False
> > COMMENTS_BANNED_USERS_GROUP
> > None
> > COMMENTS_FIRST_FEW
> > 0
> > COMMENTS_MODERATORS_GROUP
> > None
> > COMMENTS_SKETCHY_USERS_GROUP
> > None
> > DATABASE_ENGINE
> > 'mysql'
> > DATABASE_HOST
> > ''
> > DATABASE_NAME
> > 'reviewboard'
> > DATABASE_OPTIONS
> > {}
> > DATABASE_PASSWORD
> > '********************'
> > DATABASE_PORT
> > ''
> > DATABASE_USER
> > 'root'
> > DATETIME_FORMAT
> > 'N j, Y, P'
> > DATE_FORMAT
> > 'N j, Y'
> > DEBUG
> > True
> > DEFAULT_CHARSET
> > 'utf-8'
> > DEFAULT_CONTENT_TYPE
> > 'text/html'
> > DEFAULT_FROM_EMAIL
> > 'webmas...@localhost'
> > DEFAULT_INDEX_TABLESPACE
> > ''
> > DEFAULT_REPOSITORY_PATH
> > None
> > DEFAULT_TABLESPACE
> > ''
> > DIFF_CONTEXT_COLLAPSE_THRESHOLD
> > 13
> > DIFF_CONTEXT_NUM_LINES
> > 5
> > DIFF_INCLUDE_SPACE_PATTERNS
> > []
> > DIFF_SYNTAX_HIGHLIGHTING
> > False
> > DISALLOWED_USER_AGENTS
> > ()
> > DOMAIN_METHOD
> > 'http'
> > EMAIL_HOST
> > 'localhost'
> > EMAIL_HOST_PASSWORD
> > '********************'
> > EMAIL_HOST_USER
> > ''
> > EMAIL_PORT
> > 25
> > EMAIL_SUBJECT_PREFIX
> > '[Django] '
> > EMAIL_USE_TLS
> > False
> > ENABLE_SEARCH
> > False
> > FILE_CHARSET
> > 'utf-8'
> > FIXTURE_DIRS
> > ()
> > HTDOCS_ROOT
> > '/usr/apache2/htdocs/reviewboard/htdocs'
> > IGNORABLE_404_ENDS
> > ('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico',
> > '.php')
> > IGNORABLE_404_STARTS
> > ('/cgi-bin/', '/_vti_bin', '/_vti_inf')
> > INSTALLED_APPS
> > ['django.contrib.admin', 'django.contrib.auth',
> > 'django.contrib.contenttypes', 'django.contrib.sites',
> > 'django.contrib.sessions', 'djblets.datagrid', 'djblets.util',
> > 'reviewboard.accounts', 'reviewboard.diffviewer',
> > 'reviewboard.iphone', 'reviewboard.reports', 'reviewboard.reviews',
> > 'reviewboard.scmtools', 'reviewboard.utils', 'reviewboard.webapi']
> > INTERNAL_IPS
> > ()
> > JING_PATH
> > '/usr/bin/jing'
> > LANGUAGES
> > (('ar', 'Arabic'), ('bn', 'Bengali'), ('bg', 'Bulgarian'), ('ca',
> > 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de',
> > 'German'), ('el', 'Greek'), ('en', 'English'), ('es', 'Spanish'), ('es-
> > ar', 'Argentinean Spanish'), ('fa', 'Persian'), ('fi', 'Finnish'),
> > ('fr', 'French'), ('ga', 'Gaeilge'), ('gl', 'Galician'), ('hu',
> > 'Hungarian'), ('he', 'Hebrew'), ('hr', 'Croatian'), ('is',
> > 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ko', 'Korean'),
> > ('km', 'Khmer'), ('kn', 'Kannada'), ('lv', 'Latvian'), ('mk',
> > 'Macedonian'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('pl', 'Polish'),
> > ('pt', 'Portugese'), ('pt-br', 'Brazilian'), ('ro', 'Romanian'),
> > ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sr',
> > 'Serbian'), ('sv', 'Swedish'), ('ta', 'Tamil'), ('te', 'Telugu'),
> > ('tr', 'Turkish'), ('uk', 'Ukrainian'), ('zh-cn', 'Simplified
> > Chinese'), ('zh-tw', 'Traditional Chinese'))
> > LANGUAGES_BIDI
> > ('he', 'ar', 'fa')
> > LANGUAGE_CODE
> > 'en-us'
> > LOCALE_PATHS
> > ()
> > LOGIN_REDIRECT_URL
> > '/accounts/profile/'
> > LOGIN_URL
> > '/account/login'
> > LOGOUT_URL
> > '/accounts/logout/'
> > MANAGERS
> > ('Example Joe', 'ad...@example.com')
> > MEDIA_ROOT
> > '/usr/apache2/htdocs/reviewboard/htdocs'
> > MEDIA_URL
> > '/'
> > MIDDLEWARE_CLASSES
> > ('django.middleware.common.CommonMiddleware',
> > 'django.middleware.doc.XViewMiddleware',
> > 'django.middleware.locale.LocaleMiddleware',
> > 'django.contrib.sessions.middleware.SessionMiddleware',
> > 'django.contrib.auth.middleware.AuthenticationMiddleware')
> > MONTH_DAY_FORMAT
> > 'F j'
> > PREPEND_WWW
> > False
> > PROFANITIES_LIST
> > '********************'
> > REQUIRE_SITEWIDE_LOGIN
> > False
> > REVIEWBOARD_ROOT
> > '/usr/apache2/htdocs/reviewboard'
> > ROOT_URLCONF
> > 'reviewboard.urls'
> > SEARCH_INDEX
> > '/usr/apache2/htdocs/reviewboard/search-index'
> > SECRET_KEY
> > '********************'
> > SEND_BROKEN_LINK_EMAILS
> > False
> > SEND_REVIEW_MAIL
> > True
> > SERVER_EMAIL
> > 'r...@localhost'
> > SESSION_COOKIE_AGE
> > 1209600
> > SESSION_COOKIE_DOMAIN
> > None
> > SESSION_COOKIE_NAME
> > 'sessionid'
> > SESSION_COOKIE_PATH
> > '/'
> > SESSION_COOKIE_SECURE
> > False
> > SESSION_ENGINE
> > 'django.contrib.sessions.backends.db'
> > SESSION_EXPIRE_AT_BROWSER_CLOSE
> > False
> > SESSION_FILE_PATH
> > '/tmp/'
> > SESSION_SAVE_EVERY_REQUEST
> > False
> > SETTINGS_MODULE
> > 'reviewboard.settings'
> > SITE_ID
> > 1
> > TEMPLATE_CONTEXT_PROCESSORS
> > ('django.core.context_processors.auth',
> > 'django.core.context_processors.debug',
> > 'django.core.context_processors.i18n',
> > 'django.core.context_processors.media',
> > 'django.core.context_processors.request',
> > 'djblets.util.context_processors.settingsVars')
> > TEMPLATE_DEBUG
> > True
> > TEMPLATE_DIRS
> > ('/usr/apache2/htdocs/reviewboard/templates',)
> > TEMPLATE_LOADERS
> > ('django.template.loaders.filesystem.load_template_source',
> > 'django.template.loaders.app_directories.load_template_source')
> > TEMPLATE_STRING_IF_INVALID
> > ''
> > TEST_DATABASE_CHARSET
> > None
>
> ...
>
> read more »- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"reviewboard" group.
To post to this group, send email to reviewboard@googlegroups.com
To unsubscribe from this group, send email to 
reviewboard+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/reviewboard?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to