Page 1 of 1

Statistics stuck at initializing

Posted: Tue Aug 11, 2020 12:02 pm
by Khiladi
Hi,

I have followed you steps to setup the database but the page index.html is stuck at initializing. What have I missed?

Thanks

Re: Statistics stuck at initializing

Posted: Tue Aug 11, 2020 12:28 pm
by timurhai
Hi.
At first check a database connection via afcmd:
https://cgru.readthedocs.io/en/latest/a ... d-db-check

btw,
Have you set up database?
https://cgru.readthedocs.io/en/latest/a ... base-setup

Re: Statistics stuck at initializing

Posted: Wed Aug 12, 2020 11:51 am
by Khiladi
Hi,

I did run afcmd commands as mentioned. Here is the terminal out:

[khiladi@localhost cgru]$ source ./setup.sh
CGRU_VERSION 2.3.1 : '/opt/cgru'
[khiladi@localhost cgru]$ afcmd db_check
Config file does not exist:
/home/khiladi/.cgru/config.json
WARNING: SERVER ADDRESS ID NOT CONFIGURED, USING 127.0.0.1

Database connection is working.


Thanks

Re: Statistics stuck at initializing

Posted: Wed Aug 12, 2020 11:54 am
by timurhai
See Apache logs for errors (just after F5).
May be some module missing.

Re: Statistics stuck at initializing

Posted: Wed Aug 12, 2020 11:58 am
by Khiladi
Hi,

I have checked the log as you mentioned located at /var/log/httpd
Here is the log:

Tue Aug 11 18:30:27.978237 2020] [core:notice] [pid 75817] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0
[Tue Aug 11 18:30:27.979242 2020] [suexec:notice] [pid 75817] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using localhost.localdomain. Set the 'ServerName' directive globally to suppress this message
[Tue Aug 11 18:30:28.001961 2020] [lbmethod_heartbeat:notice] [pid 75817] AH02282: No slotmem from mod_heartmonitor
[Tue Aug 11 18:30:28.017856 2020] [mpm_prefork:notice] [pid 75817] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/5.4.16 mod_wsgi/3.4 Python/2.7.5 configured -- resuming normal operations
[Tue Aug 11 18:30:28.017899 2020] [core:notice] [pid 75817] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'
[Tue Aug 11 18:31:42.932939 2020] [autoindex:error] [pid 75823] [client 127.0.0.1:41154] AH01276: Cannot serve directory /var/www/html/: No matching DirectoryIndex (index.html,index.php) found, and server-generated directory index forbidden by Options directive
[Wed Aug 12 12:37:55.311023 2020] [core:notice] [pid 1905] SELinux policy enabled; httpd running as context system_u:system_r:httpd_t:s0
[Wed Aug 12 12:37:55.354031 2020] [suexec:notice] [pid 1905] AH01232: suEXEC mechanism enabled (wrapper: /usr/sbin/suexec)
AH00558: httpd: Could not reliably determine the server's fully qualified domain name, using localhost.localdomain. Set the 'ServerName' directive globally to suppress this message
[Wed Aug 12 12:37:55.412519 2020] [lbmethod_heartbeat:notice] [pid 1905] AH02282: No slotmem from mod_heartmonitor
[Wed Aug 12 12:37:55.789065 2020] [mpm_prefork:notice] [pid 1905] AH00163: Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips mod_fcgid/2.3.9 PHP/5.4.16 mod_wsgi/3.4 Python/2.7.5 configured -- resuming normal operations
[Wed Aug 12 12:37:55.789104 2020] [core:notice] [pid 1905] AH00094: Command line: '/usr/sbin/httpd -D FOREGROUND'


Cant figure out what the exact issue here is?

Thanks!!

Re: Statistics stuck at initializing

Posted: Wed Aug 12, 2020 12:02 pm
by timurhai
I do not see any mentions about cgru/afanasy/statics site.
Have you installed all needed modules (see docs) and set up Apache to serve statistic site?
What have you do for it?

Re: Statistics stuck at initializing

Posted: Thu Aug 13, 2020 4:36 pm
by Khiladi
Hi,

I am getting this error in the statistics webpage located in /opt/cgru/afanasy/statistics/index.html instead of initializing.

Query failed: ERROR: relation "jobs"does not exist LINE 1 : SELECT min (time_done) AS time_done FROM jobs WHERE time_done

Thanks

Re: Statistics stuck at initializing

Posted: Fri Aug 14, 2020 6:08 am
by timurhai
You have not created tables.
viewtopic.php?f=34&t=3326
You should set up database and ensure, that server writes in it.

Re: Statistics stuck at initializing

Posted: Fri Aug 14, 2020 6:22 am
by Khiladi
Hi,

I created the tables and refreshed the page
now its showing task graphs but they are blank even when I resubmitted the jobs.. I am soo close

Thanks

Re: Statistics stuck at initializing

Posted: Fri Aug 14, 2020 11:33 am
by timurhai
Hi,
After you created tables, you should restart afrerver. Jobs are inserted in tables on deletion.