← Back to team overview

schooltoolers team mailing list archive

Re: Reports, I can't generate them

 

Solved, thanks!

It seems, as Douglas said, that this kind of error was related to a
permission issue on shared memory.

I edited /etc/fstab and added:

none /dev/shm tmpfs rw,nosuid,nodev,noexec 0 0

And it works correctly!

2014-09-09 18:31 GMT+02:00 Tom Hoffman <tom.hoffman@xxxxxxxxx>:

> Hi Lluis,
>
> Perhaps you could try the fix in the links Douglas found?
>
> --Tom
>
> On Tue, Sep 9, 2014 at 12:23 PM, Lluís Dalmau <lluis.dalmau@xxxxxxxxx>
> wrote:
>
>> Hi Douglas,
>>
>> It's a linux container in a proxmox virtual environment. This is our
>> server, and we can make changes in the configuration, if you need or want
>> to have some tests.
>>
>> Lluís
>>
>>
>> 2014-09-09 18:05 GMT+02:00 Douglas Cerna <replaceafill@xxxxxxxxx>:
>>
>>> Hi Lluís.
>>>
>>> If I may ask, how are you running SchoolTool? A VM, a linux container,
>>> on a VPS provider?
>>>
>>> This is the first time I see this kind of error, and it seems related to
>>> a permission issue on shared memory:
>>>
>>>
>>> http://stackoverflow.com/questions/2009278/python-multiprocessing-permission-denied
>>>
>>> https://github.com/omniscale/imposm/issues/9
>>>
>>> Let us know.
>>>
>>> El 08/09/14 a las 03:42, Lluís Dalmau escibió:
>>> > 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
>>> > <mailto: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
>>> >     <mailto: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
>>> >         <mailto: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 <mailto: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
>>> >                 <mailto:schooltoolers@xxxxxxxxxxxxxxxxxxx>
>>> >                 Unsubscribe : https://launchpad.net/~schooltoolers
>>> >                 More help   : https://help.launchpad.net/ListHelp
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > _______________________________________________
>>> > Mailing list: https://launchpad.net/~schooltoolers
>>> > Post to     : schooltoolers@xxxxxxxxxxxxxxxxxxx
>>> > Unsubscribe : https://launchpad.net/~schooltoolers
>>> > More help   : https://help.launchpad.net/ListHelp
>>> >
>>>
>>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~schooltoolers
>> Post to     : schooltoolers@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~schooltoolers
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>

References