Setting up for a Network |
Top Previous Next |
Setting up Campground Master for networking is very simple, as long as your network meets the requirements. Network setup parameters and options can be found in the menu: Maintenance / Network Functions / Network Setup.
EXTREMELY IMPORTANT!
DO NOT "SHARE" THE DATABASE FILE BETWEEN MULTIPLE INSTANCES OF THE SOFTWARE.
THIS WILL RESULT IN A CORRUPTED DATABASE!
Campground Master uses TCP/IP communications to synchronize all data between computers in real time, rather than sharing the database file itself.
Because most computer administrators expect networking to be accomplished through a shared database file, it may take some effort to get past this assumption. Do not attempt to network multiple computers by loading the database through a mapped or shared drive, or in any way open or save the database through file sharing on the network. Please read through this entire networking section before attempting to set up networking for Campground Master. It's a very simple process, but must be done correctly.
Every computer running Campground Master must have its own copy of the database, on its own hard drive or other non-shared location. Never under any circumstances open a database file from more than one instance of Campground Master at the same time. If you're not sure how this will work, please read the section How Networking Works.
Here's a typical local network setup with the master and one laptop connected directly to a router and one laptop through WiFi (it doesn't matter to the setup whether it's wired or WiFi):
Quick Version of Network Setup (see below for more detailed steps)
These are useful for troubleshooting if it stops connecting, or when replacing or adding another computer.
This assumes that Campground Master is already set up (installed, database open, etc.) on the Master workstation (server).
1. Install the Campground Master software on each additional computer (workstation), and copy the database to each one.
Note: The computers do NOT all have to be running the same version of Windows. It makes no difference to the Campground Master networking.
2. On the Master workstation ("server"), go to Maintenance / Network Functions and select Show IP address for this workstation. Make a note of this number. (In the above diagram, it would have been 192.168.1.6)
Important: You do NOT need to use this "Show IP" function on any computer besides the master! All too often, people use this function on the client computers and worry that it shows a different number. Of course it does! It is normal, and in fact required, that each computer have a different IP address (just like your house has a different address than the one next door, so the mail goes to the right house), so don't use this function on the client computers and worry about them being different. That's normal! The ONLY function you should be using in the client computers is Network Setup, as explained in step 4.
3. On the Master workstation, go to Maintenance / Network Functions / Network Setup and note This workstation's ID (usually 0 for new installations) and the TCP/IP port number (usually 6010).
4. On each of the other workstations, go to Maintenance / Network Functions / Network Setup and change the Network Settings accordingly: The workstation ID should be different for each one (1, 2, 3, etc.), the Master IP address should be the address of the Master computer from step 2, and the Master's ID and port number should be as noted in step 3. Once you click OK (assuming changes were made), it should attempt connection.
Note: If you're attempting connection through the internet (not on the same local network as the master), see Networking through the Internet.
Quick Troubleshooting Tips:
Any of these 4 error messages are usually pretty self-explanatory and only require minor changes to fix, since they indicate that it is getting a response from the master but something else is wrong:
Mis-matched software version -- means you need to install the same version on each computer.
Mis-matched database name -- means you need to use File / Rename Database on either computer so the database names match.
Date format mis-match -- means the Region settings in Windows for the location / date format on the computers don't match (e.g. US vs Canada).
Incorrect network password -- means the passwords don't match under Network Setup, so enter new ones.
However, if you get a connection error message like "Verify that the IP and port settings are correct", that means it can't get a response from the master. Of course the Master computer should be on and Campground Master should be running on it, so that's the first thing to check. You can use the Ping command from Network Setup (under Maintenance / Network Functions) to make sure the master's IP address is reachable from the other computer.
-- Assuming a local connection, not through the internet:
If a Ping is successful, it just means that a computer is at that IP address -- it doesn't mean that it's the right computer, and it doesn't mean that there isn't a firewall that might Campground Master. Double-check the IP address (of the Master computer, not the client!) using the steps above. If that all looks correct, a firewall is probably blocking Campground Master on either computer. If you're not familiar with firewalls and the Firewall Configuration information in this documentation doesn't help, you'll need to contact a professional.
If a Ping fails, then you may have the wrong Master's IP address entered, or some other hardware or Windows issue exists with the network. If the settings are correct, it may be time to get a networking expert involved.
-- If connecting through the internet (the computers aren't on the same local network):
This is more complicated, since the Master's IP address is just the Internet connection IP, not the Master computer itself. (If you have the Master's IP address setting starting with 192 or 169, that's definitely wrong.) The Ping would only indicate that the modem or router is reachable, not the Master computer, and Ping may show failure even if the setting is correct. First make sure you've reviewed the Networking through the Internet information, to make sure you're using the correct IP address and have Port Forwarding set up. If you've gotten this far and either don't understand what we're talking about or it still doesn't work, it may be time to get a networking expert involved.
More Detailed Setup Information:
Networking Requirements:
•Every workstation or terminal must have its own place to save the database (e.g. its own hard drive) -- do not share the database file with other terminals.
•TCP/IP network -- the workstations must be connected via TCP/IP (which can also be through the Internet). We recommend using a switch (or router), rather than a hub, since a hub results in more load on the computers. Some installations have reported communications problems when using a simple hub.
•Winsock 2 -- the system must support Winsock 2, which has been part of Windows since Windows 98. If you are running Windows 95, you may need to install Winsock 2 in order for the program to run (you will get an error message when starting the program if Winsock 2 is not installed). This can be downloaded from the following Microsoft web site: http://www.microsoft.com/windows95/downloads/contents/wuadmintools/s_wunetworkingtools/w95sockets2/default.asp
•A known IP address for the master workstation -- The master workstation must have a known IP address that can be accessed by the other workstations, so setting a static IP address is best. See the section following this one for more details. If you will be using the internet, you should also get a static IP address from your Internet provider (to avoid setup changes every time you connect).
•An unblocked port -- you can use any TCP/IP port number you wish, just make sure it's not blocked by any security software or routers in the system. We recommend a port in the 6000 to 12000 range, to minimize the potential conflicts with other software.
Master (Server) workstation:
You don't need a separate computer for a server. Any of the workstations can be used as the "master" workstation. This workstation will automatically operate as the Server for the Campground Master network, and all other workstations will operate as Clients. (Internally, they actually run different code depending on whether they are a server or a client.)
Since the master workstation will not have to request locks from other workstations and will operate "offline" automatically if the other workstations are disconnected, you may want the most-used workstation to be the master. It should also be the fastest computer, since it has to do more work (routing all of the changes from each workstation to all other workstations).
Alternatively, you may decide that the master should be a "protected" computer separate from the reservation center, since it's the most important computer to keep running and should have the most reliable network connection. The decision will depend on your environment and whether speed is an issue. Since the master designation can be changed any time through the settings, you can always change it later.
Except for a few maintenance functions that can only be done on the master workstation, all workstations have equal abilities. Only the master workstation can perform the New database function and edit Field Definitions. Also, while any workstation can edit Raw Data Tables and Pick Lists, these should be done on the master workstation whenever possible due to the number of records that need to be locked.
Setting up on a "Server" computer:
Because certain functions must be done at the "master" workstation (network master), and because Campground Master must be running as an application on the master workstation, we don't recommend using a separate "server" computer as the network master. Campground Master cannot be run as a service, and someone should be able to access the network master at any time for maintenance and other functions. Also remember that each workstation has the entire database, so besides having automatic redundancy, backups can be done from any of the workstations.
Setup Procedure:
1. Install the Campground Master software on each computer (workstation), and decide which one will be the master. Note that you will also need to get the database copied to each computer before they can be configured for networking (see step 5), but don't do that until the authorization code is entered (step 3).
2. If you're not familiar with configuring program and/or port exceptions in firewall software and routers, temporarily disable all firewalls and other security software on each computer (they can be re-enabled with proper "exception" configurations once you get the network operational). Some typical programs that can block TCP/IP networking are Windows XP's firewall or Security Center, Norton's Antivirus with Internet Worm Protection, McAffee's antivirus, ZoneAlarm, and various other antivirus software, spyware blockers, pop-up blockers, etc. If you're using a switch or router that has firewall/gateway/blocking capability, either disable it or make sure that the TCP/IP port you'll be using (see step 7) is not blocked.
3. After you have a database set up and authorization code entered on the master, make sure the database is authorized for networking. This can be checked through the View / View Product Authorizations function -- the "Max Workstations" value will be greater than 1 if you are authorized for networking.
4. To make sure that the printer options, tab view options and other settings will be the same on each workstation (especially if you have already been using the program on a single computer for awhile), synchronize the settings for all workstations. This can be done at any time, but doing it before you copy the database to the other workstations will ensure they are set up correctly to begin with. Note that this is essentially a database function and does not require the other workstations to be connected yet -- it simply copies the master's settings to the other workstation's settings in the database. This function is under Maintenance / Network Functions / Synchronize local options to other workstations.
5. Copy the database to each workstation. A step-by-step guide to copying the database to another computer can be found in the Maintenance chapter. Do NOT set up Campground Master to open the database file through a mapped drive on the network! If more than one workstation is accessing the same database file, the data will become corrupt. Each workstation should be loading and saving the database from its local hard drive. It's also important that the database have the same name on every workstation. Note: If you get an error when connecting that the names don't match, use the File / Rename Database command to change the name. Afterwards you might also need to go to Maintenance / Program Options / Database to change the auto-open database to the current one.
6. Find the IP address(es) of the master workstation (configure it for a static IP address if possible -- this is done in the Windows system, not in Campground Master). If you don't know its IP address, you can use the Show IP address(es) function under Maintenance / Network Functions. If it shows more than one address, you will need to figure out which one is for the local network and will be visible to the other workstations. Local network IP addresses often start with 192 or 169. The IPCONFIG command from a Command Prompt (DOS window) can also indicate the local area network's IP address.
Important: You do NOT need to use this "Show IP" function on any computer besides the master! All too often, people use this function on the client computers and worry that it shows a different number. Of course it does! It is normal, and in fact required, that each computer have a different IP address (just like your house has a different address than the one next door, so the mail goes to the right house), so don't use this function on the client computers and worry about them being different. That's normal! The ONLY function you should be using in the client computers is Network Setup, as explained in step 9.
7. Decide on a TCP/IP port number. You can use the arbitrary default port (6010), or if that is known to conflict with other software you can change it.
8. On the master workstation, open the database and make sure the Network Settings (Maintenance / Network Functions / Network Setup) are set accordingly: This workstation ID should be 0, and the Master ID should be 0. (The master ID can be another number, but this is the easiest way to keep track of it -- just make sure that the "This" ID and the "Master" ID are the same, that's what tells it to be the master.) The other options are covered later, but all of the check boxes should be checked. Note that you must be logged into Campground Master as an Administrator to get into this function.
9. On each of the other workstations, open the database (if not already open) and go to Maintenance / Network Functions / Network Setup to change the client's Network Settings accordingly: The workstation ID should be different for each one (1, 2, 3, etc.), the Master ID should be 0 (assuming that's the Master's ID set in step 8 above), and the Master IP address should be the address of the Master from step 6. You do not normally need to use "Show IP address for this workstation" on a client, but if you do then be aware that it is normal for the last number of the IP address to be different on each computer (just like each person will always have a different phone number).
You can also specify various heartbeat frequency, timeout, and other options if you prefer. See the Network Setup Dialog section for more details.
If the master workstation is running at the time you perform the last step for each workstation, you should see it immediately connect after you change the settings and click OK. You're done!
If a connection error is shown, double-check your network settings and refer to the following sections, or contact us for support. If you are running a firewall, try disabling the firewall -- if connection is successful with the firewall disabled, you will need to determine how to enable the selected port for the firewall (consult the documentation for the firewall). Likewise, other security software may need to be disabled or configured to allow Campground Master to communication, such as Norton Internet Security, ZoneAlarm, McAfee, the Windows Firewall, or various antivirus or anti-spyware software. Some firewall configuration examples are given later.
IMPORTANT: Once every workstation is connected, start re-enabling any security software that was disabled previously -- enable one program at a time, and double-check to make sure it doesn't interfere with networking by closing down both the Master and Client workstation(s) and restarting them. If it prevents connection, see if you can configure exceptions in the security software to enable the Campground Master software and/or the IP port you're using (see step 7 above). Under no circumstances should you leave your computer unprotected by keeping the firewall completely disabled.
Additional Topics:
Networking Through the Internet
Setting up Multiple Connections
Firewall Configuration Examples