Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The problem is caused by use of Sec-WebSocket-Protocol in the handshake response. The client did not request a subprotocol so the only valid response from the server is to complete the handshake without specifying a subprotocol. If the server responds with an unexpected subprotocol, the client is required to close the connection. See the /subprotocol/ section in section 4.2.2 of <a href="http://tools.ietf.org/html/rfc6455#section-4.2.2" rel="nofollow noreferrer">RFC 6455</a> for details.</p> <p>The easiest fix is to remove the Sec-WebSocket-Protocol header from your response. If you want to retain it, you need to pass a subprotocol name as the second argument to the client's WebSocket constructor and use this subprotocol in your server's response. See the <a href="http://dev.w3.org/html5/websockets/#the-websocket-interface" rel="nofollow noreferrer">client API</a> docs for details.</p> <p>EDIT: <br>Once you've completed your handshake, the server will quite possibly fail trying to read the "TestOutput" message from the client's onOpen. WebSocket messages aren't plain text and don't use HTTP so the line <code>this.ReadLine()</code> is hugely unlikely to find a \r\n to terminate on. See the <a href="http://tools.ietf.org/html/rfc6455#section-5.2" rel="nofollow noreferrer">data framing</a> section of the spec for details. This <a href="https://stackoverflow.com/questions/8125507/how-can-i-send-and-receive-websocket-messages-on-the-server-side">wiki post</a> has some useful psuedo-code for websocket reads/writes. Or, you could try my <a href="https://github.com/openhome/ohNet/blob/master/OpenHome/Net/Device/Upnp/DviServerWebSocket.cpp" rel="nofollow noreferrer">C++ server</a>. See <code>WsProtocol80::Read()</code> for how to read messages. Or look at one of the open source C# servers, such as <a href="https://github.com/statianzo/Fleck/blob/master/src/Fleck/Handlers/Hybi13Handler.cs" rel="nofollow noreferrer">Fleck</a> (code to read/write messages is linked).</p> <p>There are some other small changes you could consider which would make your code more robust but won't make the difference between an immediate pass and fail:</p> <ul> <li>Any subprotocol you specify should ideally include your domain name to minimise the chances of accidentally matching any incompatible protocol request. An <a href="http://tools.ietf.org/html/rfc6455#section-1.9" rel="nofollow noreferrer">early section</a> of RFC 6455 explains why.</li> <li>It'd be worth considering checking for the presence and value of a Sec-WebSocket-Protocol header in a request before responding with your supported subprotocol.</li> <li>The order of headers in a client request isn't guaranteed so you could delay your response until you read an empty line.</li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POWebSocket Connection Drops before onmessage
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USsimonc
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWebSocket Connection Drops before onmessage
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTBountyClose
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COMay be my end solution. I'm going to employ this and pass this as an answer. Thank you. This may have just saved me quite a headache.
      singulars
      1. PO
      1. USDigitalJedi805
    2. COSadly - even after commenting out that line of my response I still end with the same result. If you don't have any further advice, I'll likely bump this to an answer due to the fact that it seems to be as close as I am going to get, but sadly, I am still in the same boat.
      singulars
      1. PO
      1. USDigitalJedi805
    3. CO@DigitalJedi805 Ah, I've just spotted another problem. I'll update my answer in a sec
      singulars
      1. PO
      1. USsimonc
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload