little problem with UBUNTU 16 LTS

[ppKrauss]

npm install -g postgraphql not working, "Error: EACCES: permission denied" (errno -13).

Not good solution: sudo npm install -g postgraphql worked.

---

Other problem, when executing the command postgraphql

PostGraphQL server listening on port 5000 🚀

  ‣ Connected to Postgres instance postgres://localhost:5432
  ‣ Introspected Postgres schema(s) public
  ‣ GraphQL endpoint served at http://localhost:5000/graphql
  ‣ GraphiQL endpoint served at http://localhost:5000/graphiql

* * *

error: password authentication failed for user "user"

---

PS: perhaps at Wiki or docs/cli.md, etc. can add some instructions about configurating env.

[benjie]

Try passing the -c option to give a connection string, e.g. postgres://user:pass@localhost/dbname replacing user/pass with your PostgreSQL credentials and dbname with your database name (e.g. "postgres")

[ppKrauss]

Hi @benjie, thanks (!). Hum... using
postgraphql -c postgres://postgres:postgres@localhost:5432/issn
but the error not makes sense, because it is runing with PGPASSWORD=postgres psql -U postgres issnl... Complete message:

PostGraphQL server listening on port 5000 🚀

  ‣ Connected to Postgres instance postgres://localhost:5432/issn
  ‣ Introspected Postgres schema(s) public
  ‣ GraphQL endpoint served at http://localhost:5000/graphql
  ‣ GraphiQL endpoint served at http://localhost:5000/graphiql

* * *

error: database "issn" does not exist
    at Connection.parseE (/usr/local/lib/node_modules/postgraphql/node_modules/pg/lib/connection.js:567:11)
    at Connection.parseMessage (/usr/local/lib/node_modules/postgraphql/node_modules/pg/lib/connection.js:391:17)
    at Socket.<anonymous> (/usr/local/lib/node_modules/postgraphql/node_modules/pg/lib/connection.js:129:22)
    at emitOne (events.js:77:13)
    at Socket.emit (events.js:169:7)
    at readableAddChunk (_stream_readable.js:146:16)
    at Socket.Readable.push (_stream_readable.js:110:10)
    at TCP.onread (net.js:523:20)

[benjie]

Not sure if this was a typo in your message, but issn and issnl are different. Psql accepts a connection string too, so try:

psql postgres://postgres:postgres@localhost:5432/issnl

If that works, change psql for postgraphql -c

[ppKrauss]

Hi @benjie ... You is great! This last problem was a typo, sorry. Now I can see... GraphiQL, GraphQL and PostgraphQL, all looks great!!

[atilacamurca]

About the first error there's an article that explains about global packages installation and permissions in Linux/Unix systems: https://github.com/nodeschool/discussions/wiki/Installing-global-node-modules-(Linux-and-Mac)

[ppKrauss]

Hi @atilacamurca, good tutorial for installations (!), I think that ideal is to citate a link in the README ... something as "check this link in case of problem with permissions".

[benjie]

A PR to add a TROUBLESHOOTING.md file to the root with problems and solutions would be welcome.

[ppKrauss]

Hi @benjie , I tryed, but Travis generated an error.

[benjie]

Please ignore the CI error; someone needs to fix it on master.

[benjie]

Closing this since the docs are now merged