# /etc/fstab: static file system information.
#
# Use 'blkid' to print the universally unique identifier for a
# device; this may be used with UUID= as a more robust way to name devices
# that works even if disks are added and removed. See fstab(5).
#
# <file system> <mount point>   <type>  <options>       <dump>  <pass>
# / was on /dev/sda2 during installation
UUID=19536631-f60e-4685-a628-dbd71f460041 /               ext4    errors=remount-ro 0       1
# /boot/efi was on /dev/sda1 during installation
UUID=47FC-8972  /boot/efi       vfat    umask=0077      0       1
# swap was on /dev/sda3 during installation
UUID=3ffbd13e-5e58-413c-a940-1c7c3a3291e0 none            swap    sw              0       0
/dev/fd0        /media/floppy0  auto    rw,user,noauto,exec,utf8 0       0

# SMB DRIVE für DatenSicherung einbinden
# <file system>                    <mount point>   		<type>       <options>                           								<dump>  	<pass>

//S1582/ED_KiFög 			/media/ED_KiFoeG 		cifs,		username=tjeckel,password=97JFBeil05#,noauto,uid=33,gid=33,file_mode=0755,dir_mode=0755  	0 		0

//NB4283/20__DatenSicherung_PSYD 	/media/DatenSicherung_PSYD	cifs,		username=tjeckel,password=97JFBeil05#,noauto,uid=33,gid=33,file_mode=0755,dir_mode=0755  0 0



# //S1582/ED_KiFög			/media/ED_KiFoeG     	cifs 		domain=mansfeldsuedharz.de,user=tjeckel,password=#97jfbeil05,noauto,uid=33,gid=33,file_mode=0755,dir_mode=0755,sec=ntlmssp,nodev,nosuid,noexec 0 0

# //NB4283/04__WebProgramme /media/WebProgramme cifs ,username=tjeckel,password=#97jfbeil05,uid=33,gid=33,file_mode=0755,dir_mode=0755  0 0

###//NB4283/04__WebProgramme /media/WebProgramme cifs defaults,noauto,nofail,username=tjeckel,passwd=#97jfbeil05,uid=33,gid=33,file_mode=0777,dir_mode=0777    0    0


### https://mycloud.netzwerk-kinderschutz-msh.de/remote.php/webdav/ /media/MSH_LNKS_Internet    davfs   defaults,uid=33,gid=33,_netdev,auto  0       0

# Am Ende der fstab muss immer noch eine Leerzeile kommen, sonst erhält man die Fehlermeldung: no final newline at the end of /etc/fstab

# /etc/crontab: system-wide crontab
# Unlike any other crontab you don't have to run the `crontab'
# command to install the new version when you edit this file
# and files in /etc/cron.d. These files also have username fields,
# that none of the other crontabs do.

SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

# m h dom mon dow user	command
17 *	* * *	root    cd / && run-parts --report /etc/cron.hourly
25 6	* * *	root	test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
47 6	* * 7	root	test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
52 6	1 * *	root	test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )
#

# */1  7-18  *  *  1,2,3,4,5 root /usr/sbin/php-fpm5.6 -f /var/www/25_NextCloud/cron.php > /dev/null 2>&1  

*/1  7-18  *  *  1,2,3,4,5 www-data php -f /var/www/25_NextCloud/cron.php  2>&1 /var/zzz/nextcloud-cronjob-log

15  19  *  *  1,2,3,4,5 root /var/zzz/00_BackupSkripte/01_DS_KiTa_LEQ_DATA.sh 2>&1 /var/zzz/01_DS_KiTa_LEQ_DATA-log

15  20  *  *  1,2,3,4,5 root perl /var/www/18_D_KiTa_LEQ_WP/tasks/A_04_DumpMYSQL/msd_cron/crondump.pl -config=mysqldumper -html_output=0

15  7  *  *  1,2,3,4,5 root perl /var/www/23_phpMyDump/msd_cron/crondump.pl -config=mysqldumper -html_output=0

45  7  *  *  1,2,3,4,5 root /var/zzz/00_BackupSkripte/02_DS_phpMyDump.sh 2>&1 /var/zzz/02_DS_phpMyDump-log

