Error with Remote Source Data Set

Get Help
1

Hello, I have trouble configuring the Data Set for remote data source. CMS version 1.8.10 installed in ubuntu 16.4. My datasource is a mysql database at a different machine. Here’s my configuration

1
11118×555 28.5 KB
2
21091×789 39.5 KB
3
31117×450 25.3 KB
4
41116×610 44.8 KB

Here’s captured log file

log%201
log%2011642×924 78.7 KB

My question is:

  1. Can Xibo DataSet fetch data from mysql database? If yes,
  2. How to know that the connection has already been established?
  3. Does Xibo DataSet only retrieve data in JSON format?

I am new with using Xibo. Please help with this issue.
Thank you

2

What you’ve done there isn’t expected to work.

Remote datasets require json data, made available on a webserver. It isn’t supposed to be able to connect to a MySQL server.

3

Okay understood…
Does it requires array or object json structure…? or could xibo DataSet understand both structure?
Thanks…:+1:

4

It consumes json data - so broadly anything that can be iterated over, that is json formatted will be fine.

There’s lots of examples on here where people have posted json data they want to consume, so I’d have search to see some examples.

1 Like