WORKING: django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")

WORKING: django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")

[Reyna, David]

[-- Attachment #1: Type: text/plain, Size: 33444 bytes --]

Hi Ryan,

Yes, I have it working now!

With the below patch I was able to launch Toaster for MySql and bring up the default Toaster Django web server.

Here is how you can make it work for yourself.

1) Get and copy the patched version of "bitbake/lib/toaster/orm/management/commands/lsupdates.py", attached to this new tracking bug:

    Bug 12723<https://bugzilla.yoctoproject.org/show_bug.cgi?id=12723> - mysql requires unicode and char length filtering

FYI: this bug summarizes the several issues I found and addressed in the MySql migration. I plan to push this patch for YP-2.5.1 (since 2.5 is now in code freeze).

2) Reset the MySql database, since you have already started it

   $ mysql -u root -p
   mysql> DROP DATABASE toaster_data;
   mysql> CREATE DATABASE toaster_data;
   mysql> quit

3) Restart Toaster, using the "poky" configuration

   $ cd  /var/www/toaster/poky/
   $ ./bitbake/lib/toaster/manage.py migrate
   $  TOASTER_DIR=`pwd` TEMPLATECONF='poky' ./bitbake/lib/toaster/manage.py checksettings
   $ ./bitbake/lib/toaster/manage.py collectstatic

You can now start the default Toaster web server and try that out:

  $ . oe-init-build-env
  $ . toaster start

Let me know how this works for you.

Thanks,
David


From: Reyna, David
Sent: Tuesday, May 01, 2018 12:43 AM
To: 'Ryan McClelland'; 'toaster@yoctoproject.org'
Cc: 'Scott Rifenbark'
Subject: RE: [Toaster] django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")

I see where the problem is.

The "meta-crosswalk" layer in the Layer Index has some hidden illegal characters in their description, I am guessing Unicode.

    "Many HTML5 applications need more than just a browser \x96 they need ..."

The sqlite connection does not mind and ignores them, but MySQL is sensitive. I will develop and workaround for this issue.

- David


From: Reyna, David
Sent: Tuesday, May 01, 2018 12:10 AM
To: 'Ryan McClelland'; toaster@yoctoproject.org
Cc: Scott Rifenbark
Subject: RE: [Toaster] django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")

OK, I see the same error now, sorry.

I got a silent error after my first pass. Once I dropped the table and repeated the steps, I hit the error.

I will debug. FYI, this host is indeed 16.04.

Thanks,
David

From: Ryan McClelland [mailto:Ryan.McClelland@apollovideo.com]
Sent: Monday, April 30, 2018 2:06 PM
To: Reyna, David; toaster@yoctoproject.org
Cc: Scott Rifenbark
Subject: RE: [Toaster] django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")

Hi David,

I'm still running into that same issue with "django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")" even with that command.

Are you also running Ubuntu 16.04.04 LTS?

Ryan McClelland
Firmware Engineer
Apollo Video Technology
Tel: 425-483-7100 x 229 / Fax: 425-483-7200
Toll Free: 888-AVT-USA1 x 229
www.apollovideo.com

________________________________
From: Reyna, David <david.reyna@windriver.com>
Sent: Sunday, April 29, 2018 4:17:38 AM
To: Ryan McClelland; toaster@yoctoproject.org
Cc: Scott Rifenbark
Subject: RE: [Toaster] django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")

Hi Ryan,

The correct command is this:

  $ TOASTER_DIR=`pwd` TEMPLATECONF='poky' ./bitbake/lib/toaster/manage.py checksettings

I am now on to step seven, setting up the Apache server.

- David

From: toaster-bounces@yoctoproject.org [mailto:toaster-bounces@yoctoproject.org] On Behalf Of Ryan McClelland
Sent: Wednesday, April 25, 2018 2:59 PM
To: toaster@yoctoproject.org
Subject: [Toaster] django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")

Hello,

