Afanasy Statistics

Installation and configuration.
vdobrv
Posts: 18
Joined: Thu May 03, 2018 2:28 pm

Re: Afanasy Statistics

Post by vdobrv »

Hello

1. I checked that the user has full rights to work with Postgresql, and specifically to the necessary databases
2. I turned on Postgresql advanced logging, which translates all calls to the database.
SELECT and INSERT operations occur without errors, as can be seen on the logs.
What direction to dig further if there are no problems with the database.

Ubuntu Server 18.04 LTS
Afanasy 2.3.1
PSQL 10
Apache 2.4.29
PHP 7.2.24

And could you add a debug mod in the future
Attachments
photo_2020-02-20_16-02-44.jpg
photo_2020-02-20_16-02-44.jpg (163.01 KiB) Viewed 22607 times
Last edited by vdobrv on Thu Feb 20, 2020 1:05 pm, edited 1 time in total.
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Afanasy Statistics

Post by timurhai »

So, now server insets data into jobs and tasks tables?
Have you checked that tables are not empty?
Can you check it by command line?
What is that commands output:

Code: Select all

select count(*) from jobs;

Code: Select all

select count(*) from tasks;
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
vdobrv
Posts: 18
Joined: Thu May 03, 2018 2:28 pm

Re: Afanasy Statistics

Post by vdobrv »

In the table TASKS created record
There are no entries in the JOBS table

Added afadmin database user, super user rights, just in case
Here is a screen of server logs and DB
Attachments
photo_2020-02-20_21-24-10.jpg
photo_2020-02-20_21-24-10.jpg (17.69 KiB) Viewed 22588 times
photo_2020-02-20_21-23-29.jpg
photo_2020-02-20_21-23-29.jpg (75.91 KiB) Viewed 22588 times
User avatar
timurhai
Site Admin
Posts: 911
Joined: Sun Jan 15, 2017 8:40 pm
Location: Russia, Korolev
Contact:

Re: Afanasy Statistics

Post by timurhai »

Hi.
It is hard (some times impossible) to read images that you attach. Can you not to do it.
If you want to show some text, please copy and paste it as a text.
And it seems that you should consult some SQL (PostgreSQL) experienced user, i am not.
Or try to google this psql errors.
"FATAL ..." errors are printed by pslq library.
Timur Hairulin
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Post Reply