Hey Wanted to check if there s any documentation on using rd

Question

Hey Wanted to check if there s any documentation on using rds with supertokens

rp · Answer

Hey It should be the same as connecting with PostgreSQL mysql

rp · Answer

See our docs for connecting with these databases

raoul97 · Answer

I see We ve implemented that already But we re getting serviceName HIB code COM 0 message INTERNAL SERVER ERROR context originalError Error No SuperTokens core available to query at Querier Users raoulnandwani AF IAM huat iam service backend node modules supertokens node lib build querier js 225 27 at Generator next at Users raoulnandwani AF IAM huat iam service backend node modules supertokens node lib build querier js 30 75 at new Promise at awaiter Users raoulnandwani AF IAM huat iam service backend node modules supertokens node lib build querier js 12 16 at Querier sendRequestHelper Users raoulnandwani AF IAM huat iam service backend node modules supertokens node lib build querier js 218 13 at Querier Users raoulnandwani AF IAM huat iam service backend node modules supertokens node lib build querier js 245 43 at Generator throw at rejected Users raoulnandwani AF IAM huat iam service backend node modules supertokens node lib build querier js 22 44 at processTicksAndRejections node internal process task queues 96 5 httpStatusCode 500 endpointUrl auth signup inputParams formFields Object Object We have changed the super tokens connection urI to SUPERTOKENS CONNECTION URI= http localhost 3567

rp · Answer

are you using docker for the node server

raoul97 · Answer

Yup we are using docker

rp · Answer

right So localhost refers to inside the docker container

raoul97 · Answer

For both posingress and super tokens

raoul97 · Answer

Yup

rp · Answer

so you need to give the IP or the service name of the supertokens container instead of using localhost

kamyab · Answer

can you please try with `http supertokens 3567`

raoul97 · Answer

Sure I ll try that

raoul97 · Answer

Getting this after the change Error getaddrinfo ENOTFOUND supertokens at GetAddrInfoReqWrap onlookup as oncomplete node dns 71 26 at GetAddrInfoReqWrap callbackTrampoline node internal async hooks 130 17 errno 3008 code ENOTFOUND syscall getaddrinfo hostname supertokens config url http supertokens 3567 apiversion method get headers Accept application json text plain api key S2P3dbAJXgV3gTWlUqaXCcTITwV6u6 User Agent axios 0 21 4 transformRequest Function transformRequest transformResponse Function transformResponse timeout 0 adapter Function httpAdapter xsrfCookieName XSRF TOKEN xsrfHeaderName X XSRF TOKEN maxContentLength 1 maxBodyLength 1 validateStatus Function validateStatus transitional silentJSONParsing true forcedJSONParsing true clarifyTimeoutError false data undefined

rp · Answer

are you using docker compose

raoul97 · Answer

request <ref 1> Writable writableState WritableState objectMode false highWaterMark 16384 finalCalled false needDrain false ending false ended false finished false destroyed false decodeStrings true defaultEncoding utf8 length 0 writing false corked 0 sync true bufferProcessing false onwrite Function bound onwrite writecb null writelen 0 afterWriteTickInfo null buffered bufferedIndex 0 allBuffers true allNoop true pendingcb 0 constructed true prefinished false errorEmitted false emitClose true autoDestroy true errored null closed false closeEmitted false Symbol kOnFinished events Object null prototype response Function handleResponse error Function handleRequestError eventsCount 2 maxListeners undefined options maxRedirects 21 maxBodyLength 10485760 protocol http path apiversion method GET headers Object agent undefined agents Object auth undefined hostname supertokens port 3567 nativeProtocols Object pathname apiversion ended true ending true redirectCount 0 redirects requestBodyLength 0 requestBodyBuffers onNativeResponse Function anonymous currentRequest ClientRequest events Object null prototype eventsCount 8 maxListeners undefined outputData outputSize 0 writable true destroyed false last true chunkedEncoding false shouldKeepAlive false maxRequestsOnConnectionReached false defaultKeepAlive true

raoul97 · Answer

useChunkedEncodingByDefault false sendDate false removedConnection false removedContLen false removedTE false contentLength 0 hasBody true trailer finished true headerSent true closed false socket Socket header GET apiversion HTTP 1 1 r n + accept application json text plain r n + api key S2P3dbAJXgV3gTWlUqaXCcTITwV6u6 r n + user agent axios 0 21 4 r n + x amzn trace id Root=1 636213ff 727ff0a21f89f6f719b9f6e8 Parent=21f6fe4f0393d277 Sampled=1 r n + Host supertokens 3567 r n + Connection close r n + r n keepAliveTimeout 0 onPendingData Function nop agent Agent socketPath undefined method GET maxHeaderSize undefined insecureHTTPParser undefined path apiversion ended false res null aborted false timeoutCb null upgradeOrConnect false parser null maxHeadersCount null reusedSocket false host supertokens protocol http addListener Function anonymous

raoul97 · Answer

