From Fedora Project Wiki

Revision as of 12:40, 21 January 2011 by Kparal (talk | contribs) (remove Fedora version numbers)

QA.png


This page details installing and configuring Package-x-generic-16.pngautotest-server.

Package installation

Autotest is currently packaged for Fedora, but due to unpackaged dependencies, is not yet available in Fedora official repositories. The following section describes how Autotest is installed on a Fedora 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. Add the same repositories as mentioned in the AutoQA installation guide.


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 Package-x-generic-16.pngautoqa-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.
    mysql> create database autotest_web;
    mysql> grant all privileges on autotest_web.* TO 'autotest'@'localhost' identified by 'NEWPASSWORD';
    mysql> grant SELECT on autotest_web.* TO 'nobody'@'%';
    mysql> grant SELECT on autotest_web.* TO 'nobody'@'localhost';
    mysql> 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.
    mysql> create database autotest_tko;
    mysql> grant all privileges on autotest_tko.* TO 'autotest'@'localhost' identified by 'NEWPASSWORD';
    mysql> grant SELECT on autotest_tko.* TO 'nobody'@'%';
    mysql> grant SELECT on autotest_tko.* TO 'nobody'@'localhost';
    mysql> 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. Note, you may need to run this command twice if debug_user does not have access to the Django administrative interface.
     # /usr/share/autotest/frontend/manage.py syncdb --noinput 
  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 Package-x-generic-16.pngautotest-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 Package-x-generic-16.pngautotest-server package.


  1. Examine the autotest configuration files /usr/share/autotest/global_config.ini and /usr/share/autotest/shadow_config.ini to determine whether updates are required
  2. Stop httpd
    # service httpd stop
  3. Stop the autotest scheduler
    # service autotestd stop
  4. 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
  5. Run the Django syncdb operation. Note, you may need to run this command twice if debug_user does not have access to the Django administrative interface.
     # /usr/share/autotest/frontend/manage.py syncdb --noinput 
  6. Restart httpd
    # service httpd restart
  7. Start the autotest scheduler
    # service autotestd start
  8. If you want to have autotest scheduler automatically started on machine boot, run one more command:
    # chkconfig autotestd on


Maintenance

Removing old results

Depending on how you use autotest, the results/ directory can fill up rather quickly. Depending on underlying file-system, you may run out of available inodes or disk space. To prevent both scenarios, you can use the tmpwatch command to remove results that meet certain criteria. For example, to remove test results older than 30 days, the following tmpwatch command can be used.

# usr/sbin/tmpwatch --dirmtime -umc -f 720 /usr/share/autotest/results/ -X README