This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
group: R1 R2 | |
description[[ casual test | |
]] | |
R1 = { A B | |
1 2 | |
3 4 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
group: emp deptno | |
description[[ from oracle example database | |
]] | |
dept = { deptno dname loc | |
10 ACCOUNTING NEW_YORK | |
20 RESEARCH DALLAS |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE TABLE emp ( | |
empno decimal(4,0) NOT NULL, | |
ename varchar(10) default NULL, | |
job varchar(9) default NULL, | |
mgr decimal(4,0) default NULL, | |
hiredate date default NULL, | |
sal decimal(7,2) default NULL, | |
comm decimal(7,2) default NULL, | |
deptno decimal(2,0) default NULL | |
); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
I copyied the cert files in /var/snap/nextcloud/current/certs/custom/ | |
and then | |
sudo nextcloud.enable-https custom -s cert.pem privkey.pem chain.pem |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Keepalived process identifier | |
lvs_id haproxy_DH_passive | |
} | |
# Script used to check if HAProxy is running | |
vrrp_script check_haproxy { | |
script "killall -0 haproxy" | |
interval 2 | |
weight 2 | |
} | |
# Virtual interface |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Keepalived process identifier | |
lvs_id haproxy_DH | |
} | |
# Script used to check if HAProxy is running | |
vrrp_script check_haproxy { | |
script "killall -0 haproxy" | |
interval 2 | |
weight 2 | |
} | |
# Virtual interface |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
global | |
log /dev/log local0 | |
log /dev/log local1 notice | |
chroot /var/lib/haproxy | |
stats socket /run/haproxy/admin.sock mode 660 level admin | |
stats timeout 30s | |
user haproxy | |
group haproxy | |
daemon |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
server { | |
listen 80; | |
#listen [::]:80; | |
server_name mail.gwtest.us autodiscover.gwtest.us; | |
return 301 https://$host$request_uri; | |
} | |
server { | |
listen 443; | |
#listen [::]:443 ipv6only=on; |