Multiple data sources

OpenSearch Dashboards
1

Hi,

I am running opensearch-dashboards-2.11.1 and opensearch-2.11.1 on a local single node. I have created this setup to test multiple data source in opensearch dashboards.

I have followed this documentation for multi-data-sources and altough the datasource can connect it either gives me 404 errors or json parse errors.

To the remote dashboard url
https:// osdashb.on.my.host (new users are allow max 2 links)

"type":"response","@timestamp":"2024-01-25T07:05:19Z","tags":[],"pid":1029671,"method":"get","statusCode":404,"req":{"url":"/_mapping?pretty=true","method":"get","headers":{"x-forwarded-for":"100.107.90.146","host":"osdashb-prd-nl1-vmo.nl1.unified.services","content-length":"0","user-agent":"opensearch-js/2.3.1 (linux 5.4.0-165-generic-x64; Node.js v18.16.0)","content-type":"application/json","x-forwarded-proto":"https","securitytenant":""},"remoteAddress":"100.107.89.146","userAgent":"opensearch-js/2.3.1 (linux 5.4.0-165-generic-x64; Node.js v18.16.0)"},"res":{"statusCode":404,"responseTime":11,"contentLength":9},"message":"GET /_mapping?pretty=true 404 11ms - 9.0B"}

Of the url mentioned in the documentation
ie: https:// osdashb.on.my.host/app/management/opensearch-dashboards/dataSources

parse@http://my.public.host:5601/6867/bundles/plugin/opensearchUiShared/opensearchUiShared.plugin.js:1:69116
expandLiteralStrings@http://my.public.host:5601/6867/bundles/plugin/opensearchUiShared/opensearchUiShared.plugin.js:1:70930
51/EditorOutputUI/<@http://my.public.host:5601/6867/bundles/plugin/console/console.chunk.2.js:1:319380
os@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:83209
gc@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:102288
__osdSharedDeps__</t.unstable_runWithPriority@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:443:3844
Xo@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45024
bc@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:102047
Qs@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:93596
Vo/<@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45315
__osdSharedDeps__</t.unstable_runWithPriority@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:443:3844
Xo@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45024
Vo@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45262
Yo@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:45195
$s@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:90458
ba@http://my.public.host:5601/6867/bundles/osd-ui-shared-deps/osd-ui-shared-deps.js:435:62277
51/useSendCurrentRequestToOpenSearch/<@http://my.public.host:5601/6867/bundles/plugin/console/console.chunk.2.js:1:250160

Result of test connection is this

{"type":"response","@timestamp":"2024-01-25T07:30:08Z","tags":[],"pid":1020841,"method":"get","statusCode":200,"req":{"url":"/app/management/opensearch-dashboards/dataSources/","method":"get","headers":{"x-forwarded-for":"100.107.90.146","host":"osdashb-prd-nl1-vmo.nl1.unified.services","user-agent":"opensearch-js/2.3.1 (linux 5.4.0-165-generic-x64; Node.js v18.16.0)","x-forwarded-proto":"https","securitytenant":""},"remoteAddress":"100.107.89.157","userAgent":"opensearch-js/2.3.1 (linux 5.4.0-165-generic-x64; Node.js v18.16.0)"},"res":{"statusCode":200,"responseTime":27,"contentLength":9},"message":"GET /app/management/opensearch-dashboards/dataSources/ 200 27ms - 9.0B"}

So I am a bit lost on this feature, am I doing something wrong or is this a bug?

Thanks.
Paul.

2

Would you share which page do you see the error

it either gives me 404 errors or json parse errors.

3

@pjanzen Did you manage to find a solution to this problem?

4

yes I did but I abandoned the solution as it did not what I hoped it did, namely combining dashboard data from different sources. I ended up creating aggregation queries and import the extracted data in to a relational DB and create the dashboards from there.

5

@pjanzen What didn’t work for you is exactly what I need. Please tell me how you connected another cluster to the dashboard.

6

Hi,

having the same issue here, documentation lacks any example of what to enter for the URL when trying to connect to a remote opensearch cluster, is it 9300/9200/xxx port etc

have tried the above and still no joy, but documentation is lacking here

7

In the environment I maintain I have 3 cluster manager node, 3 cluster coordinator nodes and 2 data nodes. In front of the coordinator node there is a loadbalancer vip. The url I type is something like https://<coordinator_vip_address>:9200/ and I have no seperate user for this. I just use the admin user.