Hi,
we are seeing this problem with terminating connections:
when a user leaves his desk, his connection with nuBuilder gets terminated after one hour. (set in Timout)
However, the connection that exists between mysql and nuBuilder stays active.
So when a user saves an edit form, that's still open on his desktop, after one hour, this will be saved in mysql without his user id. (saved in sys_user_id).
We could leave nuBuilder active longer, but for security reasons we don't want to do this.
How can we prevent that users, who are logged out of nubuilder, still can save the edit form in mysql?
Johan
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
howto terminate user connection mysql-nubuilder
-
- Posts: 392
- Joined: Sun Feb 27, 2011 11:16 am
- Location: Belgium
-
- Site Admin
- Posts: 2782
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 2 times
Re: howto terminate user connection mysql-nubuilder
Johan,
Replace this file (formupdate.php) with the attached file.
This will stop Records being updated if Users have timed out.
Steven
Replace this file (formupdate.php) with the attached file.
This will stop Records being updated if Users have timed out.
Steven
-
- Posts: 392
- Joined: Sun Feb 27, 2011 11:16 am
- Location: Belgium
Re: howto terminate user connection mysql-nubuilder
Steven,
I will replace formupdate.
Thanks a lot for your help.
Johan
I will replace formupdate.
Thanks a lot for your help.
Johan
-
- Site Admin
- Posts: 2782
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 2 times
Re: howto terminate user connection mysql-nubuilder
My pleasure, sorry it took so long I am working on nuBuilder version 3.
-
- Posts: 392
- Joined: Sun Feb 27, 2011 11:16 am
- Location: Belgium
Re: howto terminate user connection mysql-nubuilder
Steven,
What is long? If everyone would react so fast, live would be easier.
You make me verry curious about Nubuilder3. When will it be released?
Succes
Johan
What is long? If everyone would react so fast, live would be easier.
You make me verry curious about Nubuilder3. When will it be released?
Succes
Johan
-
- Site Admin
- Posts: 2782
- Joined: Mon Jun 15, 2009 2:23 am
- nuBuilder Version: 4.5
- Been thanked: 2 times
Re: howto terminate user connection mysql-nubuilder
johan,
Here's some screen captures of nuBuilder 3 Screens..
http://forums.nubuilder.cloud/viewtopic.php?f=4&t=8259
Steven
Here's some screen captures of nuBuilder 3 Screens..
http://forums.nubuilder.cloud/viewtopic.php?f=4&t=8259
Steven
-
- Posts: 392
- Joined: Sun Feb 27, 2011 11:16 am
- Location: Belgium
Re: howto terminate user connection mysql-nubuilder
Steven,
Version 3 looks great. I look forward to the moment when I can download it.
Nice work.
Johan
Version 3 looks great. I look forward to the moment when I can download it.
Nice work.
Johan