Keeping Keepass in Sync between PC and Adroid Clients via Owncloud

1. Try - using KeePassDroid

No sync features at all

2. Try - using keypass2android and owcloud-sync-folder

Put keepass.kdbx on Owncloud folder
Open on Owcloud Client and choose "keep in Sync"

+Straight forward
- Have to open Owncloud-Client on Android before opeining to make sure DBs are synced
~ Not sure if sync works when file is open on moret than one clients

3. Try - using keypass2android and webdav access

Open your kdbx-file via WEBDAV link - e.g. https://owncloud.org/remote.php/webdav/Path/To/Folder/With/Databasefile.kdbx

+ no need to sync - direct acces to remote file
- error messages (transactions) when editing file from 2 sides - can be suppressed by disabling option "Filetransactions" keepass2android - be careful!! Make sure you have backups!

For me 3. solution works fine now - always make sure to close and safe - keep in mind, where the last changes were done

Webserver Setup - Debian9 for Wordpress & Joomla

apt install sudo

adduser USERNAME sudo

(opt) visudo
apt install apache2 adminer vim mc
source /etc/apache2/envvars
apache2 -M
apache2 -v
a2enmod http2
systemctl restart apache2
apache2 -M

vi /etc/apache2/conf-enabled/security.conf

 
ServerTokens 
Prod

apt install adminer
echo "Alias /adminer /usr/share/adminer/" | sudo tee /etc/apache2/conf-available/adminer.conf
a2enconf adminer
systemctl restart apache2

apt install mariadb-server

mysql_secure_installation

mysql -p

-- LVM

apt install lvm2

fdisk /dev/sdb/

n =>new

p=>primary

1 (1st partition)

default start/end

w => write

pvcreate /dev/sdb1

vgcreate VG_VAR /dev/sdb1

lvcreate -n LV_VAR -L 19g VG_VAR

mkfs -t ext4 /dev/mapper/VG_VAR-LV_VAR

3934d4f3-baef-437b-9f22-96e65cf9b72e var
0e618be1-bc1e-4e5d-9af6-6a0b6a99cdb8 nxt

SSHFS

apt install sshfs

php -r "copy('https://getcomposer.org/installer', 'composer-setup.php');"
php -r "if (hash_file('SHA384', 'composer-setup.php') === '544e09ee996cdf60ece3804abc52599c22b1f40f4323403c44d44fdfdd586475ca9813a858088ffbc1f233e9b180f061') { echo 'Installer verified'; } else { echo 'Installer corrupt'; unlink('composer-setup.php'); } echo PHP_EOL;"
php composer-setup.php

php composer-setup.php
export COMPOSER_HOME="$HOME/.config/composer";
php composer-setup.php
php -r "unlink('composer-setup.php');"

apt install certbot

Set up dhcpd under RHEL7/Centos7

yum -y install dhcp

vi /etc/dhcp/dhcpd.conf

# create new

# specify domain name

option domain-name "test.local";

# specify name server's hostname or IP address

option domain-name-servers dns.test.local;

# default lease time

default-lease-time 600;

# max lease time

max-lease-time 7200;

# this DHCP server to be declared valid

authoritative;

# specify network address and subnet mask

subnet 10.0.0.0 netmask 255.255.255.0 {

# specify the range of lease IP address

range dynamic-bootp 10.0.0.200 10.0.0.254;

# specify broadcast address

option broadcast-address 10.0.0.255;

# specify default gateway

option routers 10.0.0.1;
}

systemctl start dhcpd

systemctl enable dhcpd

Setting up BackupPC Server on RHEL7/CENTOS7

Install Minimum Server

Enable EPEL (yum install epel-release)

optional: yum install bash-completion mc

yum install backuppc

chkconfig backuppc on

service backuppc start

Open Firewall-Port 80

firewall-cmd --zone=public --add-port=80/tcp

Edit /etc/httpd/conf.d/BackupPC.conf, so that your client access is allowed

allow from 10.0.1.0/24
Require local (remove?)

Edit user in /etc/BackupPC/config.pl

$Conf{CgiAdminUserGroup} = 'admin';
$Conf{CgiAdminUsers}     = 'user';

yum install nfs-utils nfs-utils-lib

old: rsync httpd perl-Digest-MD5 perl-Data-Dumper samba-client bzip2 par2cmdline perl-Compress-Zlib mod_perl

create Serviceaccount (useradd backuppc)

./configure

sshfs

Most comfortable way to migrate files between 2 servers is creating a mount via sshfs.

yum install sshfs (fuse-sshfs from EPEL on Redhat + derivates)

sshfs root@10.0.1.x:/var/www/ /mnt/ww.blabla.com/ -o reconnect -C -o workaround=all