Hi ,
I am unable to sign in to self hosted retool for the first time. It goes to the next scree after entering user name and password and comes back to the login page.
Thanks,
Vivek.
Hi Vivek,
To clarify, is this your first time logging in after deploying your self-hosted instance?
Have you first signed up prior to attempting to log in?
Let me know!
Best,
Evan
Hi Evan,
Thanks for the quick response.
Yes , this is the first time logging in .Did signup before trying to sign in.
Thanks,
Vivek
Thanks for that!
Could you send me a screenshot of your browser dev tools after attempting to login showing me the console and network tab?
To clarify a bit further, had you signed up on the newly deployed instance or had you signed up on cloud prior to deploying?
Thank you!
Could you please also send me the console tab?
Also, could you send me your backend api logs?
{"level":"info","message":{"http":{"method":"POST","url_base":"https://10.0.3.228:3000","url_path":"/api/signup"},"type":"REQUEST_BEGIN"},"pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:55.145Z"}
{"level":"info","message":"controller:users:signup planKey=null","pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:55.155Z"}
{"level":"info","message":"HIBP compromised password found during signup for user with email vivekanand@karboncard.com with no org ","pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:55.551Z"}
(node:59) [DEP0106] DeprecationWarning: crypto.createCipher is deprecated.
{"eventType":"USER_CREATE","level":"info","message":"[RetoolEvents][queueWorkflowsForRetoolEvent] Beginning workflows for retool-event","organizationId":1,"pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:57.067Z"}
{"eventType":"USER_CREATE","level":"info","message":"[RetoolEvents][queueWorkflowsForRetoolEvent] Retrieved 0 workflows for retool-event","numWorkflows":0,"organizationId":1,"pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:57.069Z"}
{"eventType":"USER_CREATE","level":"info","message":"[RetoolEvents][queueWorkflowsForRetoolEvent] Finished workflows for retool-event","organizationId":1,"pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:57.070Z"}
{"level":"info","message":"Creating RetoolDB for all environments..","organizationId":1,"pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:57.172Z","userId":1}
{"level":"info","message":"[Grid][dbconnector][clusterQuery] client opened\n\n","pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:57.337Z"}
{"level":"info","message":"[Grid][dbconnector][clusterQuery] client opened\n\n","pid":90,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:57.682Z"}
{"level":"info","message":"Created RetoolDB for all environments..","organizationId":1,"pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:57.766Z","userId":1}
{"endpoint":null,"level":"info","message":{"http":{"method":"POST","request":{"time":2.6275416500009596},"status_code":200,"url_base":"https://10.0.3.228:3000","url_path":"/api/signup"},"type":"REQUEST_FINISH"},"pid":59,"requestId":"d01c50e2-34af-4f01-8a6c-eab5828c102e","timestamp":"2024-03-27T10:07:57.773Z"}
{"level":"info","message":{"http":{"method":"POST","url_base":"https://10.0.3.228:3000","url_path":"/api/auth/saveAuth"},"type":"REQUEST_BEGIN"},"pid":90,"requestId":"86177015-e8d9-43b3-b41a-809836b2f615","timestamp":"2024-03-27T10:07:57.887Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"POST","request":{"time":0.06172791399993002},"status_code":200,"url_base":"https://10.0.3.228:3000","url_path":"/api/auth/saveAuth"},"type":"REQUEST_FINISH"},"pid":90,"requestId":"86177015-e8d9-43b3-b41a-809836b2f615","timestamp":"2024-03-27T10:07:57.949Z"}
{"level":"info","message":{"http":{"method":"GET","url_base":"https://10.0.3.228:3000","url_path":"/api/user/getIntercomToken"},"type":"REQUEST_BEGIN"},"pid":59,"requestId":"f64b673a-6886-4735-a738-a60980b9f80f","timestamp":"2024-03-27T10:07:58.054Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"GET","request":{"time":0.004556843999773264},"status_code":200,"url_base":"https://10.0.3.228:3000","url_path":"/api/user/getIntercomToken"},"type":"REQUEST_FINISH"},"pid":59,"requestId":"f64b673a-6886-4735-a738-a60980b9f80f","timestamp":"2024-03-27T10:07:58.058Z"}
{"level":"info","message":{"http":{"method":"GET","url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_BEGIN"},"pid":90,"requestId":"aa6ee27c-8648-48ff-8305-e595fcd8eb7d","timestamp":"2024-03-27T10:07:58.594Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"GET","request":{"time":0.033613687999546525},"status_code":200,"url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_FINISH"},"pid":90,"requestId":"aa6ee27c-8648-48ff-8305-e595fcd8eb7d","timestamp":"2024-03-27T10:07:58.628Z"}
{"level":"info","message":{"http":{"method":"GET","url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_BEGIN"},"pid":59,"requestId":"82d30597-670b-455f-b30d-1d00b935e0ed","timestamp":"2024-03-27T10:07:59.340Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"GET","request":{"time":0.018716892000287772},"status_code":304,"url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_FINISH"},"pid":59,"requestId":"82d30597-670b-455f-b30d-1d00b935e0ed","timestamp":"2024-03-27T10:07:59.359Z"}
{"level":"info","message":{"http":{"method":"GET","url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_BEGIN"},"pid":90,"requestId":"af4fa52c-ba01-4edd-8f67-aaebad50f2dd","timestamp":"2024-03-27T10:07:59.854Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"GET","request":{"time":0.016311928000301124},"status_code":304,"url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_FINISH"},"pid":90,"requestId":"af4fa52c-ba01-4edd-8f67-aaebad50f2dd","timestamp":"2024-03-27T10:07:59.870Z"}
{"level":"info","message":{"cpuUsagePercentForProcess":"2.13","isRequestHandlerProcess":false,"memoryStatsForContainer":{"freeSystemMemoryMb":3613.683712,"percentageFreeMemory":44.12,"totalSystemMemoryMb":8191.053824},"memoryStatsForProcess":{"heapTotalMb":247.554048,"heapUsedMb":229.03828,"percentageHeapUsed":92.52,"rssMb":417.73056},"namespace":"memoryUsage","pid":28},"timestamp":"2024-03-27T10:08:02.564Z"}
{"level":"info","message":{"cpuUsagePercentForProcess":"14.19","isRequestHandlerProcess":true,"memoryStatsForContainer":{"freeSystemMemoryMb":3613.683712,"percentageFreeMemory":44.12,"totalSystemMemoryMb":8191.053824},"memoryStatsForProcess":{"heapTotalMb":452.313088,"heapUsedMb":397.448408,"percentageHeapUsed":87.87,"rssMb":637.673472},"namespace":"memoryUsage","pid":59},"timestamp":"2024-03-27T10:08:04.878Z"}
{"level":"info","message":{"cpuUsagePercentForProcess":"15.87","isRequestHandlerProcess":true,"memoryStatsForContainer":{"freeSystemMemoryMb":3613.687808,"percentageFreeMemory":44.12,"totalSystemMemoryMb":8191.053824},"memoryStatsForProcess":{"heapTotalMb":441.040896,"heapUsedMb":392.003344,"percentageHeapUsed":88.88,"rssMb":629.624832},"namespace":"memoryUsage","pid":90},"timestamp":"2024-03-27T10:08:08.456Z"}
{"level":"info","message":{"http":{"method":"POST","url_base":"https://10.0.3.228:3000","url_path":"/api/login"},"type":"REQUEST_BEGIN"},"pid":59,"requestId":"76919882-06f3-4fbf-a26c-b07a3fb08f6c","timestamp":"2024-03-27T10:08:12.605Z"}
{"level":"info","message":"HIBP compromised password found during login for user with email vivekanand@karboncard.com in org null with ID 1 and planID null ","pid":59,"requestId":"76919882-06f3-4fbf-a26c-b07a3fb08f6c","timestamp":"2024-03-27T10:08:13.297Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"POST","request":{"time":0.7154486309997737},"status_code":200,"url_base":"https://10.0.3.228:3000","url_path":"/api/login"},"type":"REQUEST_FINISH"},"pid":59,"requestId":"76919882-06f3-4fbf-a26c-b07a3fb08f6c","timestamp":"2024-03-27T10:08:13.321Z"}
{"level":"info","message":{"http":{"method":"POST","url_base":"https://10.0.3.228:3000","url_path":"/api/auth/saveAuth"},"type":"REQUEST_BEGIN"},"pid":90,"requestId":"e2552d81-a80b-42de-a881-db90d938a83f","timestamp":"2024-03-27T10:08:13.426Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"POST","request":{"time":0.03546418899856508},"status_code":200,"url_base":"https://10.0.3.228:3000","url_path":"/api/auth/saveAuth"},"type":"REQUEST_FINISH"},"pid":90,"requestId":"e2552d81-a80b-42de-a881-db90d938a83f","timestamp":"2024-03-27T10:08:13.461Z"}
{"level":"info","message":{"http":{"method":"GET","url_base":"https://10.0.3.228:3000","url_path":"/api/user/getIntercomToken"},"type":"REQUEST_BEGIN"},"pid":59,"requestId":"e030e0af-9393-4024-833c-9c13c2ab9b41","timestamp":"2024-03-27T10:08:13.575Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"GET","request":{"time":0.0037218709997832774},"status_code":200,"url_base":"https://10.0.3.228:3000","url_path":"/api/user/getIntercomToken"},"type":"REQUEST_FINISH"},"pid":59,"requestId":"e030e0af-9393-4024-833c-9c13c2ab9b41","timestamp":"2024-03-27T10:08:13.579Z"}
{"level":"info","message":{"http":{"method":"GET","url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_BEGIN"},"pid":90,"requestId":"7d19efe9-8bd0-45f8-9588-d730fc431620","timestamp":"2024-03-27T10:08:14.158Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"GET","request":{"time":0.010066894000396133},"status_code":304,"url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_FINISH"},"pid":90,"requestId":"7d19efe9-8bd0-45f8-9588-d730fc431620","timestamp":"2024-03-27T10:08:14.168Z"}
{"level":"info","message":{"http":{"method":"GET","url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_BEGIN"},"pid":59,"requestId":"7076f971-9977-4993-b760-48e5c890683d","timestamp":"2024-03-27T10:08:14.870Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"GET","request":{"time":0.009667045999318362},"status_code":304,"url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_FINISH"},"pid":59,"requestId":"7076f971-9977-4993-b760-48e5c890683d","timestamp":"2024-03-27T10:08:14.879Z"}
{"level":"info","message":{"http":{"method":"GET","url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_BEGIN"},"pid":90,"requestId":"48452c01-dac4-4c1f-ba9d-6a7e968bc59d","timestamp":"2024-03-27T10:08:15.353Z"}
{"endpoint":null,"level":"info","message":{"http":{"method":"GET","request":{"time":0.011026182001456619},"status_code":304,"url_base":"https://10.0.3.228:3000","url_path":"/api/organization/preAuthData"},"type":"REQUEST_FINISH"},"pid":90,"requestId":"48452c01-dac4-4c1f-ba9d-6a7e968bc59d","timestamp":"2024-03-27T10:08:15.364Z"}
Please find the logs and also the version is '3.33.15-stable' also tried with 16
Hello, I'm observing this same issue with version 3.30.13 and version 3.39.0-edge. This is a fresh local installation and I have set up a separate external Postgres database. When I navigate to 0.0.0.0/auth/signup, I enter my username and password, then am navigated briefly to a view that says "Please tell us about yourself" with a name input field, then the browser immediately navigates back to the 0.0.0.0/auth/login page before I can enter anything. I've tried deleting the organization and user records that are created, but the issue happens repeatedly.
Hey @jmikem - Can you try setting COOKIE_INSECURE=true in your deployment? That's required to log into a Retool instance over http. Else I think you can reference localhost instead of 0.0.0.0 as the host to get around that.
Hi @jmann, thank you! That did resolve it, I had overlooked that the line was commented out in the docker.env file. Much appreciated!
1 Like