45  7  *  *  1,2,3,4,5 root mount /mnt/ED_KiFoeG

50  7  *  *  1,2,3,4,5 root mount /mnt/DatenSicherung_PSYD

5   8 * * 1,2,3,4,5 root /usr/local/bin/osync.sh /etc/osync/xxx/sync_99_www.conf --silent 

*/1 9-18 * * 1,2,3,4,5 root /usr/local/bin/osync.sh /etc/osync/xxx/sync_00_kita_uebersicht_02.conf --silent 

*/5 9-18 * * 1,2,3,4,5 root /usr/local/bin/osync-batch.sh --path=/etc/osync --silent

# 10 8 * * 1,2,3,4,5 root /usr/local/bin/osync-batch.sh --path=/etc/osync/www --silent

*/30 7-18 * * 1,2,3,4,5 root bash /home/psyd_tjeckel_msh/rsync_LNKS-DATA.sh

#!/bin/bash
#
# Automatisches sichern von speziellen anzugebenden Ordner
# mit Hilfe von "rsync" und cronjob von localhost zum remotehost
#

# Angabe der Ordner die gesichert werden soll.
# ACHTUNG
# /[Ordner]/ -> Inhalt des Ordners wird gesichert
# /[Ordner]  -> Ordner wird gesichert

 RSYNC=/usr/bin/rsync
 SSH=/usr/bin/ssh
 KEY=/home/psyd_tjeckel_msh/.ssh/lnks_msh_internet
 RUSER=psyd_tjeckel_msh
 RHOST=217.160.14.28
 RPATH=/var/www/vhosts/netzwerk-kinderschutz-msh.de/21_LNKS_02_WIKI_DATA
 LPATH=/var/www/21_LNKS_02_WIKI_DATA/
 LOGFILE="/home/psyd_tjeckel_msh/rsync.log"


$RSYNC --rsync-path="sudo rsync" -rlpt  --delete -e "$SSH -i $KEY"  $LPATH $RUSER@$RHOST:$RPATH  > $LOGFILE

# ssh -i /home/psyd_tjeckel_msh/.ssh/lnks_msh_internet psyd_tjeckel_msh@217.160.14.28 sudo chown -R 10000:1002 psyd_tjeckel_msh@217.160.14.28/var/www/vhosts/netzwerk-kinderschutz-msh.de/21_LNKS_02_WIKI_DATA


ssh -i /home/psyd_tjeckel_msh/.ssh/lnks_msh_internet psyd_tjeckel_msh@217.160.14.28 sudo chown -R 10000:1002 $RPATH

# /etc/fstab: static file system information.
#
# Use 'blkid' to print the universally unique identifier for a
# device; this may be used with UUID= as a more robust way to name devices
# that works even if disks are added and removed. See fstab(5).
#
# <file system> <mount point>   <type>  <options>       <dump>  <pass>
/dev/mapper/archiv--werkzeuge--vg-root /               ext4    errors=remount-ro 0       1
# /boot was on /dev/sda1 during installation
UUID=b798ca91-7e2b-44d8-801a-5efc818eae0b /boot           ext2    defaults        0       2
/dev/mapper/archiv--werkzeuge--vg-swap_1 none            swap    sw              0       0

# SMB DRIVE für DatenSicherung einbinden
# <file system>                    <mount point>   		<type>       <options>                           								<dump>  	<pass>

//S1582/ED_KiFög 			/media/ED_KiFoeG 		cifs,		username=tjeckel,password=97JFBeil05#,noauto,uid=33,gid=33,file_mode=0755,dir_mode=0755  	0 		0

//192.168.56.1/20__DatenSicherung_PSYD 	/media/DatenSicherung_PSYD	cifs,		username=tjeckel,password=97JFBeil05#,noauto,uid=33,gid=33,file_mode=0755,dir_mode=0755  0 0

//192.168.56.1/05__Daten 	/media/05__Daten	cifs,		username=tjeckel,password=97JFBeil05#,noauto,uid=33,gid=33,file_mode=0755,dir_mode=0755  0 0

