Proof of play report probelm

Get Help Other
1

Hi
I am on Xibo CMS V3 and having problem with the proof of play reports. Below is the case

  1. If a choose to generate a proof of play report for one media for one day (e.g. yesterday) using display group tags, then i get a complete report
  2. If a choose the same but for one week then the CMS start to collect the data (indicated by the gear) and after a short while the gear disappears and no data is provided
    Please see images and pdf file here
    Report files (pdf + jpg)
    (Sorry, i do not know how to paste images in the post and since I am new user I am not allowed to upload files)
    Regards
    Micke
2

Bonjour,
I’ve the same problem.
It is necessary to proceed by schedule because the volumes can be too large for a direct display.
My problem now is that the schedules have been working for 4 months and are no longer providing results.

As if the schedules don’t run at midnight.
Does anyone have a solution
Thanks

3

Hi
A solution could be if getting access to Xibo database and then use MY-SQL front + Crystal Reports to generate reports manually. Anyone knows how to get access to Xibo database (the CMS is on a private server without Docker)
Regards
Micke

4

I know with docker …

My SQL access

sudo docker exec -ti xibo_cms-web_1 bash
bash-5.0# mysql -u cms -padminmysqlxibo
MySQL [(none)]> use cms ;
MySQL [(cms)]> show tables ;

Views
Gérard

5

xibo_cms-web_1

is the contener (sudo docker ps -a)

6

Warning: mysql -u cms -padminmysqlxibo

the password “adminmysqlxibo” is pasted to the -p

7

Hi
Thanks Gerard, anyone know without Docker?
Regards
Micke

8

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.