Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

install-autotest-server.sh fails with error "Error creating MySQL database" #975

Open
ghost opened this issue Sep 17, 2015 · 2 comments
Open

Comments

@ghost
Copy link

ghost commented Sep 17, 2015

I am trying to set up autotest-0.16.2 on Ubuntu 14.04. I autotest-0.16.2 is unpacked at /usr/local/autotest and I am running the installation script as:

"./contrib/install-autotest-server.sh -u autotest -d autotest"

The install-autotest-server.log displays the following:

09:41:16 INFO | Creating autotest user
09:41:16 INFO | Installing autotest
09:41:16 INFO | Initializing and updating tests to the latest master
09:41:16 INFO | Setting proper permissions for the autotest directory
09:41:16 INFO | Installing packages dependencies
09:41:16 INFO | Please note that autotest is compatible with Django 1.5
09:41:16 INFO | If your distro/local install is different, you WILL have problems
09:41:16 INFO | Please stick with 1.5 for the time being
09:41:16 INFO | No specific distro release package list
09:41:16 INFO | Installing packages "apache2-mpm-prefork git libapache2-mod-wsgi makepasswd mysql-server openjdk-7-jre-headless python-crypto python-django python-django-south python-httplib2 python-imaging python-matplotlib python-mysqldb python-numpy python-paramiko python-setuptools python-simplejson python-psutil unzip wget protobuf-compiler python-protobuf pylint"
Extracting templates from packages: 100%
09:42:39 ERROR| [stderr]
09:42:39 ERROR| [stderr] Current default time zone: 'America/New_York'
09:42:39 ERROR| [stderr] Local time is now: Thu Sep 17 09:42:39 EDT 2015.
09:42:39 ERROR| [stderr] Universal Time is now: Thu Sep 17 13:42:39 UTC 2015.
09:42:39 ERROR| [stderr] Run 'dpkg-reconfigure tzdata' if you wish to change it.
09:42:39 ERROR| [stderr]
09:43:09 ERROR| [stderr] mysql start/running, process 12355
09:43:12 ERROR| [stderr] AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
09:43:13 ERROR| [stderr] apache2_invoke: Enable module wsgi
09:43:15 ERROR| [stderr] AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
09:43:26 INFO | Enabling MySQL server on boot
Adding system startup for /etc/init.d/mysql ...
/etc/rc0.d/K20mysql -> ../init.d/mysql
/etc/rc1.d/K20mysql -> ../init.d/mysql
/etc/rc6.d/K20mysql -> ../init.d/mysql
/etc/rc2.d/S20mysql -> ../init.d/mysql
/etc/rc3.d/S20mysql -> ../init.d/mysql
/etc/rc4.d/S20mysql -> ../init.d/mysql
/etc/rc5.d/S20mysql -> ../init.d/mysql
09:43:26 INFO | Re-starting MySQL server
mysql stop/waiting
mysql start/running, process 14996
09:43:29 INFO | Setting MySQL root password
09:43:29 INFO | Verifying MySQL root password
09:43:30 INFO | Creating MySQL databases for autotest
09:43:34 ERROR | Error creating MySQL database

As a workaround, I followed the steps mentioned here manually: http://autotest.readthedocs.org/en/latest/main/sysadmin/AutotestServerInstallDatabase.html
then commented out "create_autotest_database" and re-ran the script. This time the execution was successful and the output mentioned that autotest server can be accessed at http:///afe.
However, the link keeps throwing 404. Apache is up an running at http:// though.

Please help me!

@lmr
Copy link
Member

lmr commented Sep 17, 2015

09:41:16 INFO | Please note that autotest is compatible with Django 1.5
09:41:16 INFO | If your distro/local install is different, you WILL have problems
09:41:16 INFO | Please stick with 1.5 for the time being

You have to verify what's the Django version in use. If it's different than 1.5, you'll have problems.

@toralMevada
Copy link
Contributor

To avoid '' Error creating MySQL database' ', remove database manually created before.

Steps:
mysql -u root -p

drop database autotest_web;
drop database tko;

But Yes, I am also getting 404 error on http:///afe with ubuntu 12.04.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants