完整的查詢系統部署安裝手冊

導入資料

建立 SQLite 資料庫

在項目檔案夾根目錄下建立并進入 database 檔案夾，建立資料庫。

mkdir database & cd database

sqlite3 database.db

分别執行以下 SQL 語句，用于建立 QQ / 京東 / 順豐資料表。

CREATE TABLE qq

(

id BIGINT,

qq_number BIGINT,

phone_number INT

);

CREATE TABLE jd

(

id BIGINT,

name TEXT,

nickname TEXT,

password TEXT,

email TEXT,

id_number TEXT,

phone_number INT

);

CREATE TABLE sf

(

id BIGINT,

name TEXT,

phone_number INT,

address TEXT

);

1. 導入 XX 庫

把 6.9更新總庫.txt 檔案放到項目根目錄下，然後執行 python scripts/qq.py。（需要增加 utf-8*）

1. 導入JD庫

把 jd.txt 檔案放到項目根目錄下，然後執行 python scripts/jd.py。

• 建立索引

sqlite3 database.db

CREATE INDEX index_qq_qq_number ON qq (qq_number);

CREATE INDEX index_qq_phone_number ON qq (phone_number);

CREATE INDEX index_jd_email ON jd (email);

CREATE INDEX index_jd_id_number ON jd (id_number);

CREATE INDEX index_jd_phone_number ON jd (phone_number);

二、編譯過程（可在導入資料的時候同步進行）

注：伺服器版本

[root@sgk privacy]# cat /etc/redhat-release

CentOS Linux release 7.6.1810 (Core)

前期準備 所有檔案夾放在同一目錄，硬碟一定要很大 很大，至少100G以上

[root@sgk ~]# ls

anaconda-ks.cfg database database.db Desktop Documents Downloads initial-setup-ks.cfg Music Pictures privacy-main Public Templates Videos

[root@sgk ~]# cd privacy-main/

[root@sgk privacy-main]# ls

privacy-main

[root@sgk privacy-main]# mv privacy-main/ /opt/privacy # 移動privacy-main 檔案夾裡面的内容到 privacy

[root@sgk privacy-main]# cd /opt/privacy/

[root@sgk privacy]# ls

6.9更新總庫.txt config.yaml LICENSE README.md screenshot scripts server website

[root@sgk privacy]# cd ..

[root@sgk opt]# ll

total 151696

-rw-r--r--. 1 root root 21182673 Dec 18 09:52 node-v10.23.0-linux-x64.tar.gz

drwxr-xr-x. 6 root root 164 Dec 17 21:04 privacy

drwxr-xr-x. 2 root root 6 Oct 31 2018 rh徹底

1. 安裝node-v10.23.0-linux-x64.tar.gz

Wget https://nodejs.org/dist/v10.23.0/node-v10.23.0-linux-x64.tar.gz

[root@sgk opt]# tar xf node-v10.23.0-linux-x64.tar.gz 解壓下載下傳的檔案

[root@sgk opt]# mv node-v10.23.0-linux-x64 node 檔案名修改為node

[root@sgk opt]# ls

node node-v10.23.0-linux-x64.tar.gz privacy rh

[root@sgk opt]# ll node

total 148

drwxrwxr-x. 2 500 500 40 Oct 27 18:03 bin

-rw-rw-r--. 1 500 500 52653 Oct 27 18:03 CHANGELOG.md

drwxrwxr-x. 3 500 500 18 Oct 27 18:03 include

drwxrwxr-x. 3 500 500 26 Oct 27 18:03 lib

-rw-rw-r--. 1 500 500 68764 Oct 27 18:03 LICENSE

-rw-rw-r--. 1 500 500 26749 Oct 27 18:03 README.md

drwxrwxr-x. 5 500 500 45 Oct 27 18:03 share

1. 安裝go

wget https://dl.google.com/go/go1.15.2.linux-amd64.tar.gz

[root@sgk opt]# wget https://dl.google.com/go/go1.15.2.linux-amd64.tar.gz

--2020-12-18 09:54:54-- https://dl.google.com/go/go1.15.2.linux-amd64.tar.gz

