1. Installation

• If you'd like to have your own Dexter Server, you have to follow the next instructions.

• OS : Windows 7+, LINUX, Mac OS X

• System Estimation

  ~ 10	2.6 GHz * 1	4 GB	50 GB
  10 ~ 50	2.6 GHz * 2	8 GB	200 GB
  50 ~ 100	3.6 GHz * 2	32 GB	500 GB
  100 ~ 200	3.8 GHz * 4	64 GB	1 TB
  Users	CPU	RAM	HDD

• Whenever creating a snapshot of defect status, database size can be increased as amount of your source codes.

• If you don't use any snapshot, usually, database size can be as same as your source codes.

1.1 MySQL Installation

• Dexter supports only MySQL Database.

  Purpose	It is used for the Dexter Data persistence (Defect Results Management)
  Version	5.6-7
  Download	http://www.mysql.com/downloads/
  Install & Verify	http://www.tutorialspoint.com/mysql/mysql-installation.htm
  Configure	http://cameronyule.com/2008/07/configuring-mysql-to-use-utf-8/ The following codes must be added onto the (linux : my.cnf / windows: my.ini) file. [mysqld] default-character-set=utf8 default-collation=utf8_general_ci character-set-server=utf8 collation-server=utf8_general_ci init-connect='SET NAMES utf8' [client] default-character-set=utf8
  Create Dexter Database	You need to download ddl script file : 'dexter-db.sql' file using the mysql command line tool as follows. Before using the following commands, you have to decide a Dexter database name, user name and a password that will be used at the NodeJS (Next Step). ("// <== " is for a comment) root@/usr/local/share# mysql -u root -p // <== run mysql command line tool Enter password: // <== enter your mysql password mysql> create database my_dexter_db; // <== choose any name for your product Query OK, 1 row affected (0.00 sec) mysql> use my_dexter_db; Database changed mysql> create user 'dexter-user' identified by 'mypassword'; // <== choose any password Query OK, 0 rows affected (0.01 sec) // if your mysql server and node js server is not same server, you have to add node js server IP with following command mysql> grant all on my_dexter_db.* to 'dexter-user'@'localhost' identified by 'mypassword'; Query OK, 0 rows affected (0.00 sec) mysql> source ./dexter-db.sql // <== select downloaded dexter-db.sql file location Query OK, 0 rows affected (0.00 sec) Query OK, 0 rows affected (0.00 sec) ... mysql> select * from Account; // <== test DB creatation +--------+--------+----------+---------+---------------------+---------------------+ | userNo | userId | userPwd | adminYn | createdDateTime | modifiedDateTime | +--------+--------+----------+---------+---------------------+---------------------+ | 1 | admin | dex#0001 | Y | 2014-08-10 19:27:23 | 0000-00-00 00:00:00 | | 2 | minho | 1111 | N | 2014-08-10 19:27:23 | 0000-00-00 00:00:00 | +--------+--------+----------+---------+---------------------+---------------------+ 2 rows in set (0.00 sec) // <== If you can see the upper Accounts info, your installation is done successfully mysql> > The account information that is generated in the DB. admin : It is a basic administrator account. (Use of this account is optional.)
  Task	Description

1.2 NodeJS and Dexter Server Installation

• NodeJS and Dexter Server Installation

  Purpose	To execute Dexter Server and mange Dexter Clients' requests and data persistence
  Version	4.4.0
  Download	http://www.nodejs.org/
  System Variables	The nodejs bin path must be set to PATH global environment variable
  Verify	# node -v v4.4.0
  Download Dexter Server	You need to download the dexter-server zip(##########) file in GitHub, and then unzip it to any folder. or you can download the latest one here(github): 'project/server/dexter-server' folder
  Task	Description

2. Configuration

• N/A

3. Run

• To run Dexter Server, you need to type the following command in the Dexter-server folder.

  root@~> cd /usr/local/share/dexter-server_v#.#.# root@/usr/local/share/dexter-server_v#.#.#> node server.js -p=4982 -database.host=localhost -database.name=my_dexter_db -database.user=dexter-user -database.password=mypassword >> console.log & Dexter server listening on port 4982 // <== server started correctly DB Connection is fine : localhost:3306 // <== DB Connection is OK

• -p=port_number : You can change the Dexter server port number. The port number is used to access the Dexter Server by Dexter Clients such as Dexter WEB or Dexter Eclipse.

• -database.host=mysql_db_ip : Try using the IP address of the database server.

• -database.naem=my_dexter_db : Enter the name of the Dexter database that is created by previous step.

• -database.user=db_user_id : The ID you entered for the Dexter database.

• -database.password=db_user_password : The password you entered for the Dexter database.

• You can view the logs from "console.log" and "./log/dexter-server.log" files. 
  • Note : You have to delete this file by yourself, if the file size is too large.

4. Verify

• Open a web browser(IE is not supported), and then type the following URL: http://[dexter-server-ip]:[dexter-server-port]/defect 
• Example : After typing  http://localhost:4982/defect in the URL address box,  you can see the site as follows.
  

5. Eclipse Update Site

• If you want have your own Eclipse Update Site, download the following zip files.
• Then unzip those files in your Web Server
  • for 32 bit : 32.zip
  • for 64 bit : 64.zip
• Developers can install or update Dexter Eclipse Plug-ins through the following URL
  • for 32 bit : http://your-web-server-ip:port/32
  • for 64 bit : http://your-web-server-ip:port/64