I am following the instructions here for setting up a production server for toaster: https://www.yoctoproject.org/docs/latest/toaster-manual/toaster-manual.html
I am getting this error that looks related to the MySQL datasetup with Django.

What can cause this?
I have copy and pasted all the steps below, and the error is at the bottom.

I am running Ubuntu 16.04.04 LTS Desktop.

______________________________________________________

firmwarevmlinux@firmwarevmlinux-VirtualBox:~$ sudo apt-get install apache2 libapache2-mod-wsgi-py3 mysql-server python3-pip libmysqlclient-dev
[sudo] password for firmwarevmlinux:
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following additional packages will be installed:
  apache2-bin apache2-data apache2-utils libaio1 libapr1 libaprutil1
  libaprutil1-dbd-sqlite3 libaprutil1-ldap libevent-core-2.0-5 libexpat1-dev
  libhtml-template-perl liblua5.1-0 libmysqlclient20 libpython3-dev
  libpython3.5-dev mysql-client-5.7 mysql-client-core-5.7 mysql-common
  mysql-server-5.7 mysql-server-core-5.7 python-pip-whl python3-dev
  python3-setuptools python3-wheel python3.5-dev zlib1g-dev
Suggested packages:
  apache2-doc apache2-suexec-pristine | apache2-suexec-custom
  libipc-sharedcache-perl mailx tinyca python-setuptools-doc
The following NEW packages will be installed:
  apache2 apache2-bin apache2-data apache2-utils libaio1
  libapache2-mod-wsgi-py3 libapr1 libaprutil1 libaprutil1-dbd-sqlite3
  libaprutil1-ldap libevent-core-2.0-5 libexpat1-dev libhtml-template-perl
  liblua5.1-0 libmysqlclient-dev libmysqlclient20 libpython3-dev
  libpython3.5-dev mysql-client-5.7 mysql-client-core-5.7 mysql-common
  mysql-server mysql-server-5.7 mysql-server-core-5.7 python-pip-whl
  python3-dev python3-pip python3-setuptools python3-wheel python3.5-dev
  zlib1g-dev
