Set up squashTM

Install JAVA jre environment

1. Prepare jre-8u151-linux
2. Make a place for JAVA root@Moxa:# mkdir /usr/lib/jvm
3. Change directory root@Moxa:# cd /usr/lib/jvm
4. Tar the zipped file root@Moxa:# tar zxvf ~/Downloads/jre-8u151-linux-x64_bin.tar.gz
5. Set up environment variable and add the following command. root@Moxa:# vi /etc/bash.bashrc

    """
    export PATH=$PATH:/usr/lib/jvm/jdk-9/bin
    export JAVA_HOME="/usr/lib/jvm/jdk-9"
    """
   

6. Refresh environment variable root@Moxa:# . /etc/bash.bashrc
7. Test JAVA version root@Moxa:# java -version

Insatll squashTM

• Tar the zipped file and follow ReadMe

Install mySQL

• Update and install $ sudo apt-get update $ sudo apt-get install mysql-server $ mysql_secure_installation $ systemctl status mysql.service

Use a MySQL database and Set up mysql for squashtm

info - http://www.squashtest.org/en/faq-squash-tm/faq-squash-tm/comment-parametrer-squash-tm-pour-utiliser-une-base-externe

1. Configure MySQL """ Create a new database with UTF8 encoding for Squash TM, and grant all rights on this database for a user:

    mysql>
    CREATE DATABASE IF NOT EXISTS squashtm CHARACTER SET utf8 COLLATE utf8_bin;
    CREATE USER 'squash-tm'@'localhost' IDENTIFIED BY 'my_password';
    GRANT ALL ON squashtm.* TO 'squash-tm'@'localhost';
    FLUSH PRIVILEGES;
   

   Create a user with the select/insert/update/delete/create temporary tables on this database. Check the following information in the MySQL configuration file (my.cnf or my.ini):

    root@Moxa:/# vi /etc/mysql/my.cnf
    default-storage-engine = InnoDB
    max_allowed_packet=X (where X is the max authorized size of attachments by Squash. By default, the application is set to 2Mo,ie X=2M)
   

   Restart MySQL """

2. Populate Squash TM database """ Use the script 'mysql-full-install.sql' found in the folder 'database-scripts/' of the Squash TM package to populate the database you just created (the database administrator executing this script must have SUPER privilege).

    root@Moxa:/# mysql -u root -D squashtm < mysql-full-install-version-1.17.0.RELEASE.sql         
   

   """

3. Configure Squash TM to use the MySQL database """ Edit the following parameters in the startup file:

    root@Moxa:/# vi startup.sh
    DB_TYPE=mysql
    DB_URL=jdbc:mysql://localhost:3306/squashtm
    DB_USERNAME= squash-tm
    DB_PASSWORD=my_password
   

   """

4. Launch Squash TM """ Restart Squash TM Log on Squash TM with default administrator login admin/admin """

squashTM 操作

• Adminastration -> Customer field -> add "Estimate time" and "Auto testability"