Statistics

Henri, can you confirm that you have the "Enable Statistics" option selected in the Xibo Options for each client?

it's enabled even after 24hrs no stats when downloading the cvs file from management menu

Do you only have one layout being shown on the display?

Can you also confirm the server and client versions match. ie you have 1.0.3 server with 1.0.3 clients. 1.0.2 or earlier clients won't work with 1.0.3 server.

1.0.3 server and client, 1 layout and 2 regions

Assuming stats collection is switched on, the client will report the stats back in batches of 100 (if I remember correctly).

Dan: Will running one layout only still generate stat records or does it rely on the dispose of the layout to send them (ie the nested media stats aren't sent until the containing layout disposes too)?

If there is only 1 layout then the layout stat will never get sent (unless another layout gets scheduled of course). This is because the stat requires the end time of the layout.

If there are more than one media item in each region then the media stats will get sent - however if each region only contains 1 media item then the same logic as the layout will apply.

Basically the stats will only get recorded on changes in layouts or media - continuously showing the same one will not generate a stat.

i have 1 layout w/2 regions, region1 = rss, region2 = image, sfw, video, webpage (total of 8 media')
so no stats will be generated, right?

Dan will know about the stats, but your RSS will never refresh in that configuration as I understand it.

Cheers

Alex

--- original message ---
From: "Henri Behari" <email address hidden>
Subject: Re: [Question #81426]: Statistics
Date: 1st September 2009
Time: 7:27:46 pm

Question #81426 on Xibo changed:
https://answers.launchpad.net/xibo/+question/81426

    Status: Answered => Open

Henri Behari is still having a problem:
i have 1 layout w/2 regions, region1 = rss, region2 = image, sfw, video, webpage (total of 8 media')
so no stats will be generated, right?

--
You received this question notification because you are a member of Xibo
Developers, which is an answer contact for Xibo.

You should get stats from region 2 detailing the start and end times of each media item. The stats should be collected in a queue of 50 records - once 50 is reached the stats should be sent to XMDS on the Xibo server.

Could you check a few things?

Firstly could you run "SELECT * FROM stat" on the Xibo database? It is possible that it is the export which is causing the problem - rather than the stats send.

If there are no records in the stat table could you try navigating to the Xibo Client installation directory and editing the file "XiboClient.exe.config".

On line 52 you will find a element like:

<setting name="StatsFlushCount" serializeAs="String">
    <value>50</value>
</setting>

Could you change the value to 1 and restart your client.

If you then navigate to the server interface and use the "Management -> Report Fault" interface... follow the instructions there, but leave it on for a few minutes (enough time for the media to cycle round on your client).

Could you then send the troubleshoot.txt file generated to <email address hidden>... I will take a look at it for you.

Sorry for the long comment, if anything is unclear please get to me clarify.

Cheers,
Dan

what is the way to get RSS updated then?

Ideally you want to be running more than one layout - that makes sure everything refreshes as one layout is destroyed and the next one shown.

If you must have one layout, then add a very short empty text item after your RSS feed to force it to reload. Same applies to webpages.

A

Henri,

Thanks for the troubleshoot.txt file you emailed. The reason it isn't working is that the stat XML is coming across like:

logstat type="Media" fromdt="2009-09-02 12:09:15" todt="2009-09-02 12:11:48" layoutid="4" scheduleid="0" mediaid="20"/stat/log

instead of like:

<log><stat type="Media" fromdt="2009-09-02 12:09:15" todt="2009-09-02 12:11:48" layoutid="4" scheduleid="0" mediaid="20"</stat></log>

Which is causing a failure to add the stat record.

Now this is odd... it would seem to point to something with your PHP install stripping out the tags - do you know of anything on your install that might do that?

Cheers,
Dan

Dan, this the install of the server perhaps it helps!
http://www.ispconfig.org/docs/INSTALL_FEDORA_9.txt

Hmm, I cant see anything obvious in there that might be causing the problem... I think we will need to get some extra logging and confirm 100% that the server is receiving the data without < > in it...

Would it be possible for you to edit xmds.php and uncomment the debug line at the very bottom of the file... it looks like: //Debug::LogEntry($db, 'audit', $service->debug_str, "xmds", "NuSOAP");

To uncomment it just remove the // from the front. Save the file and then repeat the procedure above to generate the troubleshoot.txt

Hopefully this will provide a clue! If not then I think the only next step will be for us to try and recreate on a fedora virtual machine (or for you to try and recreate on a different platform).

Thank you for your help diagnosing this so far,
Dan

Thanks for the latest troubleshoot.txt... it would appear that the XML is arriving at the web service without the < > entities. I am not sure where to go from here, the problem is either:

  a) The Client is sending the XML without the <> tags
  b) The <> tags are being stripped by apache/php before the XMDS.php script runs.

Maybe Alex has some ideas on how we might trace this HTTP traffic to see which end is the problem - my money is on the server end.

Leave it with us - maybe we could provide a 1.0.3 server install that you could point your client to as a test.

I'll get back to you.

Cheers,
Dan

Dan,

i'm traveling from 7th till 21st, sept. i'll make a tcp trace from the client and then we can see who's the cullprit! i'll try to do it before the 7th else after 21st.

cheers!
--Henri

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Waiting for information on 21st Sept.

Dan,

Problems seems to be the client side!
i've run wireshark and as you can see the clients sends the wrong data.
will try vista/xp next week
--Henri

------------------------
output wireshark
------------------------
No. Time Source Destination Protocol Info
   9502 147.927830 92.68.107.197 213.189.16.32 HTTP/XML POST /xibo/xmds.php HTTP/1.1

Frame 9502 (886 bytes on wire, 886 bytes captured)
Ethernet II, Src: Apple_98:0b:37 (00:23:32:98:0b:37), Dst: ThomsonT_b7:96:ac (00:1d:68:b7:96:ac)
Internet Protocol, Src: 92.68.107.197 (92.68.107.197), Dst: 213.189.16.32 (213.189.16.32)
Transmission Control Protocol, Src Port: 57153 (57153), Dst Port: http (80), Seq: 291, Ack: 26, Len: 832
[Reassembled TCP Segments (1122 bytes): #9497(290), #9502(832)]
Hypertext Transfer Protocol
    POST /xibo/xmds.php HTTP/1.1\r\n
        [Expert Info (Chat/Sequence): POST /xibo/xmds.php HTTP/1.1\r\n]
            [Message: POST /xibo/xmds.php HTTP/1.1\r\n]
            [Severity level: Chat]
            [Group: Sequence]
        Request Method: POST
        Request URI: /xibo/xmds.php
        Request Version: HTTP/1.1
    User-Agent: Mozilla/4.0 (compatible; MSIE 6.0; MS Web Services Client Protocol 2.0.50727.4927)\r\n
    Content-Type: text/xml; charset=utf-8\r\n
    SOAPAction: "urn:xmds#SubmitLog"\r\n
    Host: www.jasusi.net\r\n
    Content-Length: 832\r\n
        [Content length: 832]
    Expect: 100-continue\r\n
    Connection: Keep-Alive\r\n
    \r\n
eXtensible Markup Language
    <?xml
    <soap:Envelope>
        xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"
        xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
        xmlns:tns="urn:xmds"
        xmlns:types="urn:xmds/encodedTypes"
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xmlns:xsd="http://www.w3.org/2001/XMLSchema"
        <soap:Body>
            soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"
            <tns:SubmitStats>
                <version>
                    xsi:type="xsd:string"
                    1
                    </version>
                <serverKey>
                    xsi:type="xsd:string"
                    xxxxxx
                    </serverKey>
                <hardwareKey>
                    xsi:type="xsd:string"
                    49a81247438341efd10ee3702a4a03f3
                    </hardwareKey>
                <statXml>
                    xsi:type="xsd:string"
                    &lt;log&gt;&lt;stat type="Layout" fromdt="2009-09-22 17:24:25" todt="2009-09-22 17:25:36" layoutid="5" scheduleid="3" mediaid=""&gt;&lt;/stat&gt;&lt;/log&gt;
                    </statXml>
                </tns:SubmitStats>
            </soap:Body>
        </soap:Envelope>

Yes it does indeed look like the client is sending without proper tags... Could I ask you a little about your client set up? Such as which version of Windows/.NET you have installed..

Thanks for doing all this debugging! It is very useful.

windows 7 (RTM), I believe .NET is the latest in Windows 7

Ah ok... I have a win7 RC box here.. I will try to set up a test and
debug here tomorrow

On 9/20/09, Launchpad Janitor <email address hidden> wrote:
> Question #81426 on Xibo changed:
> https://answers.launchpad.net/xibo/+question/81426
>
> Status: Open => Expired
>
> Launchpad Janitor expired the question:
> This question was expired because it remained in the 'Open' state
> without activity for the last 15 days.
>
> --
> You received this question notification because you are a member of Xibo
> Developers, which is an answer contact for Xibo.
>

--
Sent from my mobile device

Status open pending investigation on a win7 box

FYI - getting the windows 7 pc up and running is taking a little longer than expected.

I have confirmed that the client doesn't run quite as expected on Win7 (during a live demo as it happens ;-) but I haven't let narrowed down the problem

Still open pending installation of a debugger on Win7

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Created a bug for this...