summaryrefslogtreecommitdiff
Unidiff
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--backend/node/src/clipperz.js17
1 files changed, 12 insertions, 5 deletions
diff --git a/backend/node/src/clipperz.js b/backend/node/src/clipperz.js
index 37b9cae..72b6c9f 100644
--- a/backend/node/src/clipperz.js
+++ b/backend/node/src/clipperz.js
@@ -18,64 +18,66 @@ function clipperz_store(PG) {
18 var rv = function(o) { express_store.call(this,o); } 18 var rv = function(o) { express_store.call(this,o); }
19 rv.prototype.get = function(sid,cb) { PG.Q( 19 rv.prototype.get = function(sid,cb) { PG.Q(
20 "SELECT s_data FROM clipperz.thesession WHERE s_id=$1",[sid], 20 "SELECT s_data FROM clipperz.thesession WHERE s_id=$1",[sid],
21 function(e,r) { cb(e,(e||!r.rowCount)?null:JSON.parse(r.rows[0].s_data)); } 21 function(e,r) { cb(e,(e||!r.rowCount)?null:JSON.parse(r.rows[0].s_data)); }
22 ) }; 22 ) };
23 rv.prototype.set = function(sid,data,cb) { 23 rv.prototype.set = function(sid,data,cb) {
24 var d = JSON.stringify(data); 24 var d = JSON.stringify(data);
25 PG.Q( 25 PG.Q(
26 "UPDATE clipperz.thesession SET s_data=$1, s_mtime=current_timestamp" 26 "UPDATE clipperz.thesession SET s_data=$1, s_mtime=current_timestamp"
27 +" WHERE s_id=$2",[d,sid], function(e,r) { 27 +" WHERE s_id=$2",[d,sid], function(e,r) {
28 if(e) return cb(e); 28 if(e) return cb(e);
29 if(r.rowCount) return cb(); 29 if(r.rowCount) return cb();
30 PG.Q("INSERT INTO clipperz.thesession (s_id,s_data) VALUES ($1,$2)",[sid,d],cb); 30 PG.Q("INSERT INTO clipperz.thesession (s_id,s_data) VALUES ($1,$2)",[sid,d],cb);
31 }); 31 });
32 }; 32 };
33 rv.prototype.destroy = function(sid,cb) { PG.Q( 33 rv.prototype.destroy = function(sid,cb) { PG.Q(
34 "DELETE FROM clipperz.thesession WHERE s_id=$1",[sid],cb 34 "DELETE FROM clipperz.thesession WHERE s_id=$1",[sid],cb
35 ) }; 35 ) };
36 rv.prototype.length = function(cb) { PG.Q( 36 rv.prototype.length = function(cb) { PG.Q(
37 "SELECT count(*) AS c FROM clipperz.thesession", function(e,r) { 37 "SELECT count(*) AS c FROM clipperz.thesession", function(e,r) {
38 cb(e,e?null:r.rows[0].c); 38 cb(e,e?null:r.rows[0].c);
39 } 39 }
40 ) }; 40 ) };
41 rv.prototype.clear = function(cb) { PQ.Q( 41 rv.prototype.clear = function(cb) { PQ.Q(
42 "TRUNCATE clipperz.thesession", cb 42 "TRUNCATE clipperz.thesession", cb
43 ) }; 43 ) };
44 rv.prototype.__proto__ = express_store.prototype; 44 rv.prototype.__proto__ = express_store.prototype;
45 return rv; 45 return rv;
46} 46}
47 47
48var srp_g = BIGNUM(2); 48var srp_g = BIGNUM(2);
49var srp_n = BIGNUM("115b8b692e0e045692cf280b436735c77a5a9e8a9e7ed56c965f87db5b2a2ece3",16); 49var srp_n = BIGNUM("115b8b692e0e045692cf280b436735c77a5a9e8a9e7ed56c965f87db5b2a2ece3",16);
50var srp_k = BIGNUM("64398bff522814e306a97cb9bfc4364b7eed16a8c17c5208a40a2bad2933c8e",16);
51var srp_hn = "597626870978286801440197562148588907434001483655788865609375806439877501869636875571920406529";
50var n123 = '112233445566778899aabbccddeeff00112233445566778899aabbccddeeff00'; 52var n123 = '112233445566778899aabbccddeeff00112233445566778899aabbccddeeff00';
51 53
52 54
53var CLIPPERZ = module.exports = function(CONFIG) { 55var CLIPPERZ = module.exports = function(CONFIG) {
54 56
55 var LOGGER = CONFIG.logger||{trace:function(){}}; 57 var LOGGER = CONFIG.logger||{trace:function(){}};
56 58
57 var PG = { 59 var PG = {
58 url: CONFIG.psql, 60 url: CONFIG.psql,
59 PG: require('pg').native, 61 PG: require('pg').native,
60 Q: function(q,a,cb) { 62 Q: function(q,a,cb) {
61 if('function'===typeof a) cb=a,a=[]; 63 if('function'===typeof a) cb=a,a=[];
62 LOGGER.trace({query:q,args:a},'SQL: %s',q); 64 LOGGER.trace({query:q,args:a},'SQL: %s',q);
63 PG.PG.connect(PG.url,function(e,C,D) { 65 PG.PG.connect(PG.url,function(e,C,D) {
64 if(e) return cb(e); 66 if(e) return cb(e);
65 var t0=new Date(); 67 var t0=new Date();
66 C.query(q,a,function(e,r) { 68 C.query(q,a,function(e,r) {
67 var t1=new Date(), dt=t1-t0; 69 var t1=new Date(), dt=t1-t0;
68 D(); 70 D();
69 LOGGER.trace({query:q,args:a,ms:dt,rows:r&&r.rowCount,err:e},"SQL query '%s' took %dms",q,dt); 71 LOGGER.trace({query:q,args:a,ms:dt,rows:r&&r.rowCount,err:e},"SQL query '%s' took %dms",q,dt);
70 cb(e,r); 72 cb(e,r);
71 }); 73 });
72 }); 74 });
73 }, 75 },
74 T: function(cb) { 76 T: function(cb) {
75 PG.PG.connect(PG.url,function(e,C,D) { 77 PG.PG.connect(PG.url,function(e,C,D) {
76 if(e) return cb(e); 78 if(e) return cb(e);
77 C.query('BEGIN',function(e){ 79 C.query('BEGIN',function(e){
78 if(e) return D(),cb(e); 80 if(e) return D(),cb(e);
79 LOGGER.trace('SQL: transaction begun'); 81 LOGGER.trace('SQL: transaction begun');
80 cb(null,{ 82 cb(null,{
81 Q: function(q,a,cb) { 83 Q: function(q,a,cb) {
@@ -146,77 +148,82 @@ var CLIPPERZ = module.exports = function(CONFIG) {
146 cb(null,r.rows[0]); 148 cb(null,r.rows[0]);
147 }) }, 149 }) },
148 otp: ['u',function(cb,r) { 150 otp: ['u',function(cb,r) {
149 if(!req.session.otp) return cb(); 151 if(!req.session.otp) return cb();
150 if(req.session.u!=r.u.u_id) return cb(new Error('user/OTP mismatch')); 152 if(req.session.u!=r.u.u_id) return cb(new Error('user/OTP mismatch'));
151 PG.Q( 153 PG.Q(
152 "UPDATE clipperz.theotp AS otp" 154 "UPDATE clipperz.theotp AS otp"
153 +" SET" 155 +" SET"
154 +" otps_id=CASE WHEN s.otps_code='REQUESTED' THEN (" 156 +" otps_id=CASE WHEN s.otps_code='REQUESTED' THEN ("
155 +" SELECT ss.otps_id FROM clipperz.otpstatus AS ss WHERE ss.otps_code='USED'" 157 +" SELECT ss.otps_id FROM clipperz.otpstatus AS ss WHERE ss.otps_code='USED'"
156 +" ) ELSE otp.otps_id END," 158 +" ) ELSE otp.otps_id END,"
157 +" otp_utime=current_timestamp" 159 +" otp_utime=current_timestamp"
158 +" FROM clipperz.otpstatus AS s, clipperz.theotp AS o" 160 +" FROM clipperz.otpstatus AS s, clipperz.theotp AS o"
159 +" WHERE" 161 +" WHERE"
160 +" o.otp_id=otp.otp_id AND otp.otps_id=s.otps_id" 162 +" o.otp_id=otp.otp_id AND otp.otps_id=s.otps_id"
161 +" AND otp.otp_id=$1 AND otp.u_id=$2" 163 +" AND otp.otp_id=$1 AND otp.u_id=$2"
162 +" RETURNING o.otps_id!=otp.otps_id AS yes, o.otp_ref", 164 +" RETURNING o.otps_id!=otp.otps_id AS yes, o.otp_ref",
163 [ req.session.otp, req.session.u ], 165 [ req.session.otp, req.session.u ],
164 function(e,r) { 166 function(e,r) {
165 if(e) return cb(e); 167 if(e) return cb(e);
166 if(!r.rowCount) return cb(new Error('no OTP found')); 168 if(!r.rowCount) return cb(new Error('no OTP found'));
167 r=r.rows[0]; 169 r=r.rows[0];
168 if(!r.yes) return cb(new Error('OTP is in a sorry state')); 170 if(!r.yes) return cb(new Error('OTP is in a sorry state'));
169 cb(null,{ref:r.otp_ref}); 171 cb(null,{ref:r.otp_ref});
170 }); 172 });
171 }] 173 }]
172 },function(e,r) { 174 },function(e,r) {
173 if(e) return cb(e); 175 if(e) return cb(e);
174 req.session.C = ppp.C; req.session.A = ppp.A; 176 req.session.C = ppp.C; req.session.A = ppp.A;
175 req.session.s = r.u.u_srp_s; req.session.v = r.u.u_srp_v; 177 req.session.s = r.u.u_srp_s; req.session.v = r.u.u_srp_v;
176 req.session.u = r.u.u_id; 178 req.session.u = r.u.u_id;
177 req.session.b = clipperz_random(); 179 req.session.b = clipperz_random();
178 req.session.B = BIGNUM(req.session.v,16).add(srp_g.powm(BIGNUM(req.session.b,16),srp_n)).toString(16); 180 req.session.B = srp_k.mul(BIGNUM(req.session.v,16)).add(srp_g.powm(BIGNUM(req.session.b,16),srp_n)).toString(16);
179 var rv = {s:req.session.s,B:req.session.B} 181 var rv = {s:req.session.s,B:req.session.B}
180 if(r.otp && r.otp.otp_ref) rv.oneTimePassword=r.otp.otp_ref; 182 if(r.otp && r.otp.otp_ref) rv.oneTimePassword=r.otp.otp_ref;
181 res.res(rv); 183 res.res(rv);
182 }); 184 });
183 185
184 case 'credentialCheck': 186 case 'credentialCheck':
185 var u = clipperz_hash(BIGNUM(req.session.B,16).toString(10)); 187 var u = clipperz_hash(BIGNUM(req.session.A,16).toString(10)+BIGNUM(req.session.B,16).toString(10));
186 var A = BIGNUM(req.session.A,16); 188 var A = BIGNUM(req.session.A,16);
187 var S = A.mul(BIGNUM(req.session.v,16).powm(BIGNUM(u,16),srp_n)).powm( 189 var S = A.mul(BIGNUM(req.session.v,16).powm(BIGNUM(u,16),srp_n)).powm(BIGNUM(req.session.b,16),srp_n);
188 BIGNUM(req.session.b,16), srp_n);
189 var K = clipperz_hash(S.toString(10)); 190 var K = clipperz_hash(S.toString(10));
190 var M1 = clipperz_hash(A.toString(10)+BIGNUM(req.session.B,16).toString(10)+K.toString(16)); 191 var M1 = clipperz_hash(
192 srp_hn
193 +clipperz_hash(req.session.C)
194 +BIGNUM(req.session.s,16).toString(10)
195 +A.toString(10)
196 +BIGNUM(req.session.B,16).toString(10)
197 +K );
191 if(M1!=ppp.M1) return res.res({error:'?'}); 198 if(M1!=ppp.M1) return res.res({error:'?'});
192 req.session.K = K; 199 req.session.K = K;
193 var M2 = clipperz_hash(A.toString(10)+M1+K.toString(16)); 200 var M2 = clipperz_hash(A.toString(10)+M1+K.toString(16));
194 return res.res({M2:M2,connectionId:'',loginInfo:{latest:{},current:{}},offlineCopyNeeded:false,lock:'----'}); 201 return res.res({M2:M2,connectionId:'',loginInfo:{latest:{},current:{}},offlineCopyNeeded:false,lock:'----'});
195 202
196 case 'oneTimePassword': return PG.Q( 203 case 'oneTimePassword': return PG.Q(
197 "UPDATE clipperz.theotp AS otp" 204 "UPDATE clipperz.theotp AS otp"
198 +" SET" 205 +" SET"
199 +" otps_id = CASE WHEN s.otps_code!='ACTIVE' THEN s.otps_id ELSE (" 206 +" otps_id = CASE WHEN s.otps_code!='ACTIVE' THEN s.otps_id ELSE ("
200 +" SELECT ss.otps_id FROM clipperz.otpstatus AS ss WHERE ss.otps_code=CASE" 207 +" SELECT ss.otps_id FROM clipperz.otpstatus AS ss WHERE ss.otps_code=CASE"
201 +" WHEN otp.otp_key_checksum=$2 THEN 'REQUESTED'" 208 +" WHEN otp.otp_key_checksum=$2 THEN 'REQUESTED'"
202 +" ELSE 'DISABLED' END" 209 +" ELSE 'DISABLED' END"
203 +" ) END," 210 +" ) END,"
204 +" otp_data = CASE WHEN s.otps_code='ACTIVE' THEN '' ELSE otp.otp_data END," 211 +" otp_data = CASE WHEN s.otps_code='ACTIVE' THEN '' ELSE otp.otp_data END,"
205 +" otp_utime = current_timestamp," 212 +" otp_utime = current_timestamp,"
206 +" otp_rtime = CASE WHEN otp.otp_key_checksum=$2 THEN current_timestamp ELSE otp.otp_rtime END" 213 +" otp_rtime = CASE WHEN otp.otp_key_checksum=$2 THEN current_timestamp ELSE otp.otp_rtime END"
207 +" FROM clipperz.otpstatus AS s, clipperz.theotp AS o" 214 +" FROM clipperz.otpstatus AS s, clipperz.theotp AS o"
208 +" WHERE" 215 +" WHERE"
209 +" o.otp_id=otp.otp_id AND otp.otps_id=s.otps_id AND otp.otp_key=$1" 216 +" o.otp_id=otp.otp_id AND otp.otps_id=s.otps_id AND otp.otp_key=$1"
210 +" RETURNING otp.u_id, s.otps_code, otp.otp_id, otp.otp_key_checksum, o.otp_data, otp.otp_version", 217 +" RETURNING otp.u_id, s.otps_code, otp.otp_id, otp.otp_key_checksum, o.otp_data, otp.otp_version",
211 [ ppp.oneTimePasswordKey, ppp.oneTimePasswordKeyChecksum ], 218 [ ppp.oneTimePasswordKey, ppp.oneTimePasswordKeyChecksum ],
212 function(e,r) { 219 function(e,r) {
213 if(e) return cb(e); 220 if(e) return cb(e);
214 if(!r.rowCount) return cb(new Error('OTP not found')); 221 if(!r.rowCount) return cb(new Error('OTP not found'));
215 r=r.rows[0]; 222 r=r.rows[0];
216 if(r.otp_key_checksum!=ppp.oneTimePasswordKeyChecksum) 223 if(r.otp_key_checksum!=ppp.oneTimePasswordKeyChecksum)
217 return cb(new Error('OTP was disabled because of checksum mismatch')); 224 return cb(new Error('OTP was disabled because of checksum mismatch'));
218 if(r.otps_code!='ACTIVE') 225 if(r.otps_code!='ACTIVE')
219 return cb(new Error("OTP wasn't active, sorry")); 226 return cb(new Error("OTP wasn't active, sorry"));
220 req.session.u=r.u_id; req.session.otp=r.otp_id; 227 req.session.u=r.u_id; req.session.otp=r.otp_id;
221 res.res({data:r.otp_data,version:r.otp_version}); 228 res.res({data:r.otp_data,version:r.otp_version});
222 }); 229 });