Ovidiu Spatacian-Tarnu
11/13/2018, 10:11 PM[0] org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host “`IPADDRESS`“, user “`username`“, database “`database`“, SSL off
Ovidiu Spatacian-Tarnu
11/13/2018, 10:12 PMOvidiu Spatacian-Tarnu
11/13/2018, 10:12 PMmanagementApiSecret: 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
Ovidiu Spatacian-Tarnu
11/13/2018, 10:13 PMFROM 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
Mike
11/13/2018, 11:09 PMMike
11/13/2018, 11:10 PMssl: true
to databases.default
samba
11/13/2018, 11:17 PMdocker-compose up
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
samba
11/13/2018, 11:17 PMsamba
11/13/2018, 11:18 PMRamin B
11/14/2018, 2:42 AMJubal Mabaquiao
11/14/2018, 3:35 AMOvidiu Spatacian-Tarnu
11/14/2018, 3:37 AMCannot set property 'selectionSet' of undefined
Ovidiu Spatacian-Tarnu
11/14/2018, 3:37 AMconst fragment = `
fragment PageTitle on Page {
title
}
`;
const pages = await prisma.pages().$fragment(fragment);
Jubal Mabaquiao
11/14/2018, 3:37 AMOvidiu Spatacian-Tarnu
11/14/2018, 3:38 AMroberto.guerra
11/14/2018, 3:41 AMtitle
an attribute of Page?Ovidiu Spatacian-Tarnu
11/14/2018, 3:42 AMOvidiu Spatacian-Tarnu
11/14/2018, 3:42 AMtype Page {
id: ID! @unique
createdAt: DateTime!
updatedAt: DateTime!
title: String!
slug: String!
}
roberto.guerra
11/14/2018, 3:43 AMPageTitle
in Page
?Ovidiu Spatacian-Tarnu
11/14/2018, 3:44 AMconst fragment = `
fragment Title on Page {
title
}
`;
Ovidiu Spatacian-Tarnu
11/14/2018, 3:44 AMroberto.guerra
11/14/2018, 3:44 AMTitle
in Page
.roberto.guerra
11/14/2018, 3:45 AMfragment SubType on ParentType { }
, in my understandingroberto.guerra
11/14/2018, 3:45 AMfragment
for simple cases like this, only for nested objectsroberto.guerra
11/14/2018, 3:46 AMconst personFragment = `
fragment Person on User {
id
isDisabled
person {
id
firstName
lastName
email
birthdate
}
}
`
....
return await ctx.prisma.users().$fragment(personFragment)
roberto.guerra
11/14/2018, 3:47 AMroberto.guerra
11/14/2018, 3:47 AMOvidiu Spatacian-Tarnu
11/14/2018, 3:48 AMJubal Mabaquiao
11/14/2018, 3:49 AMroberto.guerra
11/14/2018, 3:50 AM