Login not work

[ggmac23]

I install the demo everything work fine, but when i try to login from the explorer it response with this error:

To Reproduce Steps to reproduce the behavior:

1. Go to http://[::1]:3000/explorer/#/LoginController/LoginController.login
2. POST /auth/login
3. Send : { "client_id": "webapp", "client_secret": "saqw21!@", "username": "super_admin", "password": "test123!@#" }
4. See error: { "error": { "statusCode": 401, "name": "UnauthorizedError", "message": { "name": "error", "length": 119, "severity": "ERROR", "code": "42P01", "position": "194", "file": "parse_relation.c", "line": "1173", "routine": "parserOpenTable" } } }

Can you help me?

[fgvicente]

Hi. could you solve it I have the same problem

[samarpanB]

It seems to be error with migration scripts. Let me check that. Give me some time. Meanwhile, can you please confirm if you have run the migration scripts alright?

[fgvicente]

Thanks @samarpanB ... the migrate had run badly

[samarpan-b]

This should have been fixed with latest updates. Closing it hence.

[personwholearn]

I have the same issue right now with the last update! , please help me the error { "error": { "statusCode": 401, "name": "UnauthorizedError", "message": { "name": "error", "length": 185, "severity": "ERROR", "code": "42P01", "position": "194", "file": "d:\pginstaller_12.auto\postgres.windows-x64\src\backend\parser\parse_relation.c", "line": "1173", "routine": "parserOpenTable" } } }

[samarpanB]

Can you please check if you have run all the migration scripts?

[personwholearn]

@samarpanB thanks for your response :) yes i checked many times in DB, i followed your steps and , ( i clone your project -> npm i -> change .env -> db-migrate up -> npm start ) and i go to "login/auth" and enter { "client_id": "webapp", "client_secret": "saqw21!@", "username": "super_admin", "password": "test123!@#" }

but the error still

"error": { "statusCode": 401, "name": "UnauthorizedError", "message": { "name": "error", "length": 185, "severity": "ERROR", "code": "42P01", "position": "194", "file": "d:\pginstaller_12.auto\postgres.windows-x64\src\backend\parser\parse_relation.c", "line": "1173", "routine": "parserOpenTable" } } }

[personwholearn]

i also changes postgresdb 12 to 10 , i also update the project whether "lb4 rest-crud"or npm update ,i made many db-migrate up and db-migrate down but still in the same issue , i used windows 10 ,npm -v is 6.14.6 ,node -v is v12.18.0 please help me😭😭😭🤯🤯

[personwholearn]

can anyone help me ?

[samarpan-b]

Can you share your .env ? Hide the DB host and password from there.

[personwholearn]

we solved in the ticket of https://github.com/sourcefuse/loopback4-starter/issues/54