Yah I'm seeing this issue in the response:
`{"cod...
# helpn
NicoNico
07/31/2021, 5:14 PMYah I'm seeing this issue in the response:
{"code":500,"msg":"Database error finding user","error_id":"945062e2-66c1-4e1b-8dfb-fe06e26efb19"}s
silentworks
07/31/2021, 5:36 PMYah I'm seeing this issue in the response:
{"code":500,"msg":"Database error finding user","error_id":"945062e2-66c1-4e1b-8dfb-fe06e26efb19"}b
burggraf
07/31/2021, 5:36 PMLooking at the posted issue now...
s
silentworks
07/31/2021, 5:37 PM@User I was getting this same error earlier, now I'm getting the following
Copy code
{
"message": "An invalid response was received from the upstream server"
}b
burggraf
07/31/2021, 5:39 PMWhat is the environment here?
n
NicoNico
07/31/2021, 5:39 PMI'm not sure if it's helpful, but this is an older project I'm working on (I started in Dec.) and it was also paused (I had to restore it which took some time)
b
burggraf
07/31/2021, 5:39 PMJavascript client, but is it React.js, or Angular, or what?
n
NicoNico
07/31/2021, 5:39 PMReact
s
silentworks
07/31/2021, 5:39 PMSvelte for me
b
burggraf
07/31/2021, 5:39 PMI'm guessing it has to do with older projects
s
silentworks
07/31/2021, 5:39 PMMy project is more recent btw
n
NicoNico
07/31/2021, 5:39 PMyah, I'm guessing it is an older project thing too
s
silentworks
07/31/2021, 5:39 PMAs in my project was created around 4 months ago
n
NicoNico
07/31/2021, 5:40 PMmine was Dec. 2020 I believe
b
burggraf
07/31/2021, 5:40 PMI just create a new project and I'm having no problems with auth, I just tested email login, magic link, and 9 OAuth providers 🙂
s
silentworks
07/31/2021, 5:40 PMI can test in a bit on a project I just created today
silentworks
07/31/2021, 5:40 PMhmm
b
burggraf
07/31/2021, 5:40 PMyeah if you could do a single test on a newer project that would narrow it down
s
silentworks
07/31/2021, 5:40 PMMine is still a demo project, so I can delete it and create it again
n
NicoNico
07/31/2021, 5:40 PMI'm waiting for another project I had to delete it, build a new one, and then try it out
NicoNico
07/31/2021, 5:41 PM(it's still limited to 2 projects / person even if paying right?)
b
burggraf
07/31/2021, 5:41 PMyes, I think it's 2 projects per account on the free tier
n
NicoNico
07/31/2021, 5:42 PMah the UI was confusing to me, I see what's going on now
b
burggraf
07/31/2021, 5:42 PMwait no, it's 3 or 4.
n
NicoNico
07/31/2021, 5:42 PMtrying a new project, will report back
NicoNico
07/31/2021, 5:42 PM(I was trying to make a new org, not a project)
b
burggraf
07/31/2021, 5:42 PMI just created a 3rd project no problem
s
silentworks
07/31/2021, 5:42 PMYeah I think the limit has upped
silentworks
07/31/2021, 5:43 PMIt used to be just 2 projects
b
burggraf
07/31/2021, 5:43 PMSo, anyway... I created a new project and moved my auth over to the new project (so I can get all that groovy PostgreSQL 13.3 goodness...)
burggraf
07/31/2021, 5:44 PMAnd it was fine, but kind of a pain because I had to manually copy over all my OAuth keys and secrets. Then I thought "hey I'm done!" but realized....
n
NicoNico
07/31/2021, 5:44 PMone nice feature would be being able to say, create me a database with the same schema as the other one
b
burggraf
07/31/2021, 5:44 PMnow I have to go into each Auth Provider's web site and change my callback URL.
s
silentworks
07/31/2021, 5:44 PMI think @User will get around to testing a new project before me, I need to go to the barber shortly
b
burggraf
07/31/2021, 5:44 PMTook another hour or so, but all is good!
burggraf
07/31/2021, 5:45 PMCopying schemas to a new project is pretty easy
n
NicoNico
07/31/2021, 5:45 PMnew project is provisioning
b
burggraf
07/31/2021, 5:45 PMBut at the moment, there are permissions issues with the database user, so
pg_dumps
silentworks
07/31/2021, 5:45 PM@User use a migration tool or a tool like https://www.npmjs.com/package/@sdelements/flan
s
Scott P
07/31/2021, 5:45 PMFor older projects, the postgres user is a super-admin, which makes it easy to export. For newer projects, that user isn't super-admin, so you might have some migration issues if you're doing direct export--> import
b
burggraf
07/31/2021, 5:46 PMBut very soon that'll be fixed and you just use pg_dump then psql and you're done, real easy
s
silentworks
07/31/2021, 5:46 PMI keep all my schemas in migration files
b
burggraf
07/31/2021, 5:46 PM@User exactly. The short-term workaround was just to make the postgres user a super-admin, do the dump and restore, then turn off super-admin
burggraf
07/31/2021, 5:47 PMOnce permissions are ironed out for new projects, I'll document this and create a super simple utility for migrating schemas and/or data.
s
Scott P
07/31/2021, 5:47 PMI wonder if a toggle for setting postgres as superadmin in the dashboard would be a good idea - perhaps enable it for a time period, and then automatically disable super-admin on the postgres user when that time expires
b
burggraf
07/31/2021, 5:47 PMIt's on my back burner list of things to do
burggraf
07/31/2021, 5:48 PMI don't think they want you using super-admin for the postgres user for security reasons
s
silentworks
07/31/2021, 5:48 PMI think for now, documenting it as a workaround is probably easier until the fix happens
b
burggraf
07/31/2021, 5:49 PMhoping the fix happens in a couple days
n
NicoNico
07/31/2021, 5:51 PM@User @User auth worked on the new project
b
burggraf
07/31/2021, 5:52 PMOk, so is auth broken on older projects? Is there already a bug report for this?
burggraf
07/31/2021, 5:53 PM@User is the guy who needs to know about it, once you have a report for him.
burggraf
07/31/2021, 5:57 PMI have a project from late May I think, and it's authenticating just fine
n
NicoNico
07/31/2021, 6:11 PMI don't know that there's a bug report, but I'm happy to help file one
b
burggraf
07/31/2021, 6:16 PMIf you can narrow it down, that'd be very helpful. Thanks, @User .