Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

howto terminate user connection mysql-nubuilder

Locked
johan
Posts: 399
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times

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: 2797
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 21 times

Re: howto terminate user connection mysql-nubuilder

Unread post by admin »

Johan,

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

Steven
You do not have the required permissions to view the files attached to this post.
johan
Posts: 399
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times

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: 2797
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 21 times

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: 399
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times

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: 2797
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 21 times

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: 399
Joined: Sun Feb 27, 2011 11:16 am
Location: Belgium
Been thanked: 3 times

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: 2797
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 21 times

Re: howto terminate user connection mysql-nubuilder

Unread post by admin »

.
Locked