Comments (4)
@carl-reverb Thanks for reaching out on this!
It might be easier to discuss this via a support ticket (since it contains a lot of specifics about your environment, and we may ask you to run some more debug steps, etc). Could you open one through the in-app UI?
I'd be happy to update this GitHub issue with a description of the issue/solution, once we've found it.
from collector.
Thanks @carl-reverb 🤩 It helped!
I found that I needed to have DB_PORT
explicitly set in the collector environment in order to have the IAM auth to work.
from collector.
Same issue here, did you manage to find a solution?
from collector.
I built a custom helm chart to deploy this and get it functioning. It's private though, but I can share the templates. It's based on the default helm chart template.
secret.yaml
apiVersion: v1
kind: Secret
metadata:
name: {{ include "pganalyze-collector.fullname" . }}
type: Opaque
data:
PGA_API_KEY: {{ .Values.pgAnalyze.apiKey | b64enc }}
DB_HOST: {{ .Values.pgAnalyze.dbHost | b64enc }}
DB_NAME: {{ .Values.pgAnalyze.dbName | b64enc }}
DB_USERNAME: {{ .Values.pgAnalyze.dbUsername | b64enc }}
{{- if .Values.pgAnalyze.dbUseIamAuth }}
DB_USE_IAM_AUTH: {{ print "true" | b64enc }}
{{- else }}
DB_PASSWORD: {{ .Values.pgAnalyze.dbPassword | default "none" | b64enc }}
{{- end }}
deployment.yaml
apiVersion: apps/v1
kind: Deployment
metadata:
name: {{ include "pganalyze-collector.fullname" . }}
labels:
{{- include "pganalyze-collector.labels" . | nindent 4 }}
spec:
replicas: 1
selector:
matchLabels:
{{- include "pganalyze-collector.selectorLabels" . | nindent 6 }}
template:
metadata:
{{- with .Values.podAnnotations }}
annotations:
{{- toYaml . | nindent 8 }}
{{- end }}
labels:
{{- include "pganalyze-collector.labels" . | nindent 8 }}
spec:
{{- with .Values.imagePullSecrets }}
imagePullSecrets:
{{- toYaml . | nindent 8 }}
{{- end }}
serviceAccountName: {{ include "pganalyze-collector.serviceAccountName" . }}
securityContext:
{{- toYaml .Values.podSecurityContext | nindent 8 }}
containers:
- name: {{ .Chart.Name }}
securityContext:
{{- toYaml .Values.securityContext | nindent 12 }}
image: "{{ .Values.image.repository }}:{{ .Values.image.tag | default .Chart.AppVersion }}"
imagePullPolicy: {{ .Values.image.pullPolicy }}
envFrom:
- secretRef:
name: {{ include "pganalyze-collector.fullname" . }}
optional: false
resources:
{{- toYaml .Values.resources | nindent 12 }}
{{- with .Values.nodeSelector }}
nodeSelector:
{{- toYaml . | nindent 8 }}
{{- end }}
{{- with .Values.affinity }}
affinity:
{{- toYaml . | nindent 8 }}
{{- end }}
{{- with .Values.tolerations }}
tolerations:
{{- toYaml . | nindent 8 }}
{{- end }}
And our values.yaml file sets the role ARN annotation for IRSA
serviceAccount:
annotations:
eks.amazonaws.com/role-arn: arn:aws:iam::XXXXXXX:role/XXXXXXXX
name: production-pganalyze
I can't recall if there was anything special besides setting up OIDC/IRSA and the role trust properly.
from collector.
Related Issues (20)
- Error calling pg_stat_statements_reset() as requested intermittently HOT 2
- Regular collector oom-kill at midnight UTC on Sundays HOT 1
- Publish Docker image to ECR public registry HOT 1
- Error to send snapshots HOT 2
- Upgrade go.uuid module HOT 3
- Missing image for v0.50.1 HOT 2
- Additional security settings for pganalyze collector HOT 3
- Add rudimentary test suite for Helm chart
- Debian build uses EOL version HOT 1
- Error: Failed to reload collector HOT 1
- OTEL connector - can it support Datadog APM traces for PostgreSQL HOT 2
- OTEL connector - can it support Datadog?
- Feature request: Add DB_PASSWORD_FILE or similar HOT 1
- Regarding SSO login HOT 1
- Configuring Log Insights for pganalyze runnning on kubernetes pod HOT 1
- Can't ctrl-c pganalyze-collector HOT 1
- panic: runtime error: index out of range [0] with length 0 HOT 5
- Inefficient usage of AWS DescribeDBInstances and DescribeDBClusters API HOT 1
- OTEL Collector: allow plain json payloads HOT 3
- Panic when processing server HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from collector.