Install and configure autotest

This page details installing and configuring autotest-server.

Package installation

Autotest is currently packaged for Fedora 13, but due to unpackaged dependencies, is not yet available for Fedora. The following section describes how autotest is installed on a Fedora 13 system using the autoqa package repository.

Use the right repos

Setup the required package repositories.

1. If using RHEL or CentOS, configure the system to receive package updates using the update mechanism provided by the distribution (e.g. for RHEL, run rhn_register).
2. If using RHEL or CentOS, enable EPEL by following the instructions at EPEL/FAQ#howtouse
3. Configure the AutoQA package repository.
   • For Fedora, execute the command: wget -P /etc/yum.repos.d http://repos.fedorapeople.org/repos/fedora-qa/autoqa/fedora-autoqa.repo
   • Otherwise, for EPEL, execute the command: wget -P /etc/yum.repos.d http://repos.fedorapeople.org/repos/fedora-qa/autoqa/epel-autoqa.repo

Install

Finally, with yum repositories configured, use the yum command to install autotest and it's dependencies.

# yum install autotest-server

Configuration

With the packages installed, it's time to configure related system services.

httpd

The autotest server requires the Apache HTTP Server. No additional configuration is required, autotest provides a /etc/httpd/conf.d/autotest.conf configuration file.

1. Start httpd:

   # service httpd restart

2. Configure httpd to start on system boot:

   # chkconfig httpd on

If you install the results front-end autoqa-israwhidebroken package, you will need to enable mod_wsgi.

1. In /etc/httpd/conf.d/wsgi.conf, be sure that the mod_wsgi.so module is being loaded. You should see a line of text like the following:

   LoadModule wsgi_module modules/mod_wsgi.so

mysql

Autotest requires access to a mysql server. You can use an existing server, or setup a new mysql server using the instructions below.

Initialization (optional)

If you are using an existing mysql-server, you may skip this section.

1. Install and setup mysql server

   # yum install mysql-server

   # chkconfig mysqld on

   # service mysqld start

2. Setup a password for the root database user. Please use a password other than NEWPASSWORD.

   # mysqladmin -u root password NEWPASSWORD

Tables and priveleges

Whether using a local mysql-server, or connecting to an existing mysql-server, autotest requires database tables with appropriate permissions.

1. Using the mysql command, login to the root database using the password specified above

   $ mysql -u root -p

2. Create the autotest_web database and user permissions needed by autotest using the following SQL commands. It is recommended that you use a password other than NEWPASSWORD.

   create database autotest_web;

   grant all privileges on autotest_web.* TO 'autotest'@'localhost' identified by 'NEWPASSWORD';

   grant SELECT on autotest_web.* TO 'nobody'@'%';

   grant SELECT on autotest_web.* TO 'nobody'@'localhost';

   flush privileges;

3. Create the tko database and user permissions needed by autotest using the following SQL commands. It is recommended that you use a password other than NEWPASSWORD.

   create database autotest_tko;

   grant all privileges on autotest_tko.* TO 'autotest'@'localhost' identified by 'NEWPASSWORD';

   grant SELECT on autotest_tko.* TO 'nobody'@'%';

   grant SELECT on autotest_tko.* TO 'nobody'@'localhost';

   flush privileges;

autotest

With the mysql database configured, it's time to tell autotest how to connect, and to pre-populate the database with initial data.

1. Update the autotest configuration files /usr/share/autotest/global_config.ini and /usr/share/autotest/shadow_config.ini
   • In sections [TKO] and [AUTOTEST_WEB], enter the correct values for password
   • In section [TKO], change the value of database to autotest_tko
   • In section [SERVER], set the value of hostname
2. Setup the database schemas and populate initial data

   $ python /usr/share/autotest/database/migrate.py --database=AUTOTEST_WEB sync

   $ python /usr/share/autotest/database/migrate.py --database=TKO sync

3. Run the Django syncdb operation

   $ /usr/share/autotest/frontend/manage.py syncdb --noinput

   # you may have to run this twice, like if the debug_user does not have access to the Django Admin interface

   $ /usr/local/autotest/frontend/manage.py syncdb

4. Restart httpd

   $ service httpd restart

5. Start the autotest scheduler

   $ service autotestd start

6. If you want to have autotest scheduler automatically started on machine boot, run one more command:

   $ chkconfig autotestd on

Congratulations! Your autotest server should be up and running. Direct your web browser to http://localhost.

Package upgrade

When upgrading to a newer autotest-server package, it is common that the newer server includes database schema changes. The procedure for updating your autotest database is the same procedure used when initially setting up the database. Follow the instructions in #autotest after installing a newer autotest-server package.

1. Stop httpd

   $ service httpd stop

2. Stop the autotest scheduler

   $ service autotestd stop

3. Setup the database schemas and populate initial data

   $ python /usr/share/autotest/database/migrate.py --database=AUTOTEST_WEB sync

   $ python /usr/share/autotest/database/migrate.py --database=TKO sync

4. Run the Django syncdb operation

   $ /usr/share/autotest/frontend/manage.py syncdb --noinput

   # you may have to run this twice, like if the debug_user does not have access to the Django Admin interface

   $ /usr/local/autotest/frontend/manage.py syncdb

5. Restart httpd

   $ service httpd restart

6. Start the autotest scheduler

   $ service autotestd start

7. If you want to have autotest scheduler automatically started on machine boot, run one more command:

   $ chkconfig autotestd on