I am adjusting the SQL statement for data input. There is a guideline to use rising input mode.
SELECT * FROM your_table
WHERE dtime > ?
ORDER BY dtime ASC
How to use the checkpoint value (?) also as upper limit? Say ... WHERE dtime > ? AND dtime < ? + INTERVAL '1 day'
... View more
I am setting up connection for the Splunk instance and Splunk Cloud Gateway via a proxy. Proxy server is basically set to allow all , Splunk Cloud Gateway is installed on search head.
According to the guideline in Troubleshoot Splunk Cloud Gateway Connection Issues,
for https connection, it can return "healthy":true
curl https://prod.spacebridge.spl.mobi/health_check -x http://my_proxy_svr:8000
for wss connection, it can return 200 and 101 Switching Protocols
curl -i -N -H "Connection: Upgrade" -H "Upgrade: websocket" -H "Host: prod.spacebridge.spl.mobi" -H "Origin: https://prod.spacebridge.spl.mobi"; -H "Authorization: xyz" https://prod.spacebridge.spl.mobi/mobile -x http://my_proxy_svr:8000
However, the status shown in Cloud Gateway Status Dashboard keep showing "Not Connected". For loggings in search, once restarting splunkd, the proxies config is read into program at first but become empty after first "handshake failed" occurred.
May I know if there is any clue why cloudgateway is not connected? Thank you.
... View more