Resolving dl.google.com (dl.google.com)... 203.208.40.97

Connecting to dl.google.com (dl.google.com)|203.208.40.97|:443... connected.

HTTP request sent, awaiting response... 200 OK

Length: 121149509 (116M) [application/octet-stream]

Saving to: ‘go1.15.2.linux-amd64.tar.gz’

100%[=====================================================================================================================================================================>] 121,149,509 10.4MB/s in 11s

2020-12-18 09:55:05 (10.9 MB/s) - ‘go1.15.2.linux-amd64.tar.gz’ saved [121149509/121149509]

[root@sgk opt]# tar xf go1.15.2.linux-amd64.tar.gz 解壓下載下傳的檔案

[root@sgk opt]# vim /etc/profile.d/node.sh 編譯環境變量

export NODE_HOME=/opt/node

export PATH=$NODE_HOME/bin:$PATH

[root@sgk opt]# vim /etc/profile.d/go.sh 編譯環境變量

export GOROOT=/opt/go

export GOPATH=/opt/gopath

export PATH=$PATH:$GOROOT/bin:$GOPATH/bin

[root@sgk opt]# mkdir -p gopath/{src,pkg,bin}

[root@sgk opt]# source /etc/profile.d/node.sh 即時生效

[root@sgk opt]# source /etc/profile.d/go.sh 即時生效

[root@sgk opt]# npm config set registry https://registry.npm.taobao.org 設定國内鏡像

[root@sgk opt]# npm config get registry 檢視鏡像

https://registry.npm.taobao.org/

[root@sgk opt]# ls

go gopath node node-v10.23.0-linux-x64.tar.gz privacy rh

[root@sgk opt]# source /etc/profile.d/go.sh 即時生效

[root@sgk opt]# go env -w GO111MODULE=on 編譯go環境變量

[root@sgk opt]# go env -w GOPROXY=https://goproxy.cn,direct

[root@sgk opt]# npm install -g yarn 安裝yarn

> [email protected] preinstall /opt/node/lib/node_modules/yarn

> :; (node ./preinstall.js > /dev/null 2>&1 || true)

/opt/node/bin/yarn -> /opt/node/lib/node_modules/yarn/bin/yarn.js

/opt/node/bin/yarnpkg -> /opt/node/lib/node_modules/yarn/bin/yarn.js

+ [email protected]

added 1 package in 2.144s

[root@sgk opt]# node –v 檢視 node版本

v10.23.0

[root@sgk opt]# cd privacy/

[root@sgk privacy]# cd website/

[root@sgk website]# ls

package.json public README.md src tsconfig.json yarn.lock

[root@sgk website]# yarn install

yarn install v1.22.10

[1/4] Resolving packages...

[2/4] Fetching packages...

info [email protected]: The platform "linux" is incompatible with this module.

warning " > @testing-library/[email protected]" has unmet peer dependency "@testing-library/dom@>=7.21.4".

[4/4] Building fresh packages...

Done in 169.63s.

[root@sgk website]# yarn build

yarn run v1.22.10

$ react-scripts build

Creating an optimized production build...

Compiled successfully.

。。。。。。。。。

Done in 251.70s.

[root@sgk website]# cd ../server/

[root@sgk server]# ls

config database ent go.mod go.sum main service

[root@sgk server]# yum install gcc gcc-c++

Loaded plugins: fastestmirror, langpacks

Loading mirror speeds from cached hostfile

* base: mirrors.163.com

* extras: mirrors.ustc.edu.cn

* updates: mirrors.163.com

Resolving Dependencies

......

Complete!

[root@sgk server]# go build -o app main/main.go

[root@sgk server]# pkill app

[root@sgk server]# ls

app config database ent go.mod go.sum main service

[root@sgk server]# ./app --config ../config.yaml

到此結束

防火牆添加對應端口

[root@sgk privacy]# firewall-cmd --zone=public --add-port=8888/tcp --permanent

success

[root@sgk privacy]# firewall-cmd --reload

Success

[root@sgk privacy]# systemctl stop firewalld

[root@sgk privacy]# systemctl start firewalld