From Fedora Project Wiki

Revision as of 15:13, 1 February 2011 by Kparal (talk | contribs) (syncdb must be run twice, tested many times)

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

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 file /usr/share/autotest/global_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. This needs to be run twice, otherwise debug_user won't have access to the Django administrative interface.
    # /usr/share/autotest/frontend/manage.py syncdb --noinput
    # /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 file /usr/share/autotest/global_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. This needs to be run twice, otherwise debug_user won't have access to the Django administrative interface.
    # /usr/share/autotest/frontend/manage.py syncdb --noinput
    # /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