search

ApiLogicServer / ApiLogicServer-src

Create an executable project (API and Admin App) from a database or natural language prompt with 1 command, customize with declarative rules and Python in your IDE, containerize and deploy.
https://apilogicserver.github.io/Docs/
BSD 3-Clause "New" or "Revised" License
30 stars 5 forks source link

postgres authdb missing role, userrole rows #40

Closed valhuber closed 9 months ago

valhuber commented 9 months ago

As shown below, the authdb creation fails to create the sa role, and assigning it to user admin. You can fix this as shown below:

auth db initialization
valhuber commented 9 months ago

Fixed in 10.02.04

controlade commented 4 months ago

Hello. I am testing the APILogicServer in a prototype I am developing for my employer. So far everything went well, and I could prove ALS's value to the CEO.

Nevertheless, I have tried several times to add Security and create the Image, following this procedure: https://apilogicserver.github.io/Docs/DevOps-Containers-Deploy-Multi/#:~:text=customers%20returns%20data.-,II.%20Add%20Security,-Using%20the%20terminal

The authdb database was not created automatically when running ApiLogicServer add-auth, so I created it manually using the authdb_postgres.sql script. After running the authdb command again and restarting the server, the AdminUI goes directly to the list of tables instead of showing the login page.

Please guide me on what I could have done wrong, or if there is any output from the terminal/console that could help determine where the issue could be. Thanks,

valhuber commented 4 months ago

Hi!

Thanks for your interest! Sorry about the glitch…. We will look into it and get back to you

Are you able to share your project?

Thanks, Val

510-703-5909 valhuber on skype

On Sun, Jul 14, 2024 at 1:20 PM Alberto Delgado @.***> wrote:

Hello. I am testing the APILogicServer in a prototype I am developing for my employer. So far everything went well, and I could prove ALS's value to the CEO.

Nevertheless, I have tried several times to add Security and create the Image, following this procedure:

https://apilogicserver.github.io/Docs/DevOps-Containers-Deploy-Multi/#:~:text=customers%20returns%20data.-,II.%20Add%20Security,-Using%20the%20terminal

The authdb database was not created automatically when running ApiLogicServer add-auth, so I created it manually using the authdb_postgres.sql script. After running the authdb command again and restarting the server, the AdminUI goes directly to the list of tables instead of showing the login page.

Please guide me on what I could have done wrong, or if there is any output from the terminal/console that could help determine where the issue could be. Thanks,

— Reply to this email directly, view it on GitHub https://github.com/ApiLogicServer/ApiLogicServer-src/issues/40#issuecomment-2227472772, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABKSG36YQBQVQAKL42IQ3PTZMLMP3AVCNFSM6AAAAABDHSSIYKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEMRXGQ3TENZXGI . You are receiving this because you modified the open/close state.Message ID: @.***>

valhuber commented 4 months ago

Mr. Vasquez...

Hi, I am Val from the dev team.

You are right - the system does not create your authdb database, so it was correct to create it yourself.

To confirm, this is your project (not the sample project), right? If you can share it, that might be helpful.

In the next week or so, we are about the release v11 which support Keycloak as an identity manager, as an alternative to using a database. This supports single-signon, social login (GitHub, gmail etc)... but it is a complex environment. I am not super familiar with it, but other customers like it.

It's important I know what version you are using. If possible, can you upgrade to a dev release I can supply? It is near GA, and has passed all tests except for a few UI bugs in the Admin App.

Now, regarding your current issue. There are 2 Admin Apps you can run:

  1. Use http://localhost:5656/ to see your data
  2. Use http://localhost:5656/admin/authentication_admin/ to see the admin data

So, perhaps we were not clear about that... can you confirm what happens when you try both URLs?

Also, when you run the apps, click Configuration, and let us know what that says.

Finally, I would like to invite you to our slack channel. That is the easiest way to keep in touch, exchange messages, and screen share to diagnose issues.

Famous last works (;)), but I believe we should be able to resolve this.

controlade commented 4 months ago

Hello Mr. Huber,

Yes, it is not a sample project. I have shared the project and more information with you via e-mail. I am using version ALS v10.04.61

Thanks,