Hot Topic (More than 10 Replies) Disconnecting Phantom Users & Local Socket Problem (Read 2193 times)
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Disconnecting Phantom Users & Local Socket Problem
Jul 25th, 2005 at 10:37pm
Print Post Print Post  
I just had a situation where a user disconnected to the server inappropriately.  It appears they removed their laptop off their docking station while Sesame was running.

In the server administration, I tried disconnecting them to no avail. 

Eventually I had to shut the server down but it created the "Unable to create a local socket".  I can only get it to open if I change the properties to a different port #.

I have only one server running currently with no port numbers assigned in the icon properties (thereby defaulting to 20000:20001).

I know visually that no other Sesame server is running, but if it is how do I determine that in order to fix the above local socket problem ?

Also, should I have not been able to disconnect any user through the server admin interface ?

Thanks,

Louis

  

Louis Galvao
Back to top
 
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #1 - Jul 26th, 2005 at 1:11pm
Print Post Print Post  
P.S. With advice from Erika, Sesame was still running as a process.  She indicated to hit ALT-CTRL-DEL on the server and check Processes under the Task Manager.

Sure enough Sesame was running many times and by hghlighting sesame.exe and clicking on END PROCESS, it cleared the ports.

Databases had to also be unlocked as well.

QUESTION STILL:  Why was I not able to disconnect a user (phantom) through the server administration window ?

Thanks,

Louis
  

Louis Galvao
Back to top
 
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #2 - Jul 26th, 2005 at 2:28pm
Print Post Print Post  
Also, what kind of damage does this do to the Database, if any?

Steve
  
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #3 - Jul 26th, 2005 at 3:27pm
Print Post Print Post  
The only way we have seen to cause a phantom client is to cause the network connection to be suddenly disconnected. Killing the client process, or even rebooting the client computer will not do it. From the look of things, Louis' client suddenly disconnected from the network by removing the laptop from its cradle.

The reason you connect force a disconnect from a phantom client is because a disconnect requires a connect. By suddenly disconnecting, the operating system (any MS) will takeover that connection and begin a timeout sequence. Sesame cannot get the server end of the connection to pay attention until MS gives it up. We're working on it to find if there is a way to get around Mickey.

It is very unlikely that a sudden disconnect would damage the app files.
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #4 - Jul 26th, 2005 at 3:57pm
Print Post Print Post  
Mark:

Thanks for the reply.  I haven't noticed any problems with my data.

Thanks,

Louis
  

Louis Galvao
Back to top
 
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #5 - Aug 8th, 2005 at 1:01pm
Print Post Print Post  
Further to the "Phantom User" issue, it turns out that it was not a laptop.  I have had two cases now where they were desktop users.

I am not sure what the circumstances were, but at this point, nothing out of the ordinary happened to these users.

If I find something, I will post.

Thanks,

Louis
  

Louis Galvao
Back to top
 
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #6 - Aug 30th, 2005 at 4:52pm
Print Post Print Post  
As a continuation of this problem, I have the same 3 desktop users who close the program properly but remain connected to the databases as viewed thru Server Admin.

The funny part (coincident ?) is that these three users' offices are all beside each other and they are the closest to the server.  I doubt this makes a difference but I thought I would share this.

Could there be a setup issue on these computers that would cause this ?

Any suggestions would be welcome as it happens everyday they go in to Sesame.

The only way to disconnect them is to shut down Sesame server, especially if I am trying to reconcile changes.

Thanks,

Louis
  

Louis Galvao
Back to top
 
IP Logged
 
Steve_in_Texas
Senior Member
*****
Offline


No personal text

Posts: 893
Location: San Antonio
Joined: Feb 21st, 2004
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #7 - Jan 12th, 2006 at 11:36pm
Print Post Print Post  
We're seeing a similar issue:

a users connection is dropped unexpectedly, and sesame server still shows them as logged in.

