Editing RaspberryPi3B (section)

===OwnCloud===

====Settings====
* WebDAV https://uweheuer.spdns.de/owncloud/remote.php/dav/files/uwe.heuer%40gmail.com/
* installation directory is <code>/var/www/html/owncloud/</code>
* configuration including data directory is <code>/var/www/html/owncloud/config/config.php</code>
* data directory is <code>/media/usbstick/owncloud/data/uwe.heuer@gmail.com</code>
* latest version of the files are in subdirectory <code>/files</code>

====Operation====
* make occ executable
 root@raspberrypi:/var/www/html/owncloud# sudo chmod +x occ
* test occ
 root@raspberrypi:/var/www/html/owncloud# sudo -u www-data ./occ
* scan filesystem and update DB
 root@raspberrypi:/var/www/html/owncloud# sudo -u www-data ./occ files:scan --all

====Installation====
[[ownCloud|ownCloud]] installed according to [https://eltechs.com/owncloud-on-raspberry-pi/ here]:
 apt-get install apache2 php5 php5-gd php-xml-parser php5-intl
 apt-get install php5-sqlite php5-mysql smbclient curl libcurl3 php5-curl
 usermod -a -G www-data www-data
* download owncloud-10.0.3.tar.bz2
 cd /var/www/html
 tar xfj /home/pi/owncloud-10.0.2.tar.bz2
 chown -R www-data:www-data /var/www/html
 service apache2 restart
* call <IP>/owncloud, admin user uwe.heuer@gmail.com Halloo0@1, DB root root owncloud localhost:3306
* change data directory according to [https://doc.owncloud.org/server/10.0/admin_manual/maintenance/manually-moving-data-folders.html here] by
 mkdir /media/usbstick/owncloud/data
 chown -R www-data:www-data /media/usbstick/owncloud/data
 apachectl -k stop
 rsync -avz /var/www/html/owncloud/data /media/usbstick/owncloud/
 mv data data_obsolete
 ln -s /media/usbstick/owncloud/data/ /var/www/html/owncloud/data
 apachectl -k graceful
* to make owncloud accessible via uweheuer domain added to /var/www/html/owncloud/config/config.php in trusted domains
  'trusted_domains' => 
  array (
    0 => '192.168.178.35',
    1 => 'uweheuer.spdns.de',
  )
* to make it accessible only via SSL see '000-default.conf' and '000-default-le-ssl.conf' in  [[#Site_Configuration|/etc/apache2/sites-enabled/]] 
* to correct inconsistent database and filesystem
 :/var/www/html/owncloud# sudo -u www-data php occ files:scan --all
====Contacts====
* Contacts-App via Market installed
* CardDav URL https://uweheuer.spdns.de/owncloud/remote.php/dav/addressbooks/users/uwe.heuer@gmail.com/contacts/ by Contacts -> Settings -> ... -> Link -> Copy URL to Clipboard
* for client configuration see e.g. [[SamsungTabletTabA#CardDAV-Sync_free|Samsung Tablet]]

====Calendar====
* Calendar-App via Market installed
* CalDav URL https://uweheuer.spdns.de/owncloud/remote.php/dav/
* for client configuration see e.g. [[SamsungTabletTabA#CalDAV-Sync|Samsung Tablet]]

====Upgrade====
* user (right top corner) -> settings
* admin area (left area) -> General -> Scroll down to Updater
* install apps again

====Backup====
=====Backup Files=====
* create <code>/backup/BackupOwncloudFiles.sh</code> with
** <code>cd /media/usbstick/owncloud/data/uwe.heuer@gmail.com/files</code>
** <code>zip -rFS -P "<STANDARD>" /media/usbstick/backup/owncloud/owncloud_backup.zip .</code>
* zipping every night by <code>sudo crontab -e</code>
* file will be fetched from Raspberry 4 and copied to Google drive (see [[RaspberryPi4B#Backup_of_Raspberry_3B|here]])

=====config directory=====
* and config directory <code>/var/www/html/owncloud/config/</code> to [[Computer#Backup|external discs]]

=====DB backup=====
created /media/ubunturoot permanently
* start Ubuntu HomePC (via fritz.box or WOL)
* login (as root) to Raspberry e.g. by Putty from Windows or Ubuntu
* mount directory for backup by
 sudo mount -t cifs -o username=uwe //192.168.178.202/shareroot /media/ubunturoot/
 <ROOT_PWD>
* change to Owncloud directory by
 cd /var/www/html/owncloud/
* backup DB by
 mysqldump --single-transaction -h localhost -u root -p  owncloud > /media/ubunturoot/backup/raspberry/owncloud/owncloud_<YYYY-MM-DD>.txt
 Enter password:
* unmount directory by
 umount /media/ubunturoot
* and copy dump file to [[Computer#Backup|external discs]]

=====Data Backup=====
* copy data directory <code>/media/usbstick/owncloud/data</code> to [[Computer#Backup|external discs]]