summaryrefslogtreecommitdiff
authorMichael Krelin <hacker@klever.net>2013-11-25 20:52:38 (UTC)
committer Michael Krelin <hacker@klever.net>2013-11-25 20:52:38 (UTC)
commit352f2216eec032efce4bdeddd2ffe5a9e326a99d (patch) (unidiff)
tree902272eaff4d42c0e732cc446baa3b5958cfae73
parentc79ee694f71f787e896fe3f954316723ef0f5544 (diff)
downloadclipperz-352f2216eec032efce4bdeddd2ffe5a9e326a99d.zip
clipperz-352f2216eec032efce4bdeddd2ffe5a9e326a99d.tar.gz
clipperz-352f2216eec032efce4bdeddd2ffe5a9e326a99d.tar.bz2
postgresql-based clipperz own session store
the use thereof is not mandatory, but may come in handy for the standalone deployment
Diffstat (more/less context) (ignore whitespace changes)
-rw-r--r--backend/node/src/app.js20
-rw-r--r--backend/node/src/clipperz.js37
-rw-r--r--backend/node/src/clipperz.schema.sql7
3 files changed, 54 insertions, 10 deletions
diff --git a/backend/node/src/app.js b/backend/node/src/app.js
index d4d60c2..61c2c72 100644
--- a/backend/node/src/app.js
+++ b/backend/node/src/app.js
@@ -18,4 +18,14 @@ var HTTP = require('http');
18var PATH = require('path'); 18var PATH = require('path');
19 19
20
21var CLIPPERZ = require('./clipperz');
22var CONF = require('./conf');
23var clipperz = CLIPPERZ({
24 psql: CONF.psql||'postgresql:///clipperz',
25 logger: LOGGER,
26 dump_template: PATH.join(__dirname,'htdocs/beta/index.html')
27});
28
29
20var app = EXPRESS(); 30var app = EXPRESS();
21 31
@@ -25,5 +35,5 @@ app.use(EXPRESS.urlencoded());
25app.use(EXPRESS.methodOverride()); 35app.use(EXPRESS.methodOverride());
26app.use(EXPRESS.cookieParser('your secret here')); 36app.use(EXPRESS.cookieParser('your secret here'));
27app.use(EXPRESS.session()); 37app.use(EXPRESS.session({secret:'99 little bugs in the code', key:'sid', store: clipperz.session_store() }));
28app.use(app.router); 38app.use(app.router);
29app.use(EXPRESS.static(PATH.join(__dirname, 'htdocs/'))); 39app.use(EXPRESS.static(PATH.join(__dirname, 'htdocs/')));
@@ -33,12 +43,4 @@ if ('development' == app.get('env')) {
33 43
34 44
35var CLIPPERZ = require('./clipperz');
36var CONF = require('./conf');
37var clipperz = CLIPPERZ({
38 psql: CONF.psql||'postgresql:///clipperz',
39 logger: LOGGER,
40 dump_template: PATH.join(__dirname,'htdocs/beta/index.html')
41});
42
43app.post('/json',clipperz.json); 45app.post('/json',clipperz.json);
44app.get('/beta/dump',clipperz.dump); 46app.get('/beta/dump',clipperz.dump);
diff --git a/backend/node/src/clipperz.js b/backend/node/src/clipperz.js
index eebd5bf..73af0a0 100644
--- a/backend/node/src/clipperz.js
+++ b/backend/node/src/clipperz.js
@@ -4,4 +4,6 @@ var BIGNUM = require('bignum');
4var ASYNC = require('async'); 4var ASYNC = require('async');
5 5
6var express_store = require('express').session.Store;
7
6function clipperz_hash(v) { 8function clipperz_hash(v) {
7 return CRYPTO.createHash('sha256').update( 9 return CRYPTO.createHash('sha256').update(
@@ -13,4 +15,33 @@ function clipperz_random() {
13 return r.substr(0,64); 15 return r.substr(0,64);
14}; 16};
17function clipperz_store(PG) {
18 var rv = function(o) { express_store.call(this,o); }
19 rv.prototype.get = function(sid,cb) { PG.Q(
20 "SELECT s_data FROM clipperz.thesession WHERE s_id=$1",[sid],
21 function(e,r) { cb(e,(e||!r.rowCount)?null:r.rows[0].s_data); }
22 ) };
23 rv.prototype.set = function(sid,data,cb) { PG.Q(
24 "UPDATE clipperz.thesession SET s_data=$1, s_mtime=current_timestamp"
25 +" WHERE s_id=$2",[data,sid], function(e,r) {
26 if(e) return cb(e);
27 if(r.rowCount) return cb();
28 PG.Q("INSERT INTO clipperz.thesession (s_id,s_data) VALUES ($1,$2)",[sid,data],cb);
29 }
30 ) };
31 rv.prototype.destroy = function(sid,cb) { PG.Q(
32 "DELETE FROM clipperz.thesession WHERE s_id=$1",[sid],cb
33 ) };
34 rv.prototype.length = function(cb) { PG.Q(
35 "SELECT count(*) AS c FROM clipperz.thesession", function(e,r) {
36 cb(e,e?null:r.rows[0].c);
37 }
38 ) };
39 rv.prototype.length = function(cb) { PQ.Q(
40 "DELETE FROM clipperz.thesession", cb
41 ) };
42 rv.prototype.__proto__ = express_store.prototype;
43 return rv;
44}
45
15var srp_g = BIGNUM(2); 46var srp_g = BIGNUM(2);
16var srp_n = BIGNUM("115b8b692e0e045692cf280b436735c77a5a9e8a9e7ed56c965f87db5b2a2ece3",16); 47var srp_n = BIGNUM("115b8b692e0e045692cf280b436735c77a5a9e8a9e7ed56c965f87db5b2a2ece3",16);
@@ -77,5 +108,5 @@ var CLIPPERZ = module.exports = function(CONFIG) {
77 108
78 109
79 return { 110 var rv = {
80 111
81 json: function clipperz_json(req,res,cb) { 112 json: function clipperz_json(req,res,cb) {
@@ -533,5 +564,9 @@ var CLIPPERZ = module.exports = function(CONFIG) {
533 }); 564 });
534 } 565 }
566
535 }; 567 };
568 rv.__defineGetter__('session_store',function(){ return function(o) { return new (clipperz_store(PG))(o) } });
569
570 return rv;
536 571
537}; 572};
diff --git a/backend/node/src/clipperz.schema.sql b/backend/node/src/clipperz.schema.sql
index ba6f482..1c2305c 100644
--- a/backend/node/src/clipperz.schema.sql
+++ b/backend/node/src/clipperz.schema.sql
@@ -59,2 +59,9 @@ CREATE TABLE clipperz.theotp (
59 otp_utime timestamp NOT NULL DEFAULT current_timestamp 59 otp_utime timestamp NOT NULL DEFAULT current_timestamp
60); 60);
61
62CREATE TABLE clipperz.thesession (
63 s_id varchar PRIMARY KEY,
64 s_data json,
65 s_ctime timestamp DEFAULT current_timestamp,
66 s_mtime timestamp DEFAULT current_timestamp
67);