2018年7月25日 星期三

Mi Wifi VPN Server

ROM:
http://hk.miui.com/thread-2780-1-1.html
http://bigota.miwifi.com/xiaoqiang/rom/r1cm/miwifi_r1cm_firmware_46a10_2.7.63.bin

使用小米路由器搭建VPN服務器(2)
https://kknews.cc/zh-hk/tech/4p862lv.html
http://www1.miwifi.com/miwifi_open.html
https://d.miwifi.com/rom/ssh
https://d.miwifi.com/rom/ssh?userId=1686824632

root@XiaoQiang:~# cat /proc/mtd
dev:    size   erasesize  name
mtd0: 01000000 00010000 "ALL"
mtd1: 00030000 00010000 "Bootloader"
mtd2: 00010000 00010000 "Config"
mtd3: 00010000 00010000 "Factory"
mtd4: 00c80000 00010000 "OS1"
mtd5: 00b11ea4 00010000 "rootfs"
mtd6: 00200000 00010000 "OS2"
mtd7: 00100000 00010000 "overlay"
mtd8: 00010000 00010000 "crash"
mtd9: 00010000 00010000 "reserved"
mtd10: 00010000 00010000 "Bdata"

cd /tmp
mkdir rom
dd if=/dev/mtd0 of=/tmp/rom/ALL.bin
dd if=/dev/mtd1 of=/tmp/rom/Bootloader.bin
dd if=/dev/mtd2 of=/tmp/rom/Config.bin
dd if=/dev/mtd3 of=/tmp/rom/Factory.bin
dd if=/dev/mtd4 of=/tmp/rom/OS1.bin
dd if=/dev/mtd5 of=/tmp/rom/rootfs.bin
dd if=/dev/mtd6 of=/tmp/rom/OS2.bin
dd if=/dev/mtd7 of=/tmp/rom/overlay.bin
dd if=/dev/mtd8 of=/tmp/rom/crash.bin
dd if=/dev/mtd9 of=/tmp/rom/reserved.bin
dd if=/dev/mtd10 of=/tmp/rom/Bdata.bin
tar -zcvf rom.tar.gz rom
恢覆指令 (以後備用)
mtd write /tmp/rom/Bootloader.bin Bootloader
mtd write /tmp/rom/Config.bin Config
mtd write /tmp/rom/Factory.bin Factory
mtd write /tmp/rom/OS1.bin OS1
mtd write /tmp/rom/rootfs.bin rootfs
mtd write /tmp/rom/OS2.bin OS2
mtd write /tmp/rom/overlay.bin overlay
mtd write /tmp/rom/crash.bin crash
mtd write /tmp/rom/reserved.bin reserved
mtd write /tmp/rom/Bdata.bin Bdata

OpenWRT


Use Breed to install it
openwrt-18.06.1-ramips-mt7620-miwifi-mini-squashfs-sysupgrade.bin

SSH 2200

https://www.jianshu.com/p/73cad120841d

221.124.79.187:2200 root mobi


End

2018年7月24日 星期二

MySQL 5.7 with Visual Studio 2017 C++


Create empty C++ solution
Select x64
Project > C++ > General > Additional include Path > Add include path "C:\Program Files\MySQL\MySQL Server 5.7\include"
From C:\Program Files\MySQL\MySQL Server 5.7\lib, copy below 3 files
libmysql.dll
libmysql.lib
mysqlclient.lib

main.cpp

