Explore and Discover

Thu 2024-10-10: Will demos DBeaver

• DBeaver vs pgAdmin 4

Thu 2024-10-02: AWS EKS Kubernetes upgrade report

• Anthony finally got Kubernetes in the AWS EKS cluster in fgp-gscriskprofiler-prod upgraded from 1.22 1.23 to 1.31
• Notes in OneNote > OpenDRR > AWS Deployment > Arash’s RiskProfiler AWS Deployment Tutorials → Upgrading EKS in Cloud9 etc.
• (need to copy to wiki)
• Cost exploration

---

TODO

---

2024-03-14

• (WordPress? RiskProfiler)

2024-02-28: Elasticsearch queries troubleshooting

• Drew demos query for StatCan in Kibana/Elasticsearch:
  • Microsoft Copilot suggests using relation: "intersects" instead of relation: "within"
  • relation: "contains" works too, see https://www.elastic.co/guide/en/elasticsearch/reference/7.17/query-dsl-geo-shape-query.html#_spatial_relations
• Drew notices a query works in Kibana but not with curl:
  • WAFv2, PathRule...

Follow-up: added -v to see what curl is doing. By taking out -X GET, and with the JSON query -d, curl was actually sending a POST request:

* using HTTP/2
* h2h3 [:method: POST]
* h2h3 [:path: /opendrr_psra_indicators_csd/_search]
* h2h3 [:scheme: https]
* h2h3 [:authority: api.riskprofiler.ca]
* h2h3 [user-agent: curl/7.88.1]
* h2h3 [accept: */*]
* h2h3 [content-type: application/json]
* h2h3 [content-length: 472]

This page gives some insights: https://stackoverflow.com/questions/14339696/elasticsearch-post-with-json-search-body-vs-get-with-json-in-url Perhaps Arash's WAF rules currently block "GET with request body"?

(See Slack DM chat between Drew, Will and Anthony)

2024-02-22: Will learns how to update RiskProfiler stats pages

• RiskProfiler stats?
• Will gave Kibana accounts for StatCan folks
• Drew seeks help on stack build bug: (sourceTypes.csv?ref=master)
• Drew shows how to access AWS EC2 instance from NRCan PC
  • (e.g. ~/.ssh/config; IdentifyFile, ProxyCommand "aws ssm start-session", etc.)
• aws-cloud9-opendrr-ops
• Will tries to update OpenDRR/riskprofiler-stats on his computer
  • First tried with WSL Ubuntu
  • Then tried GitHub Desktop on Windows; worked just as well.

Mon 2024-02-12

Wed 2024-01-31

Thu 2024-01-25

Wed 2024-01-17

Thu 2024-01-11

• Initial explorations (Will, Anthony)
• See the OneNote page "RiskProfiler: Adding new scenarios" (TODO)