Hi there
I was using a database to store values for users logged in. The problem I found is that if the publication closed unexpectedly the database value would remain the same and the user could not log in again. This was not the only problem, the point of me using the login system was to protect records that were being modified.
I was going to make another system tray pub to possibly constantly monitor the first pub and change a registry entry created by the original publication,this could also run at startup in case of an unexpected shutdown, however this could equally fail.
Does anyone have have a possible workarkind for this?
Many thanks
Two questions regarding unexpected shutdown
Moderator: Neosoft Support
Re: Two questions regarding unexpected shutdown
We have faced a similar problem on our software BiblioControl (bibliocontrol.es).
To avoid that we have an "Unlock user" option on the admin panel that returns the "logged in" database registry to its original value for a given user.
To avoid that we have an "Unlock user" option on the admin panel that returns the "logged in" database registry to its original value for a given user.
Luis Hernández - SinLios Soluciones Digitales
http://sinlios.com
http://sinlios.com
Re: Two questions regarding unexpected shutdown
bypass666:
You could even clear this recorded timestamp value when the application is shut down (or user logs out) properly.
BTW, what causes the unexpected shut down ? ... something in the pub ? ... or hardware/software ? ... is it just the pub or do all running programs shut down ?
Or, you could use the Timer object to write a timestamp to the user's record (say every 2 to 5 seconds) ... and when user attempts to log in (after a scheduled or unexpected shutdown), check this value ... if older than 2 to 5 seconds, do what is necessary to allow him/her to login again.I was going to make another system tray pub to possibly constantly monitor the first pub and change a registry entry created by the original publication,this could also run at startup in case of an unexpected shutdown, however this could equally fail.
You could even clear this recorded timestamp value when the application is shut down (or user logs out) properly.
BTW, what causes the unexpected shut down ? ... something in the pub ? ... or hardware/software ? ... is it just the pub or do all running programs shut down ?
Can you elaborate ? ... is there a field in the record(s) that stores id of user ? ... if so, the afore mentioned check of timestamp can also clear this value in the record(s).This was not the only problem, the point of me using the login system was to protect records that were being modified.