[Teammetrics-discuss] What next?

[Andreas Tille]

On Fri, Jul 20, 2012 at 09:32:07AM +0530, Vipin Nair wrote:
> >> 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.

But *what* exact result do you want to see.  Could you fake a result
output to let me understand more clearly.  Some procedures are defined
in create_names_prefered.sql in the Git repository and there are
simple examples for their usage.

> 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.
 
I personally dived into UDD starting by

 \d
 \d tablename

and tried to write some functions that did the needed preparation.  I'm
fine with helping out in some SQL issues but I need more precise
questions to find a reasonable answer.
 
> 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? :)

I did - but now it also does not work ... and there is even no entry
in the error.log:

debian-med:~# tail /srv/blends.debian.net/log/error.log
[Fri Jul 20 01:04:39 2012] [error] [client 207.46.13.48] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/robots.txt
[Fri Jul 20 01:15:44 2012] [error] [client 180.76.5.173] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/robots.txt
[Fri Jul 20 01:29:11 2012] [error] [client 58.218.199.227] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/httpproxy
[Fri Jul 20 01:32:25 2012] [error] [client 1.202.218.8] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/robots.txt
[Fri Jul 20 02:06:16 2012] [error] [client 207.46.13.48] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/robots.txt
[Fri Jul 20 03:14:27 2012] [error] [client 65.52.109.62] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/robots.txt
[Fri Jul 20 04:04:09 2012] [error] [client 61.111.15.70] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/edu/bugs/main-server.htmlopicid=101621
[Fri Jul 20 04:04:28 2012] [error] [client 61.111.15.70] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/edu/bugs/networked-common.htmllogNo=20125116624DR-HNRDVD.html_Spey_Aviemore_and_the_Cairngorms_Scottish_Highlands_Scotland.html
[Fri Jul 20 04:25:46 2012] [error] [client 58.218.199.227] File does not exist: /var/lib/gforge/chroot/home/groups/blends/htdocs/jj.php
[Fri Jul 20 05:06:20 2012] [error] [client 65.52.108.12] File doesdebian-med:~# 

It looks very strange that the error log seems to even lack an fflush()
call.  This is the status after having restarted apache twice!. 

More Django magic???

Kind regards

        Andreas.

-- 
http://fam-tille.de