Hello, I have an Ubuntu 14.04 LTS desktop. I used the script install-autotest-server.sh to install the auto test server, it ran fine until it reached line 414 where it invokes script autotest-database-turnkey
13:12:01 INFO | Setting MySQL root password
13:12:01 INFO | Verifying MySQL root password
13:12:01 INFO | Creating MySQL databases for autotest
13:12:03 ERROR | Error creating MySQL database
Running this script with same params
sudo /usr/local/autotest/installation_support/autotest-database-turnkey -s
--root-password=mypasswd -p mypasswd
produces this error:
Traceback (most recent call last):
File "/usr/local/autotest/installation_support/autotest-database-turnkey",
line 201, in <module>
result = app.run()
File "/usr/local/autotest/installation_support/autotest-database-turnkey",
line 174, in run
django.core.management.execute_from_command_line(argv)
........
django.db.utils.ProgrammingError: Problem installing fixture
'/usr/local/autotest/frontend/tko/fixtures/initial_data.json': Could not load
tko.Status(pk=1): (1146, "Table 'autotest_web.tko_status' doesn't exist")
Indeed, mysql has the autotest_web database, but there is no tko_status table.
Also, the steps to setup MySQL manually are out of sync with the script and
don't contain much info. They contain a command to create database tko, that is
also not created by the automated script.
http://autotest.readthedocs.org/en/latest/main/sysadmin/AutotestServerInstallDatabase.html
Can you help?
Thanks
Danut
install-autotest-server-08-07-2015-13-10-32.log
Description: install-autotest-server-08-07-2015-13-10-32.log
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | autotest_web | | mysql | | performance_schema | +--------------------+ 4 rows in set (0.00 sec) mysql> use autotest_web Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> show tables; +------------------------------------------------+ | Tables_in_autotest_web | +------------------------------------------------+ | afe_aborted_host_queue_entries | | afe_acl_groups | | afe_acl_groups_hosts | | afe_acl_groups_users | | afe_atomic_groups | | afe_autotests | | afe_autotests_dependency_labels | | afe_drone_sets | | afe_drone_sets_drones | | afe_drones | | afe_host_attributes | | afe_host_queue_entries | | afe_hosts | | afe_hosts_labels | | afe_ineligible_host_queues | | afe_job_keyvals | | afe_jobs | | afe_jobs_dependency_labels | | afe_kernels | | afe_labels | | afe_parameterized_job_kernels | | afe_parameterized_job_parameters | | afe_parameterized_job_profiler_parameters | | afe_parameterized_jobs | | afe_parameterized_jobs_profilers | | afe_profilers | | afe_recurring_run | | afe_special_tasks | | afe_test_parameters | | afe_users | | auth_group | | auth_group_permissions | | auth_permission | | auth_user | | auth_user_groups | | auth_user_user_permissions | | django_admin_log | | django_content_type | | django_session | | django_site | | linux_distro | | linux_distro_available_software_components | | migrate_info | | software_component | | software_component_arch | | software_component_kind | | south_migrationhistory | | test_environment | | test_environment_installed_software_components | +------------------------------------------------+ 49 rows in set (0.00 sec)
_______________________________________________ Autotest-kernel mailing list [email protected] https://www.redhat.com/mailman/listinfo/autotest-kernel
