schooltoolers team mailing list archive

Thread
Date
Re: Reports, I can't generate them

To: Tom Hoffman <tom.hoffman@xxxxxxxxx>
From: Lluís Dalmau <lluis.dalmau@xxxxxxxxx>
Date: Mon, 8 Sep 2014 11:42:53 +0200
Cc: SchoolTool Users <schooltoolers@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAJmy8XRoWfAiCjMVnB0_sW7z-x=9s6XrQ_XETbHGXV22az3NTg@mail.gmail.com>
Sender: dalmau.lluis@xxxxxxxxx
Thanks Tom,

I send /var/log/schooltool/celery_report.log.1.gz, because
celery_report.log is empty yet,



2014-09-05 15:34 GMT+02:00 Tom Hoffman <tom.hoffman@xxxxxxxxx>:

> Thanks Lluis.
>
> Could you send us
>
> /var/log/schooltool/celery_report.log
>
> Thanks!
>
> --Tom
>
>
> On Fri, Sep 5, 2014 at 4:32 AM, Lluís Dalmau <lluis.dalmau@xxxxxxxxx>
> wrote:
>
>> Hi Tom,
>>
>> Thank you for the answer!
>>
>> It seems that the problem is in the services:celery_report, which after
>> start, immediatly stops, and it seems that it is not a memory problem because
>> this virtual machine has 3 gigabytes of RAM and 0.5 of swap:
>>
>> root@pompeu:~# service schooltool status
>> schooltool                       RUNNING    pid 1146, uptime 0:13:32
>> services:celery_report           EXITED     Sep 05 11:39 AM
>> services:redis                   RUNNING    pid 1143, uptime 0:13:32
>> services:zeo                     RUNNING    pid 1144, uptime 0:13:32
>>
>> root@pompeu:~# service schooltool stop
>>  * Stopping
>> SchoolTool...
>> [ OK ]
>>
>> root@pompeu:~# service schooltool start
>>  * Starting
>> SchoolTool...
>> [ OK ]
>>
>> root@openerp:~# service schooltool status
>> schooltool                       RUNNING    pid 1143, uptime 0:00:15
>> services:celery_report           EXITED     Sep 05 11:55 AM
>> services:redis                   RUNNING    pid 1140, uptime 0:00:15
>> services:zeo                     RUNNING    pid 1141, uptime 0:00:15
>>
>> top - 12:03:59 up 8 min,  1 user,  load average: 0.36, 0.25, 0.11
>> Tasks:  41 total,   1 running,  40 sleeping,   0 stopped,   0 zombie
>> Cpu(s): 10.2%us,  1.7%sy,  0.0%ni, 88.1%id,  0.0%wa,  0.0%hi,  0.0%si,
>> 0.0%st
>> Mem:   3145728k total,   582192k used,  2563536k free,        0k buffers
>> Swap:   524288k total,        0k used,   524288k free,    46064k cached
>>
>> And this is part of /var/log/schooltool/error.log:
>> 2014-09-03 01:02:24,109 ['/var/run/schooltool/zeo.sock'] ClientStorage
>> (pid=31369) created RW/normal for storage: '1'
>> 2014-09-03 01:02:24,109 created temporary cache file '<fdopen>'
>> 2014-09-03 01:02:24,208 ['/var/run/schooltool/zeo.sock'] Testing
>> connection <ManagedClientConnection /var/run/schooltool/zeo.sock>
>> 2014-09-03 01:02:24,208 (/var/run/schooltool/zeo.sock) received handshake
>> 'Z309'
>> 2014-09-03 01:02:24,309 ['/var/run/schooltool/zeo.sock'] Server
>> authentication protocol None
>> 2014-09-03 01:02:24,309 ['/var/run/schooltool/zeo.sock'] Connected to
>> storage: /var/run/schooltool/zeo.sock
>> 2014-09-03 01:02:24,310 ['/var/run/schooltool/zeo.sock'] No verification
>> necessary -- empty cache
>> 2014-09-03 01:02:24,322 main db: evolving in mode EVOLVEMINIMUM
>> 2014-09-03 01:02:24,323 main db/schooltool: currently at generation 43,
>> targetting generation 44
>> 2014-09-03 01:02:24,442 main db/schooltool.intervention: currently at
>> generation 8, targetting generation 9
>> 2014-09-03 01:02:41,870 ['/var/run/schooltool/zeo.sock'] ClientStorage
>> (pid=32579) created RW/normal for storage: '1'
>> 2014-09-03 01:02:41,870 created temporary cache file '<fdopen>'
>> 2014-09-03 01:02:41,977 ['/var/run/schooltool/zeo.sock'] Testing
>> connection <ManagedClientConnection /var/run/schooltool/zeo.sock>
>> 2014-09-03 01:02:41,977 (/var/run/schooltool/zeo.sock) received handshake
>> 'Z309'
>> 2014-09-03 01:02:42,077 ['/var/run/schooltool/zeo.sock'] Server
>> authentication protocol None
>> 2014-09-03 01:02:42,078 ['/var/run/schooltool/zeo.sock'] Connected to
>> storage: /var/run/schooltool/zeo.sock
>> 2014-09-03 01:02:42,078 ['/var/run/schooltool/zeo.sock'] No verification
>> necessary -- empty cache
>> 2014-09-03 01:02:42,091 main db: evolving in mode EVOLVEMINIMUM
>> 2014-09-03 01:22:07,364 ['/var/run/schooltool/zeo.sock'] ClientStorage
>> (pid=1012) created RW/normal for storage: '1'
>> 2014-09-03 01:22:07,365 created temporary cache file '<fdopen>'
>> 2014-09-03 01:22:07,461 (1012) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:22:23,356 ['/var/run/schooltool/zeo.sock'] ClientStorage
>> (pid=1032) created RW/normal for storage: '1'
>> 2014-09-03 01:22:23,357 created temporary cache file '<fdopen>'
>> 2014-09-03 01:22:24,819 (1032) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:22:29,821 (1032) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:22:42,519 ['/var/run/schooltool/zeo.sock'] ClientStorage
>> (pid=1050) created RW/normal for storage: '1'
>> 2014-09-03 01:22:42,520 created temporary cache file '<fdopen>'
>> 2014-09-03 01:22:42,622 (1050) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:22:47,623 (1050) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:22:57,633 (1050) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:23:17,653 (1050) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:24:00,796 ['/var/run/schooltool/zeo.sock'] ClientStorage
>> (pid=1092) created RW/normal for storage: '1'
>> 2014-09-03 01:24:00,796 created temporary cache file '<fdopen>'
>> 2014-09-03 01:24:00,909 (1092) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:24:05,915 (1092) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:24:15,925 (1092) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:24:27,386 ['/var/run/schooltool/zeo.sock'] ClientStorage
>> (pid=1134) created RW/normal for storage: '1'
>> 2014-09-03 01:24:27,386 created temporary cache file '<fdopen>'
>> 2014-09-03 01:24:27,452 ['/var/run/schooltool/zeo.sock'] Testing
>> connection <ManagedClientConnection /var/run/schooltool/zeo.sock>
>> 2014-09-03 01:24:27,452 (/var/run/schooltool/zeo.sock) received handshake
>> 'Z309'
>> 2014-09-03 01:24:27,552 ['/var/run/schooltool/zeo.sock'] Server
>> authentication protocol None
>> 2014-09-03 01:24:27,553 ['/var/run/schooltool/zeo.sock'] Connected to
>> storage: /var/run/schooltool/zeo.sock
>> 2014-09-03 01:24:27,553 ['/var/run/schooltool/zeo.sock'] No verification
>> necessary -- empty cache
>> 2014-09-03 01:24:27,566 main db: evolving in mode EVOLVEMINIMUM
>> 2014-09-03 01:29:30,414 ['/var/run/schooltool/zeo.sock'] ClientStorage
>> (pid=1333) created RW/normal for storage: '1'
>> 2014-09-03 01:29:30,414 created temporary cache file '<fdopen>'
>> 2014-09-03 01:29:30,511 (1333) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:29:35,514 (1333) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>> 2014-09-03 01:29:45,522 (1333) CW: error connecting to
>> /var/run/schooltool/zeo.sock: ECONNREFUSED
>>
>>
>>
>> 2014-09-04 14:31 GMT+02:00 Tom Hoffman <tom.hoffman@xxxxxxxxx>:
>>
>>> Hi Lluis,
>>>
>>> Can you try the steps described here:
>>> http://book.schooltool.org/troubleshooting.html
>>>
>>> And send the results?
>>>
>>> --Tom
>>>
>>>
>>> On Thu, Sep 4, 2014 at 7:22 AM, Lluís Dalmau <lluis.dalmau@xxxxxxxxx>
>>> wrote:
>>>
>>>> Hello,
>>>>
>>>> I'm new with Schooltool, I read the book, I've installed 2.8.1, it
>>>> works fine with our school information and data, but I can't generate
>>>> reports. For example, if I want to print ID carts, I select a student
>>>> 'People > Surname Name' and 'ID card' as a report, this opens the ID Card
>>>> popup, then I select 'Generate', and appears new information in this popup,
>>>> 'Sheduled. * You can close ...', but it doesn't work.
>>>>
>>>> In 'Messages' appears a new message like this 'Generating
>>>> id_card_Name_Surname.pdf...'
>>>>
>>>> Where can I find these reports?
>>>>
>>>> Thanks!
>>>>
>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~schooltoolers
>>>> Post to     : schooltoolers@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~schooltoolers
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>>
>>>
>>
>
Attachment: celery_report.log.1.gz
Description: GNU Zip compressed data
Follow ups

Re: Reports, I can't generate them
From: Douglas Cerna, 2014-09-09
References

Reports, I can't generate them
From: Lluís Dalmau, 2014-09-04
Re: Reports, I can't generate them
From: Tom Hoffman, 2014-09-04
Re: Reports, I can't generate them
From: Lluís Dalmau, 2014-09-05
Re: Reports, I can't generate them
From: Tom Hoffman, 2014-09-05