Unauthorized Dashboard implemented postgres with grafana

Grafana
1 
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.

image
image718×119 11.1 KB

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

2

@arunpandiyan Your browser has a cookie that becomes invalid when you switch from SQLite to Postgres. Just log-out and log in to refresh the cookie.

It started in G10 when recreating the database and has active cookies from previous sessions.

3

After I Clear all my Cookies and tried lot of time still show the same issue

image
image1116×406 8.42 KB

4

If you guys having any idea regarding with this means please keep it posted,thanks!

5

Seems that there is an issue with pgbouncer.
Error says “unnamed prepared statement does not exist”
that mostly means that your bouncer is not in session mode