annotate doc/Todo @ 15:c262e17de9b1

db download skip-mode.
author pyon@macmini
date Sat, 08 Jun 2019 15:50:59 +0900
parents f5ffc34f045a
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
1 ** client.exe の機能 ************************************************************
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
2
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
3 * client で画像取得
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
4 > client.exe 192.168.0.1:3910 0800012345 20170105
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
5
4
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
6 * client でアップロード
13
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
7 > client.exe -a 192.168.0.1:3910 localfile # /upload へ
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
8 > client.exe -m 192.168.0.1:3910 localfile # /db ヘ
4
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
9
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
10 * バージョンアップ
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
11 + パスワード機能を追加 ( ver1.11 )
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
12 + ヘッダ拒否機能を追加 ( ver1.2 )
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
13
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
14 ** crypto/crypto.exe の機能 *****************************************************
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
15 + auth 用 ( ハッシュ化 )
3
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
16 * -a で plaintext を暗号化 # server/client
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
17 > crypto.exe -a plaintext -s salt
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
18 * -b で auth.csv を暗号化 # server
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
19 > crypto.exe -b auth.csv -s salt > auth.db
3
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
20 * -c で 認証チェック # gui
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
21 > crypto.exe -c auth.db -s salt user passwd
4
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
22 + user/passwd が一致したら "valid user" を表示し、"39" を返す
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
23 + 認証なしのテストのときは user/passwd: test/test
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
24 + auth.db のための salt は gui に内蔵する
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
25 + hhs 用 ( 双方向、キーは crypto.go と gui に内蔵 )
3
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
26 * -d で復号化、-e で暗号化 # server
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
27 > crypto.exe -d hhs.db key > hhs.csv
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
28 > crypto.exe -e hhs.csv key > hhs.db
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
29 * -f で 認証チェック # gui
2
pyon@macmini
parents: 0
diff changeset
30 > crypto.exe -f hhs.db hhs key
3
db4813125eb8 many changes.
pyon@macmini
parents: 2
diff changeset
31 + hhs/key が一致したら hhs の情報を返す
13
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
32 * -o で ファイル出力
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
33
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
34 ** extsql.exe の機能 ************************************************************
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
35 searcher03.exe で作成される hhs.db と index.db から
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
36 re:searcher 用の hhs.db と index.db を作成する.
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
37 client.exe(guiから) でサーバにアップロードする.
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
38
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
39 ** imgtgz の機能 ****************************************************************
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
40 * jpeg を 1.jpg, ..., 5.jpg とリネームし tgz にする.
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
41
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
42 ** server の機能 ****************************************************************
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
43 * 単なる web-server
4
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
44 * バージョンアップ
10
pyon@macmini
parents: 8
diff changeset
45 + log 機能を強化(user-id) ( ver1.x )
pyon@macmini
parents: 8
diff changeset
46 + ヘッダ拒否機能を追加 ( ver1.x )
2
pyon@macmini
parents: 0
diff changeset
47
pyon@macmini
parents: 0
diff changeset
48 ** grsearcher の機能 ****************************************************************
4
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
49 * バージョンアップ
10
pyon@macmini
parents: 8
diff changeset
50 + サテライトウィンドウのマウスジェスチャー(close)
pyon@macmini
parents: 8
diff changeset
51 + キャッシュを使わずメモリで
4
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
52 + client に pw
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
53 + 10分間 Idle なら password
6
9a8b581c1993 improve performance.
pyon@macmini
parents: 5
diff changeset
54 + green-mode の搭載 ( green, green/b, beige, gray )
4
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
55 + プライベートフォルダに写真 userid/startup.jpg, default.jpg, avatar.jpg
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
56
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
57 ** その他 ***********************************************************************
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
58 * IP Address
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
59 Seibu kai-cl11 192.168.31.202 75-1130
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
60 Rokugo kai-cl26 192.168.14.201 88-8404
2
pyon@macmini
parents: 0
diff changeset
61 Nishiki kai-cl?? 192.168.16.203 49-6210
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
62 #Nishiki kai-cl25 192.168.16.201
2
pyon@macmini
parents: 0
diff changeset
63 Isono 192.168.21.151 # nginx:3910
pyon@macmini
parents: 0
diff changeset
64 Fuguta 192.168.21.153 # server:3910
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
65
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
66 * server ( FreeBSD )
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
67 server_root/server, crypto, imgtgz
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
68 + db/auth.db, hhs.db, index.db
13
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
69 + release/grsearcher.exe, client.exe, crypto.exe, manual.pdf
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
70 + images/20180707/0800012345.tgz, ...
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
71
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
72 * client ( Windows )
13
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
73 rsearcher_root/grsearcher.exe, client.exe, crypto.exe (, sqlite3.exe, extsql.exe )
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
74 auth.db, hhs.db, index.db
4
06342fc544e4 mouse gesture.
pyon@macmini
parents: 3
diff changeset
75 + .cache/20180707_1, ...
2
pyon@macmini
parents: 0
diff changeset
76 + image/*.png, *.jpg
0
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
77
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
78 __DONE__
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
79
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
80 * server は rc で起動する(cron は電源入れ忘れがあるからダメ)
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
81 + Handbook の 11.2
d3b8cd5aeb70 make repo.
pyon@macmini
parents:
diff changeset
82
8
82f9af6aa7e4 add net.cpp
pyon@macmini
parents: 6
diff changeset
83 * DB情報の取得を gui で
82f9af6aa7e4 add net.cpp
pyon@macmini
parents: 6
diff changeset
84 > client -u 192.168.0.1:3910 と同等機能
82f9af6aa7e4 add net.cpp
pyon@macmini
parents: 6
diff changeset
85 # GET /db/auth.db, /db/hhs.db, /db/index.db (14day)
82f9af6aa7e4 add net.cpp
pyon@macmini
parents: 6
diff changeset
86 + GUI(grsearcher) 終了時に auth.db と hhs.db は削除
82f9af6aa7e4 add net.cpp
pyon@macmini
parents: 6
diff changeset
87 * auth.db は任意の、hhs.db は月一のアップデートだが、漏洩防止のため毎回削除
13
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
88 * 毎月13日と28日に index.db を取得
8
82f9af6aa7e4 add net.cpp
pyon@macmini
parents: 6
diff changeset
89
13
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
90 * 自動バージョンアップ
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
91 # upgrade.bat
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
92 client -r 192.168.0.1:3910
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
93 # GET /release/grsearcher.exe, /release/crypto.exe, /release/client1.exe
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
94 # /release/manual.pdf
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
95 copy client1.exe client.exe
f5ffc34f045a manage DB.
pyon@macmini
parents: 10
diff changeset
96