//192.168.56.1/04__WebProgramme 	/media/04__WebProgramme	cifs,		username=tjeckel,password=97JFBeil05#,noauto,uid=33,gid=33,file_mode=0755,dir_mode=0755  0 0

# Am Ende der fstab muss immer noch eine Leerzeile kommen, sonst erhält man die Fehlermeldung: no final newline at the end of /etc/fstab

# /etc/crontab: system-wide crontab
# Unlike any other crontab you don't have to run the `crontab'
# command to install the new version when you edit this file
# and files in /etc/cron.d. These files also have username fields,
# that none of the other crontabs do.

SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

# m h dom mon dow user	command
17 *	* * *	root    cd / && run-parts --report /etc/cron.hourly
25 6	* * *	root	test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily )
47 6	* * 7	root	test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.weekly )
52 6	1 * *	root	test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.monthly )
#

*/1  7-18  *  *  1,2,3,4,5 www-data php -f /var/www/25_NextCloud/cron.php  2>&1 /var/zzz/nextcloud-cronjob-log

@reboot  root perl /var/www/23_phpMyDump/msd_cron/crondump.pl -config=mysqldumper -html_output=0

@reboot  root mount /media/05__Daten

@reboot  root mount /media/DatenSicherung_PSYD

@reboot  root mount /media/04__WebProgramme

# 30 7 * * 1,2,3,4,5   root mount /media/05__Daten

# 30 7 * * 1,2,3,4,5  root mount /media/DatenSicherung_PSYD

# 30 7 * * 1,2,3,4,5  root mount /media/04__WebProgramme

# */5 9-18 * * 1,2,3,4,5 root /usr/local/bin/osync-batch.sh --path=/etc/osync/tj_server --silent

5 8-22 * * 1,2,3,4,5 root /usr/local/bin/osync-batch.sh --path=/etc/osync/tj_server --silent

# 15 20 * * 1,2,3,4,5 root /usr/local/bin/osync-batch.sh --path=/etc/osync/tj_server --silent

#!/usr/bin/env bash

###### osync - Rsync based two way sync engine with fault tolerance
###### (C) 2013-2017 by Orsiris de Jong (www.netpower.fr)
###### osync v1.1x / v1.2x config file rev 2017020801

## ---------- GENERAL OPTIONS

## Sync job identification
INSTANCE_ID="sync_tj_01_DatenWeb"

## Directories to synchronize.
## Initiator is the system osync runs on. The initiator directory must be a local path.
INITIATOR_SYNC_DIR="/var/www/01_DatenWeb"

## Target is the system osync synchronizes to (can be the same system as the initiator in case of local sync tasks). The target directory can be a local or remote path.
TARGET_SYNC_DIR="/media/05__Daten/01_DatenWeb"
#TARGET_SYNC_DIR="ssh://backupuser@yourhost.old:22//home/git/osync/dir2"

## If the target system is remote, you can specify a RSA key (please use full path). If not defined, the default ~/.ssh/id_rsa will be used. See documentation for further information.
 SSH_RSA_PRIVATE_KEY="/home/backupuser/.ssh/id_rsa"

## Alternatively, you may specify an SSH password file (less secure). Needs sshpass utility installed.
 SSH_PASSWORD_FILE=""

## When using ssh filter, you must specify a remote token matching the one setup in authorized_keys
 _REMOTE_TOKEN=SomeAlphaNumericToken9

## Create sync directories if they do not exist
CREATE_DIRS=no

## Log file location. Leaving this empty will create a logfile at /var/log/osync_version_SYNC_ID.log (or current directory if /var/log doesn't exist)
LOGFILE=""

## Generate an alert if initiator or target replicas have less free space than given value in KB. Set this to zero to skip disk space tests. 
MINIMUM_SPACE=10240

## Bandwidth limit Kbytes / second. Leave 0 to disable limitation
BANDWIDTH=0

## If enabled, synchronization on remote system will be processed as superuser. See documentation for /etc/sudoers file configuration.
SUDO_EXEC=no
## Paranoia option. Don't change this unless you read the documentation.
RSYNC_EXECUTABLE=rsync
## Remote rsync executable path. Leave this empty in most cases
RSYNC_REMOTE_PATH=""

