Hot Topic (More than 10 Replies) New Server, New Troubles (Read 2216 times)
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
New Server, New Troubles
Aug 2nd, 2011 at 2:11pm
Print Post Print Post  
We are upgrading our Windows 2000 server to a 64-bit Windows 2008 server.  The new one has been configured so that there's a host, called JAMIARAHOST, within which is the virtual server, called DC01.  Connecting to these, and also within the same machine, is a virtual Windows 7 computer (all our workstations are being upgraded from XP to 7).

I'm using Remote Desktop to connect to the server and the virtual Win 7 machine.

A folder off of the DC01 C: drive has been created, called Data, which is where I've installed Sesame on DC01 (we're trying to keep C: out of the reach of users).  The program and data reside in a folder called Sesame, which has been mapped to drive G:

The program runs fine as a server.  Also on the desktop I've put a client shortcut, which connects to the server just fine with the following startup switch:

Code
Select All
C:\Sesame\Program\sesame.exe -Client DC01 -system_id "SCOTT" -ini_file G:\Sesame\Miara\1150-950-sesame.ini MIARA.db 



So that's all cool.  Server is running, and on the server I can fire up a Client.

Switching to the virtual Win 7 machine I encounter problems.  Sesame has been installed on its C: drive and runs, but I cannot connect to the server.  I've tried every variation of the startup switch I can think of, but I'm clearly missing something.  Any idea how I should proceed?  As usual, your help is immensely appreciated.



  

**
Captain Infinity
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: New Server, New Troubles
Reply #1 - Aug 2nd, 2011 at 3:14pm
Print Post Print Post  
Hello Scott,

First thing we are going to want to look at is if the virtual Windows 7 machine can see the virtual DC01 machine.

So on the virtual Windows 7 machine bring up a command prompt.
Type Ping DC01
Hit Enter

Does it ping DC01 successfully or does it fail?

-Ray
  

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


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: New Server, New Troubles
Reply #2 - Aug 2nd, 2011 at 3:49pm
Print Post Print Post  
Success.  Received - 4, Fail = 0, Average 3ms.
  

**
Captain Infinity
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: New Server, New Troubles
Reply #3 - Aug 2nd, 2011 at 4:44pm
Print Post Print Post  
Is there a firewall on the DC01 computer or the Windows 7 Computer?

Try turning them both off at this time and see if it will allow you to connect.

-Ray
  

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


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: New Server, New Troubles
Reply #4 - Aug 2nd, 2011 at 4:58pm
Print Post Print Post  
Thanks Ray.  I will run this by the tech's who are working with me on the new server and see what I can do.
  

**
Captain Infinity
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: New Server, New Troubles
Reply #5 - Aug 2nd, 2011 at 5:15pm
Print Post Print Post  
Ray, are there specific ports that Sesame accesses?
  

**
Captain Infinity
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: New Server, New Troubles
Reply #6 - Aug 2nd, 2011 at 6:17pm
Print Post Print Post  
TCP ports 20,000 and 20,001 on the Server. Client side will use 2 TCP ports that are going to be assigned to us at Runtime by the system.

-Ray
  

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


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: New Server, New Troubles
Reply #7 - Aug 30th, 2011 at 6:53pm
Print Post Print Post  
OK, I'm making progress on this.

I copied the entire Sesame folder and shortcuts from the old server to the new server, and mapped my drives.  Sesame Server runs fine on the new server, as does a client running on the server itself.  So yay, I know the programs work.

On the client side, I've tested two of the new workstations so far.  One refuses to connect to the server at all.  I think I need to tweak the shortcuts a bit, or it may be something to do with the IP Addresses.  The second one connects but I get a message that one of the files is "set to read-only" or something, and the database fails to open.  If I then navigate to the database on the server it opens fine, and Sesame Server shows a client connected.

The next problem is that if I start a client on the server, I get a "too many clients" message when trying to connect the workstation client.  Something to do with my license file?

Thank you for your help.
  

**
Captain Infinity
Back to top
IP Logged
 
Infinity
Senior Member
Members
*****
Offline


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: New Server, New Troubles
Reply #8 - Aug 30th, 2011 at 7:30pm
Print Post Print Post  
ENVIRONMENT VARIABLES!  I had totally forgotten environment variables.

OK, so now Sesame Server starts up.  I start Sesame Server with a batch file that runs Sunlock on all the databases before starting up.

Sesame client on the server starts up, and the server window shows 1 of 10, cool.

On the workstation I can connect to the server but immediately get the message "The application is locked and may currently be in use."  If I close the app on the server client, Sesame client on the workstation fires right up and opens the DB.

Puzzled.  I'm going to play with Sunlock, see what happens.
  

**
Captain Infinity
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: New Server, New Troubles
Reply #9 - Aug 30th, 2011 at 7:42pm
Print Post Print Post  
Hello Scott,

No need to play with Sunlock!

What path to the DB is the client on the workstation opening and what path to the DB is the client on the Server opening?

-Ray
  

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


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: New Server, New Troubles
Reply #10 - Aug 30th, 2011 at 8:09pm
Print Post Print Post  
Sunlocking each of my databases allowed the workstation client to open correctly.  YAY!

I'm not sure why the batch file failed to do so.
  

**
Captain Infinity
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: New Server, New Troubles
Reply #11 - Aug 31st, 2011 at 1:09pm
Print Post Print Post  
Hello Scott,

Can the Client on the Server load the files when a Client on a Workstation has them loaded as well? If not there is most likely a problem with the paths still.

-Ray
  

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


Diagonally parked in a
parallel dimension

Posts: 1290
Location: Massachusetts
Joined: May 27th, 2005
Re: New Server, New Troubles
Reply #12 - Sep 1st, 2011 at 10:33am
Print Post Print Post  
Yep, that was it.  Until I put C:\Sesame\Program in the server's Path environment variables, the license file was not being read.  So when I started up a client on the server, Sesame Server read 1 of 1, and then when I fired up a client on the workstation, of course the file was locked.  I'm carefully tweaking every path now and everything seems to be working fine.  Thanks for your help Ray.
  

**
Captain Infinity
Back to top
IP Logged