Mercurial Hosting > luan

annotate src/luan/host/Util.luan @ 1611:f67f972bd648

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
make postgres.luan optional
author Franklin Schmidt <fschmidt@gmail.com>
date Sat, 15 May 2021 17:24:07 -0600
parents 04615093b19d
children cf9dfead83a3
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
1181
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
1 local Luan = require "luan:Luan.luan"
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
2 local error = Luan.error
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
3 local do_file = Luan.do_file or error()
1210
3db95cc00d09 luanhost - add digest authentication
Franklin Schmidt <fschmidt@gmail.com>
parents: 1190
diff changeset
4 local ipairs = Luan.ipairs or error()
1190
Franklin Schmidt <fschmidt@gmail.com>
parents: 1181
diff changeset
5 local stringify = Luan.stringify or error()
1611
f67f972bd648 make postgres.luan optional
Franklin Schmidt <fschmidt@gmail.com>
parents: 1517
diff changeset
6 local Package = require "luan:Package.luan"
1181
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
7 local Io = require "luan:Io.luan"
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
8 local String = require "luan:String.luan"
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
9 local lower = String.lower or error()
1210
3db95cc00d09 luanhost - add digest authentication
Franklin Schmidt <fschmidt@gmail.com>
parents: 1190
diff changeset
10 local format = String.format or error()
1517
04615093b19d use digest_message
Franklin Schmidt <fschmidt@gmail.com>
parents: 1472
diff changeset
11 local to_binary = String.to_binary or error()
1210
3db95cc00d09 luanhost - add digest authentication
Franklin Schmidt <fschmidt@gmail.com>
parents: 1190
diff changeset
12 local Binary = require "luan:Binary.luan"
3db95cc00d09 luanhost - add digest authentication
Franklin Schmidt <fschmidt@gmail.com>
parents: 1190
diff changeset
13 local bytes = Binary.byte or error()
1472
60f6741f000a base64_encode
Franklin Schmidt <fschmidt@gmail.com>
parents: 1418
diff changeset
14 local base64_encode = Binary.base64_encode or error()
1517
04615093b19d use digest_message
Franklin Schmidt <fschmidt@gmail.com>
parents: 1472
diff changeset
15 local digest_message = Binary.digest_message or error()
1418
732b5de211fc add Hosted.luan
Franklin Schmidt <fschmidt@gmail.com>
parents: 1416
diff changeset
16 local Hosted = require "luan:host/Hosted.luan"
1394
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
17 local Sql = require "luan:sql/Sql.luan"
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
18 local database = Sql.database or error()
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
19 local Logging = require "luan:logging/Logging.luan"
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
20 local logger = Logging.logger "Util"
1181
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
21
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
22
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
23 local Util = {}
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
24
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
25 function Util.read_password(domain)
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
26 domain = lower(domain)
1418
732b5de211fc add Hosted.luan
Franklin Schmidt <fschmidt@gmail.com>
parents: 1416
diff changeset
27 return do_file(Hosted.sites_dir..domain.."/info.luan").password or error()
1181
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
28 end
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
29
1394
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
30 function Util.set_password(domain,password)
1418
732b5de211fc add Hosted.luan
Franklin Schmidt <fschmidt@gmail.com>
parents: 1416
diff changeset
31 local dir = Hosted.sites_dir..lower(domain)
1382
Franklin Schmidt <fschmidt@gmail.com>
parents: 1353
diff changeset
32 local file = Io.schemes.file(dir.."/info.luan")
Franklin Schmidt <fschmidt@gmail.com>
parents: 1353
diff changeset
33 file.delete()
1384
f5368cd8c056 remove template expressions and String.concat
Franklin Schmidt <fschmidt@gmail.com>
parents: 1382
diff changeset
34 file.write_text("return "..stringify{password=password}.."\n")
1396
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
35 end
1394
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
36
1611
f67f972bd648 make postgres.luan optional
Franklin Schmidt <fschmidt@gmail.com>
parents: 1517
diff changeset
37 local pg_admin = Package.load("file:postgres.luan")
1396
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
38
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
39 function Util.set_postgres_password(domain,password)
1611
f67f972bd648 make postgres.luan optional
Franklin Schmidt <fschmidt@gmail.com>
parents: 1517
diff changeset
40 if pg_admin == false then
1394
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
41 return
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
42 end
1396
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
43 local db = database(pg_admin)
1407
1979cff9aad2 add sql/Web_query
Franklin Schmidt <fschmidt@gmail.com>
parents: 1396
diff changeset
44 local exists = db.query("select rolname from pg_roles where rolname=?",domain).results() ~= nil;
1394
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
45 --logger.info("exists "..exists)
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
46 if exists then
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
47 db.update( [[alter role "]]..domain..[[" with encrypted password ']]..password..[[']] )
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
48 end
8fe777ba5045 change postgres password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1384
diff changeset
49 db.close()
1210
3db95cc00d09 luanhost - add digest authentication
Franklin Schmidt <fschmidt@gmail.com>
parents: 1190
diff changeset
50 end
3db95cc00d09 luanhost - add digest authentication
Franklin Schmidt <fschmidt@gmail.com>
parents: 1190
diff changeset
51
1396
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
52 function Util.check_postgres_password(domain,password)
1611
f67f972bd648 make postgres.luan optional
Franklin Schmidt <fschmidt@gmail.com>
parents: 1517
diff changeset
53 if pg_admin == false then
1396
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
54 return
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
55 end
1416
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
56 local db = database(pg_admin)
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
57 local exists = db.query("select rolname from pg_roles where rolname=?",domain).results() ~= nil;
1396
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
58 db.close()
1416
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
59 if exists then
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
60 db = database{
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
61 class = "org.postgresql.Driver"
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
62 url = "jdbc:postgresql://localhost:5432/"..domain
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
63 user = domain
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
64 password = password
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
65 }
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
66 db.close()
db57d562c4bd add Http.is_hosted
Franklin Schmidt <fschmidt@gmail.com>
parents: 1407
diff changeset
67 end
1396
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
68 end
a5f61890ad84 add check_postgres_password
Franklin Schmidt <fschmidt@gmail.com>
parents: 1394
diff changeset
69
1181
51d1342e25ad luanhost password handling
Franklin Schmidt <fschmidt@gmail.com>
parents:
diff changeset
70 return Util