[Reconnoiter-users] DB: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema prism

Toby DiPasquale toby at relaynetwork.com
Tue Jun 8 11:03:27 EDT 2010


Hi all,

I finally got Reconnoiter up and running, noitd and stratcond talking to each other, Apache configured properly, cronjobs running, etc. Pheewh ;) Now, however, when I go to look at any of the graphs, I get the following error:

DB: SQLSTATE[42501]: Insufficient privilege: 7 ERROR: permission denied for schema prism LINE 1: SELECT 1 FROM ONLY "prism"."saved_graphs" x WHERE "graphid" ... ^ QUERY: SELECT 1 FROM ONLY "prism"."saved_graphs" x WHERE "graphid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x

When looking into the PostgreSQL logs, I see the following output for when I'm trying to load a graph in the web UI:

2010-06-08 10:32:46 EDT ERROR:  permission denied for schema prism at character 20
2010-06-08 10:32:46 EDT QUERY:  SELECT 1 FROM ONLY "prism"."saved_graphs" x WHERE "graphid" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x
2010-06-08 10:32:46 EDT STATEMENT:  insert into prism.saved_graphs_dep
                                                     (graphid, sid,
                                                      metric_name, metric_type)
                                              values ($1,$2,$3,$4)
2010-06-08 10:32:46 EDT ERROR:  invalid input syntax for uuid: "null"
2010-06-08 10:32:46 EDT STATEMENT:  select *
                                         from prism.saved_graphs
                                        where graphid=$1

It seems that the PHP is passing in the string "null", which is causing this condition. Here it is replicated on the command line:

> psql -Uprism reconnoiter -c "select * from prism.saved_graphs where graphid='null'"
Password for user prism:
ERROR:  invalid input syntax for uuid: "null"
LINE 1: select * from prism.saved_graphs where graphid='null'

Is there some configuration that I'm missing or have incorrect? Any ideas on this?

--
Toby DiPasquale



More information about the Reconnoiter-users mailing list