0 upgraded, 31 newly installed, 0 to remove and 120 not upgraded.
Need to get 61.1 MB of archives.
After this operation, 236 MB of additional disk space will be used.
Do you want to continue? [Y/n]
Get:1 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 libapr1 amd64 1.5.2-3 [86.0 kB]
Get:2 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 libaprutil1 amd64 1.5.4-1build1 [77.1 kB]
Get:3 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 libaprutil1-dbd-sqlite3 amd64 1.5.4-1build1 [10.6 kB]
Get:4 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 libaprutil1-ldap amd64 1.5.4-1build1 [8,720 B]
Get:5 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 liblua5.1-0 amd64 5.1.5-8ubuntu1 [102 kB]
Get:6 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 apache2-bin amd64 2.4.18-2ubuntu3.8 [926 kB]
Get:7 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 apache2-utils amd64 2.4.18-2ubuntu3.8 [82.0 kB]
Get:8 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 apache2-data all 2.4.18-2ubuntu3.8 [162 kB]
Get:9 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 apache2 amd64 2.4.18-2ubuntu3.8 [86.8 kB]
Get:10 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-common all 5.7.22-0ubuntu0.16.04.1 [15.4 kB]
Get:11 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 libaio1 amd64 0.3.110-2 [6,356 B]
Get:12 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-client-core-5.7 amd64 5.7.22-0ubuntu0.16.04.1 [6,425 kB]
Get:13 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-client-5.7 amd64 5.7.22-0ubuntu0.16.04.1 [1,673 kB]
Get:14 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server-core-5.7 amd64 5.7.22-0ubuntu0.16.04.1 [7,268 kB]
Get:15 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 libevent-core-2.0-5 amd64 2.0.21-stable-2ubuntu0.16.04.1 [70.6 kB]
Get:16 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server-5.7 amd64 5.7.22-0ubuntu0.16.04.1 [2,583 kB]
Get:17 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 libapache2-mod-wsgi-py3 amd64 4.3.0-1.1build1 [78.6 kB]
Get:18 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 libexpat1-dev amd64 2.1.0-7ubuntu0.16.04.3 [115 kB]
Get:19 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 libhtml-template-perl all 2.95-2 [60.4 kB]
Get:20 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 libmysqlclient20 amd64 5.7.22-0ubuntu0.16.04.1 [809 kB]
Get:21 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 zlib1g-dev amd64 1:1.2.8.dfsg-2ubuntu4.1 [168 kB]
Get:22 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 libmysqlclient-dev amd64 5.7.22-0ubuntu0.16.04.1 [1,159 kB]
Get:23 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 libpython3.5-dev amd64 3.5.2-2ubuntu0~16.04.4 [37.3 MB]
Get:24 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 libpython3-dev amd64 3.5.1-3 [6,926 B]
Get:25 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 mysql-server all 5.7.22-0ubuntu0.16.04.1 [10.8 kB]
Get:26 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 python-pip-whl all 8.1.1-2ubuntu0.4 [1,110 kB]
Get:27 http://us.archive.ubuntu.com/ubuntu xenial-updates/main amd64 python3.5-dev amd64 3.5.2-2ubuntu0~16.04.4 [413 kB]
Get:28 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 python3-dev amd64 3.5.1-3 [1,186 B]
Get:29 http://us.archive.ubuntu.com/ubuntu xenial-updates/universe amd64 python3-pip all 8.1.1-2ubuntu0.4 [109 kB]
Get:30 http://us.archive.ubuntu.com/ubuntu xenial/main amd64 python3-setuptools all 20.7.0-1 [88.0 kB]
Get:31 http://us.archive.ubuntu.com/ubuntu xenial/universe amd64 python3-wheel all 0.29.0-1 [48.1 kB]
Fetched 61.1 MB in 43s (1,396 kB/s)
Extracting templates from packages: 100%
Preconfiguring packages ...
Selecting previously unselected package libapr1:amd64.
(Reading database ... 177255 files and directories currently installed.)
Preparing to unpack .../libapr1_1.5.2-3_amd64.deb ...
Unpacking libapr1:amd64 (1.5.2-3) ...
Selecting previously unselected package libaprutil1:amd64.
Preparing to unpack .../libaprutil1_1.5.4-1build1_amd64.deb ...
Unpacking libaprutil1:amd64 (1.5.4-1build1) ...
Selecting previously unselected package libaprutil1-dbd-sqlite3:amd64.
Preparing to unpack .../libaprutil1-dbd-sqlite3_1.5.4-1build1_amd64.deb ...
Unpacking libaprutil1-dbd-sqlite3:amd64 (1.5.4-1build1) ...
Selecting previously unselected package libaprutil1-ldap:amd64.
Preparing to unpack .../libaprutil1-ldap_1.5.4-1build1_amd64.deb ...
Unpacking libaprutil1-ldap:amd64 (1.5.4-1build1) ...
Selecting previously unselected package liblua5.1-0:amd64.
Preparing to unpack .../liblua5.1-0_5.1.5-8ubuntu1_amd64.deb ...
Unpacking liblua5.1-0:amd64 (5.1.5-8ubuntu1) ...
Selecting previously unselected package apache2-bin.
Preparing to unpack .../apache2-bin_2.4.18-2ubuntu3.8_amd64.deb ...
Unpacking apache2-bin (2.4.18-2ubuntu3.8) ...
Selecting previously unselected package apache2-utils.
Preparing to unpack .../apache2-utils_2.4.18-2ubuntu3.8_amd64.deb ...
Unpacking apache2-utils (2.4.18-2ubuntu3.8) ...
Selecting previously unselected package apache2-data.
Preparing to unpack .../apache2-data_2.4.18-2ubuntu3.8_all.deb ...
Unpacking apache2-data (2.4.18-2ubuntu3.8) ...
Selecting previously unselected package apache2.
Preparing to unpack .../apache2_2.4.18-2ubuntu3.8_amd64.deb ...
Unpacking apache2 (2.4.18-2ubuntu3.8) ...
Selecting previously unselected package mysql-common.
Preparing to unpack .../mysql-common_5.7.22-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-common (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package libaio1:amd64.
Preparing to unpack .../libaio1_0.3.110-2_amd64.deb ...
Unpacking libaio1:amd64 (0.3.110-2) ...
Selecting previously unselected package mysql-client-core-5.7.
Preparing to unpack .../mysql-client-core-5.7_5.7.22-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-client-core-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-client-5.7.
Preparing to unpack .../mysql-client-5.7_5.7.22-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-client-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-server-core-5.7.
Preparing to unpack .../mysql-server-core-5.7_5.7.22-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-server-core-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package libevent-core-2.0-5:amd64.
Preparing to unpack .../libevent-core-2.0-5_2.0.21-stable-2ubuntu0.16.04.1_amd64.deb ...
Unpacking libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...
Processing triggers for libc-bin (2.23-0ubuntu10) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for ufw (0.35-0ubuntu2) ...
Processing triggers for systemd (229-4ubuntu21.1) ...
Processing triggers for ureadahead (0.100.0-19) ...
Setting up mysql-common (5.7.22-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-5.7.
(Reading database ... 178105 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.22-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package libapache2-mod-wsgi-py3.
Preparing to unpack .../libapache2-mod-wsgi-py3_4.3.0-1.1build1_amd64.deb ...
Unpacking libapache2-mod-wsgi-py3 (4.3.0-1.1build1) ...
Selecting previously unselected package libexpat1-dev:amd64.
Preparing to unpack .../libexpat1-dev_2.1.0-7ubuntu0.16.04.3_amd64.deb ...
Unpacking libexpat1-dev:amd64 (2.1.0-7ubuntu0.16.04.3) ...
Selecting previously unselected package libhtml-template-perl.
Preparing to unpack .../libhtml-template-perl_2.95-2_all.deb ...
Unpacking libhtml-template-perl (2.95-2) ...
Selecting previously unselected package libmysqlclient20:amd64.
Preparing to unpack .../libmysqlclient20_5.7.22-0ubuntu0.16.04.1_amd64.deb ...
Unpacking libmysqlclient20:amd64 (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package zlib1g-dev:amd64.
Preparing to unpack .../zlib1g-dev_1%3a1.2.8.dfsg-2ubuntu4.1_amd64.deb ...
Unpacking zlib1g-dev:amd64 (1:1.2.8.dfsg-2ubuntu4.1) ...
Selecting previously unselected package libmysqlclient-dev.
Preparing to unpack .../libmysqlclient-dev_5.7.22-0ubuntu0.16.04.1_amd64.deb ...
Unpacking libmysqlclient-dev (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package libpython3.5-dev:amd64.
Preparing to unpack .../libpython3.5-dev_3.5.2-2ubuntu0~16.04.4_amd64.deb ...
Unpacking libpython3.5-dev:amd64 (3.5.2-2ubuntu0~16.04.4) ...
Selecting previously unselected package libpython3-dev:amd64.
Preparing to unpack .../libpython3-dev_3.5.1-3_amd64.deb ...
Unpacking libpython3-dev:amd64 (3.5.1-3) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.22-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-server (5.7.22-0ubuntu0.16.04.1) ...
Selecting previously unselected package python-pip-whl.
Preparing to unpack .../python-pip-whl_8.1.1-2ubuntu0.4_all.deb ...
Unpacking python-pip-whl (8.1.1-2ubuntu0.4) ...
Selecting previously unselected package python3.5-dev.
Preparing to unpack .../python3.5-dev_3.5.2-2ubuntu0~16.04.4_amd64.deb ...
Unpacking python3.5-dev (3.5.2-2ubuntu0~16.04.4) ...
Selecting previously unselected package python3-dev.
Preparing to unpack .../python3-dev_3.5.1-3_amd64.deb ...
Unpacking python3-dev (3.5.1-3) ...
Selecting previously unselected package python3-pip.
Preparing to unpack .../python3-pip_8.1.1-2ubuntu0.4_all.deb ...
Unpacking python3-pip (8.1.1-2ubuntu0.4) ...
Selecting previously unselected package python3-setuptools.
Preparing to unpack .../python3-setuptools_20.7.0-1_all.deb ...
Unpacking python3-setuptools (20.7.0-1) ...
Selecting previously unselected package python3-wheel.
Preparing to unpack .../python3-wheel_0.29.0-1_all.deb ...
Unpacking python3-wheel (0.29.0-1) ...
Processing triggers for man-db (2.7.5-1) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for systemd (229-4ubuntu21.1) ...
Processing triggers for doc-base (0.10.7) ...
Processing 1 added doc-base file...
Processing triggers for libc-bin (2.23-0ubuntu10) ...
Setting up libapr1:amd64 (1.5.2-3) ...
Setting up libaprutil1:amd64 (1.5.4-1build1) ...
Setting up libaprutil1-dbd-sqlite3:amd64 (1.5.4-1build1) ...
Setting up libaprutil1-ldap:amd64 (1.5.4-1build1) ...
Setting up liblua5.1-0:amd64 (5.1.5-8ubuntu1) ...
Setting up apache2-bin (2.4.18-2ubuntu3.8) ...
Setting up apache2-utils (2.4.18-2ubuntu3.8) ...
Setting up apache2-data (2.4.18-2ubuntu3.8) ...
Setting up apache2 (2.4.18-2ubuntu3.8) ...
Enabling module mpm_event.
Enabling module authz_core.
Enabling module authz_host.
Enabling module authn_core.
Enabling module auth_basic.
Enabling module access_compat.
Enabling module authn_file.
Enabling module authz_user.
Enabling module alias.
Enabling module dir.
Enabling module autoindex.
Enabling module env.
Enabling module mime.
Enabling module negotiation.
Enabling module setenvif.
Enabling module filter.
Enabling module deflate.
Enabling module status.
Enabling conf charset.
Enabling conf localized-error-pages.
Enabling conf other-vhosts-access-log.
Enabling conf security.
Enabling conf serve-cgi-bin.
Enabling site 000-default.
Setting up libaio1:amd64 (0.3.110-2) ...
Setting up mysql-client-core-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Setting up mysql-client-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Setting up mysql-server-core-5.7 (5.7.22-0ubuntu0.16.04.1) ...
Setting up libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...
Setting up mysql-server-5.7 (5.7.22-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
Setting up libapache2-mod-wsgi-py3 (4.3.0-1.1build1) ...
apache2_invoke: Enable module wsgi
Setting up libexpat1-dev:amd64 (2.1.0-7ubuntu0.16.04.3) ...
Setting up libhtml-template-perl (2.95-2) ...
Setting up libmysqlclient20:amd64 (5.7.22-0ubuntu0.16.04.1) ...
Setting up zlib1g-dev:amd64 (1:1.2.8.dfsg-2ubuntu4.1) ...
Setting up libmysqlclient-dev (5.7.22-0ubuntu0.16.04.1) ...
Setting up libpython3.5-dev:amd64 (3.5.2-2ubuntu0~16.04.4) ...
Setting up libpython3-dev:amd64 (3.5.1-3) ...
Setting up mysql-server (5.7.22-0ubuntu0.16.04.1) ...
Setting up python-pip-whl (8.1.1-2ubuntu0.4) ...
Setting up python3.5-dev (3.5.2-2ubuntu0~16.04.4) ...
Setting up python3-dev (3.5.1-3) ...
Setting up python3-pip (8.1.1-2ubuntu0.4) ...
Setting up python3-setuptools (20.7.0-1) ...
Setting up python3-wheel (0.29.0-1) ...
Processing triggers for libc-bin (2.23-0ubuntu10) ...
Processing triggers for systemd (229-4ubuntu21.1) ...
Processing triggers for ureadahead (0.100.0-19) ...
Processing triggers for ufw (0.35-0ubuntu2) ...
firmwarevmlinux@firmwarevmlinux-VirtualBox:~$ sudo /usr/sbin/useradd toaster -md /var/www/toaster -s /bin/false
firmwarevmlinux@firmwarevmlinux-VirtualBox:~$ sudo su - toaster -s /bin/bash
toaster@firmwarevmlinux-VirtualBox:~$
toaster@firmwarevmlinux-VirtualBox:~$ git clone git://git.yoctoproject.org/poky
The program 'git' is currently not installed. To run 'git' please ask your administrator to install the package 'git'
toaster@firmwarevmlinux-VirtualBox:~$ sudo apt install git
[sudo] password for toaster:
Sorry, try again.
[sudo] password for toaster:
sudo: 1 incorrect password attempt
toaster@firmwarevmlinux-VirtualBox:~$ sudo apt install git
[sudo] password for toaster:
toaster@firmwarevmlinux-VirtualBox:~$ git clone git://git.yoctoproject.org/poky
Cloning into 'poky'...
remote: Counting objects: 400904, done.
remote: Compressing objects: 100% (95421/95421), done.
remote: Total 400904 (delta 298922), reused 400608 (delta 298626)
Receiving objects: 100% (400904/400904), 145.04 MiB | 8.01 MiB/s, done.
Resolving deltas: 100% (298922/298922), done.
Checking connectivity... done.
toaster@firmwarevmlinux-VirtualBox:~$ git checkout sumo
fatal: Not a git repository (or any of the parent directories): .git
toaster@firmwarevmlinux-VirtualBox:~$ cd poky/
toaster@firmwarevmlinux-VirtualBox:~/poky$ git checkout sumo
Branch sumo set up to track remote branch sumo from origin.
Switched to a new branch 'sumo'
toaster@firmwarevmlinux-VirtualBox:~/poky$
toaster@firmwarevmlinux-VirtualBox:~/poky$ cd /var/www/toaster/
toaster@firmwarevmlinux-VirtualBox:~$
toaster@firmwarevmlinux-VirtualBox:~$ pip3 install --user -r ./poky/bitbake/toaster-requirements.txt
Collecting Django<1.11.9,>1.8 (from -r ./poky/bitbake/toaster-requirements.txt (line 1))
  Downloading https://files.pythonhosted.org/packages/7e/36/5266e0c51ee9b953d60ea8ea1fea10e268b1368f9c0ad08e2ff76ee9c1b5/Django-1.11.8-py2.py3-none-any.whl (6.9MB)
    100% |████████████████████████████████| 7.0MB 233kB/s
Collecting beautifulsoup4>=4.4.0 (from -r ./poky/bitbake/toaster-requirements.txt (line 2))
  Downloading https://files.pythonhosted.org/packages/9e/d4/10f46e5cfac773e22707237bfcd51bbffeaf0a576b0a847ec7ab15bd7ace/beautifulsoup4-4.6.0-py3-none-any.whl (86kB)
    100% |████████████████████████████████| 92kB 10.5MB/s
Collecting pytz (from -r ./poky/bitbake/toaster-requirements.txt (line 3))
  Downloading https://files.pythonhosted.org/packages/dc/83/15f7833b70d3e067ca91467ca245bae0f6fe56ddc7451aa0dc5606b120f2/pytz-2018.4-py2.py3-none-any.whl (510kB)
    100% |████████████████████████████████| 512kB 3.1MB/s
Installing collected packages: pytz, Django, beautifulsoup4
Successfully installed Django beautifulsoup4-4.4.1 pytz
You are using pip version 8.1.1, however version 10.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
toaster@firmwarevmlinux-VirtualBox:~$ pip3 install --user mysqlclient
Collecting mysqlclient
  Downloading https://files.pythonhosted.org/packages/6f/86/bad31f1c1bb0cc99e88ca2adb7cb5c71f7a6540c1bb001480513de76a931/mysqlclient-1.3.12.tar.gz (89kB)
    100% |████████████████████████████████| 92kB 6.0MB/s
Building wheels for collected packages: mysqlclient
  Running setup.py bdist_wheel for mysqlclient ... done
  Stored in directory: /var/www/toaster/.cache/pip/wheels/50/c7/31/81a516762c8e9324f2b1fdffc1e84b9f07224fe3707956f6e1
Successfully built mysqlclient
Installing collected packages: mysqlclient
Successfully installed mysqlclient-1.3.12
You are using pip version 8.1.1, however version 10.0.1 is available.
You should consider upgrading via the 'pip install --upgrade pip' command.
toaster@firmwarevmlinux-VirtualBox:~$ nano /var/www/toaster/poky/bitbake/lib/toaster/toastermain/settings
toaster@firmwarevmlinux-VirtualBox:~$ nano /var/www/toaster/poky/bitbake/lib/toaster/toastermain/settings.py
toaster@firmwarevmlinux-VirtualBox:~$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
toaster@firmwarevmlinux-VirtualBox:~$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.22-0ubuntu0.16.04.1 (Ubuntu)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE DATABASE toaster_data;
Query OK, 1 row affected (0.00 sec)

mysql> CREATE USER 'toaster'@'localhost' identified by 'apollo';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT all on toaster_data.* to 'toaster'@'localhost';
Query OK, 0 rows affected (0.02 sec)

mysql> quit;
Bye
toaster@firmwarevmlinux-VirtualBox:~$ cd  /var/www/toaster/poky/
toaster@firmwarevmlinux-VirtualBox:~/poky$ ./bitbake/lib/toaster/manage.py migrate
Operations to perform:
  Apply all migrations: admin, auth, bldcontrol, contenttypes, orm, sessions
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial... OK
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying contenttypes.0002_remove_content_type_name... OK
  Applying auth.0002_alter_permission_name_max_length... OK
  Applying auth.0003_alter_user_email_max_length... OK
  Applying auth.0004_alter_user_username_opts... OK
  Applying auth.0005_alter_user_last_login_null... OK
  Applying auth.0006_require_contenttypes_0002... OK
  Applying auth.0007_alter_validators_add_error_messages... OK
  Applying auth.0008_alter_user_username_max_length... OK
  Applying orm.0001_initial... OK
  Applying bldcontrol.0001_initial... OK
  Applying bldcontrol.0002_auto_20160120_1250... OK
  Applying bldcontrol.0003_add_cancelling_state... OK
  Applying bldcontrol.0004_auto_20160523_1446... OK
  Applying bldcontrol.0005_reorder_buildrequest_states... OK
  Applying bldcontrol.0006_brlayer_local_source_dir... OK
  Applying bldcontrol.0007_brlayers_optional_gitinfo... OK
  Applying orm.0002_customimagerecipe... OK
  Applying orm.0003_customimagepackage... OK
  Applying orm.0004_provides... OK
  Applying orm.0005_task_field_separation... OK
  Applying orm.0006_add_cancelled_state... OK
  Applying orm.0007_auto_20160523_1446... OK
  Applying orm.0008_refactor_artifact_models... OK
  Applying orm.0009_target_package_manifest_path... OK
  Applying orm.0010_delete_layer_source_references... OK
  Applying orm.0011_delete_layersource... OK
  Applying orm.0012_use_release_instead_of_up_branch...Converting all layer version up_branches to releases
OK
  Applying orm.0013_recipe_parse_progress_fields... OK
  Applying orm.0014_allow_empty_buildname... OK
  Applying orm.0015_layer_local_source_dir... OK
  Applying orm.0016_clone_progress... OK
  Applying orm.0017_distro_clone... OK
  Applying sessions.0001_initial... OK

toaster@firmwarevmlinux-VirtualBox:~/poky$ TOASTER_DIR=`pwd` TOASTER_CONF=./meta-poky/conf/toasterconf.json \
>      ./bitbake/lib/toaster/manage.py checksettings

Build configuration saved
Loading default settings
Installed 7 object(s) from 1 fixture(s)
Loading OE-Core configuration
Installed 12 object(s) from 1 fixture(s)
TEMPLATECONF not found. You may have to manually configure layer paths
Please enter the path of your openembedded-core layer:
Importing custom settings if present
NOTE: optional fixture 'custom' not found

Fetching information from the layer index, please wait.
You can re-update any time later by running bitbake/lib/toaster/manage.py lsupdates

/2018-04-25 14:49:22,827 INFO Fetching metadata releases for rocko HEAD master
Updating Releases 100%
2018-04-25 14:49:23,001 INFO Fetching layers
Updating layers 42%Failure while trying to setup toaster: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")
Traceback (most recent call last):
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 101, in execute
    return self.cursor.execute(query, args)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 247, in execute
    res = self._query(query)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 411, in _query
    rowcount = self._do_query(q)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 374, in _do_query
    db.query(q)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/connections.py", line 277, in query
    _mysql.connection.query(self, query)
_mysql_exceptions.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/var/www/toaster/poky/bitbake/lib/toaster/bldcontrol/management/commands/checksettings.py", line 120, in _verify_be
    call_command("lsupdates")
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/core/management/__init__.py", line 131, in call_command
    return command.execute(*args, **defaults)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/core/management/base.py", line 330, in execute
    output = self.handle(*args, **options)
  File "/var/www/toaster/poky/bitbake/lib/toaster/orm/management/commands/lsupdates.py", line 337, in handle
    self.update()
  File "/var/www/toaster/poky/bitbake/lib/toaster/orm/management/commands/lsupdates.py", line 175, in update
    l.save()
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/models/base.py", line 808, in save
    force_update=force_update, update_fields=update_fields)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/models/base.py", line 838, in save_base
    updated = self._save_table(raw, cls, force_insert, force_update, using, update_fields)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/models/base.py", line 905, in _save_table
    forced_update)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/models/base.py", line 955, in _do_update
    return filtered._update(values) > 0
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/models/query.py", line 664, in _update
    return query.get_compiler(self.db).execute_sql(CURSOR)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 1204, in execute_sql
    cursor = super(SQLUpdateCompiler, self).execute_sql(result_type)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 899, in execute_sql
    raise original_exception
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 889, in execute_sql
    cursor.execute(sql, params)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/backends/utils.py", line 79, in execute
    return super(CursorDebugWrapper, self).execute(sql, params)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/utils.py", line 94, in __exit__
    six.reraise(dj_exc_type, dj_exc_value, traceback)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/utils/six.py", line 685, in reraise
    raise value.with_traceback(tb)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/backends/utils.py", line 64, in execute
    return self.cursor.execute(sql, params)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 101, in execute
    return self.cursor.execute(query, args)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 250, in execute
    self.errorhandler(self, exc, value)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/connections.py", line 50, in defaulterrorhandler
    raise errorvalue
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 247, in execute
    res = self._query(query)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 411, in _query
    rowcount = self._do_query(q)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/cursors.py", line 374, in _do_query
    db.query(q)
  File "/var/www/toaster/.local/lib/python3.5/site-packages/MySQLdb/connections.py", line 277, in query
    _mysql.connection.query(self, query)
django.db.utils.OperationalError: (1366, "Incorrect string value: '\\xC2\\x96 the...' for column 'description' at row 1")
CONFIDENTIALITY NOTICE: This message (including any attachments) transmitted by Apollo Video Technology contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should notify the sender, delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.
CONFIDENTIALITY NOTICE: This message (including any attachments) transmitted by Apollo Video Technology contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should notify the sender, delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited.

[-- Attachment #2: Type: text/html, Size: 63851 bytes --]