[Teammetrics-discuss] What next?

[Vipin Nair]

Hi Andreas,

>> For example, I want annual upload data of say top N members for a
>> team. How do I get this? I did spend quiet some time on it, but could
>> not really figure it out. That crosstab is not what I want.
>
> If the crosstab is not what you want - what exactly do you want?

One single SQL query that returns the result if possible. I also want
the data on a monthly basis in addition to the annual data. Where in
the database is all this stored? I do not have a clear idea of UDD and
it is intimidating.


> After restarting apache2 and pointing a browser to
>
>   http://blends.debian.net/teammetrics
>
> I get
>
> # tail -n13 /srv/blends.debian.net/log/error.log
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104] mod_wsgi (pid=817): Exception occurred processing WSGI script '/var/lib/teammetrics/web/teammetrics.wsgi'.
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104] Traceback (most recent call last):
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]   File "/usr/lib/python2.6/dist-packages/django/core/handlers/wsgi.py", line 250, in __call__
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]     self.load_middleware()
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]   File "/usr/lib/python2.6/dist-packages/django/core/handlers/base.py", line 39, in load_middleware
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]     for middleware_path in settings.MIDDLEWARE_CLASSES:
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]   File "/usr/lib/python2.6/dist-packages/django/utils/functional.py", line 276, in __getattr__
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]     self._setup()
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]   File "/usr/lib/python2.6/dist-packages/django/conf/__init__.py", line 42, in _setup
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]     self._wrapped = Settings(settings_module)
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]   File "/usr/lib/python2.6/dist-packages/django/conf/__init__.py", line 89, in __init__
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104]     raise ImportError("Could not import settings '%s' (Is it on sys.path?): %s" % (self.SETTINGS_MODULE, e))
> [Thu Jul 19 22:42:07 2012] [error] [client 217.88.91.104] ImportError: Could not import settings 'web.settings' (Is it on sys.path?): No module named web.settings
>
> So something seems to be wrong with your code and I have no idea what
> this might be.


That helps :) I am sorry, it was my mistake.

Inside the wsgi script (web/teammetrics.wsgi) I add the location of
the code to PYTHONPATH. Since I am actively working on the code,
locally, I was serving the code from my home folder instead of a
directory in /var/lib/. I had not changed this configuration, once I
pulled the code to the server. I have fixed it now. Andreas, this
should work now. Could you please restart the web server? :)

-- 
Regards,
Vipin Nair
National Institute of Technology, Calicut
http://swvist.github.com