Reports not being generated.

Asked by Daniel Alberts

I'm guessing I may have missed something in the setup but I can't seem to generate a report.
If I click Generate for an ID Card, for instance, I get the message saying that I can close the prompt and download from home but I never get a download link from home. Am I doing something wrong? Where should this download link be?

Additional Info:
If I try to generate a report, a message is added to Messages on the Homepage but it continually says a report is being generated.
If I check the status of SchoolTool on my server all processes are RUNNING.

Question information

Language:
English Edit question
Status:
Expired
For:
SchoolTool Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Tom Hoffman (tom-hoffman) said :
#1

Do you see any errors in /var/log/schooltool/celery.log?

Revision history for this message
Tom Hoffman (tom-hoffman) said :
#2

That is /var/log/schooltool/celery_report.log.

Revision history for this message
Daniel Alberts (alberts-jd) said :
#3

No errors in celery_report.log. Just a line saying "celery@schooltool ready."

I'm running SchoolTool on a VirtualBox VM and everything else seems to work.

Revision history for this message
Douglas Cerna (replaceafill) said :
#4

Hi Daniel.

Could you restart the service? Try to get the report again and then paste the contents of your /var/log/schooltool/celery_report.log here.

Revision history for this message
Daniel Alberts (alberts-jd) said :
#5

After running "sudo service schooltool restart" I get this, but I should add that it says that the restart "[fail]"ed. If I stop then start it they both succeed.

[2015-09-09 20:17:55,376: WARNING/MainProcess] celery@schooltool ready.

worker: Cold shutdown (MainProcess)
[2015-09-09 20:28:02,855: WARNING/Worker-1] (1244) CW: error connecting to /var/run/schooltool/zeo.sock: ECONNREFUSED
("\nThe 'celeryd' command is deprecated, please use 'celery worker' instead:\n\n$ celery worker --loader=schooltool.task.celery:ReportLoader --config=schooltool.task.config.worker_report --queues=zodb.report,default\n\n",)

 -------------- celery@schooltool v3.1.6 (Cipater)
---- **** -----
--- * *** * -- Linux-3.16.0-30-generic-x86_64-with-Ubuntu-14.04-trusty
-- * - **** ---
- ** ---------- [config]
- ** ---------- .> broker: redis://127.0.0.1:7079/0
- ** ---------- .> app: default:0x7f7e6762ab50 (schooltool.task.celery.ReportLoader)
- ** ---------- .> concurrency: 1 (prefork)
- *** --- * --- .> events: OFF (enable -E to monitor this worker)
-- ******* ----
--- ***** ----- [queues]
 -------------- .> default exchange=default(direct) key=default
                .> zodb.report exchange=zodb.report(direct) key=zodb.report

[2015-09-09 20:30:20,117: WARNING/MainProcess] celery@schooltool ready.

worker: Cold shutdown (MainProcess)[2015-09-09 20:50:43,976: WARNING/Worker-1] (1433) CW: error connecting to /var/run/schooltool/zeo.sock: ECONNREFUSED

("\nThe 'celeryd' command is deprecated, please use 'celery worker' instead:\n\n$ celery worker --loader=schooltool.task.celery:ReportLoader --config=schooltool.task.config.worker_report --queues=zodb.report,default\n\n",)

 -------------- celery@schooltool v3.1.6 (Cipater)
---- **** -----
--- * *** * -- Linux-3.16.0-30-generic-x86_64-with-Ubuntu-14.04-trusty
-- * - **** ---
- ** ---------- [config]
- ** ---------- .> broker: redis://127.0.0.1:7079/0
- ** ---------- .> app: default:0x7f092d715d50 (schooltool.task.celery.ReportLoader)
- ** ---------- .> concurrency: 1 (prefork)
- *** --- * --- .> events: OFF (enable -E to monitor this worker)
-- ******* ----
--- ***** ----- [queues]
 -------------- .> default exchange=default(direct) key=default
                .> zodb.report exchange=zodb.report(direct) key=zodb.report

[2015-09-24 13:39:50,084: WARNING/MainProcess] celery@schooltool ready.

worker: Warm shutdown (MainProcess)

worker: Cold shutdown (MainProcess)
[2015-09-24 13:56:45,033: WARNING/Worker-1] (1289) CW: error connecting to /var/run/schooltool/zeo.sock: ECONNREFUSED
("\nThe 'celeryd' command is deprecated, please use 'celery worker' instead:\n\n$ celery worker --loader=schooltool.task.celery:ReportLoader --config=schooltool.task.config.worker_report --queues=zodb.report,default\n\n",)

 -------------- celery@schooltool v3.1.6 (Cipater)
---- **** -----
--- * *** * -- Linux-3.16.0-30-generic-x86_64-with-Ubuntu-14.04-trusty
-- * - **** ---
- ** ---------- [config]
- ** ---------- .> broker: redis://127.0.0.1:7079/0
- ** ---------- .> app: default:0x7f602a9e8b50 (schooltool.task.celery.ReportLoader)
- ** ---------- .> concurrency: 1 (prefork)
- *** --- * --- .> events: OFF (enable -E to monitor this worker)
-- ******* ----
--- ***** ----- [queues]
 -------------- .> default exchange=default(direct) key=default
                .> zodb.report exchange=zodb.report(direct) key=zodb.report

