When you start the MDS for the first time it asks the following questions:
Do you want to continue?
To continue type 'y' and press 'enter'
A.Which database product do you use?
[1] Oracle
[2] PostgreSQL
[3] MS SQL Server
[4] DB2
Type the appropriate number and press 'enter'
B. What is the JDBC connection url to use?
This is the JDBC (Java Database Connectivity) connection to your database and has different formats for different databases.
Oracle database:
The format for the URL is as follows:
jdbc:oracle:thin:@<hostname>:<port>:<database name>
The hostname can also be an IP adress. If you called the database ResultsDB and it is running on port 1521 (the default Oracle port) on a machine with IP adress 192.168.84.16, the url is: jdbc:oracle:thin:@192.168.84.16:1521:ResultsDB.
Postgresql database:
The format for the URL is as follows:
jdbc:postgresql://<hostname>:<port>/<database name>
The hostname can also be an IP adress. The port number only has te be given when it is another value than the default value, which is 5432. So if you called the database ResultsDB and it is running on a machine with IP adress 192.168.84.16, the url is jdbc:postgresql://192.168.84.16:5432/ResultsDB
Microsoft SQL Server database:
The format for the URL is as follows:
jdbc:microsoft:sqlserver://<hostname>:<Port>;databaseName=<database name>;selectMethod=cursor
The hostname can also be an IP adress. The default port number for Microsoft SQL Server is 1433. So if you called the database ResultsDB and it is running on a machine with IP adress 192.168.84.16, the url is jdbc:microsoft:sqlserver://192.168.84.16:1433;databaseName=ResultsDB;selectMethod=cursor
Please note that you cannot use Windows authentication to connect to an SQL Server database. You need to acces any SQL Server database using SQL Server authentication. If your SQL Server is not installed to use SQL Server authentication, then you can try to use ODBC to connect to this database (see below).
IBM DB2 database:
The format for the URL is as follows:
jdbc:db2://<hostname>:<port>/<database name>
The hostname can also be an IP adress. The default port number for IBM DB2 is 50000. So if you called the database ResultsDB and it is running on a machine with IP adress 192.168.84.16, the url is jdbc:db2://192.168.84.16:50000/ResultsDB
C. What is the username to logon to the database?
If the MDS needs a username and password to connect to the database, here you can fill out the username. If no username is needed, you can leave this space blank and just press enter.
D. What is the password to logon to the database?
If the MDS needs a username and password to connect to the database, here you can fill out the password. If no password is needed, you can leave this space blank and just press enter. The password that you enter will be echoed in readable text while you type it. Make sure nobody is 'watching over your shoulder' when you enter the password.
E. You can change the driver name if needed.
Or accept the default JDBC driver for the database you selected.
The MDS automatically selects the database driver that is to be used to connect to the database. Generally, you can leave this value unchanged. The MDS uses proprietary drivers for Oracle, PostgreSQL, MS SQL Server and IBM DB2 databases. These drivers are incorporated in the software. Type 'y' to accept the default driver. If you want to use another driver, you can type 'n', after which you will be given an opportunity to type the name of the driver you wish to use. Please bear in mind that the name of the database driver is case-sensitive, and that the driver files need to be in your CLASS_PATH.
Please note: The same JDBC URL's and drivers can be used to connect to a stakeholder database from the Metatude Project Manager.
F. What is the SMTP adress?
Here you can enter the adress of the SMTP server that is to be used by the MDS for sending out email. This can be either a hostname or an IP adress.
G. You can change the port to use for the SMTP connection.
Or accept the default port for the SMTP connection.
The MDS needs to know the port on which the SMTP server runs. For SMTP servers this nearly always is the value 25. If this is the case, accept the default value by typing 'y'. When the SMTP server runs on a different port, type 'n' for no and you will be given an opportunity to enter the value of the SMTP port.
H. Please enter a name for your site
Please enter the name that you wish to give your Stakeholder feedback site. You can enter any name here. This name will show up in the Metatude Project Manager, when creating a new project. A good name to choose is the name of your company. For more information, see the chapter 'Multiple Sites'.
I. Please enter the MCIC URL for this site
The MDS needs to know on which webserver the Metatude Channel Integration Component runs. This information is used to send out emails with the right URL to launch a dialogue. In case you use IIS to serve the dialogues, the format of the adress is:
http://webservername/directory/default.asp
So if the MCIC will run on your internet server called 'www.mycompany.com' in the directory 'metatude', you need to enter http://www.mycompany.com/metatude/default.asp
In case you are using the Apache/Tomcat combination, the URL has the form:
http://webservername/directory/Get
The default directory that is used when installing the MCIC for IIS or Apache/Tomcat is 'metatude'. An example of an URL is http://www.mycompany.com/metatude/Get
If you are using Tomcat without Apache, then you also need to enter the port Tomcat is running on in the URL. The default port for a standalone Tomcat installation is 8080.
J. Do you wish to specify an e-mail template for this site? [optional]
If you have an e-mail template ready, and have placed in the Stationery subdirectory, then you can enter its name. Choose 'y' to enter the name of the template. The MDS checks if the template exists and has the correct format. If you do not have an e-mail template ready, choose 'n'. You can specify an e-mail template later. For more information, see the chapter 'E-mail templates'.
K. Please enter the Client's Name (For whom the License Key is registered)
In order for the MDS to function, you need to enter the client name that is given to you. This name is matched against the name that is encrypted in the license key. If they are not exactly the same, the MDS will not start. This name is case sensitive.
L. Please enter the License Key
In order for the MDS to function you need to enter the license key that is given to you. This Key will unlock a number of users, stakeholders and a period of time that the MDS will run. After you enter the correct license key, the MDS will check the key. If the key is valid, the console will display the number of users and the number of stakeholders that are unlocked and will show the date untill which the MDS will run with this license key. The license key is case-sensitive.
M. Please enter the Administrator's password
Here you can enter the password for username 'Administrator'. You can use this password to log on to the MDS using the Metatude Project Manager. Please note that the username and the password are case-sensitive. The password that you enter will be echoed in readable text while you type it. Make sure nobody is 'watching over your shoulder' when you enter the password.
N. You can set MDS to send Response Report Status (RRS) to Metatude and/or MDS administrator (own email address). Which one you like?
[1]Send only to Metatude.
[2]Send only to MDS administrator (own email address).
[3]Send to both Metatude and MDS administrator (own email address).
[4]Do not send.
You can choose if you want the monthly response reports to be e-mailed to you and/or to Metatude. When you choose to have the response reports e-mailed to you, you will be asked to enter your e-mail address.
After you have answered these questions, the MDS has all the information to operate. The console will display the following message:
Main Database Product Name and Version : PostgreSQL 7.3.4
JDBC Driver Name and Version : PostgreSQL Native Driver PostgreSQL 7.3.4 JDBC3 jdbc driver
MDS Database Encoding/Character set : UNICODE
Product ID: 1
Product version: 1
Client ID: 1
Client Name: Metatude
Total users: 9999
Total LDAP connections: Unlimited
Total JDBC connections: Unlimited
Total stakeholders: Unlimited
Total monthly responses: 999999999
Database Feedback Option: true
This Server will run until: Jan 1, 2010 12:00 AM
-----------------------------------------------------------------
Metatude Dialogue Server running on port 6382
This is MDS R2.2 Final
-----------------------------------------------------------------
You can verify the database connection info, such as the encoding. Also, your license options are shown.
You can stop the MDS by typing the command exit in the console window. For more commands, please see the chapter 'Console window'.