2018年2月17日 星期六

Downloading SDK Platform Android 8.1.0, API 27, revision 1 Download finished with wrong size. Expected 65606517 bytes, got 65738431 byt

Ref:https://stackoverflow.com/questions/47719420/sdk-platform-android-8-1-0-cant-download

1. copy
C:\Program Files (x86)\Android\android-sdk\temp\platform-27_r01.zip
2. unzip platform-27_r01.zip
3. md C:\Program Files (x86)\Android\android-sdk\platforms\android-27
4. copy all files into android-27

Test android simulator by visual studio 2017 and then
tns run android == > OK

2018年2月7日 星期三

docker mysql utf8

Ref:https://github.com/docker-library/docs/blob/93eaf4f47c52c4b65d1cd31a5dcaa257848e5f13/mysql/README.md#configuration-without-a-cnf-file

ASUS X450J / Windows 10 /  Docker version 17.12.0-ce, build c97c6d6

1. Excel file save quiz1.csv and re-save as utf-8
cols.
id, Ans, QS, A1, A2, A3, A4, IM1, OK1
2.
docker run --name mysql2 -e MYSQL_ROOT_PASSWORD=password -d mysql --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
3. copy quiz1.csv into container
docker cp quiz1.csv acc:/var/lib/mysql-files/quiz1.csv
4. Chrome MySQL Admin
5.
CREATE DATABASE quizs;
use quizs;
6.
CREATE TABLE quiz1 (id INT);
ALTER TABLE quiz1 ADD COLUMN Ans INT;
ALTER TABLE quiz1 ADD COLUMN QS VARCHAR(512);
ALTER TABLE quiz1 ADD COLUMN A1 VARCHAR(256);
ALTER TABLE quiz1 ADD COLUMN A2 VARCHAR(256);
ALTER TABLE quiz1 ADD COLUMN A3 VARCHAR(256);
ALTER TABLE quiz1 ADD COLUMN A4 VARCHAR(256);
ALTER TABLE quiz1 ADD COLUMN IM1 VARCHAR(256);
ALTER TABLE quiz1 ADD COLUMN OK1 VARCHAR(256);
7. Import data
LOAD DATA INFILE '/var/lib/mysql-files/quiz1.csv'
INTO TABLE quiz1
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;
8. C# code
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace newMySQL
{
    using System.Data;
    using MySql.Data.MySqlClient;
    class Program
    {
        static void Main(string[] args)
        {
            string 連線字串 = "Server=localhost;Database=quizs;Uid=root;pwd=password;";
            MySqlConnection 連線物件 = new MySqlConnection(連線字串);
            DataTable 資料表 = new DataTable();
            string SQL = "Select * From quiz1";
            連線物件.Open();
            MySqlDataAdapter 配接器 = new MySqlDataAdapter(SQL, 連線物件);
            配接器.Fill(資料表);
            連線物件.Close();
            //Console.WriteLine(資料表.Rows.Count);
            for (int i=0; i<資料表.Rows.Count; i++)
            {
                for (int j=0; j<8; j++)
                Console.Write(資料表.Rows[i].ItemArray[j].ToString());

                Console.WriteLine();
            }
            Console.ReadLine();
        }
    }
}
9. Results



docker Error: driver failed programming external connectivity on endpoint

Ref: https://github.com/docker/for-win/issues/573
ASUS X450J / Windows 10 /  Docker version 17.12.0-ce, build c97c6d6


1.  docker run --name mysql1 -e MYSQL_ROOT_PASSWORD=mypassword -d -p 3306:3306 mysql
fail:
C:\Program Files\Docker\Docker\Resources\bin\docker.exe: Error response from daemon: driver failed programming external
connectivity on endpoint mysql1 (571b7c68da7b048831e01138e6d0aa39ca571dbb0914c1d950ab2b1b1ff2001a): Error starting userl
and proxy: mkdir /port/tcp:0.0.0.0:3306:tcp:172.17.0.2:3306: input/output error.

2. Restart docker can solve the problem.



2017年7月31日 星期一

Fast Style Transfer in TensorFlow

Ref: https://github.com/lengstrom/fast-style-transfer