#include "mysql.h"
#pragma comment(lib,"libmysql.lib")
#include <iostream>
int main() {
 try
 {
  MYSQL mysql = { 0 };
  mysql_init(&mysql);
  if (!mysql_real_connect(&mysql, "localhost", "root", "Tin.netS1", "", 3306, NULL, 0))
  {
   std::cerr << mysql_error(&mysql) << '\n';
   return -1;
  }

  const char* q1 = "create database if not exists test;";
  std::cout << q1 << '\n';
  if (mysql_real_query(&mysql, q1, strlen(q1)) != 0)
  {
   std::cerr << mysql_error(&mysql) << '\n';
   return -1;
  }

  const char* q2 = "create table if not exists test.temp_table( ID CHAR(10), Name VARCHAR(255), Descs VARCHAR(255), PRIMARY KEY (ID))";
  std::cout << q2 << '\n';
  if (mysql_real_query(&mysql, q2, strlen(q2)) != 0)
  {
   std::cerr << mysql_error(&mysql) << '\n';
   return -1;
  }
  std::cout << "SQL completed successfully" << '\n';
 }
 catch (std::exception& e)
 {
  std::cerr << e.what() << '\n';
  return -1;
 }
 catch (...)
 {
  std::cerr << "Unknown exception" << '\n';
  return -1;
 }
 return 0;
}

query.cpp
#include "winsock.h" 
#include "mysql.h"
#pragma comment(lib,"libmysql.lib")
#include 

int main() {
 try
 {
  MYSQL *mysql;
  MYSQL_RES *result;
  MYSQL_ROW row;
  my_bool reconnect = 0;
  MYSQL_STMT    *stmt;
  MYSQL_BIND    bind[1];
  MYSQL_BIND    bResult[1];
  unsigned long length[1];
  int        int_data;

  mysql = mysql_init(NULL);
  mysql_options(mysql, MYSQL_OPT_RECONNECT, &reconnect);
  mysql_real_connect(mysql, "localhost", "root", "Tin.netS1", "test", 3306, NULL, 0);

  mysql_query(mysql, "drop table test2");
  mysql_query(mysql, "create table test2(n int, m int)");
  mysql_query(mysql, "insert into test2 values (1,2), (1,3), (1,4), (1,5)");

  const char *normalSql = "select m from test2 where n = 1";
  // 1. normal buffer
  mysql_query(mysql, normalSql);
  result = mysql_store_result(mysql);
  while (row = mysql_fetch_row(result)) {
   printf("1 - %d\n", atoi(row[0]));
  }
  mysql_free_result(result);

  // 2. normal unbuffer
  mysql_query(mysql, normalSql);
  result = mysql_use_result(mysql);
  while (row = mysql_fetch_row(result)) {
   printf("2 - %d\n", atoi(row[0]));
  }
  mysql_free_result(result);

  const char *stmtSql = "select m from test2 where n = ?";

  //3. stmt buffer
  stmt = mysql_stmt_init(mysql);

  mysql_stmt_prepare(stmt, stmtSql, strlen(stmtSql));

  memset(bind, 0, sizeof(bind));
  bind[0].buffer_type = MYSQL_TYPE_LONG;
  bind[0].buffer = (char *)&int_data;
  mysql_stmt_bind_param(stmt, bind);

  memset(bResult, 0, sizeof(bResult));
  bResult[0].buffer_type = MYSQL_TYPE_LONG;
  bResult[0].buffer = (char *)&int_data;
  mysql_stmt_bind_result(stmt, bResult);

  int_data = 1;
  mysql_stmt_execute(stmt);
  mysql_stmt_store_result(stmt);

  while (!mysql_stmt_fetch(stmt)) {
   printf("3 - %d \n", int_data);
  }

  mysql_stmt_close(stmt);

  // 4. stmt unbuffer
  stmt = mysql_stmt_init(mysql);

  mysql_stmt_prepare(stmt, stmtSql, strlen(stmtSql));

  memset(bind, 0, sizeof(bind));
  bind[0].buffer_type = MYSQL_TYPE_LONG;
  bind[0].buffer = (char *)&int_data;
  mysql_stmt_bind_param(stmt, bind);

  memset(bResult, 0, sizeof(bResult));
  bResult[0].buffer_type = MYSQL_TYPE_LONG;
  bResult[0].buffer = (char *)&int_data;
  mysql_stmt_bind_result(stmt, bResult);

  int_data = 1;
  mysql_stmt_execute(stmt);

  while (!mysql_stmt_fetch(stmt)) {
   printf("4 - %d \n", int_data);
  }

  mysql_stmt_close(stmt);

  // 5. stmt server cursor default
  stmt = mysql_stmt_init(mysql);

  mysql_stmt_prepare(stmt, stmtSql, strlen(stmtSql));

  unsigned long type = (unsigned long)CURSOR_TYPE_READ_ONLY;
  mysql_stmt_attr_set(stmt, STMT_ATTR_CURSOR_TYPE, (void*)&type);

  memset(bind, 0, sizeof(bind));
  bind[0].buffer_type = MYSQL_TYPE_LONG;
  bind[0].buffer = (char *)&int_data;
  mysql_stmt_bind_param(stmt, bind);

  memset(bResult, 0, sizeof(bResult));
  bResult[0].buffer_type = MYSQL_TYPE_LONG;
  bResult[0].buffer = (char *)&int_data;
  mysql_stmt_bind_result(stmt, bResult);

  int_data = 1;
  mysql_stmt_execute(stmt);

  while (!mysql_stmt_fetch(stmt)) {
   printf("5 - %d \n", int_data);
  }

  mysql_stmt_close(stmt);


  // 6. stmt server cursor setting
  stmt = mysql_stmt_init(mysql);

  mysql_stmt_prepare(stmt, stmtSql, strlen(stmtSql));

  type = (unsigned long)CURSOR_TYPE_READ_ONLY;
  mysql_stmt_attr_set(stmt, STMT_ATTR_CURSOR_TYPE, (void*)&type);

  unsigned long prefetch_rows = 2;
  mysql_stmt_attr_set(stmt, STMT_ATTR_PREFETCH_ROWS, (void*)&prefetch_rows);

  memset(bind, 0, sizeof(bind));
  bind[0].buffer_type = MYSQL_TYPE_LONG;
  bind[0].buffer = (char *)&int_data;
  mysql_stmt_bind_param(stmt, bind);

  memset(bResult, 0, sizeof(bResult));
  bResult[0].buffer_type = MYSQL_TYPE_LONG;
  bResult[0].buffer = (char *)&int_data;
  mysql_stmt_bind_result(stmt, bResult);

  int_data = 1;
  mysql_stmt_execute(stmt);

  while (!mysql_stmt_fetch(stmt)) {
   printf("6 - %d \n", int_data);
  }

  mysql_stmt_close(stmt);

  mysql_close(mysql);

  std::cout << "SQL completed successfully" << '\n';
  std::cin.get();
 }
 catch (std::exception& e)
 {
  std::cerr << e.what() << '\n';
  return -1;
 }
 catch (...)
 {
  std::cerr << "Unknown exception" << '\n';
  return -1;
 }
 return 0;
}


