Hi,
I try to create a C# app to programmatically add media into the library but I don’t find any information on how to connect to the Server.
I tried to create a new application with Xibo CMS but
What am I supposed to do?
I read here that I can leave the third and fourth boxes empty but then, the Submit button doesn’t do anything.
Thank you,
You should be able to add an application without those last 2 items - can you follow the Fault page so we can get some logs?
Disclaimer - you might want to switch to the development branch in GitHub - the API comes out of beta in 1.8 and has been vastly improved.
I think the fault is this one :
Date: 2015-09-03 14:57:26
Page: fault
Function:
Message: Undefined offset: 2
8
Notice
/www/xibo/lib/pages/fault.class.php
256
Actually that message can be ignored - you’d be looking for something from the pages/oauth.class.php page.
ok so here is the complete log
--------------------------------------
LOG Dump
--------------------------------------
Date: 2015-09-03 14:57:26
Page: fault
Function:
Message: <errormsg>Undefined offset: 2</errormsg>
<errornum>8</errornum>
<errortype>Notice</errortype>
<scriptname>/www/xibo/lib/pages/fault.class.php</scriptname>
<scriptlinenum>256</scriptlinenum>
Date: 2015-09-03 14:57:26
Page: fault
Function:
Message: <errormsg>Undefined offset: 2</errormsg>
<errornum>8</errornum>
<errortype>Notice</errortype>
<scriptname>/www/xibo/lib/pages/fault.class.php</scriptname>
<scriptlinenum>256</scriptlinenum>
Date: 2015-09-03 14:57:08
Page: admin
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:57:08
Page: admin
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:57:08
Page: admin
Function:
Message: SELECT IFNULL(SUM(Size), 0) AS BandwidthUsage FROM `bandwidth` WHERE Month = 1441080000
Date: 2015-09-03 14:57:08
Page: admin
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:57:08
Page: admin
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Administration Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:57:08
Page: oauth
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:57:08
Page: oauth
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:57:08
Page: oauth
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:57:08
Page: oauth
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Administration Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:34
Page: fault
Function:
Message: <errormsg>Undefined offset: 2</errormsg>
<errornum>8</errornum>
<errortype>Notice</errortype>
<scriptname>/www/xibo/lib/pages/fault.class.php</scriptname>
<scriptlinenum>256</scriptlinenum>
Date: 2015-09-03 14:55:34
Page: fault
Function:
Message: <errormsg>Undefined offset: 2</errormsg>
<errornum>8</errornum>
<errortype>Notice</errortype>
<scriptname>/www/xibo/lib/pages/fault.class.php</scriptname>
<scriptlinenum>256</scriptlinenum>
Date: 2015-09-03 14:55:32
Page: fault
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:55:32
Page: fault
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:32
Page: fault
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:55:32
Page: fault
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Advanced Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:27
Page: log
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:55:27
Page: log
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Advanced Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:26
Page: log
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:55:26
Page: log
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:13
Page: oauth
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:55:13
Page: oauth
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:13
Page: oauth
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:55:13
Page: oauth
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Administration Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:09
Page: user
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:55:09
Page: user
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:09
Page: user
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:55:09
Page: user
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Administration Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:55:09
Page:
Function:
Message: SELECT user.UserID, user.UserName, user.usertypeid, user.loggedin, user.lastaccessed, user.email, user.homepage FROM `user` WHERE 1 = 1 ORDER by UserName
Date: 2015-09-03 14:53:31
Page: fault
Function:
Message: <errormsg>Undefined offset: 2</errormsg>
<errornum>8</errornum>
<errortype>Notice</errortype>
<scriptname>/www/xibo/lib/pages/fault.class.php</scriptname>
<scriptlinenum>256</scriptlinenum>
Date: 2015-09-03 14:53:31
Page: fault
Function:
Message: <errormsg>Undefined offset: 2</errormsg>
<errornum>8</errornum>
<errortype>Notice</errortype>
<scriptname>/www/xibo/lib/pages/fault.class.php</scriptname>
<scriptlinenum>256</scriptlinenum>
Date: 2015-09-03 14:53:25
Page: fault
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:53:25
Page: fault
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:53:25
Page: fault
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:53:25
Page: fault
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Advanced Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:53:03
Page: log
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:53:03
Page: log
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Advanced Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:53:02
Page: log
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:53:02
Page: log
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:57
Page: fault
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:57
Page: fault
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:57
Page: fault
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:57
Page: fault
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Advanced Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:56
Page: log
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:56
Page: log
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:56
Page: log
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:56
Page: log
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Advanced Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:44
Page: user
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:44
Page: user
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:44
Page: user
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:44
Page: user
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Administration Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:44
Page:
Function:
Message: SELECT user.UserID, user.UserName, user.usertypeid, user.loggedin, user.lastaccessed, user.email, user.homepage FROM `user` WHERE 1 = 1 ORDER by UserName
Date: 2015-09-03 14:52:44
Page: oauth
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:44
Page: oauth
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:44
Page: oauth
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:44
Page: oauth
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Administration Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:35
Page: fault
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:35
Page: fault
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:35
Page: fault
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:35
Page: fault
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Advanced Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:33
Page: log
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:33
Page: log
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Advanced Menu' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:32
Page: log
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:32
Page: log
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:30
Page:
Function:
Message: Login with refering page:
Date: 2015-09-03 14:52:30
Page: index
Function:
Message: Authing the menu for usertypeid [1]
Date: 2015-09-03 14:52:30
Page: index
Function:
Message: SELECT DISTINCT pages.name , menuitem.Args , menuitem.Text , menuitem.Class, menuitem.Img, menuitem.External FROM menuitem INNER JOIN menu ON menuitem.MenuID = menu.MenuID INNER JOIN pages ON pages.pageID = menuitem.PageID WHERE menu.Menu = 'Top Nav' ORDER BY menuitem.Sequence
Date: 2015-09-03 14:52:17
Page:
Function:
Message: No session returned
--------------------------------------
Display Dump
--------------------------------------
DisplayID: 1
Display: MIRPC8900
Default Layout: Mirabel CAE TV Default
Logged In: 0
Last Accessed: 1438092916
Interleave: 1
Licensed: 1
DisplayID: 3
Display: TestLocal
Default Layout: Presentation
Logged In: 0
Last Accessed: 1441034476
Interleave: 1
Licensed: 1
Thank you for the help btw!
Unfortunately I still don’t see any clues in the log - which is very unusual.
If you are familiar with development, can you try with Chrome developer tools open and observe the Network tab - the form OK will submit a request, the details of the response would be most helpful… otherwise if you can provide temporary access to the CMS i’d be happy to look.
Hi,
This is what I get from the developer tools :
{“html”:null,“buttons”:"",“uniqueReference”:"",“success”:false,“callBack”:null,“message”:“Token does not match”,“clockUpdate”:false,“sortable”:null,“sortingDiv”:null,“paging”:null,“pageSize”:10,“pageNumber”:0,“initialSortColumn”:0,“initialSortOrder”:0,“dialogSize”:null,“dialogWidth”:0,“dialogHeight”:0,“dialogTitle”:null,“dialogClass”:"",“keepOpen”:null,“hideMessage”:null,“loadForm”:null,“loadFormUri”:null,“refresh”:null,“refreshLocation”:null,“focusInFirstInput”:true,“modal”:false,“login”:null,“extra”:[]}
This is the response header :
HTTP/1.1 200 OK
Date: Tue, 08 Sep 2015 15:04:05 GMT
Server: Apache/2.2.15 (CentOS)
X-Powered-By: PHP/5.3.3
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
X-XRDS-Location: ______________________/index.php/service.php?xrds
Content-Length: 0
Connection: close
Content-Type: text/html; charset=UTF-8
(I’ve intentionnaly hide the X-XEDS-Location URL)
Token does not match is only output in two places, neither of which relate to the Application form in question. Can you also post the request header so I can see exactly what is being called?
Thanks,
Dan
This is the request header:
Accept:application/json, text/javascript, /; q=0.01
Accept-Encoding:gzip, deflate
Accept-Language:en-US,en;q=0.8,fr;q=0.6
Connection:keep-alive
Content-Length:133
Content-Type:application/x-www-form-urlencoded; charset=UTF-8
Cookie:ga=GA1.2.292483400.1439987221; PHPSESSID=qmsginvqc4qkri9e44otck3bf4
Host:.com
Origin:http://.com
Referer:http://_________.com/index.php?p=oauth&
User-Agent:Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/45.0.2454.85 Safari/537.36
X-Requested-With:XMLHttpRequest
What version of the CMS are you using please? Something doesn’t make sense at present 
We just upgraded to 1.7.4
I will make some test and come back with a solution if I find one.
Hi Dan,
We upgraded the server to 1.7.4 and I still have the same issue.
I see the request header but I don’T seems to get any response.
I can give you temporary access to the CMS so you can take a look as you asked.
--------------------------------------
LOG Dump
--------------------------------------
Date,Page,Function,Message
"2015-09-15 07:50:01","oauth","","Form token incorrect from: 10.85.2.95 with token [11573576ebc78509c8916c74486bcf7d] for session_id [fehqr36ejttkmr4cl9o431lr97]"
"2015-09-15 07:50:01","oauth","","<errormsg>Sorry the form has expired. Please refresh.</errormsg>
<errornum>256</errornum>
<errortype>User Error</errortype>
<scriptname>/www/xibo/lib/pages/oauth.class.php</scriptname>
<scriptlinenum>255</scriptlinenum>Your last error is actually better as it does provide an error message from the oauth page (prior errors didn’t which we really confusing).
Do you find that you have general errors with Xibo on other forms too? Do you operate with multiple tabs open, etc?
Basically when the add application form opens it records a token which it submits with the request, this token is stored in the session and the values compared when they submit. I think something else is clearing that token (perhaps another form request from another tab?)
First of all, I use Chrome as browser if this information can help.
I don’t have any other errors while using Xibo and everything seems to be working just fine.
I do not operate with multiple tabs open except when I record logs.
But since I tried to add an application for the first time, the little “wheel” keeps turning just like if the Application page was waiting for a response or something.
I just looked at the response header and I found what may be the reason. Is there a “s” missing at “service.php” ?
X-XRDS-Location:http://myCMS.com/index.php/service.php?xrds
Shouldn’t it be ->
X-XRDS-Location:http://myCMS.com/index.php/serviceS.php?xrds ??
Nevermind, I just read this this thread so this is not the problem.
I think the only way to proceed will be with temporary access as offered - you can PM me the details if you’d like?
OK, lets go back to basics.
The screenshot you’ve posted shows that Xibo can’t render the Grid of applications - the “Add Form” has disappeared in this case and most likely added the application successfully.
Can you check in the database:
SELECT *
FROM `oauth_server_registry`
To see if your applications have been registered?
The table is empty.
Maybe we have a config file missing?
Do we have to install some kind of script ?
All you need is included with the Xibo installation.
I am at a loss as to how we proceed without debugging capabilities of some sort as this is working in lots of other installations - i.e. its an environment issue