Windows 10 x64 @ ASUS X450J
1. Install tensorflow (ref: https://www.tensorflow.org/install/install_windows)
1-1 c:\conda create -n tensorflow python=3.5
1-2 activate tensorflow
1-3 pip install --ignore-installed --upgrade https://storage.googleapis.com/tensorflow/windows/cpu/tensorflow-1.2.1-cp35-cp35m-win_amd64.whl

--- nstall the CPU-only version of TensorFlow

2. python evaluate.py --checkpoint udnie.ckpt --in-path INimgs --out-path OUTimgs
2-1 error no module for scipy
2-1-1 download scipy-0.19.1-cp35-cp35m-win_amd64.whl (http://www.lfd.uci.edu/~gohlke/pythonlibs/)
2-1-2 pip install scipy-0.19.1-cp35-cp35m-win_amd64.whl

2-2 ImportError: cannot import name 'NUMPY_MKL'
2-2-1 download numpy-1.13.1+mkl-cp35-cp35m-win_amd64.whl
2-2-2 pip install numpy-1.13.1+mkl-cp35-cp35m-win_amd64.whl

2-3 AttributeError: module 'scipy.misc' has no attribute 'imread'
2-3-1 download Pillow-4.2.1-cp35-cp35m-win_amd64.whl
2-3-2 pip install Pillow-4.2.1-cp35-cp35m-win_amd64.whl

2-4  'Resize images or use --allow-different-dimensions.'

3. Download udnie.ckpt (https://drive.google.com/drive/folders/0B9jhaT37ydSyRk9UX0wwX3BpMzQ)

4. python evaluate.py --checkpoint udnie.ckpt --in-path INimgs --out-path OUTimgs --allow-different-dimensions




5. Results

6. python transform_video.py --in-path INimgs/joy.mp4 --checkpoint udnie.ckpt --out-path OUTimgs/joy.mp4

fail due to lack of ffmpeg

6.1 Install ffmpeg

6.2 OK. 


2017年6月30日 星期五

Docker NETCore Application Created by Visual Studio 2017

REF:http://kevintsengtw.blogspot.tw/2016/11/docker-for-windows-aspnet-core-part1.html

 Visual Studio 2017/
PS C:\Windows\system32> docker version
Client:
 Version:      17.06.0-ce
 API version:  1.30
 Go version:   go1.8.3
 Git commit:   02c1d87
 Built:        Fri Jun 23 21:30:30 2017
 OS/Arch:      windows/amd64

Server:
 Version:      17.06.0-ce
 API version:  1.30 (minimum version 1.12)
 Go version:   go1.8.3
 Git commit:   02c1d87
 Built:        Fri Jun 23 21:51:55 2017
 OS/Arch:      linux/amd64
 Experimental: true

1. VS2017 open new NETCore WebApplication (Enable for Docker)
2. Share C:\ ??

3.Enable app
4. Show web app


5.Check Container

6.Close VS2017 project/ Web App (Container) is still running

7. Run image created by VS 2017
7-1 Build project in release mode
7-2 The images file will be shown xxxx:latest rather than xxxx:dev. The late is created by debug mode.
7-3 docker run -d -p 1234:80 --name app1 webapplication1:latest

8. The container will be down when the VS 2017 project was stop. The container will be working as that by debug mode.




2017年6月26日 星期一

docker php hello world


Ref: http://mmenozzi.github.io/2016/01/22/php-web-development-with-docker/
1. docker run -p 80:80 webgriffe/php-apache-base
2. Test w3school php tutorials

3. Test file upload example (confirm FileUpload enable)

3-1 prepare ex5.php and upload.php
3-2 login container
       docker exec -it #ID /bin/bash
       mkdir uploads   (@ /var/www/html)
       chmod 777 upload
3-3 test ex5.php
<!DOCTYPE html>
<html>
<body>

<form action="upload.php" method="post" enctype="multipart/form-data">
    Select image to upload:
    <input type="file" name="fileToUpload" id="fileToUpload">
    <input type="submit" value="Upload Image" name="submit">
</form>

</body>
</html>

     




Fail---
Ref: https://github.com/rmuch/docker-php-hello-world


1, git clone https://github.com/rmuch/docker-php-hello-world.git
2. docker build -t docker-php-hello-world .
3.

2017年6月23日 星期五

gitlab in docker

Ref:https://jigsawye.com/2015/09/25/gitlab-ce-in-docker/   (A student provided)

1. docker pull sameersbn/gitlab:8.0.2
2. docker run --name gitlab-postgresql -d --env 'DB_NAME=gitlabhq_production' --env 'DB_USER=gitlab' --env 'DB_PASS=password' --volume /srv/docker/gitlab/postgresql:/var/lib/postgresql sameersbn/postgresql:9.4-3

3. docker run --name gitlab-redis -d --volume /srv/docker/gitlab/redis:/var/lib/redis sameersbn/redis:latest

4. docker run --name gitlab -d --link gitlab-postgresql:postgresql --link gitlab-redis:redisio --publish 10022:22 --publish 10080:80 --env 'GITLAB_HOST=your-gitlab-ip' --env 'GITLAB_PORT=10080' --env 'GITLAB_SSH_PORT=10022' --env 'GITLAB_SECRETS_DB_KEY_BASE=long-and-random-alpha-numeric-string' --volume /srv/docker/gitlab/gitlab:/home/git/data sameersbn/gitlab:8.0.2

打開瀏覽器瀏覽 http://localhost:10080,就可以看到 Gitlab 架設好了,輸入預設的帳號密碼就可以直接登入:

username: root
password: 5iveL!fe