All CyberMatrix web applications require a web server application running at all times. Similarly, all CyberMatrix client/server applications require a database server application running at all times. Many customers are confused as to why we offer a separate service form of both these server applications.
The Difference Between Service and Desktop Applications
The main difference between a service application and a desktop application is that a service can be always running on your server machine even if there is no one logged in. A desktop application on the other hand requires someone to be logged in in order to run the software. Having a machine logged in at all times can represent a serious security hazard for any company. Anyone passing by a logged in machine can do anything they like on that machine including access any data.
Also, service applications can be configured to start automatically when the server machine is rebooted. So for example, suppose you lose power. When the power comes back your server machine restarts. Because the database or web server is a service, it will be automatically running despite the fact that no one is logged into the server machine or had to manually start the server software.
All CyberMatrix business software can be shared with multiple people on your company’s network. The Client/Server, Enterprise and Web editions of our software can also be accessed outside of your network via the Internet.
Sharing Data on Your Network
To share data on your network you enter your network IP address in the Network tab of the Options screen in the Client/Server and Enterprise editions of our software or the web browser URL of the Web editions of our software.
Finding Your Network IP Address
The easiest way to find your network IP address is through the Windows program called IPConfig. To start IPConfig, right click on your Start button and choose Open Windows Explorer. In the windows that pops up, type cmd in the navigation box that says Libraries. Press enter and a command line window will appear. Type IPConfig and press return. If you are on a wired connection look for a line like this: Ethernet adapter Local Area Connection:. If you are connecting wirelessly, check for a line like this: Wireless LAN adapter Wireless Network Connection 3:. Your IP address will be on the line that starts with: IPv4 Address. Usually it will start with 192.168.
Sharing Data Over the Internet
To share data over the Internet you enter your Internet IP address in the Network tab of the Options screen in the Client/Server and Enterprise editions of our software or the web browser URL of the Web editions of our software.
Finding Your Internet IP Address
Finding your Internet IP address can be a bit harder. Often it is not listed in the IPConfig output. If that’s the case you can easily find it by typing the text “what is my ip” in your web browser.
Static Vs Dynamic IP Addresses
A final note on the importance of the type of IP addresses your network or Internet connection uses. The best type of IP address to use with our software is called a static IP address. The benefit of a static IP address is that it never changes. Dynamic IP address on the other hand will change. When your IP address changes you will have to find the new address and enter it in the software again.
Using a DNS Service
If you have a dynamic IP address the simplest way to get a static IP address is to use a DNS service like no-ip,com.
Another option to try is to enter the server’s name instead of it’s IP address.
Running a server application as a service has some definite advantages. The most significant advantage is that when the server is running as a service it can be configured so that no user is required to be logged in on the server machine. Another advantage is that services can be configured to automatically restart if the server ever has to be restarted.
Several CyberMatrix products have client/server editions. Some other products have client/server options. Pro Schedule, Meeting Manager, Project Clock and Timesheets all have a client/server edition. Employee Project Clock and CyberMatrix Point Of Sale have an option to use the software in a client/server configuration. The server for all these products can be configured to run as a service.
Before Installing the Server as a Service
There are a few steps you should perform before installing the server application as a service.
- Verify the server IP address.
Run the server application. You will see an orange icon is the system tray. Double click that to see the ElevateDB server manager. Click the icon in the upper left that says “Stop Server”. Click the icon below that says “Edit Server Options”. Under the Connections tab you can change the IP address if you had set it wrong during installation or if the IP has changed. If you make the IP address field blank, all IP addresses will be listened for.
- Set the temp folder.
In the Miscellaneous tab of the “Edit Server Options” you should verify the server temporary folder. For a service you should ensure that the user the service will run under will have full write access for the temp folder used. In particular you should not use any user folders as they may not exist later on.
- Run first as a non-service application.
Before running the server as a service, run the server as a non-service application to verify that there are no problems like obvious folder rights issues or firewall issues.
- Configure your firewall.
Make sure there is an application exception for the server application. Also make sure that the port used (default 12010) is opened in the firewall.
Installing the Server as a Service
To install the edbsrvr.exe database server as a service, enter the following command at a command line prompt or from the Run Menu:
To install the database server so that it does not interact with the desktop at all, which is required in instances where the current user will be logged out of the system, you should use the /nointeract flag along with the /install command-line switch:
edbsrvr.exe /install /nointeract
This will install the service as a non-interactive service and the database server will not display a user interface when it is started.
Starting the Server Service
To start the edbsrvr.exe database server as a service enter the following command at a command line prompt or from the Run Menu:
net start edbsrvr
Uninstalling the Server Service
To uninstall the service first stop it and then type: