https://www.prisma.io/ logo
Join SlackCommunities
Powered by
# orm-help
  • o
    Hi I’m trying to deploy a dockerfile to zeit now. My database engine is PostgreSQL hosted on an external service but unfortunately I keep getting this error WARNING: SQLException occurred while connecting to HOSTNAME:PORT
    [0] org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host “`IPADDRESS`“, user “`username`“, database “`database`“, SSL off
  • o
    I must say that the external service requires SSL and this may be what causes the issue but I couldn’t see any option to in the prisma.yml file to set SSL to true
  • o
    Copy code
    managementApiSecret: PRISMA_MANAGEMENT_API_SECRET
port: 4466
databases:
  default:
    connector: postgres
    host: POSTGRES_HOST
    port: 14055
    user: USERNAME
    database: DATABASE
    password: POSTGRES_PASSWORD
    migrations: true
    rawAccess: true
  • o
    this is my Dockerfile
    Copy code
    FROM prismagraphql/prisma:1.20
ARG POSTGRES_HOST
ARG POSTGRES_PASSWORD
ARG PRISMA_MANAGEMENT_API_SECRET
ARG PRISMA_CONFIG_PATH
ENV PRISMA_CONFIG_PATH prisma.yml
COPY config.yml prisma.yml
RUN sed -i s~POSTGRES_HOST~$POSTGRES_HOST~g prisma.yml
RUN sed -i s~POSTGRES_PASSWORD~$POSTGRES_PASSWORD~g prisma.yml
RUN sed -i s~POSTGRES_MANAGEMENT_API_SECRET~$PRISMA_MANAGEMENT_API_SECRET~g prisma.yml
EXPOSE 4466
  • m
  • m
    TL;DR, add 
    ssl: true
    to 
    databases.default
    o
    • 2
    • 4
  • s
    quick question here. having an issue with getting started example copy pasted a docker-compose file and trying to 
    docker-compose up
    Copy code
    mysql_1   | 2018-11-13T23:14:49.229437Z 14 [Note] Access denied for user 'root'@'172.29.0.3' (using password: YES)
prisma_1  | Exception in thread "main" java.sql.SQLTransientConnectionException: database - Connection is not available, request timed out after 5001ms.
prisma_1  | 	at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:548)
prisma_1  | 	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:186)
prisma_1  | 	at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:145)
prisma_1  | 	at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:83)
prisma_1  | 	at slick.jdbc.hikaricp.HikariCPJdbcDataSource.createConnection(HikariCPJdbcDataSource.scala:14)
prisma_1  | 	at slick.jdbc.JdbcBackend$BaseSession.<init>(JdbcBackend.scala:453)
prisma_1  | 	at slick.jdbc.JdbcBackend$DatabaseDef.createSession(JdbcBackend.scala:46)
prisma_1  | 	at slick.jdbc.JdbcBackend$DatabaseDef.createSession(JdbcBackend.scala:37)
prisma_1  | 	at slick.basic.BasicBackend$DatabaseDef.acquireSession(BasicBackend.scala:249)
prisma_1  | 	at slick.basic.BasicBackend$DatabaseDef.acquireSession$(BasicBackend.scala:248)
prisma_1  | 	at slick.jdbc.JdbcBackend$DatabaseDef.acquireSession(JdbcBackend.scala:37)
prisma_1  | 	at slick.basic.BasicBackend$DatabaseDef$$anon$2.run(BasicBackend.scala:274)
prisma_1  | 	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
prisma_1  | 	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
prisma_1  | 	at java.lang.Thread.run(Thread.java:748)
prisma_1  | Caused by: java.sql.SQLInvalidAuthorizationSpecException: Could not connect: Access denied for user 'root'@'172.29.0.3' (using password: YES)
prisma_1  | 	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:159)
prisma_1  | 	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)
prisma_1  | 	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1036)
prisma_1  | 	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:490)
prisma_1  | 	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:144)
prisma_1  | 	at org.mariadb.jdbc.Driver.connect(Driver.java:90)
prisma_1  | 	at slick.jdbc.DriverDataSource.getConnection(DriverDataSource.scala:101)
prisma_1  | 	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
prisma_1  | 	at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:193)
prisma_1  | 	at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:430)
prisma_1  | 	at com.zaxxer.hikari.pool.HikariPool.access$500(HikariPool.java:64)
prisma_1  | 	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:570)
prisma_1  | 	at com.zaxxer.hikari.pool.HikariPool$PoolEntryCreator.call(HikariPool.java:563)
prisma_1  | 	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
prisma_1  | 	... 3 more
prisma_1  | Caused by: java.sql.SQLException: Could not connect: Access denied for user 'root'@'172.29.0.3' (using password: YES)
prisma_1  | 	at org.mariadb.jdbc.internal.com.send.AbstractAuthSwitchSendResponsePacket.handleResultPacket(AbstractAuthSwitchSendResponsePacket.java:97)
prisma_1  | 	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authentication(AbstractConnectProtocol.java:774)
prisma_1  | 	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:713)
prisma_1  | 	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:402)
prisma_1  | 	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1032)
prisma_1  | 	... 14 more
  • s
  • s
    seems like user is not getting authenticated some how on database.
  • r
    Is there a better way to get support for Prisma? Don't seem to get much responses on this slacl
  • j
    what version of node are you guys using with the new prisma client?
    s
    • 2
    • 1
  • o
    It looks I may have run into a bug unless the documentation is not up-to-date. When I try to fetch only a fragment I’m getting a 
    Cannot set property 'selectionSet' of undefined
    👍🏻 1
    j
    • 2
    • 2
  • o
    This is my code
    Copy code
    const fragment = `
    fragment PageTitle on Page {
      title
    }
    `;
    const pages = await prisma.pages().$fragment(fragment);
  • j
    @Ovidiu Spatacian-Tarnu exactly what I was going to ask just now
  • o
    thanks @Jubal Mabaquiao Maybe someone in the channel will be able to help us
    🙏🏻 1
  • r
    Is 
    title
    an attribute of Page?
  • o
    yes
  • o
    this is my schema
    Copy code
    type Page {
  id: ID! @unique
  createdAt: DateTime!
  updatedAt: DateTime!
  title: String!
  slug: String!
}
  • r
    there is no 
    PageTitle
    in 
    Page
    ?
  • o
    no but even with this fragment
    Copy code
    const fragment = `
    fragment Title on Page {
      title
    }
    `;
  • o
    I get the same error
  • r
    yeah, I’m assuming it is because there is no 
    Title
    in 
    Page
    .
  • r
    it is generally: 
    fragment SubType on ParentType { }
    , in my understanding
  • r
    I have not used a 
    fragment
    for simple cases like this, only for nested objects
  • r
    eg:
    Copy code
    const personFragment = `
fragment Person on User {
    id
    isDisabled
    person {
        id
        firstName
        lastName
        email
        birthdate
    }
}
`

....
return await ctx.prisma.users().$fragment(personFragment)
  • r
    ah well, my assumptions are wrong 🙂
  • r
  • o
    I see
  • j
    also worth noting I encounterd such with the new Prisma Client
  • r
    what version of prisma?
1...156157158...637Latest