[2015-09-24 13:58:23,252: WARNING/MainProcess] celery@schooltool ready.

worker: Warm shutdown (MainProcess)
[2015-09-24 14:02:47,778: WARNING/Worker-1] (1256) CW: error connecting to /var/run/schooltool/zeo.sock: ECONNREFUSED

worker: Cold shutdown (MainProcess)
[2015-09-24 14:03:52,707: WARNING/MainProcess] celery@schooltool ready.

worker: Warm shutdown (MainProcess)
[2015-09-24 14:18:53,574: WARNING/Worker-1] (1255) CW: error connecting to /var/run/schooltool/zeo.sock: ECONNREFUSED

worker: Cold shutdown (MainProcess)
("\nThe 'celeryd' command is deprecated, please use 'celery worker' instead:\n\n$ celery worker --loader=schooltool.task.celery:ReportLoader --config=schooltool.task.config.worker_report --queues=zodb.report,default\n\n",)

 -------------- celery@schooltool v3.1.6 (Cipater)
---- **** -----
--- * *** * -- Linux-3.16.0-30-generic-x86_64-with-Ubuntu-14.04-trusty
-- * - **** ---
- ** ---------- [config]
- ** ---------- .> broker: redis://127.0.0.1:7079/0
- ** ---------- .> app: default:0x7fb89ceddb50 (schooltool.task.celery.ReportLoader)
- ** ---------- .> concurrency: 1 (prefork)
- *** --- * --- .> events: OFF (enable -E to monitor this worker)
-- ******* ----
--- ***** ----- [queues]
 -------------- .> default exchange=default(direct) key=default
                .> zodb.report exchange=zodb.report(direct) key=zodb.report

[2015-09-24 15:03:39,150: WARNING/MainProcess] celery@schooltool ready.

worker: Cold shutdown (MainProcess)[2015-09-24 15:11:47,887: WARNING/Worker-1] (1310) CW: error connecting to /var/run/schooltool/zeo.sock: ECONNREFUSED

("\nThe 'celeryd' command is deprecated, please use 'celery worker' instead:\n\n$ celery worker --loader=schooltool.task.celery:ReportLoader --config=schooltool.task.config.worker_report --queues=zodb.report,default\n\n",)

 -------------- celery@schooltool v3.1.6 (Cipater)
---- **** -----
--- * *** * -- Linux-3.16.0-30-generic-x86_64-with-Ubuntu-14.04-trusty
-- * - **** ---
- ** ---------- [config]
- ** ---------- .> broker: redis://127.0.0.1:7079/0
- ** ---------- .> app: default:0x7fa554c57b50 (schooltool.task.celery.ReportLoader)
- ** ---------- .> concurrency: 1 (prefork)
- *** --- * --- .> events: OFF (enable -E to monitor this worker)
-- ******* ----
--- ***** ----- [queues]
 -------------- .> default exchange=default(direct) key=default
                .> zodb.report exchange=zodb.report(direct) key=zodb.report

[2015-09-24 15:13:15,314: WARNING/MainProcess] celery@schooltool ready.

worker: Cold shutdown (MainProcess)
[2015-09-24 15:25:16,247: WARNING/Worker-1] (1364) CW: error connecting to /var/run/schooltool/zeo.sock: ECONNREFUSED
("\nThe 'celeryd' command is deprecated, please use 'celery worker' instead:\n\n$ celery worker --loader=schooltool.task.celery:ReportLoader --config=schooltool.task.config.worker_report --queues=zodb.report,default\n\n",)

 -------------- celery@schooltool v3.1.6 (Cipater)
---- **** -----
--- * *** * -- Linux-3.16.0-30-generic-x86_64-with-Ubuntu-14.04-trusty
-- * - **** ---
- ** ---------- [config]
- ** ---------- .> broker: redis://127.0.0.1:7079/0
- ** ---------- .> app: default:0x7ffec07f6b50 (schooltool.task.celery.ReportLoader)
- ** ---------- .> concurrency: 1 (prefork)
- *** --- * --- .> events: OFF (enable -E to monitor this worker)
-- ******* ----
--- ***** ----- [queues]
 -------------- .> default exchange=default(direct) key=default
                .> zodb.report exchange=zodb.report(direct) key=zodb.report

Revision history for this message
Tom Hoffman (tom-hoffman) said :
#6

Permission issue with /var/run/schooltool/zeo.sock?

Revision history for this message
Launchpad Janitor (janitor) said :
#7

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Revision history for this message
Hernaldo Peñaranda Bello (hpenarandabello-6) said :
#8

Hi.
I have the same problem.

Propietarian: schooltool
Access: Reading and Writing.

Group: schooltool
Access: Read only

Others:
Access: read-only.

- I turn off the service sudo /etc/init.d/schooltool stop
- Change all permissions to Read and Write.
- Home service sudo /etc/init.d/schooltool start

Permits the changes again and does not generate the report.