Disconnect users from database - Forum - OpenEdge RDBMS - Progress Community

Disconnect users from database

 Forum

Disconnect users from database

  • Our ERP database Openedge 10.2b is running under Linux Redhat 6.0 . We have openedge RDBMS enterprise license . In this platform  is it possible to disconnect users from database who make no transaction in last 10 minutes or idle users ?

     I want to that, automatically when there is a user unconnected to the system, time-out is 10 minutes. How can I do ? Have you got any parameters for this ? I used -PendConnTime 900 parameter but İt doesn’t.

  • Why would you want to do this? In my very humble opinion this is a very bad idea.

  • That's your opinion , but in our ERP system ,idle users sometimes can cause craches with eachother. Additionally , I want to automatically disconnect users from database  who  do not any transaction. (Time - out ).If you do not have relevant information,Please do not respond.

  • I'm only trying to get to the bottom of your request, as I feel it is ill-advised. It may be a sign that other things are not working correctly.

    For example, I don't understand how idle users who aren't performing transactions, can cause crashes with each other.

  • it is only one simple . For example an user enter ERP system . Generally users don't log off  from ERP.  Then they come to work after one day , They try to log in ERP ve sometimes they crashes themselves in database . So I want to automatically disconnect users from database  who  do not any transaction after 10 minutes. Ok ? Do you have any idea ?

  • I can see that this is an issue. Are you able to modify the source of your ERP system? It would be better for the system to log users out when they are done rather than having a script to kill users. If you can't modify source, then maybe your vendor can advise a method that is safer than a script.

  • If it is a ChUI app you can check the UNIX idle time for inactivity then the _Trans table.

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://dbappraise.com/protop.html
  • What is ChUI app ? Can you explain in detail ?

  • "They try to log in ERP ve sometimes they crashes themselves in database"

    If they don't logoff then can't do a log in?!

    I don't think that users like to be throwed out after 10 minutes inactivity.

    You should solve the main problem because idle users shouldn't create any problems in any application.

    Perhaps it would help to describe "crashes themselves " more precise?

    Recognition of "idle" is not possible in a distributed app - only in CHaracterUserInterface where a process/terminal session can be watched.

  • Stefan answered : Character user interface.

    Paul Koufalis
    White Star Software

    pk@wss.com
    @oeDBA (https://twitter.com/oeDBA)

    ProTop: The #1 Free OpenEdge DB Monitoring Tool
    http://dbappraise.com/protop.html
  • Summurize , Is there any parameter or code to disconnect from database  for users who have any transaction or operation for unix ?

    Progress has a parameter for this issue but ClientTimeOut Startup Parameter is running only windows server .

    I need a paramter for unix server.

    knowledgebase.progress.com/.../P15531

  • The simple answer is "no, there is no parameter that will do what you are asking".

    The longer answer is longer -- you could, in theory, write some scripts but as various people are trying to point out, there are many things to take into consideration if want those scripts to work well.

    This is something that, superficially, seems simple and easy but, in reality it is much more complex than generally imagined.

    The first problem is to define what you mean by "idle".  You say "no transactions for 10 minutes".  So you'd be happy to zap a user who has been doing inquires for 11 minutes?



    On 8/27/14, 7:51 AM, ozgunkus wrote:
    Reply by ozgunkus

    Summurize , Is there any parameter or code to disconnect from database  for users who have any transaction or operation for unix ?

    Progress has a parameter for this issue but ClientTimeOut Startup Parameter is running only windows server .

    I need a paramter for unix server.

    knowledgebase.progress.com/.../P15531

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.



    -- 
    Tom Bascom
    603 396 4886
    tom@greenfieldtech.com

    --
    Tom Bascom
    tom@wss.com

  • Thank you for your reply  

    Do you have available script about this issue ?

    Thank you

  • No, I do not have scripts for this -- my advice to clients is that they not pursue these sorts of things.  IMHO idle users are not a problem -- if they aren't truly doing anything they aren't causing any issues.  Almost every time that I have run into one of these "idle user killer" scripts it has been because it was killing users that it should not kill or it was killing them in an unsafe manner that was causing much, much bigger issues in the application.  It is a case of the "cure" being worse than the disease.

    Also, many times the real impetus for these scripts is not any actual problem -- it is someone completely misunderstanding licensing.

    I prefer to focus my efforts on actual problems that really need to be solved.


    On 8/27/14, 8:20 AM, ozgunkus wrote:
    Reply by ozgunkus

    Thank you for your reply  

    Do you have available script about this issue ?

    Thank you

    Stop receiving emails on this subject.

    Flag this post as spam/abuse.



    -- 
    Tom Bascom
    603 396 4886
    tom@greenfieldtech.com

    --
    Tom Bascom
    tom@wss.com

  • @ozgunkus: i am sorry but there are no configuration parameters or other features in OpenEdge to disconnect "idle" users. also, we do not know what "idle" means for you.

    you will have to make it part of your application and add code to perform the calculations required for your particular definition of "idle" to do it. you will find this to be quite difficult. alternatively, do as chuimonster has suggested and forget about it.