End

Why KDB?



http://www.timestored.com/b/kdb-qsql-query-vs-sql/

Joining Records on Nearest Time

Lastly we want to consider performing a time based join. A common finance query is to find the prevailing quote for a given set of trades.

2018年7月5日 星期四

C# MongoDB Driver

Visual Studio 2017 > Tools > NuGet Package Manager > PM Console
.NET Framework 4.6.1
Install-Package mongocsharpdriver -Version 2.7.0

2018年6月29日 星期五

Windows Server 2012 Server Code on Hyper-V

Windows Server 2012 Server Code on Hyper-V

LAN
netsh interface ipv4 show config
Ethernet
netsh interface ipv4 set address Ethernet static 172.31.118.247 255.255.255.240 172.31.118.240
netsh interface ipv4 set dns Ethernet static 172.31.118.240

Enable Ping
netsh firewall set icmpsetting 8

Change to Private Network
Get-NetConnectionProfile
Set-NetConnectionProfile -Name “Unidentified network” -NetworkCategory Private

---

[check here to do better for PS and OnClient later]


PS 5.1
"Turn off password protected sharing" on remote server
\\172.31.118.241\share\Win8.1AndW2K12R2-KB3191564-x64.msu /quite
Get-Host shows 5.1
Enable-PSRemoting -Force
Restart-Service WinRM
winrm quickconfig

On Client
winrm quickconfig
winrm set winrm/config/client '@{TrustedHosts="172.31.118.247"}'
Set-Item wsman:\localhost\client\trustedhosts *
Test-WsMan 172.31.118.247
Enter-PSSession -ComputerName 172.31.118.247 -Credential Administrator



