Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

howto terminate user connection mysql-nubuilder

Locked
johan
Posts: 392
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium

howto terminate user connection mysql-nubuilder

Unread post by johan »

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
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: howto terminate user connection mysql-nubuilder

Unread post by admin »

Johan,

Replace this file (formupdate.php) with the attached file.
formupdate.zip
(5.03 KiB) Downloaded 329 times
This will stop Records being updated if Users have timed out.

Steven
johan
Posts: 392
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium

Re: howto terminate user connection mysql-nubuilder

Unread post by johan »

Steven,

I will replace formupdate.

Thanks a lot for your help.

Johan
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: howto terminate user connection mysql-nubuilder

Unread post by admin »

My pleasure, sorry it took so long I am working on nuBuilder version 3.
johan
Posts: 392
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium

Re: howto terminate user connection mysql-nubuilder

Unread post by johan »

Steven,

What is long? If everyone would react so fast, live would be easier. :D
You make me verry curious about Nubuilder3. When will it be released?


Succes
Johan
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: howto terminate user connection mysql-nubuilder

Unread post by admin »

johan,

Here's some screen captures of nuBuilder 3 Screens..

http://forums.nubuilder.cloud/viewtopic.php?f=4&t=8259

Steven
johan
Posts: 392
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium

Re: howto terminate user connection mysql-nubuilder

Unread post by johan »

Steven,

Version 3 looks great. I look forward to the moment when I can download it.
Nice work.

Johan
admin
Site Admin
Posts: 2781
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5
Been thanked: 1 time

Re: howto terminate user connection mysql-nubuilder

Unread post by admin »

.
Locked