Editing RaspberryPi3B (section)

===UweHeuer===
* create database mysql505 with PHPMyAdmin
* export and import database
* create /wildfly/wildfly-11.0.0.Final/standalone/data/uweheuer
* copy abc.tmp and /wildfly/wildfly-11.0.0.Final/standalone/data
* download mysql-connector-java-5.1.44-bin.jar from MySQL site
* deploy it via the Wildfly admin console
* create datasources via Web admin console with
 MySQLDS (see [[:File:RaspberryMySQL505Configuration.pdf]])
 jdbc:mysql://localhost/mysql505?autoReconnect=true
 root root
 ...
 UwesWikiDS
 ...
* after [[RaspberryPi3B#SSL|SSL]] setup added to [[#Site_Configuration|/etc/apache2/sites-enabled/]]000-default-le-ssl.conf
 ProxyPass /uweheuer ajp://localhost:8009/uweheuer
 ProxyPassReverse /uweheuer http://localhost/uweheuer
 ProxyPass /uweheuer_qa ajp://localhost:8009/uweheuer_qa
 ProxyPassReverse /uweheuer_qa http://localhost/uweheuer_qa

* /etc/apache2/sites-available/000-default.conf permanent redirect to SSL 
 RedirectMatch ^/$ https://uweheuer.spdns.de/wordpress
 Redirect /uweheuer https://uweheuer.spdns.de/uweheuer
 Redirect /uweheuerqs https://uweheuer.spdns.de/uweheuerqs
 Redirect /owncloud https://uweheuer.spdns.de/owncloud

* create <code>/myprogs</code> and copy DisAndEnableUweHeuer.bat
* Wildfly logger configuratoin according to [[Uweheuer#Server_Logging|here]]
* after deployment uweheuer.war is probably extracted to (vfs stands for virtual file system)
 /home/uwe/raspberry_root/wildfly/wildfly-11.0.0.Final/standalone/tmp/vfs/temp

====Backup August 2025====
* C:\Uwes\owncloud\batches\Raspberry3BBookmarksToCTemp.bat Window cmd batch (not Powershell) to copy DB content for uweheuer to C:\temp

====Backup====
* on laptop (xampp must be running)
** create DB mysql506
** run script
 C:\Uwes\Batches\RaspberryBookmarksToLocalhost.bat
** rename DB with date extension
* on Raspberry map ubunturoot
 mysqldump --single-transaction -h localhost -u root -p  mysql506 > /media/ubunturoot/backup/raspberry/uweheuer/mysql506_<YYYY-MM-DD>.txt
 Enter password:
** copy <code>/wildfly/wildfly-19.1.0.Final/data/uweheuer/abc.tmp|Configuration.properties</code> to <code>/media/ubunturoot/backup/raspberry/uweheuer/</code>
** copy files to [[Computer#Backup|external discs]]