OSQA error 500 viewing member profile

Repository of web frameworks and applications for Microsoft IIS.
User avatar
Posts: 14
Joined: 10 Mar 2014, 10:24

OSQA error 500 viewing member profile

01 Apr 2014, 05:44

Hello,

I have an error 500 when clicking on member name to see member profile, but only when I perform external network access.

I use always the same url to access my server: external DNS, here is an example url : http://forum.imagx.org/users/11/simon

An apache proxy redirects to internal server (an IIS 7.5 website, using Helicon OSQA package, 08/2013).

In log file I don't have error logged at time of 500 error, but I see user profile related errors. Thanks for giving me a clue, here is log file with some anonymization.

Code: Select all
D:\[...]\forum\venv\lib\site-packages\django\core\handlers\base.py TIME: 2014-04-01 10:33:11,358 MSG: base.py:handle_uncaught_exception:209 Internal Server Error: /users/11/simon
Traceback (most recent call last):
  File "D:\[...]\forum\venv\lib\site-packages\django\core\handlers\base.py", line 111, in get_response
    response = callback(request, *callback_args, **callback_kwargs)
  File "D:\[...]\forum\osqa_project\forum\modules\decorators.py", line 95, in decorated
    return decoratable(*args, **kwargs)
  File "D:\[...]\forum\osqa_project\forum\modules\decorators.py", line 60, in __call__
    res = dec(res, *args, **kwargs)
  File "D:\[...]\forum\osqa_project\forum\views\users.py", line 317, in result
    return render_to_response(template, context, context_instance=RequestContext(request))
  File "D:\[...]\forum\venv\lib\site-packages\django\shortcuts\__init__.py", line 20, in render_to_response
    return HttpResponse(loader.render_to_string(*args, **kwargs), **httpresponse_kwargs)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\loader.py", line 188, in render_to_string
    return t.render(context_instance)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 123, in render
    return self._render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 117, in _render
    return self.nodelist.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
    bits.append(self.render_node(node, context))
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
    return node.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 127, in render
    return compiled_parent._render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 117, in _render
    return self.nodelist.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
    bits.append(self.render_node(node, context))
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
    return node.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 127, in render
    return compiled_parent._render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 117, in _render
    return self.nodelist.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
    bits.append(self.render_node(node, context))
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
    return node.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 64, in render
    result = block.nodelist.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
    bits.append(self.render_node(node, context))
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
    return node.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 64, in render
    result = block.nodelist.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
    bits.append(self.render_node(node, context))
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
    return node.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 159, in render
    return self.render_template(self.template, context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 141, in render_template
    output = template.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 123, in render
    return self._render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 117, in _render
    return self.nodelist.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
    bits.append(self.render_node(node, context))
  File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
    return node.render(context)
  File "D:\[...]\forum\venv\lib\site-packages\django\template\defaulttags.py", line 450, in render
    raise e
NoReverseMatch: Reverse for 'user_report' with arguments '('',)' and keyword arguments '{}' not found.
D:\[...]\forum\osqa_project\forum\views\meta.py TIME: 2014-04-01 10:33:11,358 MSG: meta.py:error_handler:200
        error executing request:
        PATH: /users/11/simon
        USER: <anonymous>
        METHOD: GET
        POST PARAMETERS:
        None
        GET PARAMETERS:
        None
        HTTP HEADERS:
              AUTH_TYPE:
      wsgi.multiprocess: False
      HTTPS_SERVER_ISSUER:
      HTTP_X_FORWARDED_SERVER: [forum address]
      HTTP_COOKIE: csrftoken=035e2e135850258ee9805dd561530050; sessionid=1f8e90baa3d9713c7237194a89a6369a; __utma=207241483.1434223479.1394640968.1395830371.1396007517.3; __utmz=207241483.1394640968.1.1.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not%20provided)
      HTTP_X_FORWARDED_HOST: [forum address]
      wsgi.multithread: False
      SERVER_SOFTWARE: Microsoft-IIS/7.5
      SCRIPT_NAME:
      LOCAL_ADDR: [server internal IP]
      QUERY_STRING:
      REQUEST_METHOD: GET
      REMOTE_USER:
      PATH_INFO: /users/11/simon
      SERVER_PROTOCOL: HTTP/1.0
      CERT_COOKIE:
      AUTH_PASSWORD:
      CONTENT_LENGTH: 0
      wsgi.url_scheme: http
      APPL_PHYSICAL_PATH: D:\[...]\forum      HTTP_REFERER: http://[forum address]
      SERVER_NAME: [forum address]
      REMOTE_ADDR: [my computer IP]
      APPL_MD_PATH: /LM/W3SVC/2/ROOT
      INSTANCE_ID: 2
      HTTPS_KEYSIZE:
      SERVER_PORT: 80
      REQUEST_URI: /users/11/simon
      CERT_SERIALNUMBER:
      HTTP_ACCEPT: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
      HTTPS_SERVER_SUBJECT:
      URL: /users/11/simon
      HTTPS_SECRETKEYSIZE:
      SCRIPT_FILENAME: D:\[...]\forum\users\11\simon
      wsgi.input: <__main__.InputStream object at 0x013B4390>
      HTTP_USER_AGENT: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:28.0) Gecko/20100101 Firefox/28.0
      HTTP_HOST: [forum address]
      HTTPS: off
      SERVER_PORT_SECURE: 0
      CERT_SUBJECT:
      CERT_ISSUER:
      CERT_FLAGS:
      PATH_TRANSLATED: D:\[...]\forum\users\11\simon
      CSRF_COOKIE_USED: True
      wsgi.version: (1, 0)
      GATEWAY_INTERFACE: CGI/1.1
      HTTP_X_FORWARDED_FOR: [some IP]
      CSRF_COOKIE: 035e2e135850258ee9805dd561530050
      wsgi.errors: <__main__.TeeOutputStream object at 0x013B4810>
      REMOTE_PORT: 50051
      HTTP_ACCEPT_LANGUAGE: fr,fr-fr;q=0.8,en-us;q=0.5,en;q=0.3
      APPL_PATH:
      LOGON_USER:
      INSTANCE_NAME: [forum address]
      wsgi.run_once: False
      CONTENT_TYPE:
      INSTANCE_META_PATH: /LM/W3SVC/2
      AUTH_USER:
      DOCUMENT_ROOT: D:\[...]\forum      REMOTE_HOST: [my computer IP]
      HTTP_ACCEPT_ENCODING: gzip, deflate

        COOKIES:
              csrftoken: 035e2e135850258ee9805dd561530050
      __utma: 207241483.1434223479.1394640968.1395830371.1396007517.3
      sessionid: 1f8e90baa3d9713c7237194a89a6369a
      __utmz: 207241483.1394640968.1.1.utmcsr=google|utmccn=(organic)|utmcmd=organic|utmctr=(not%20provided)

        EXCEPTION INFO:
              Traceback (most recent call last):
        File "D:\[...]\forum\venv\lib\site-packages\django\core\handlers\base.py", line 111, in get_response
          response = callback(request, *callback_args, **callback_kwargs)
        File "D:\[...]\forum\osqa_project\forum\modules\decorators.py", line 95, in decorated
          return decoratable(*args, **kwargs)
        File "D:\[...]\forum\osqa_project\forum\modules\decorators.py", line 60, in __call__
          res = dec(res, *args, **kwargs)
        File "D:\[...]\forum\osqa_project\forum\views\users.py", line 317, in result
          return render_to_response(template, context, context_instance=RequestContext(request))
        File "D:\[...]\forum\venv\lib\site-packages\django\shortcuts\__init__.py", line 20, in render_to_response
          return HttpResponse(loader.render_to_string(*args, **kwargs), **httpresponse_kwargs)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\loader.py", line 188, in render_to_string
          return t.render(context_instance)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 123, in render
          return self._render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 117, in _render
          return self.nodelist.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
          bits.append(self.render_node(node, context))
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
          return node.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 127, in render
          return compiled_parent._render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 117, in _render
          return self.nodelist.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
          bits.append(self.render_node(node, context))
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
          return node.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 127, in render
          return compiled_parent._render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 117, in _render
          return self.nodelist.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
          bits.append(self.render_node(node, context))
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
          return node.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 64, in render
          result = block.nodelist.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
          bits.append(self.render_node(node, context))
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
          return node.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 64, in render
          result = block.nodelist.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
          bits.append(self.render_node(node, context))
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
          return node.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 159, in render
          return self.render_template(self.template, context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\loader_tags.py", line 141, in render_template
          output = template.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 123, in render
          return self._render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 117, in _render
          return self.nodelist.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 744, in render
          bits.append(self.render_node(node, context))
        File "D:\[...]\forum\venv\lib\site-packages\django\template\base.py", line 757, in render_node
          return node.render(context)
        File "D:\[...]\forum\venv\lib\site-packages\django\template\defaulttags.py", line 450, in render
          raise e
      NoReverseMatch: Reverse for 'user_report' with arguments '('',)' and keyword arguments '{}' not found.

User avatar
Posts: 110
Joined: 07 Mar 2012, 10:22

Re: OSQA error 500 viewing member profile

01 Apr 2014, 06:31

Hello,

I can not reproduce the error.

Does this error appears only when request goes from apache proxy?
Does this url works if it requested locally, not via proxy?

Thanks.

User avatar
Posts: 14
Joined: 10 Mar 2014, 10:24

Re: OSQA error 500 viewing member profile

01 Apr 2014, 10:45

Yes to both questions, it fails when going through Apache proxy only.

Here is the proxy configuration, very basic:

Code: Select all
<VirtualHost *:80>
   ServerName forum.imagx.org
   ServerAlias forum.imagx.org
   ProxyRequests Off
   ProxyVia Off
   # Preserve host so that PHP $_SERVER['HTTP_HOST'] has external server name value
        ProxyPreserveHost On

   ErrorLog /var/log/apache2/forum_org.log
   LogLevel error
   
   ProxyPass / http://internalServerIp/
    ProxyPassReverse / http://internalServerIp/
   
   <Proxy *>
      Order deny,allow
      Allow from all
   </Proxy>
   <Location />
      Order allow,deny
      Allow from all
   </Location>
</VirtualHost>

User avatar
Posts: 110
Joined: 07 Mar 2012, 10:22

Re: OSQA error 500 viewing member profile

02 Apr 2014, 05:23

Hello,

We need to compare request from apache proxy and locally request.

In order to enable request logging please add these lines to osqa web.config:

Code: Select all
<environmentVariables>
  ...
  <add name="ERROR_LOG_DIR"  value="logs" />
  <add name="ERROR_LOG_LEVEL"  value="trace" />
</environmentVariables>


Then make ONE request via apache proxy and ONE request locally and show log file located in 'logs' directory.

Thanks.

User avatar
Posts: 14
Joined: 10 Mar 2014, 10:24

Re: OSQA error 500 viewing member profile

03 Apr 2014, 11:51

Hello, here are the log files as zipped attachments.

Thanks for helping,

ZooError-0_see_user_profile_locally.zip
(2.4 KiB) Downloaded 1669 times


ZooError-0_see_user_profile_through_proxy.zip
(2.32 KiB) Downloaded 1751 times

User avatar
Posts: 14
Joined: 10 Mar 2014, 10:24

Re: OSQA error 500 viewing member profile

03 Apr 2014, 12:02

I also attach the django log, same error as mentioned before.

django.osqa.log.zip
(2.23 KiB) Downloaded 1716 times

User avatar
Posts: 110
Joined: 07 Mar 2012, 10:22

Re: OSQA error 500 viewing member profile

04 Apr 2014, 10:57

Hello!

Thank you for the logs.

The error occurs depending on whether you are logged in or not.
If you go to user profile as not-logged user then error will occur.

It looks like OSQA error but i'm not sure.

User avatar
Posts: 14
Joined: 10 Mar 2014, 10:24

Re: OSQA error 500 viewing member profile

07 Apr 2014, 04:18

Thanks Ruslan, I confirm that unlogged external access triggers 500 error, while logged external access works, so I will report bug to OSQA.

Return to Helicon Zoo

Who is online

Users browsing this forum: No registered users and 5 guests