[Toaster] database-related critical bugs - 7363 7365

[Damian, Alexandru]

Hello,

We have two show-stopper bugs that break QA process. These bugs were
introduced by an optimization I tried for MySQL, but they break SQLite3 in
a non straight-forward way.

There are two options to work around this issue in order to unblock QA
until the problem is fixed.

​a). temporarily switch to mysql, instead of sqlite, using these steps:

  - install mysql server (sudo apt-get install mysql-server, sudo yum
install mysql-server), select empty password
  - install mysql client (sudo apt-get install mysql-client, sudo yum
install mysql)
NOTE: Fedora will install mariadb instead of mysql, but that's fine
  - start the mysql server (sudo service mysql start, sudo systemctl start
mysqld.service)
  - create the toaster database;
> echo create database toaster | mysql -u root
  - install mysql adapter (pip install mysql-python)
  - export the database environment string
> export DATABASE_URL=mysql://root:@localhost:3306/toaster

    ... and use Toaster normally;

b). remove the offending commit:

> git revert cb23e3043bf5c07f111787287a321df0ece647dd


Cheers,
Alex

-- 
Alex Damian
Yocto Project
SSG / OTC
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.yoctoproject.org/pipermail/toaster/attachments/20150225/5ddd2e21/attachment.html>