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
Afanasy Statistics
Re: Afanasy Statistics
- Attachments
-
- photo_2020-02-20_16-02-44.jpg (163.01 KiB) Viewed 22957 times
Last edited by vdobrv on Thu Feb 20, 2020 1:05 pm, edited 1 time in total.
Re: Afanasy Statistics
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:
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).
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).
Re: Afanasy Statistics
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
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 (17.69 KiB) Viewed 22938 times
-
- photo_2020-02-20_21-23-29.jpg (75.91 KiB) Viewed 22938 times
Re: Afanasy Statistics
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.
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).
CGRU 3.3.1, Ubuntu 20.04, 22.04, MS Windows 10 (clients only).