## Rsync exclude / include order (the option set here will be set first, eg: include will make include then exclude patterns)
RSYNC_PATTERN_FIRST=include

## List of files / directories to incldue / exclude from sync on both sides (see rsync patterns, wildcards work).
## Paths are relative to sync dirs. List elements are separated by a semicolon.
RSYNC_INCLUDE_PATTERN=""
RSYNC_EXCLUDE_PATTERN=""
#RSYNC_EXCLUDE_PATTERN="tmp;archives"

## Files that contains lists of files / directories to include / exclude from sync on both sides. Leave this empty if you don't want to use an exclusion file.
## This file has to be in the same directory as the config file
## Paths are relative to sync dirs. One element per line.
RSYNC_INCLUDE_FROM=""
#RSYNC_EXCLUDE_FROM=""
RSYNC_EXCLUDE_FROM="exclude.list"

## List elements separator char.  You may set an alternative separator char for your directories lists above.
PATH_SEPARATOR_CHAR=";"

## ---------- REMOTE SYNC OPTIONS

## ssh compression should be used unless your remote connection is good enough (LAN)
SSH_COMPRESSION=yes

## Ignore ssh known hosts. DANGER WILL ROBINSON DANGER ! This can lead to security issues. Only enable this if you know what you're doing.
SSH_IGNORE_KNOWN_HOSTS=no

## Check for connectivity to remote host before launching remote sync task. Be sure the hosts responds to ping. Failing to ping will stop sync.
REMOTE_HOST_PING=no

## Check for internet access by pinging one or more 3rd party hosts before remote sync task. Leave empty if you don't want this check to be be performed. Failing to ping will stop sync.
## If you use this function, you should set more than one 3rd party host, and be sure you can ping them.
## Be aware some DNS like opendns redirect false hostnames. Also, this adds an extra execution time of a bit less than a minute.
REMOTE_3RD_PARTY_HOSTS="www.kernel.org www.google.com"

## ---------- MISC OPTIONS

## Optional arguments passed to rsync executable. The following are already managed by the program and shoul never be passed here
## -r -l -p -t -g -o -D -E - u- i- n --executability -A -X -L -K -H -8 -zz –skip-compress –checksum –bwlimit –partial –partial-dir –no-whole-file –whole-file –backup –backup-dir –suffix
## --exclude --exclude-from --include --include-from --list-only --stats
RSYNC_OPTIONAL_ARGS=""

## Preserve basic linux permissions
PRESERVE_PERMISSIONS=yes
PRESERVE_OWNER=yes
PRESERVE_GROUP=yes
## On MACOS X, does not work and will be ignored
PRESERVE_EXECUTABILITY=yes

## Preserve ACLS. Make sure source and target FS can handle ACL. Disabled on Mac OSX.
PRESERVE_ACL=no
## Preserve Xattr. Make sure source and target FS can manage identical XATTRS. Disabled on Mac OSX.
PRESERVE_XATTR=no
## Transforms symlinks into referent files/dirs. Be careful as symlinks without referrent will break sync as if standard files could not be copied.
COPY_SYMLINKS=no
## Treat symlinked dirs	as dirs. CAUTION: This also follows symlinks outside of the replica root.
KEEP_DIRLINKS=no
## Preserve hard links. Make sure source and target FS can manage hard links or you will lose them.
PRESERVE_HARDLINKS=no
## Do a full checksum on all files that have identical sizes, they are checksummed to see if they actually are identical. This can take a long time.
CHECKSUM=no

## Let RSYNC compress file transfers. Do not use this if both initator and target replicas are on local system. Also,  do not use this if you already enabled SSH compression.
RSYNC_COMPRESS=no

## Maximum execution time (in seconds) for sync process. Set these values zero will disable max execution times.
## Soft exec time only generates a warning. Hard exec time will generate a warning and stop sync process.
SOFT_MAX_EXEC_TIME=7200
HARD_MAX_EXEC_TIME=10600

## Log a message every KEEP_LOGGING seconds just to know the task is still alive
KEEP_LOGGING=1801

## Minimum time (in seconds) in file monitor /daemon mode between modification detection and sync task in order to let copy operations finish.
MIN_WAIT=60

