[Solved] Sign in loop to front end db
Posted: Wed Dec 18, 2019 1:22 pm
Hi,
Scenario, a time tracking db with the following options for rollout.
Dedicated old pc at office entrance - Base Front and HSQL Back in standalone mode on same machine, user fronts the login prompt, logs in, has a button to logoff which effectively would execute the sql shutdown command,.....
Or HSQL backend on a file server with db in server mode, user logs in from his workstation, clocks in and terminates the session.
Now the automacro in the splitdb template and or FreeHSQL does all the connection work in the background for standalone.
What I ideally would like to achieve using the first scenario is admin fires up the db in the morning with an empty login prompt, user logs in, does his stuff and once clicking the logout button his session from the backend is terminated and the frontend returns to the blank login screen waiting for the next user.
Is this at all doable ? , because if I rightclick in the db container and change the user name from the database option, base gets angry or better said the jar which can not be found, however if I save and exit and restart with the other user no problem.
Just wondering if its somehow possible to configure some setup to kick the user off and reload the db or form with prompting renewed for a login.
Sort of inclined to think it might be a driver related thing.
In the attachment is a mockup with three users SA no pw, gkick pw =winzi and mark pw=wilson- You may find that the password is not masked, not sure if this a bug with the driver?
It really would not be practical to having restart LO. Obviously the server side poses another issue with the server shutting down once the last connection terminates.
Of course it would also be fantastic if the user could be somehow prompted to set or change his own password like on a LAN/WAN ?
I also would like to take the opportunity to express my sincere gratitude to all of the tireless LO volunteers. You guys just rock !
Seasons Greetings from the other Down Under.
Link to mockup: https://www.dropbox.com/s/g4o03vmrjej3ng6/PLAY.rar?dl=0
Scenario, a time tracking db with the following options for rollout.
Dedicated old pc at office entrance - Base Front and HSQL Back in standalone mode on same machine, user fronts the login prompt, logs in, has a button to logoff which effectively would execute the sql shutdown command,.....
Or HSQL backend on a file server with db in server mode, user logs in from his workstation, clocks in and terminates the session.
Now the automacro in the splitdb template and or FreeHSQL does all the connection work in the background for standalone.
What I ideally would like to achieve using the first scenario is admin fires up the db in the morning with an empty login prompt, user logs in, does his stuff and once clicking the logout button his session from the backend is terminated and the frontend returns to the blank login screen waiting for the next user.
Is this at all doable ? , because if I rightclick in the db container and change the user name from the database option, base gets angry or better said the jar which can not be found, however if I save and exit and restart with the other user no problem.
Just wondering if its somehow possible to configure some setup to kick the user off and reload the db or form with prompting renewed for a login.
Sort of inclined to think it might be a driver related thing.
In the attachment is a mockup with three users SA no pw, gkick pw =winzi and mark pw=wilson- You may find that the password is not masked, not sure if this a bug with the driver?
It really would not be practical to having restart LO. Obviously the server side poses another issue with the server shutting down once the last connection terminates.
Of course it would also be fantastic if the user could be somehow prompted to set or change his own password like on a LAN/WAN ?
I also would like to take the opportunity to express my sincere gratitude to all of the tireless LO volunteers. You guys just rock !
Seasons Greetings from the other Down Under.
Link to mockup: https://www.dropbox.com/s/g4o03vmrjej3ng6/PLAY.rar?dl=0