on Function anonymous once Function anonymous prependListener Function anonymous prependOnceListener Function anonymous removeListener Function anonymous off Function anonymous removeAllListeners Function anonymous redirectable Circular 1 Symbol kCapture false Symbol kNeedDrain false Symbol corked 0 Symbol kOutHeaders Object null prototype Symbol OtListeners Object null prototype currentUrl http supertokens 3567 apiversion Symbol kCapture false response undefined isAxiosError true toJSON Function toJSON serviceName HIB code ENOTFOUND message INTERNAL SERVER ERROR context originalError message getaddrinfo ENOTFOUND supertokens name Error description undefined number undefined fileName undefined lineNumber undefined columnNumber undefined stack Error getaddrinfo ENOTFOUND supertokens n + at GetAddrInfoReqWrap onlookup as oncomplete node dns 71 26 n + at GetAddrInfoReqWrap callbackTrampoline node internal async hooks 130 17 config url http supertokens 3567 apiversion method get headers Object transformRequest Array transformResponse Array timeout 0 adapter Function httpAdapter xsrfCookieName XSRF TOKEN xsrfHeaderName X XSRF TOKEN maxContentLength 1 maxBodyLength 1 validateStatus Function validateStatus transitional Object data undefined code ENOTFOUND httpStatusCode 500 endpointUrl auth signin inputParams formFields Object Object

raoul97 · Answer

Sorry that s the full long error

raoul97 · Answer

We re not using docker compose

raoul97 · Answer

Actually I tried following this blog https supertokens com blog connect supertokens to database And at the end it says to testing this way Verify that it is setup correctly by querying the core service curl http localhost 3567 hello If you get back a Hello reply the core setup is done But it says connection refused

raoul97 · Answer

Should the port be supertokens 3567 as well

rp · Answer

hmm Whats the docker run command you are using And which OS

raoul97 · Answer

I used this docker run p 3567 3567 network=host e POSTGRESQL CONNECTION URI= postgresql supertokens user somePassword 192 168 1 1 5432 supertokens d registry supertokens io supertokens supertokens postgresql

raoul97 · Answer

OS is macos

rp · Answer

can you remove ` network=host`

rp · Answer

and then try

rp · Answer

if you visit localhost 3567 hello on your browser what do you get

raoul97 · Answer

This is what we get

kamyab · Answer

docker run p 3567 3567 e POSTGRESQL USER= root e POSTGRESQL PASSWORD= root e POSTGRESQL HOST= localhost e POSTGRESQL PORT= 5432 e POSTGRESQL DATABASE NAME= supertokens d registry supertokens io supertokens supertokens postgresql

kamyab · Answer

try to run this

raoul97 · Answer

tried this as well

raoul97 · Answer

Trying again in a few seconds for 57 0 mins 02 Nov 2022 08 14 32 840 +0000 | ERROR | pid 58a9ed63 73b5 4880 a406 39c8ef0e8d80 | main thread | io supertokens storage postgresql HikariLoggingAppender doAppend HikariLoggingAppender java 132 | SuperTokens Exception during pool initialization 02 Nov 2022 08 14 32 840 +0000 | INFO | pid 58a9ed63 73b5 4880 a406 39c8ef0e8d80 | main thread | io supertokens storage postgresql ConnectionPool initPool ConnectionPool java 154 | Trying again in a few seconds for 56 8 mins

raoul97 · Answer

getting these errors

rp · Answer

this means the db connection is not working

raoul97 · Answer

ah i see

raoul97 · Answer

hmm

rp · Answer

are you sure you have provided the right password username port host of the db

raoul97 · Answer

yup it should be right

raoul97 · Answer

This is our database server

raoul97 · Answer

i can access the connected database as well

raoul97 · Answer

through pgAdmin

rp · Answer

oh right ok so the problem is that you are giving the host as localhost

rp · Answer

for the postgresql connection

rp · Answer

localhost in docker points to inside the container

raoul97 · Answer

ah i see

rp · Answer

and since you are running postgresql on a different container it s not reachable

rp · Answer

so give it the Ip of your machine instead and make sure that postgresql is reachable via that IP

raoul97 · Answer

okay i ll try that

raoul97 · Answer

Trying to use this to create a container with both services

raoul97 · Answer

version 3 services db image postgres latest environment POSTGRES USER root POSTGRES PASSWORD root POSTGRES DB supertokens ports 5432 5432 networks app network restart unless stopped healthcheck test CMD pg isready U supertokens user interval 5s timeout 5s retries 5 supertokens image registry supertokens io supertokens supertokens postgresql depends on db ports 3567 3567 environment POSTGRESQL CONNECTION URI postgresql root root 203 116 73 130 5432 supertokens networks app network restart unless stopped healthcheck test > bash c exec 3<> dev tcp 127 0 0 1 3567 echo e GET hello HTTP 1 1 r nhost 127 0 0 1 3567 r nConnection close r n r n > 3 cat < 3 | grep Hello interval 10s timeout 5s retries 5 networks app network driver bridge

raoul97 · Answer

still can t seem to connect for some reason

rp · Answer

use `db` instead of `203 116 73 130`

rp · Answer

it would be good if you do some reading up on networking with docker

rp · Answer

since all these issues are docker related an not supertokens related

raoul97 · Answer

yup thanks for the help