Open Gresliebear opened 2 years ago
Sep 5, 02:26:22 AM: ac90aa8e ERROR Unhandled Promise Rejection {"errorType":"Runtime.UnhandledPromiseRejection","errorMessage":"Error: error:0909006C:PEM routines:get_name:no start
line","reason":{"errorType":"Error","errorMessage":"error:0909006C:PEM routines:get_name:no start
line","code":"ERR_OSSL_PEM_NO_START_LINE","library":"PEM routines","function":"get_name","reason":"no start line","stack":
["Error: error:0909006C:PEM routines:get_name:no start line"," at Sign.sign (node:internal/crypto/sig:131:29)"," at
Object.sign (/var/task/node_modules/jws/node_modules/jwa/index.js:152:45)"," at Object.jwsSign [as sign]
(/var/task/node_modules/jws/lib/sign-stream.js:32:24)"," at GoogleToken.requestToken (/var/task/node_modules/gtoken/build/src/index.js:225:31)"," at GoogleToken.getTokenAsyncInner
(/var/task/node_modules/gtoken/build/src/index.js:163:21)"," at GoogleToken.getTokenAsync
(/var/task/node_modules/gtoken/build/src/index.js:142:55)"," at GoogleToken.getToken
(/var/task/node_modules/gtoken/build/src/index.js:94:21)"," at JWT.refreshTokenNoCache (/var/task/node_modules/google-auth-library/build/src/auth/jwtclient.js:158:36)"," at JWT.refreshToken (/var/task/node_modules/google-auth-
library/build/src/auth/oauth2client.js:143:25)"," at JWT.authorizeAsync (/var/task/node_modules/google-auth-
library/build/src/auth/jwtclient.js:139:35)"]},"promise":{},"stack":["Runtime.UnhandledPromiseRejection: Error:
error:0909006C:PEM routines:get_name:no start line"," at process.<anonymous> (file:///var/runtime/index.mjs:1131:17)"," at process.emit (node:events:527:28)"," at emit (node:internal/process/promises:140:20)"," at processPromiseRejections (node:internal/process/promises:274:27)"," at processTicksAndRejections (node:internal/process/task_queues:97:32)"]}
this solution doesn't work for dev localhost env
https://answers.netlify.com/t/using-firebase-admin-sdk-with-lambda-function/2136/5
We tried private_key: JSON.parse(process.env.PRIVATE_KEY.replace(/\n/gm, "\n")),
result is
api | were inside testagfas@gmail.com
api | were inside No
api | (node:24412) ExperimentalWarning: buffer.Blob is an experimental feature. This feature could change at any time
api | (Use `node --trace-warnings ...` to show where the warning was created)
api | SyntaxError: Unexpected number in JSON at position 1
api | at JSON.parse (<anonymous>)
api | at null.insertEmail (E:\SweepaLandingPage\Sweepa\sweepa-app\api\src\lib\googlesheet.js:26:21)
api | at Object.createEmailSignUp (E:\SweepaLandingPage\Sweepa\sweepa-app\api\src\services\emailSignUps\emailSignUps.js:15:3)
api | at Object.createEmailSignUp (E:\SweepaLandingPage\Sweepa\sweepa-app\node_modules\@redwoodjs\graphql-server\dist\makeMergedSchema\makeMergedSchema.js:63:62)
api | at useRedwoodDirectiveValidatorResolver (E:\SweepaLandingPage\Sweepa\sweepa-app\node_modules\@redwoodjs\graphql-server\dist\plugins\useRedwoodDirective.js:96:22)
api | at executeField (E:\SweepaLandingPage\Sweepa\sweepa-app\node_modules\graphql\execution\execute.js:481:20)
api | at E:\SweepaLandingPage\Sweepa\sweepa-app\node_modules\graphql\execution\execute.js:377:22
api | at promiseReduce (E:\SweepaLandingPage\Sweepa\sweepa-app\node_modules\graphql\jsutils\promiseReduce.js:23:9)
api | at executeFieldsSerially (E:\SweepaLandingPage\Sweepa\sweepa-app\node_modules\graphql\execution\execute.js:373:43)
api | at executeOperation (E:\SweepaLandingPage\Sweepa\sweepa-app\node_modules\graphql\execution\execute.js:347:14)
web | <e> [webpack-dev-server] [HPM] Error occurred while proxying request localhost:8910/graphql to
http://localhost:8911/ [ECONNRESET] (https://nodejs.org/api/errors.html#errors_common_system_errors)
api | [change] \src\lib\googlesheet.js
api | Building... Took 185 ms
api | Debugger listening on ws://127.0.0.1:18911/20d41db7-8e19-4662-9ffb-4eac8a9fee46
api | For help, see: https://nodejs.org/en/docs/inspector
api | Starting API Server...
api | Loading server config from E:\SweepaLandingPage\Sweepa\sweepa-app\api\server.config.js
api |
api | Importing Server Functions...
We fixed it now a new error
PRIVATE_KEY2 = PRIVATE_KEY[0] === '-' ? PRIVATE_KEY : JSON.parse(PRIVATE_KEY)
const serviceCredential = {
// env var values are copied from service account credentials generated by google
// see "Authentication" section in docs for more info
type: process.env.TYPE,
project_id: process.env.PROJECT_ID,
private_key_id: process.env.PRIVATE_KEY_ID,
// private_key: process.env.PRIVATE_KEY.replace(/\\n/gm, "\n"),
// private_key: JSON.parse(process.env.PRIVATE_KEY.replace(/\\n/gm, "\n")),
private_key: PRIVATE_KEY2,
// JSON.parse(${process.env.GATSBY_CREDENTIALS})
client_email: process.env.CLIENT_EMAIL,
client_id: process.env.CLIENT_ID,
auth_uri: process.env.AUTH_URI,
token_uri: process.env.TOKEN_URI,
auth_provider_x509_cert_url: process.env.AUTH_PROVIDER_X509_CERT_URL,
client_x509_cert_url: process.env.CLIENT_X509_CERT_URL
}
ERROR Unhandled Promise Rejection {"errorType":"Runtime.UnhandledPromiseRejection","errorMessage":"Error: invalid_grant: Invalid grant: account not found","reason":{"errorType":"Error","errorMessage":"invalid_grant: Invalid grant: account not found","code":"400","response":{"config":{"method":"POST","url":"https://www.googleapis.com/oauth2/v4/token","data":{"grant_type":"urn:ietf:params:oauth:grant-type:jwt-bearer","assertion":"eyJhbGciOiJSUzI1NiJ9.eyJzY29wZSI6Imh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL2F1dGgvc3ByZWFkc2hlZXRzIiwiYXVkIjoiaHR0cHM6Ly93d3cuZ29vZ2xlYXBpcy5jb20vb2F1dGgyL3Y0L3Rva2VuIiwiZXhwIjoxNjYyNDA4MTc2LCJpYXQiOjE2NjI0MDQ1NzYsInN1YiI6bnVsbH0.Mi8efRPSVI1qwI8bgY0mwJnPYP9tlo8ShpJvu-B2rFP7A-Ep3DCNHeDqNmYETVHBwdKsEchw3v54rgAFkbe5OzOX93ak_FGGDAifzPNbO_LSNRVHMkRcafk3cPskwhQQhE79uzoskU3X86ZCJcVl-_eooMxOijbRhr76ZNpwihPBBGfXrdA6Z-LiZO8ijdU5nKDFCQZzS1SFbu3U0Y6T3X2fXnl7sCVVc_M_LFWX9_XGMehpKoMf9IXV24Cin63S0FG_TONDzfxltK3qiE6ujgAN0H1GEHwQsfJ5INpWUD2eq7QC0bqmSUtHGxjXqM6h5YqpyVoW3FqDL_Dy2BnUcA"},"headers":{"Content-Type":"application/x-www-form-urlencoded","Accept":"application/json"},"responseType":"json","body":"grant_type=urn%3Aietf%3Aparams%3Aoauth%3Agrant-type%3Ajwt-bearer&assertion=eyJhbGciOiJSUzI1NiJ9.eyJzY29wZSI6Imh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL2F1dGgvc3ByZWFkc2hlZXRzIiwiYXVkIjoiaHR0cHM6Ly93d3cuZ29vZ2xlYXBpcy5jb20vb2F1dGgyL3Y0L3Rva2VuIiwiZXhwIjoxNjYyNDA4MTc2LCJpYXQiOjE2NjI0MDQ1NzYsInN1YiI6bnVsbH0.Mi8efRPSVI1qwI8bgY0mwJnPYP9tlo8ShpJvu-B2rFP7A-Ep3DCNHeDqNmYETVHBwdKsEchw3v54rgAFkbe5OzOX93ak_FGGDAifzPNbO_LSNRVHMkRcafk3cPskwhQQhE79uzoskU3X86ZCJcVl-_eooMxOijbRhr76ZNpwihPBBGfXrdA6Z-LiZO8ijdU5nKDFCQZzS1SFbu3U0Y6T3X2fXnl7sCVVc_M_LFWX9_XGMehpKoMf9IXV24Cin63S0FG_TONDzfxltK3qiE6ujgAN0H1GEHwQsfJ5INpWUD2eq7QC0bqmSUtHGxjXqM6h5YqpyVoW3FqDL_Dy2BnUcA"},"data":{"error":"invalid_grant","error_description":"Invalid grant: account not found"},"headers":{"alt-svc":"h3=\":443\"; ma=2592000,h3-29=\":443\"; ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\"; ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000; v=\"46,43\"","cache-control":"private","connection":"close","content-encoding":"gzip","content-type":"application/json; charset=UTF-8","date":"Mon, 05 Sep 2022 19:02:56 GMT","server":"scaffolding on HTTPServer2","transfer-encoding":"chunked","vary":"Origin, X-Origin, Referer","x-content-type-options":"nosniff","x-frame-options":"SAMEORIGIN","x-xss-protection":"0"},"status":400,"statusText":"Bad Request","request":{"responseURL":"https://www.googleapis.com/oauth2/v4/token"}},"config":{"method":"POST","url":"https://www.googleapis.com/oauth2/v4/token","data":{"grant_type":"urn:ietf:params:oauth:grant-type:jwt-bearer","assertion":"eyJhbGciOiJSUzI1NiJ9.eyJzY29wZSI6Imh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL2F1dGgvc3ByZWFkc2hlZXRzIiwiYXVkIjoiaHR0cHM6Ly93d3cuZ29vZ2xlYXBpcy5jb20vb2F1dGgyL3Y0L3Rva2VuIiwiZXhwIjoxNjYyNDA4MTc2LCJpYXQiOjE2NjI0MDQ1NzYsInN1YiI6bnVsbH0.Mi8efRPSVI1qwI8bgY0mwJnPYP9tlo8ShpJvu-B2rFP7A-Ep3DCNHeDqNmYETVHBwdKsEchw3v54rgAFkbe5OzOX93ak_FGGDAifzPNbO_LSNRVHMkRcafk3cPskwhQQhE79uzoskU3X86ZCJcVl-_eooMxOijbRhr76ZNpwihPBBGfXrdA6Z-LiZO8ijdU5nKDFCQZzS1SFbu3U0Y6T3X2fXnl7sCVVc_M_LFWX9_XGMehpKoMf9IXV24Cin63S0FG_TONDzfxltK3qiE6ujgAN0H1GEHwQsfJ5INpWUD2eq7QC0bqmSUtHGxjXqM6h5YqpyVoW3FqDL_Dy2BnUcA"},"headers":{"Content-Type":"application/x-www-form-urlencoded","Accept":"application/json"},"responseType":"json","body":"grant_type=urn%3Aietf%3Aparams%3Aoauth%3Agrant-type%3Ajwt-bearer&assertion=eyJhbGciOiJSUzI1NiJ9.eyJzY29wZSI6Imh0dHBzOi8vd3d3Lmdvb2dsZWFwaXMuY29tL2F1dGgvc3ByZWFkc2hlZXRzIiwiYXVkIjoiaHR0cHM6Ly93d3cuZ29vZ2xlYXBpcy5jb20vb2F1dGgyL3Y0L3Rva2VuIiwiZXhwIjoxNjYyNDA4MTc2LCJpYXQiOjE2NjI0MDQ1NzYsInN1YiI6bnVsbH0.Mi8efRPSVI1qwI8bgY0mwJnPYP9tlo8ShpJvu-B2rFP7A-Ep3DCNHeDqNmYETVHBwdKsEchw3v54rgAFkbe5OzOX93ak_FGGDAifzPNbO_LSNRVHMkRcafk3cPskwhQQhE79uzoskU3X86ZCJcVl-_eooMxOijbRhr76ZNpwihPBBGfXrdA6Z-LiZO8ijdU5nKDFCQZzS1SFbu3U0Y6T3X2fXnl7sCVVc_M_LFWX9_XGMehpKoMf9IXV24Cin63S0FG_TONDzfxltK3qiE6ujgAN0H1GEHwQsfJ5INpWUD2eq7QC0bqmSUtHGxjXqM6h5YqpyVoW3FqDL_Dy2BnUcA"},"stack":["Error: invalid_grant: Invalid grant: account not found"," at Gaxios._request (/var/task/node_modules/gaxios/build/src/gaxios.js:129:23)"," at processTicksAndRejections (node:internal/process/task_queues:96:5)"," at async GoogleToken.requestToken (/var/task/node_modules/gtoken/build/src/index.js:231:23)"," at async GoogleToken.getTokenAsync (/var/task/node_modules/gtoken/build/src/index.js:142:20)"," at async JWT.refreshTokenNoCache (/var/task/node_modules/google-auth-library/build/src/auth/jwtclient.js:158:23)"," at async JWT.authorizeAsync (/var/task/node_modules/google-auth-library/build/src/auth/jwtclient.js:139:24)"," at async GoogleSpreadsheet.renewJwtAuth (/var/task/node_modules/google-spreadsheet/lib/GoogleSpreadsheet.js:113:5)"," at async GoogleSpreadsheet.useServiceAccountAuth (/var/task/node_modules/google-spreadsheet/lib/GoogleSpreadsheet.js:108:5)"," at async insertEmail (/var/task/api/dist/lib/googlesheet.js:46:3)"]},"promise":{},"stack":["Runtime.UnhandledPromiseRejection: Error: invalid_grant: Invalid grant: account not found"," at process.<anonymous> (file:///var/runtime/index.mjs:1131:17)"," at process.emit (node:events:527:28)"," at emit (node:internal/process/promises:140:20)"," at processPromiseRejections (node:internal/process/promises:274:27)"," at processTicksAndRejections (node:internal/process/task_queues:97:32)"]}
invalid_grant: Invalid grant https://blog.timekit.io/google-oauth-invalid-grant-nightmare-and-how-to-fix-it-9f4efaf1da35
{"errorType":"Runtime.UnhandledPromiseRejection","errorMessage":"Error: error:0909006C:PEM routines:get_name:no start line","trace":["Runtime.UnhandledPromiseRejection: Error: error:0909006C:PEM routines:get_name:no start line"," at process. (file:///var/runtime/index.mjs:1131:17)"," at process.emit (node:events:527:28)"," at emit (node:internal/process/promises:140:20)"," at processPromiseRejections (node:internal/process/promises:274:27)"," at processTicksAndRejections (node:internal/process/task_queues:97:32)"]}