{"action":"created","issue":{"url":"https://api.github.com/repos/LaCasemate/fab-manager/issues/36","repository_url":"https://api.github.com/repos/LaCasemate/fab-manager","labels_url":"https://api.github.com/repos/LaCasemate/fab-manager/issues/36/labels{/name}","comments_url":"https://api.github.com/repos/LaCasemate/fab-manager/issues/36/comments","events_url":"https://api.github.com/repos/LaCasemate/fab-manager/issues/36/events","html_url":"https://github.com/LaCasemate/fab-manager/issues/36","id":171699570,"number":36,"title":"Mac OSX & Ubuntu 16.04: ERROR:  permission denied to create extension \"unaccent\"","user":{"login":"Vincent14","id":1963080,"avatar_url":"https://avatars.githubusercontent.com/u/1963080?v=3","gravatar_id":"","url":"https://api.github.com/users/Vincent14","html_url":"https://github.com/Vincent14","followers_url":"https://api.github.com/users/Vincent14/followers","following_url":"https://api.github.com/users/Vincent14/following{/other_user}","gists_url":"https://api.github.com/users/Vincent14/gists{/gist_id}","starred_url":"https://api.github.com/users/Vincent14/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Vincent14/subscriptions","organizations_url":"https://api.github.com/users/Vincent14/orgs","repos_url":"https://api.github.com/users/Vincent14/repos","events_url":"https://api.github.com/users/Vincent14/events{/privacy}","received_events_url":"https://api.github.com/users/Vincent14/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-17T16:17:27Z","updated_at":"2016-08-17T20:43:22Z","closed_at":null,"body":"In [this](https://github.com/LaCasemate/fab-manager#general-guidelines) documentation section, at step 8:\r\n\r\n> $ rake db:setup\r\n> fablab_development already exists\r\n> -- enable_extension(\"plpgsql\")\r\n>    -> 0.0568s\r\n> -- enable_extension(\"unaccent\")\r\n> rake aborted!\r\n> ActiveRecord::StatementInvalid: PG::InsufficientPrivilege: ERROR:  permission denied to create extension \"unaccent\"\r\n> HINT:  Must be superuser to create this extension.\r\n> : CREATE EXTENSION IF NOT EXISTS \"unaccent\"\r\n\r\nBut I get the same error even if I do it:\r\n\r\n> postgres=# CREATE EXTENSION IF NOT EXISTS \"unaccent\";\r\n> CREATE EXTENSION\r\n> postgres=#\r\n\r\nDo you have any idea?"},"comment":{"url":"https://api.github.com/repos/LaCasemate/fab-manager/issues/comments/240541589","html_url":"https://github.com/LaCasemate/fab-manager/issues/36#issuecomment-240541589","issue_url":"https://api.github.com/repos/LaCasemate/fab-manager/issues/36","id":240541589,"user":{"login":"sylvainbx","id":5102799,"avatar_url":"https://avatars.githubusercontent.com/u/5102799?v=3","gravatar_id":"","url":"https://api.github.com/users/sylvainbx","html_url":"https://github.com/sylvainbx","followers_url":"https://api.github.com/users/sylvainbx/followers","following_url":"https://api.github.com/users/sylvainbx/following{/other_user}","gists_url":"https://api.github.com/users/sylvainbx/gists{/gist_id}","starred_url":"https://api.github.com/users/sylvainbx/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sylvainbx/subscriptions","organizations_url":"https://api.github.com/users/sylvainbx/orgs","repos_url":"https://api.github.com/users/sylvainbx/repos","events_url":"https://api.github.com/users/sylvainbx/events{/privacy}","received_events_url":"https://api.github.com/users/sylvainbx/received_events","type":"User","site_admin":false},"created_at":"2016-08-17T20:43:21Z","updated_at":"2016-08-17T20:43:21Z","body":"As the error message said:\r\n\r\n> ERROR: permission denied to create extension \"unaccent\"\r\n> HINT: Must be superuser to create this extension.\r\n\r\nI guess the user you configured in `database.yml` was not granted full permissions on the fab-manager's database. Maybe you can try something like the following, in `psql`:\r\n\r\n        GRANT ALL PRIVILEGES ON fabmanager_development TO myuser;\r\n"}}
{"actor":{"display_login":"sylvainbx"}}