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月17日 星期六
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
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.
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
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:\ ??
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-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
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
訂閱:
文章 (Atom)