---


Set Filewall and Start MT4
netsh advfirewall firewall add rule name="MetaTrader 4 Server" protocol=TCP enable=yes DIR=In program="C:\MetaTrader4Server\mtsrv.exe" Action=Allow
Expand-Archive \\172.31.118.241\share\MetaTrader4Server.zip C:\
C:\MetaTrader4Server\mtsrv.exe /install
C:\MetaTrader4Server\mtsrv.exe /stop
Copy-Item \\172.31.118.241\share\StopOut.dll C:\MetaTrader4Server\plugins\ -force
C:\MetaTrader4Server\mtsrv.exe /start


2018年6月21日 星期四

C++ with NSQ and Visual Studio and vcpkg



vcpkg
https://www.jianshu.com/p/f06b8f77bc34
git clone https://github.com/Microsoft/vcpkg.git
powershell -exec bypass scripts\bootstrap.ps1
vcpkg.exe integrate install
vcpkg.exe search sqlite
vcpkg.exe install sqlite3 boost
vcpkg.exe list
vcpkg.exe install sqlite3:x64-windows

#include <sqlite3.h>
#include <iostream>
void main() {
std::cout << sqlite3_libversion() << "\n";
std::cin.get();
}

cmake (may not required)
Download cmake-3.8.0-win64-x64.msi with "Add CMake to the system PATH for all users"


getopt.h
https://github.com/skandhurkat/Getopt-for-Visual-Studio

https://github.com/Qihoo360/evpp/blob/master/docs/quick_start_windows_with_visualstudio.md

1. run bat file to generate vcpkg.exe

vcpkg install gflags:x64-windows glog:x64-windows openssl:x64-windows libevent:x64-windows thrift:x64-windows
vcpkg install evpp:x64-windows





Simplest


git clone https://github.com/Microsoft/vcpkg.git (so that C:\d\git\vcpkg\vcpkg.exe)
powershell -exec bypass scripts\bootstrap.ps1
vcpkg install evpp:x64-windows

2018年6月13日 星期三

QT 5.11


https://hk.saowen.com/

在visual studio 2017中配置Qt

QT creator編程C++第一步,説“Hello world!”

QLabel label("Hello, world");
label.setGeometry(200,200,200,200);
label.show();
Qt主窗口(Top Level Window)


QtGuiApplication1 w;           //創造一個主窗口物件
w.resize(300, 300);      //窗口尺寸為300*300
w.move(100, 100);        //窗口移動到距螢幕左上角100*100處
int windowXPos = w.x(); //窗口左上角x座標
int windowYPos = w.y(); //窗口左上角y座標
QRect windowGeometry = w.frameGeometry(); //返回的QRect可得窗口長、寬、位置等資訊。   
w.setWindowTitle(QObject::tr("Window Title")); //設定窗口標題
w.show();               //在螢幕上秀出窗口
元件概念(QWidget)

MainWindow, Dialog, Label, Buttons inherits from QWidget inherits from QObject.
Top Level Widget includes MainWindow that must has no parents.
Non-window widget includes labels, buttons that must has a parent.
Typically top level widget put in stack in main() but sub widget put in heap using new with chained parents.

int main(int argc, char *argv[]) {
QApplication a(argc, argv);
QLabel *label1 = new QLabel();
label1->setText("Label 1");
label1->show();
QLabel label2;
label2.setText("Label 2");
label2.show();
int ret = a.exec();
delete label1;    //label1需自行釋放記憶體
return ret;
}

QWidget (Typical)

int main(int argc, char *argv[]) {
QApplication a(argc, argv);
QWidget w;
w.show();
return a.exec();
}

QPushButton

