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

  1. Put keepass.kdbx on Owncloud folder
  2. 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

  1. 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

 

Breadcrumbs