Xibo

red required files indicator

Asked by Saad Asif

Hi all,

I am running the Xibo client in an ubuntu vm, and it seems to be stuck at the splash page and isn't displaying my layout. The indicators are as follows:
required files: red
get files: grey with 0
schedule: green
register display: green
log: switches between green and yellow
stats: grey

Also I cant seem to figure out how to enable logging to see what's wrong following instructions in the launchpad answers, or figure out where logs should be saved, as the manual on the wiki has a blank page on logs.

Thanks,
Saad A.

Question information

Language:
English Edit question
Status:
Solved
For:
Xibo Edit question
Assignee:
No assignee Edit question
Solved by:
Dan Garner
Solved:
Last query:
Last reply:
Revision history for this message
Saad Asif (shinigtears-chaos) said : 		#1

I think I may have worked out the solution, but to complete it I need to know what the following query is trying to do:

        $SQL = " SELECT 'layout' AS RecordType, layout.layoutID AS path, layout.layoutID AS id, layout.xml AS `MD5`, NULL AS FileSize, layout.background ";
        $SQL .= " FROM layout ";
        $SQL .= sprintf(" WHERE layout.layoutid IN (%s) ", $layoutIdList);
        $SQL .= " UNION ";
        $SQL .= " SELECT 'media' AS RecordType, storedAs AS path, media.mediaID AS id, media.`MD5`, media.FileSize, NULL AS background ";
        $SQL .= " FROM media ";
        $SQL .= " INNER JOIN lklayoutmedia ";
        $SQL .= " ON lklayoutmedia.MediaID = media.MediaID ";
        $SQL .= " INNER JOIN layout ";
        $SQL .= " ON layout.LayoutID = lklayoutmedia.LayoutID";
        $SQL .= sprintf(" WHERE layout.layoutid IN (%s) ", $layoutIdList);
        $SQL .= " ORDER BY RecordType DESC";

what I dont understand is that both media and layout id are different, yet they are set to id how does that work? also layoutID is set to path along with storedAs, and they are both different data types so I am having a hard time understanding all this.

Thanks,
Saad A.

Revision history for this message
Best Dan Garner (dangarner) said : 		#2

Hi,

To aide your understanding - Layouts and Media are entirely different concepts in the data model, however Xibo sends both as files. Therefore the client will get an XML packet explaining each layout and media item it requires in terms of the path to save the file as, and the ID to request from GetFile.

You can enable logging in XMDS by enabling logging in the CMS - you will also need to enable logging on the display record you are testing with (in the display management page of the CMS).

That query is part of the required files call and is definitely not broken (it is being used across hundreds of installs). So perhaps there is some other issue - the most common one being the library location is not readable/writable to the CMS install.

The report fault wizard might show you the problem.

Revision history for this message
Saad Asif (shinigtears-chaos) said : 		#3

Thanks Dan Garner, that solved my question.