## Maximum time (in seconds) waiting in file monitor / daemon mode. After this time, sync is run.
## Use 0 to wait indefinitely.
MAX_WAIT=7200

## ---------- BACKUP AND DELETION OPTIONS

## Enabling this option will keep a backup of a file on the target replica if it gets updated from the source replica. Backups will be made to .osync_workdir/backups
CONFLICT_BACKUP=yes
## Keep multiple backup versions of the same file. Warning, This can be very space consuming.
CONFLICT_BACKUP_MULTIPLE=no
## Osync will clean backup files after a given number of days. Setting this to 0 will disable cleaning and keep backups forever. Warning: This can be very space consuming.
CONFLICT_BACKUP_DAYS=30
## If the same file exists on both replicas, newer version will be synced. However, if both files have the same timestamp but differ, CONFILCT_PREVALANCE sets winner replica.
CONFLICT_PREVALANCE=initiator

## On deletion propagation to the target replica, a backup of the deleted files can be kept. Deletions will be kept in .osync_workdir/deleted
SOFT_DELETE=yes
## Osync will clean deleted files after a given number of days. Setting this to 0 will disable cleaning and keep deleted files forever. Warning: This can be very space consuming.
SOFT_DELETE_DAYS=30

## Optional deletion skip on replicas. Valid values are "initiator", "target", or "initiator,target"
SKIP_DELETION=

## ---------- RESUME OPTIONS

## Try to resume an aborted sync task
RESUME_SYNC=yes
## Number maximum resume tries before initiating a fresh sync.
RESUME_TRY=2
## When a pidlock exists on slave replica that does not correspond to the initiator's instance-id, force pidlock removal. Be careful with this option if you have multiple initiators.
FORCE_STRANGER_LOCK_RESUME=no

## Keep partial uploads that can be resumed on next run, experimental feature
PARTIAL=no

## Use delta copy algortithm (usefull when local paths are network drives), defaults to yes
DELTA_COPIES=yes

## ---------- ALERT OPTIONS

## List of alert mails separated by spaces
## Most Unix systems (including Win10 bash) have mail support out of the box
## Just make sure that the current user has enough privileges to use mail / mutt / sendmail and that the mail system is configured to allow outgoing mails
## on pfSense platform, smtp support needs to be configured in System > Advanced > Notifications
DESTINATION_MAILS="tjeckel@mansfeldsuedharz.de"

## Optional change of mail body encoding (using iconv)
## By default, all mails are sent in UTF-8 format without header (because of maximum compatibility of all platforms)
## You may specify an optional encoding here (like "ISO-8859-1" or whatever iconv can handle)
MAIL_BODY_CHARSET=""

## Additional mail parameters needed for Android / Busybox / Cygwin / MSYS
## Android & Busybox use sendmail (and openssl if encryption is needed)
## MSYS & Cygwin Windows mail support relies on mailsend.exe from muquit, http://github.com/muquit/mailsend which needs to be in %PATH% environment variable

SENDER_MAIL="osync@psysd.mansfeldsuedharz.de"
SMTP_SERVER=mail.mansfeldsuedharz.de
SMTP_PORT=25
# encryption can be tls, ssl or none
SMTP_ENCRYPTION=tls
SMTP_USER=tjeckel
SMTP_PASSWORD=zo24el

## ---------- EXECUTION HOOKS

## Commands can will be run before and / or after sync process (remote execution will only happen if REMOTE_OPERATION is set).
LOCAL_RUN_BEFORE_CMD=""
LOCAL_RUN_AFTER_CMD=""

REMOTE_RUN_BEFORE_CMD=""
REMOTE_RUN_AFTER_CMD=""

## Max execution time of commands before they get force killed. Leave 0 if you don't wan't this to happen. Time is specified in seconds.
MAX_EXEC_TIME_PER_CMD_BEFORE=0
MAX_EXEC_TIME_PER_CMD_AFTER=0

## Stops osync execution if one of the above commands fail
STOP_ON_CMD_ERROR=yes

## Run local and remote after sync commands even on failure
RUN_AFTER_CMD_ON_ERROR=no