class MyWidget : public QWidget
{
 Q_OBJECT
public:
 MyWidget(QWidget *parent = 0) {
  setWindowTitle(tr("My Title"));
  btn1 = new QPushButton(tr("Start"), this); //第二個參數指定父元件,如果沒有就要用布局管理員,否則無法顯現該元件
  btn1->setGeometry(30, 30, 80, 30);         //設定位置大小
  btn1->setText(tr("Change"));               //設定內容文字
  btn1->setFont(QFont("Times", 12));       //設定字型
  btn2 = new QPushButton(this);
  btn2->setGeometry(30, 80, 60, 60);
  btn2->setIcon(QIcon("icon.jpg"));       //設定按鈕圖案
  btn2->setIconSize(QSize(50, 50));       //設定圖案大小
 }
private:
 QPushButton *btn1;
 QPushButton *btn2;
};

#include "MyWidget.h"
int main(int argc, char *argv[]) {
QApplication a(argc, argv);
MyWidget w;
w.show();
return a.exec();
}
QLabel

MyWidget(QWidget *parent = 0) {
 setWindowTitle(tr("Two Labels"));
 label1 = new QLabel(this);
 label1->setText(tr("Text Label"));
 label1->setGeometry(20, 20, 60, 20);        //設定位置大小
 label1->setAlignment(Qt::AlignCenter);   //label文字置中

 QPixmap p("icon.png");                   //載入圖檔
 label2 = new QLabel(this);
 label2->setGeometry(25, 60, 60, 60);
 label2->setPixmap(p.scaled(60, 60, Qt::KeepAspectRatio));  //將圖案縮小為(60,60)
}
QFrame

MyWidget(QWidget *parent = 0) {
 setWindowTitle(tr("QFrame Title"));
 myFrame = new QFrame(this);
 myFrame->setGeometry(10, 10, 150, 40);
 myFrame->setLineWidth(2);
 myFrame->setFrameStyle(QFrame::Box | QFrame::Sunken);
}
QRadioButton

setWindowTitle(tr("Radio Titles"));
myGroupBox = new QGroupBox(tr("Set of buttons"), this);
myGroupBox->setGeometry(30, 30, 100, 100);
check1 = new QRadioButton(tr("B1"), this);
check1->setChecked(true);                //設定check1為打勾狀態
check2 = new QRadioButton(tr("B2"), this);
check3 = new QRadioButton(tr("B3"), this);
myLayout = new QVBoxLayout;
myLayout->addWidget(check1);
myLayout->addWidget(check2);
myLayout->addWidget(check3);
myGroupBox->setLayout(myLayout);
And more widght...


信號槽範例

Button clicked() broadcasts a signal and a "private slot:" function can handle data.

connect(myBtn, SIGNAL(clicked()), this, SLOT(showMessageBox()));
connect(myEdit, SIGNAL(textChanged()), this, SLOT(showMessageBox()));
The object button broadcasts a signal clicked() and this object handle it by the slot function.


































class MyWidget : public QWidget
{
 Q_OBJECT
public:
 MyWidget(QWidget *parent = 0) :
  QWidget(parent)
 {
  m_value = 0;
  myLcd = new QLCDNumber(this);
  myLcd->setGeometry(80, 30, 150, 50);
  mySlider = new QSlider(Qt::Horizontal, this);
  mySlider->setRange(0, 100);
  mySlider->setValue(30);
  mySlider->setGeometry(80, 110, 150, 50);
  connect(mySlider, SIGNAL(valueChanged(int)), this, SLOT(setValue(int)));
  connect(this, SIGNAL(valueChanged(int)), myLcd, SLOT(display(int)));
  setValue(30);
 }
private:
 int m_value;
 QLCDNumber *myLcd;
 QSlider *mySlider;
public slots:
 void setValue(int value) {
  if (value != m_value) {
   m_value = value;
   emit valueChanged(m_value);
  }
 }
signals:
 void valueChanged(int);
};
自建的signal和slot函式回傳值皆為void,且參數基本上要相同(本例為int)
若signal的參數多於slot的參數,則額外的參數會被slot忽略


QTableWidget

















Ending

2007 to 2023 HP and Dell Servers Comparison

  HP Gen5 to Gen11  using ChatGPT HP ProLiant Gen Active Years CPU Socket Popular HP CPUs Cores Base Clock Max RAM Capacity Comparable Dell ...