grafana.ini
database:
enabled: true
type: postgres
host: hostname:5432
port: 5432
name: sample
user: sample
password: db-password
url: postgres://user:password@host:5432/db-name
ssl_mode: disable
reconnect: true
binary_parameters: yes
after I Add the Db configuration in grafana–>values.yaml to integrate db into grafana i facing issue with dashboard,I am not able to access dashboard it shows unauthorize.
level=error msg="Could not find plugin definition for data source" datasource_type=PostgreSQL
logger=context t=2023-08-22T05:46:20.976861632Z level=warn msg="failed to look up session from cookie" error="pq: unnamed prepared statement does not exist"
logger=context t=2023-08-22T05:46:20.977242312Z level=error msg="Failed to get user with id" userId=2 error="pq: unnamed prepared statement does not exist"
logger=context userId=0 orgId=0 uname= t=2023-08-22T05:46:20.978842771Z level=warn msg= error="pq: unnamed prepared statement does not exist" traceID=
logger=context userId=0 orgId=0 uname= t=2023-08-22T05:46:20.979783774Z level=warn msg= error="pq: unnamed prepared statement does not exist" traceID=
logger=context userId=0 orgId=0 uname= t=2023-08-22T05:46:20.979823545Z level=info msg="Request Completed" method=GET path=/avatar/46d229b033af06a191ff2267bca9ae56 status=403 remote_addr=49.37.192.10 time_ms=7 duration=7.031342ms size=15 referer=https://sample.test.com/dashboards
logger=context t=2023-08-22T05:46:21.062320708Z level=warn msg="failed to look up session from cookie" error="pq: unnamed prepared statement does not exist"
logger=context userId=2 orgId=1 uname=admin t=2023-08-22T05:46:21.06237708Z level=error msg="Search failed" error="pq: unnamed prepared statement does not exist" remote_addr=49.37.192.10 traceID=
logger=context userId=2 orgId=1 uname=admin t=2023-08-22T05:46:21.062424361Z level=error msg="Request Completed" method=GET path=/api/search status=500 remote_addr=49.37.192.10 time_ms=4 duration=4.687973ms size=40 referer=https://sample.test.com/dashboards handler=/api/search/
logger=context userId=0 orgId=0 uname= t=2023-08-22T05:46:21.064844161Z level=warn msg=Unauthorized error="pq: unnamed prepared statement does not exist" remote_addr=49.37.192.10 traceID=
THANK YOU!!
~ the grafana team
