Statistics stuck at initializing

General discussions and questions.
Post Reply
Khiladi
Posts: 34
Joined: Mon Jul 06, 2020 6:49 am

Statistics stuck at initializing

Post 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
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Statistics stuck at initializing

Post 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
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Khiladi
Posts: 34
Joined: Mon Jul 06, 2020 6:49 am

Re: Statistics stuck at initializing

Post 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
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Statistics stuck at initializing

Post by timurhai »

See Apache logs for errors (just after F5).
May be some module missing.
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Khiladi
Posts: 34
Joined: Mon Jul 06, 2020 6:49 am

Re: Statistics stuck at initializing

Post 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!!
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Statistics stuck at initializing

Post 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?
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Khiladi
Posts: 34
Joined: Mon Jul 06, 2020 6:49 am

Re: Statistics stuck at initializing

Post 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
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Statistics stuck at initializing

Post 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.
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Khiladi
Posts: 34
Joined: Mon Jul 06, 2020 6:49 am

Re: Statistics stuck at initializing

Post 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
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Statistics stuck at initializing

Post by timurhai »

Hi,
After you created tables, you should restart afrerver. Jobs are inserted in tables on deletion.
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Post Reply