[git] git server & git command

http://toyroom.bruceli.net/tw/2011/02/04/install-git-server-on-ubuntu-linux.html
https://git-scm.com/book/zh-tw/v1/%E4%BC%BA%E6%9C%8D%E5%99%A8%E4%B8%8A%E7%9A%84-Git-%E6%9E%B6%E8%A8%AD%E4%BC%BA%E6%9C%8D%E5%99%A8

[SQLITE] Compile SQLCipher in Android

Compile SQLCipher
Source: http://qiita.com/idaisuke/items/b4386705db7ec714f98a

My NDK version is r10d.

# export LIBRARY_PATH=/your/library/path

arm platform

# $NDK_ROOT/build/tools/make-standalone-toolchain.sh --arch=arm --install-dir=toolchain --platform=android-19

# HOST=arm-linux

# find toolchain/bin -name arm-linux-androideabi* -type f | while read FILE

do

  cp -f $FILE ${FILE%/*}/arm-linux${FILE##*-androideabi}

done

# cd src

# export PATH=$LIBRARY_PATH/SQLCipher/toolchain/bin:$PATH

armeabi

# ARCH=armv5

# PREFIX=$LIBRARY_PATH/SQLCipher/dest/armeabi

# OPENSSL_INCLUDE_PATH=$LIBRARY_PATH/OpenSSL/dest/armeabi/include

# OPENSSL_LIBRARY_PATH=$LIBRARY_PATH/OpenSSL/dest/armeabi/lib

# ./configure --prefix=$PREFIX -host=$HOST --enable-tempstore=yes --disable-tcl --disable-readline --with-pic CFLAGS="-DSQLITE_HAS_CODEC -DSQLITE_TEMP_STORE=2 -march=$ARCH -fPIE -I$OPENSSL_INCLUDE_PATH" LDFLAGS="-L$OPENSSL_LIBRARY_PATH"

# make clean && make && make install

armeabi-v7a

# ARCH=armv7-a

# PREFIX=$LIBRARY_PATH/SQLCipher/dest/armeabi-v7a

# OPENSSL_INCLUDE_PATH=$LIBRARY_PATH/OpenSSL/dest/armeabi-v7a/include

# OPENSSL_LIBRARY_PATH=$LIBRARY_PATH/OpenSSL/dest/armeabi-v7a/lib

# ./configure --prefix=$PREFIX -host=$HOST --enable-tempstore=yes --disable-tcl --disable-readline --with-pic CFLAGS="-DSQLITE_HAS_CODEC -DSQLITE_TEMP_STORE=2 -march=$ARCH -fPIE -I$OPENSSL_INCLUDE_PATH" LDFLAGS="-L$OPENSSL_LIBRARY_PATH"

# make clean && make && make install

x86 platform

# $NDK_ROOT/build/tools/make-standalone-toolchain.sh --arch=x86 --install-dir=toolchainx86 --platform=android-19

# HOST=i686-linux

# find toolchainx86/bin -name i686-linux-android* -type f | while read FILE

do

  cp -f $FILE ${FILE%/*}/i686-linux${FILE##*-android}

done

# cd src

# export PATH=$LIBRARY_PATH/SQLCipher/toolchainx86/bin:$PATH

x86

# ARCH=i386

# PREFIX=$LIBRARY_PATH/SQLCipher/dest/x86

# OPENSSL_INCLUDE_PATH=$LIBRARY_PATH/OpenSSL/dest/x86/include

# OPENSSL_LIBRARY_PATH=$LIBRARY_PATH/OpenSSL/dest/x86/lib

# ./configure --prefix=$PREFIX -host=$HOST --enable-tempstore=yes --disable-tcl --disable-readline CFLAGS="-DSQLITE_HAS_CODEC -DSQLITE_TEMP_STORE=2 -march=$ARCH -fPIE -fPIC -I$OPENSSL_INCLUDE_PATH" LDFLAGS="-L$OPENSSL_LIBRARY_PATH"

# make clean && make && make install

Add Android.mk

LOCAL_PATH := $(call my-dir)

include $(CLEAR_VARS)

LOCAL_EXPORT_C_INCLUDES := $(LOCAL_PATH)/$(TARGET_ARCH_ABI)/include/sqlcipher

LOCAL_MODULE := sqlcipher

LOCAL_SRC_FILES := $(TARGET_ARCH_ABI)/lib/libsqlcipher.a

include $(PREBUILT_STATIC_LIBRARY)

Modify Android.mk & Application.mk

Please follow the link: http://qiita.com/idaisuke/items/b4386705db7ec714f98a

Error fixed:

1. ErrMsg: ...external/curl/prebuilt/android/armeabi/libcurl.a(sha512-armv4.o): requires unsupported dynamic reloc R_ARM_REL32; recompile with -fPIC

http://discuss.cocos2d-x.org/t/android-cpp-test-compilation-error-solved/18348/3

[SQLITE] Compile OpenSSL in Android

Compile OpenSSL

Source: http://qiita.com/idaisuke/items/22e2ebc24812681cd61d

!!Note!! Have to upgrade OpenSSL with version higher than 1.02f/1.01r, otherwise has security issue.
https://support.google.com/faqs/answer/6376725

My NDK version is r10d.

# export LIBRARY_PATH=/your/library/path

ARM platform

# $NDK_ROOT/build/tools/make-standalone-toolchain.sh --arch=arm --install-dir=toolchain --platform=android-19

armeabi

# cd src

# export ANDROID_DEV=$NDK_ROOT/platforms/android-19/arch-arm/usr

# CROSS_COMPILE_PREFIX=$LIBRARY_PATH/OpenSSL/toolchain/bin/arm-linux-androideabi-

# PREFIX=$LIBRARY_PATH/OpenSSL/dest/armeabi

# ./Configure --prefix=$PREFIX --cross-compile-prefix=$CROSS_COMPILE_PREFIX android threads no-shared

# make -s && make install

armeabi-v7a

# PREFIX=$LIBRARY_PATH/OpenSSL/dest/armeabi-v7a

# make clean

# ./Configure --prefix=$PREFIX --cross-compile-prefix=$CROSS_COMPILE_PREFIX android-armv7 threads no-shared

# make -s && make install

x86 platform

# $NDK_ROOT/build/tools/make-standalone-toolchain.sh --arch=x86 --install-dir=toolchainx86 --platform=android-19

x86

# make clean

# export ANDROID_DEV=$NDK_ROOT/platforms/android-19/arch-x86/usr

# CROSS_COMPILE_PREFIX=$LIBRARY_PATH/OpenSSL/toolchainx86/bin/i686-linux-android-

# PREFIX=$LIBRARY_PATH/OpenSSL/dest/x86

# cd src

# ./Configure --prefix=$PREFIX --cross-compile-prefix=$CROSS_COMPILE_PREFIX android threads no-shared

# make -s && make install

Android.mk

LOCAL_PATH := $(call my-dir)

include $(CLEAR_VARS)

LOCAL_EXPORT_C_INCLUDES := $(LOCAL_PATH)/$(TARGET_ARCH_ABI)/include/sqlcipher

LOCAL_MODULE := sqlcipher

LOCAL_SRC_FILES := $(TARGET_ARCH_ABI)/lib/libsqlcipher.a

include $(PREBUILT_STATIC_LIBRARY)

Modify Android.mk & Application.mk

Please follow the link: http://qiita.com/idaisuke/items/22e2ebc24812681cd61d

[MMO] Cocos2D-x ~ MMO

AppWarp: Cocos2DX Multiplayer Game Development, NinjaFight (tutorial)
planeshift
photon: VMware
KBEngine: Example

The Mana World
Worldforge

AnyNDK: EarthWarrior3D

[SQLITE] sqlite3 encryption/decryption

SQLite3 Simple works

sqlite3 commands.
http://www.runoob.com/sqlite/sqlite-syntax.html

SQLite Manager on Firefox. (Of course, it's free.)
https://addons.mozilla.org/zh-tw/firefox/addon/sqlite-manager/
https://dotblogs.com.tw/toysboy21/2014/04/21/144813

Android SQLite Database Tutorial.
http://www.tutorialspoint.com/android/android_sqlite_database.htm

SQLite for iOS.
http://pro.ctlok.com/2010/07/iphone-ipad-with-sqlite.html
https://www.facebook.com/teacherchi/posts/359338594127416

SQLite for Android.
https://github.com/sqlcipher/android-database-sqlcipher

CopyFiles.
http://www.iforce2d.net/cc2dxres/fileutils

SQLite Manager
http://www.sqlabs.com/sqlitemanager.php

SQLite3 Encryption/Decryption

Types of sqlite3 encryption/decryption

http://foggry.com/blog/2014/05/19/jia-mi-ni-de-sqlite/

sqlcipher_export() to make plain text database to be encrypted.
https://www.zetetic.net/sqlcipher/sqlcipher-api/#sqlcipher_export

SQL Cipher is free but need some works.

Here is SQL Cipher official web site:

https://www.zetetic.net/sqlcipher/

sqlcipher gits:

https://github.com/sqlcipher/sqlcipher

https://github.com/AlbertTian/sqlcipherLib

https://github.com/guilhermeandrade/sqlcipher

https://github.com/shenghe/FreeSQLiteEncryption

Make Sqlcipher available on iOS and Android.

http://www.cnblogs.com/dyllove98/p/3249405.html

To Make Sqlcipher available on iOS.

http://blog.dalt.me/1095

To Make Sqlcipher available on Android.

http://qiita.com/idaisuke/items/b4386705db7ec714f98a
http://ends.cc/?p=619
https://www.zetetic.net/sqlcipher/sqlcipher-for-android/

Reference web sites:

OpenSSL

https://www.zetetic.net/sqlcipher/sqlcipher-binaries-ios-and-osx/

My Solution:
1. Use SQLiteManager to encrypt the database.


2. To decrypt the database in code.