That’s reassuring. I wouldn’t be concerned at all about security with them 
3 Likes
Hi Scott,
I have managed to get the project to the stage that I need the database schema to test locally. In the video there was no details for this. Can you share please?
On a side note the tail -r commands in your install.sh file was an unknown command on my windows machine using GIT BASH for windows. This was stripped out and the routes.json file seemed ok. I did see that there was the first route that was missing (written when before the tail -r command was stripped out) so I manually entered it and it seemed to create all the routes. Was hoping to setup to use an Sql-lite database for testing.
Cheers!
Steve
Hi Steve, you’re treading new ground here. I’ve not tested it on Windows or with a SQLite database.
How far through the installation process did you get? Once you’ve run the install script, added a database connection, set a STEWARD_PASSWORD and then gone to the userauth/login page, it should prompt you with a Database Reset screen. If you perform this reset action then the necessary database tables are created for you. After that, if you refresh the database schema in Wappler, it should pick up the schema for the new tables.
Thanks for the info on the tail -r command in GIT BASH for Windows. At some point it would be good to get the install script working seamlessly across all environments.
I think there may be route issues still which would make sense given the tail -r command not running.
I have managed to get it to create the database tables so we are getting there. I think I just need to persist with the database as it seems to be partly working - it added the username and password from the reset - note I had to manually load the page as I was just getting an error on the login page. I was looking through the different API code to build the database when I found it had already been built so I think it is just fine tuning now. Very late in Australia so will pick it up tomorrow. Cheers and thanks for the quick reply!
When you check your routes.json file it needs to contain the following items (as well as items for your own app’s pages):
{
“routes”: [
{
“path”: “/userauth/login”,
“page”: “userauth/login”,
“layout”: “userauth/login”,
“exec”: “/api/userauth/database/exists”
},
{
“path”: “/userauth/manage”,
“page”: “userauth/manage”,
“layout”: “userauth/manage”,
“exec”: “/api/userauth/admin/authorize”
},
{
“path”: “/userauth/info”,
“page”: “userauth/info”,
“layout”: “userauth/info”
},
{
“path”: “/userauth/forbidden”,
“page”: “userauth/forbidden”,
“layout”: “userauth/forbidden”
},
{
“path”: “/userauth/register”,
“page”: “userauth/register”,
“layout”: “userauth/register”
},
{
“path”: “/userauth/register-success”,
“page”: “userauth/register-success”,
“layout”: “userauth/register-success”
},
{
“path”: “/userauth/password-reset-request”,
“page”: “userauth/password-reset-request”,
“layout”: “userauth/password-reset-request”
},
{
“path”: “/userauth/password-reset-request-success”,
“page”: “userauth/password-reset-request-success”,
“layout”: “userauth/password-reset-request-success”
},
{
“path”: “/userauth/password-reset”,
“page”: “userauth/password-reset”,
“layout”: “userauth/password-reset”
},
{
“path”: “/userauth/password-reset-success”,
“page”: “userauth/password-reset-success”,
“layout”: “userauth/password-reset-success”
},
{
“path”: “/userauth/password-change”,
“page”: “userauth/password-change”,
“layout”: “userauth/password-change”,
“exec”: “/api/userauth/account/authorize”
},
{
“path”: “/userauth/password-change-success”,
“page”: “userauth/password-change-success”,
“layout”: “userauth/password-change-success”
},
{
“path”: “/userauth/database-reset”,
“page”: “userauth/database-reset”,
“layout”: “userauth/database-reset”
},
{
“path”: “/userauth/database-reset-success”,
“page”: “userauth/database-reset-success”,
“layout”: “userauth/database-reset-success”
},
Note: the above is truncated as I only copied/pasted the userauth items
Thanks Scott, very helpful!
1 Like
Thanks Scott, I think you make a fantastic contribution to Wappler in this way. Keep up the good work