I am only seeing this with 2 users, 1 works remotely, via broadband and the other is on our local wired lan. However, both usernames show up as ip address in admin panel...not as their user (machine?) names. All users who show up as their user names in the admin panel can disconnect gracefully.

Are there any workarounds for this?

Unfortunately, I've had to ask both users to not log into sesame until we get this fixed.

Steve
  
Back to top
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #8 - Jan 12th, 2006 at 11:56pm
Print Post Print Post  
Typically, I can actually see the users computer names in lieu of the IP address. 

I am still having this issue with the same 3 desktop users who sit side by side.  It hasn't happened as much recently to one of them since we took off their hybernation settings.

Hopefully we can get down to the bottom of this one.

Louis
  

Louis Galvao
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #9 - Jan 13th, 2006 at 4:24pm
Print Post Print Post  
Hello Steve,

Quote:
I am only seeing this with 2 users, 1 works remotely, via broadband and the other is on our local wired lan. However, both usernames show up as ip address in admin panel...not as their user (machine?) names. All users who show up as their user names in the admin panel can disconnect gracefully.


The Computer name means nothing to Sesame. We operate on the IP address. We display the computer name for your convenience as you may not know who '192.168.0.35' is but you know who 'Marys_Computer' is.

Here are the known ways to create a ghost client
1. Unplug Clients Network Cable
2. Disable Clients Network Connection in Control Panel
3. Change the Client's IP address
4. Bring up a Firewall on the client that does not let Sesame through.
5. Bring up a Firewall on the server that does not let Sesame through.
6. Server goes into Standby mode.

Is this all of them? Probably not, but this should give you a general idea of what to look for. Check for a Static IP address on the client on the LAN.

You can set up Ping so that it pings a computer until you tell it to stop. Ping your One client that drops from the Server. When it drops, and leaves a ghost client, look at the Ping output and see what it says. Note: This will slow down your network so do it during a slow part of the day or at night.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #10 - Jan 13th, 2006 at 4:27pm
Print Post Print Post  
Hello Louis,

Do the clients have static IP addresses or are they assigned by DHCP?
If by DHCP what is the Client Lease time set to?
Do you see any patterns in the behavoir? Example always in the afternoon, only after sitting for more than 30 minutes, etc. etc.
Do those three computers drop at the same time or at different times?

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #11 - Jan 13th, 2006 at 6:25pm
Print Post Print Post  
Ray:

We do use DHCP.  How do I find the setting that indicates the client lease time ?  Are we talking on the server or the client ?

Also, pattern seems to be client has application open without use for an extended time.

Our server does not go on standby automatically, but maybe it has in the past without anyone noticing it ?

Thanks,

Louis
  

Louis Galvao
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #12 - Jan 13th, 2006 at 6:38pm
Print Post Print Post  
Hello Louis,

DHCP lease time is set on the DHCP server. As for where to find it that depends on what the DHCP server is. For the training center the DHCP was assigned by the wireless router. In this case the DHCP Lease time was on the setup page for the router.

If the Server went into standby all clients would be disconnected and become phantoms.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #13 - Jan 19th, 2006 at 4:06pm
Print Post Print Post  
Ray:

We found out that the DHCP client lease time on the firewall has been set to the default of 10 hours (maximum is 12 hours).

On one of the units, we have a network card issue and have replaced it.  Hopefully this was the problem.

Thanks,

Louis
  

Louis Galvao
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Disconnecting Phantom Users & Local Socket Pro
Reply #14 - Jan 19th, 2006 at 4:32pm
Print Post Print Post  
Quote:
Ray:

We found out that the DHCP client lease time on the firewall has been set to the default of 10 hours (maximum is 12 hours).

Louis


The machines attached to the DHCP server should attempt to renew their leases at %50 of the lease time, and thereby retain a single IP address longer than 10 hours. I say "should" - do you have any reason to believe that they are not?
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged