It's been some time since I've dealt with user permissions in InfluxDB 0.8, but I suspect there is some form of corruption in the metastore around that database's user permissions. It's very odd that users wouldn't show in the list, and that the `influx-admin` user wouldn't have full permissions to it. Are you able to perform the necessary queries now or do you still have no admin user for the "latency" database?
On Tue, Aug 2, 2016 at 4:02 AM, Jakub Muszynski <[email protected]> wrote: > Hi > That was one of the most stupid thing I've ever seen. > @Sean - You were right! > My root user (influx-admin? user) did not have the permissions to the > 'latency' database. > > But it could create other users, and make them admin! : > > curl -X POST 'http://localhost:8086/db/latency/users?u=root&p=passs' -d > '{"name": "kuba", "password": "kuba"}' > curl -G 'http://influx01:8086/db/latency/users/kuba?u=root&p=pass' -d > '{"admin": "true"}' > > But I couldn't get the user list with the 'root' user: > > curl -G 'http://influx01:8086/db/latency/users?u=root&p=pass' > Insufficient permissions to list db users on latency > > and with my new admin-user 'kuba', I can get that list, but the user > 'kuba' itself is not present there: > > curl -G 'http://influx01:8086/db/latency/users?u=kuba&p=kuba' > [{"name":"root","isAdmin":false,"writeTo":".*","readFrom":".*"}] > > I did create another user: > curl -G 'http://influx01:8086/db/latency/users?u=root&p=pass' -d > '{"name": "kuba2", "password": "kuba2"}' > > but still user 'kuba2' is not present there: > curl -G 'http://influx01:8086/db/latency/users?u=kuba&p=kuba' > [{"name":"root","isAdmin":false,"writeTo":".*","readFrom":".*"}] > > Wow! > > On Tue, Aug 2, 2016 at 12:02 AM, Sean Beckett <[email protected]> wrote: > >> For 0.8, non-read queries should typically be sent using curl. Your error >> appears to indicate that the user you are authenticating as doesn't have >> permissions to delete from that database. Can you check your user >> permissions and try again? >> >> On Mon, Aug 1, 2016 at 10:47 AM, <[email protected]> wrote: >> >>> I know that we have a new version, and I'm migrating towards, but I do >>> have some old 0.8.8 version running. >>> >>> >>> What is the delete command in that version? >>> >>> #curl -G 'http://influx01:8086/db/latency/series?u=user&p=pass' >>> --data-urlencode "q=delete from logstash where time < now() -30d" -v >>> >>> < HTTP/1.1 403 Forbidden >>> >>> >>> via web 8083 interface ExploreData window: >>> Insufficient permissions to write to latency >>> >>> I'm not sure what are the API endpoints for the curl -X DELETE >>> >>> Should I run a GET curl with delete as mentioned in the documentation: >>> >>> https://docs.influxdata.com/influxdb/v0.8/api/query_language/#deleting-data-or-dropping-series >>> >>> Should I Use the web interface? >>> >>> What would be the place from where (how) would You execute delete >>> commands mentioned in the documentation (curl command, interface, etc) >>> >>> -- >>> Remember to include the InfluxDB version number with all issue reports >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "InfluxDB" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at https://groups.google.com/group/influxdb. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/influxdb/688fa571-3da9-4125-988c-e3171290f2e0%40googlegroups.com >>> . >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> >> >> -- >> Sean Beckett >> Director of Support and Professional Services >> InfluxDB >> >> -- >> Remember to include the InfluxDB version number with all issue reports >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "InfluxDB" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/influxdb/rvOWOskOUfk/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> [email protected]. >> To post to this group, send email to [email protected]. >> Visit this group at https://groups.google.com/group/influxdb. >> To view this discussion on the web visit >> https://groups.google.com/d/msgid/influxdb/CALGqCvPF2%3DQVv5gk_5ismPQ-wowxtX7GNBmijFvTBLfpSwRMaA%40mail.gmail.com >> <https://groups.google.com/d/msgid/influxdb/CALGqCvPF2%3DQVv5gk_5ismPQ-wowxtX7GNBmijFvTBLfpSwRMaA%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> >> For more options, visit https://groups.google.com/d/optout. >> > > -- > Remember to include the InfluxDB version number with all issue reports > --- > You received this message because you are subscribed to the Google Groups > "InfluxDB" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/influxdb. > To view this discussion on the web visit > https://groups.google.com/d/msgid/influxdb/CAGqkPEj9BRB_ZHFTikwMSCYz7Q4%3DqLQzFf6PrMPN%3DB57Am5KMQ%40mail.gmail.com > <https://groups.google.com/d/msgid/influxdb/CAGqkPEj9BRB_ZHFTikwMSCYz7Q4%3DqLQzFf6PrMPN%3DB57Am5KMQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > For more options, visit https://groups.google.com/d/optout. > -- Sean Beckett Director of Support and Professional Services InfluxDB -- Remember to include the InfluxDB version number with all issue reports --- You received this message because you are subscribed to the Google Groups "InfluxDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/CALGqCvN%2BNCQ7TanNYpqemykAjeZsPzb9Y_dzNdSDO5stEjgbfw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
