<< Click to Display Table of Contents >> Navigation: Server Utility > Overview |
The server utility is a small program that enables you to do certain things with the database server without having to start MemberTies at all. It enables you to configure server settings, and start/stop the server manually if necessary.
The server utility has a separate executable file located in the MemberTies program directory called "mtsrv.exe". (There should also be an icon for it in the Start Menu along with the MemberTies icon.)
Note: The server utility window is a way to look at the server that is running in the background. It is not the server itself. You can open and close the utility without affecting whether the server is running or not. The only way to manually shutdown the server is to click "Stop Server". Closing the window will have no effect.
When you launch the utility, it will immediately refresh and display the current status of the server.
The server utility includes several sections containing various options.
The options in this section control the starting/stopping of the server itself:
•Start Server - reads configuration files and starts/restarts the server. If a Windows service has been installed to control the service, this will attempt to start/restart the service.
•Stop Server - stops (shuts down) the running server and aborts all existing connections. You should be certain nobody is logged in before doing this. If a Windows service has been installed to control the service, this will instruct Windows to stop the service. If you are not running Windows with enough permissions, you may be prompted for elevated rights, or you may need to start the Server Utility as an administrator by right-clicking the program icon and choosing Run as Administrator.
•Refresh Status - refreshes the server status with the current version and uptime values.
•System Info - generates a text file of system information that can be sent to the support team to help diagnose a problem. The file contains information from various MemberTies configuration and log files.
The options in this section control the way the server starts and runs on your computer. The word "Local" is important -- if you are connected to a remote computer, these settings do not apply to that machine. Ordinarily you should never need to change any settings here. If you choose to make changes, be very careful and take note of what the current settings are. An incorrect setting will prevent the server from starting and MemberTies will be unable to access any databases.
Never include a trailing backslash ( \ ) on any directory entry!
The following fields are available:
•Root Database Directory - the parent directory containing all of your database sub-directories. This defaults to "c:\programdata\MemberTies\database".
•Root Server Directory - the parent directory containing the server files. On a 64 bit system, this defaults to "c:\program files\MemberTies\server". On a 32 bit system, the default is "c:\program files (x86)\MemberTies\server.
•Temp Files Directory - the directory where the server should write temporary files. You must have read/write permissions to this directory or the server will not be able to start. This defaults to "c:\programdata\MemberTies\temp".
•Server IP Address - the address to which the server is bound. This defaults to "localhost."
•Server Engine - the name of the MySQL server engine in use. This defaults to mtmysqld.exe.
•Server Port - the port on which the server is listening for connections. This defaults to 3310.
•Windows Service Name - (optional, but recommended) the name of the service that controls the server. There is no default for this because it is optional. See Running the Server as a Windows Service for details.