Editing EDTLaptop1

==Data==

* HP Elitebook 850 G5

===Certificates===
[[File:Certificates_1.PNG]]
* Interface Utility
[[File:InterfaceUtility_1.PNG|500px]]
[[File:InterfaceUtility_2.PNG|500px]]
[[File:InterfaceUtility_3.PNG|500px]]

*Interface Manager
[[File:InterfaceManager_1.PNG|500px]]
[[File:InterfaceManager_2.PNG|500px]]
[[File:InterfaceManager_3.PNG|500px]]


====Virtual Smartcard====
[[File:VSC_1.PNG|500px]]  [[File:VSC_2.PNG|500px]]

If the card is blocked you have to set a new PIN via PKI portal (16891689). You need one colleague which confirms your identity via the PKI portal.

==Windows 10==
* delete items in Explorer section 'Dieser PC' by deleting corresponding registry entries below HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\MyComputer\NameSpace (entries have been saved before to *.reg files in <code>C:\Uwes\Backup\Windows10</code> (see [https://www.deskmodder.de/wiki/index.php?title=Dieser_PC_3D-Objekte_unter_Ordner_entfernen_WIndows_10 here])

==Backup==
===Preparation===
* create C:\temp\export\
* create C:\Uwes\Backup\LocalMySQLBackup.bat // exports db files to C:\temp\export\
* [[File:Win10MapNetworkDrive1.PNG|400px]]
* [[File:Win10MapNetworkDrive2.PNG|400px]]
* [[File:Win10MapNetworkDrive3.PNG|400px]]
* create C:\Uwes\Backup\LocalBackupFileList.txt
* create C:\Uwes\Backup\LocalBackup.bat

===Operation===

==Programs==

===Angular===
* see [[Angular#Installation|here]]

===Angular IDE===
* installed from https://www.genuitec.com/docs/workbench/using-workbench-perspectives/ to C:\Uwes\Programme\Angular IDE
* uses the local angular installation

===Angular Material===
* see [[Angular_Material|here]]

===AWS Command Line Interface (AWS CLI)===
* [https://docs.aws.amazon.com/cli/latest/userguide/getting-started-install.html Installation Instructions and Download]
* installed to C:\Uwes\Programme\Amazon\AWSCLIV2\
* check by
 aws --version

===AWS eksctl===
* [https://eksctl.io/introduction/ install] eksctl via scoop
 eksctl version

===Beyond Compare===
* installed 2020-12-27 30-days trial version

===CalDav Synchronizer===
* configured in Outlook

===[[Curl|Curl]]===
* unzipped to <code>C:\Uwes\Programme\curl\curl-7.76.1-win64-mingw</code>

===Docker===
* install Docker Desktop for Windows 4.3.2
** asked for installation of Updatepaket für den WSL2-Linux-Kernel für x64-Computer
* now docker deskop app can be started
* in Powershell docker commands
 docker version
 docker run hello-world

===eclipse===
* download installer from https://www.eclipse.org/
* select 'Eclipse IDE for Enterprise Java Developers'
* create directory C:\Uwe\Uwes\eclipse\2020-12
* create directory C:\Uwes\eclipse\workspace_2020-12
* install via Help -> Eclipse Marketplace -> Spring Tools 4
[[File:SpringIDE1.PNG|400px]]

===Git===
* download Git-2.27.0-64-bit.ext from [https://gitforwindows.org/ here]
* Installed to <code>C:\Uwes\Programme\Git</code>
* PATH variable extended to <code>C:\Uwes\Programme\Git\cmd\</code>
 git --version
 git version 2.27.0.windows.1

===GitHub Cli===
* downloaded from [https://cli.github.com/ here]
* installed to C:\Uwes\Programme\GitHub CLI\

===Heroku===
* downlaod 64bit Windows installer

===JDK===

====Java 8====
* installed to <code>C:\Uwes\java\jdk1.8.0_212</code>
* set JAVA_HOME to <code>C:\Uwes\java\jdk1.8.0_212</code> to be used by [[/EDTLaptop1#Wildfly|Wildfly]] and javac task in generation for uweheuer app


====Java 13====
* new byte code raises problems with Axis
* download JDK 13.0.2 from oracle.com as exe and install it to <code>C:\Uwes\Java\jdk-13.0.2\</code>
 C:\Uwes\java\jdk-13.0.2\bin>java -version
 java version "13.0.2" 2020-01-14

===Magento===
* download Magento-CE-2.3.4_sample_data-2020-01-22-11-05-42.zip from Magento 
* extract to <code>C:\Uwes\Programme\xampp7.2.27\htdocs\magento234</code>
* create DB 'magento234' by PHPMyAdmin
* start Web Installation by http://localhost:8080/magento234/setup
* in <code>C:\Uwes\Programme\xampp7.2.27\htdocs\magento234\vendor\magento\framework\View\Element\Template\File\Validator.php</code> replace
 // $realPath = $this->fileDriver->getRealPath($path);
 if (PHP_OS_FAMILY === 'Windows')
   $realPath = str_replace('\\', '/', $this->fileDriver->getRealPath($path));
 else
   $realPath = $this->fileDriver->getRealPath($path);
* because of not working links in admin area replace in <code>C:\Uwes\Programme\xampp7.2.27\htdocs\magento234\app\etc</code>
  // <item name="view_preprocessed" xsi:type="object">Magento\Framework\App\View\Asset\MaterializationStrategy\Symlink</item> with
  <item name="view_preprocessed" xsi:type="object">Magento\Framework\App\View\Asset\MaterializationStrategy\Copy</item>
* powershell to start XAMPP-Control Center has to be run as admin
* edit DB password in <code>C:\Uwes\Programme\xampp7.2.27\htdocs\magento234\app\etc\env.php</code>

===Maven===
* downlaod apache-maven-3.8.5-bin.zip
* extract to <code>C:\Uwes\Programme\apache-maven-3.8.5\</code>
* add to system path <code>C:\Uwes\Programme\apache-maven-3.8.5\bin</code>

===MP3 Tag===
* C:\Uwes\Programme\MP3Tag\

===MS Teams===
* create directory <code>C:\Users\U1728\AppData\Roaming\Microsoft\Teams\Backgrounds\Uploads\</code> and put pictures here
* free background pictures https://pixabay.com/de/videos/search/hintergr%C3%BCnde/?pagi=3

===JQ===
* download 64-bit Windows executable to C:\Uwes\Programme\jq
* rename it to jq.exe
* add path to environment variables of U1728

===Kindle===
* download and intstallation

===NodeJS===
* [[NodeJS|NodeJS]] 
* download version 12.18.2 LTS from https://nodejs.org/en/
* installation to <code>C:\Uwes\Programme\nodejs\</code>

===Outlook===
* see signature files in <code>C:\Users\U1728\AppData\Roaming\Microsoft\Signatures</code>
* RTF mails

===OwnCloud Windows Client===
* installed via github download with uwe.heuer@gmail.com Halloo0@1 to <code>C:\Uwes\Programme\ownCloud\</code>
* data folder is C:\Uwes\owncloud\

===PHPStorm===
* download and install to <code>C:\Uwes\Programme\JetBrains\</code>
* take activation key from <code>C:\Uwes\owncloud\documents\Applications\PHPStorm\WendwebPHPStormActiviationKey.txt</code>

===[[Postgres|Postgres]]===
* from https://www.enterprisedb.com/downloads/postgres-postgresql-downloads to C:\Uwes\Programme\
* led to error [[File:PostgresInstallationError.PNG|thumb]]

* after Googling this seems to work, but did not 
 C:\Uwes\Programme\PostgreSQL\12\bin>initdb.exe -D "C:\Uwes\Programme\PostgreSQL\12\data"
 .\pg_ctl.exe -D "C:\Uwes\Programme\PostgreSQL\12\data" start
* therefore Postgres installation to be used on [[RaspberryPi4B#PostgreS.28QL.29|Raspberry]] remotely
* pgAdmin (master pwd <Lp>Halloo0@1<Lp>) by C:\Uwes\Programme\PostgreSQL\12\pgAdmin 4\bin\pgAdmin4.exe can be used on this Windows computer

===Postman===
* standard installation to <code>C:\Users\U1728\AppData\Local\Postman\Postman.exe</code>

===[[Python|Python]]===
* installation by 64-bit installer to <code>C:\Uwes\Programme\Python\Python39\</code>
* installation of pyscopg
 pip install psycopg2-binary
* installation of [[Python#Flask|Flask]]
 pip install flask
 pip install flask-sqlalchemy
* installation of Flask Migrate
 pip install Flask-migrate

===[[SpringBoot|Spring Boot CLI]]===
* download <code>spring-boot-cli-2.6.5-bin.zip</code>
* extract to <code>C:\Uwes\Programme\spring-2.6.5</code>
* add environment variable SPRING_HOME as <ocde>C:\Uwes\Programme\spring-2.6.5</code>
* add <code>C:\Uwes\Programme\spring-2.6.5\bin</code> to path
* test by
 spring version

===SSHFS===
* in order to be able to map a linux directory via SSH install WinFsp and SSHFS-Win according to [http://makerlab.cs.hku.hk/index.php/en/mapping-network-drive-over-ssh-in-windows here]
* a drive can be mapped by file manager with e.g. 
 \\sshfs\ubuntu@ec2-34-219-153-128.us-west-2.compute.amazonaws.com   
* or via cmd line with e.g.
 net use X: \\sshfs\billziss@mac2018.local

===Thunderbird===
* download and installation to C:\Uwes\Programme\
* copied data from old laptop according to [https://support.mozilla.org/de/kb/thunderbird-daten-auf-neuen-rechner-uebertragen here]

===UweHeuer App===
* create MySQL tables and copy content for productive server by batches <code>Raspberry*.bat</code>
* see also [[EDTLaptop1#MySQL_configuration|Wildfly Configuration]]
* call ant target 'deploy_laptop'

===UltraEdit===
* installation

===Visual Paradigm Community Edition===
* download and install to <code>C:\Uwes\Programme\Visual Paradigm CE 16.1</code>
* activation via uwe.heuer@eon.com and mail reply with code F9595-7A624-CUBR9-WTVJ5-C35JW

===Visual Studio Code===
* download User Installer from [https://code.visualstudio.com/download here]
* installed to <code>C:\Uwes\Programme\Microsoft VS Code</code>

===Wake On Lan (WOL)===
* C:\Uwes\Programme\WakeOnLan

===Wildfly===
* download from https://wildfly.org/downloads/ version 18.0.1
* extract to <code>C:\Uwes\Programme\wildfly-18.0.1.Final</code>
* edit <code>C:\Uwes\Programme\wildfly-18.0.1.Final\standalone\configuration</code>
  // <socket-binding name="http" port="${jboss.http.port:8080}"/>
  <socket-binding name="http" port="${jboss.http.port:8888}"/>
* logging configuration according to [[Uweheuer#Server_Logging|logging configuration]]

====MySQL configuration====
* download OS independent mysql-connector-java-8.0.19.zip from [https://dev.mysql.com/downloads/connector/ here] and extract it to <code>C:\Uwes\java\mysql-connector-java-8.0.19</code>
* install it to Wildfly by dragging jar file to Admin Console -> Deployments
* add Datasource for UweHeuer App by <code>C:\Uwes\Programme\wildfly-18.0.1.Final\bin\jboss-cli.bat</code> (Admin Console -> Configuration -> Subsystems -> Datasources & Drivers -> Datasources throws a frontend error) (see <code>/uweheuer/src/WEB-INF/classes/META-INF/persistence.xml</code>)
 /subsystem=datasources/data-source=MySQLDS:add(jndi-name="java:jboss/datasources/MySQLDS", driver-name="mysql-connector-java-8.0.19.jar",driver-class="com.mysql.cj.jdbc.Driver",user-name="root",password="mHalloo0@1m",connection-url="jdbc:mysql://localhost/mysql505?autoReconnect=true")

 /subsystem=datasources/data-source=MySQLDS_QA:add(jndi-name="java:jboss/datasources/MySQLDS_QA", driver-name="mysql-connector-java-8.0.19.jar",driver-class="com.mysql.cj.jdbc.Driver",user-name="root",password="mHalloo0@1m",connection-url="jdbc:mysql://localhost/mysql505_qa?autoReconnect=true")

* add Datasource for UwesWiki
 /subsystem=datasources/data-source=UwesWikiDS:add(jndi-name="java:jboss/datasources/UwesWikiDS", driver-name="mysql-connector-java-8.0.19.jar",driver-class="com.mysql.cj.jdbc.Driver",user-name="root",password="mHalloo0@1m",connection-url="jdbc:mysql://localhost/mediawiki")
* this creates entries which can have to be edited in the Admin Console
[[File:MySQLDS_Conf1.PNG|400px]]

[[File:MySQLDS_Conf2.PNG|400px]]

[[File:MySQLDS_Conf3.PNG|400px]]

[[File:MySQLDS_Conf4.PNG|400px]]

====Operations====
* manual start by (!!! start [[EDTLaptop1#Operations_2|xampp]] before !!!)
 C:\Uwes\Programme\wildfly-18.0.1.Final\bin\standalone.bat [--debug] // -debug for enabling Java Debugging
* check by [http://localhost:8888/ Wildfly Home]
* manual stop
 CTRL+C

===WinMerge===
* installed to C:\Uwes\Programme\WinMerge

===WinSCP===
* export and import of ini file from <code>C:\Uwes\owncloud\documents\Applications\WinSCP\2019-07-12_WinSCP.ini</code>

===XAMPP===
====XAMPP 7.4.2 (obsolete)====
* currently go to [[EDTLaptop1#XAMPP_7.2.27|7.2.27]], because of Magento incompatibility
* download 64 bit version and install via setup to <code>C:\Uwes\Programme\xampp\</code>
* installs PHP 7.4.2
* change Apache port according to [https://alexjustesen.com/2018/07/30/how-to-change-your-apache-listen-port-number-in-xampp/ here]
** press 'Config' button of Apache in httpd.conf:
 Listen 8080 // replaced Listen 80
 ServerName localhost:8080 // ServerName localhost:80

=====Add PHP to Path=====
* [[Windows10|Windows 10 set environment variables]] 
* add C:\Uwes\Programme\xampp7.2.27\php

=====Enable XDebug=====
* Download php_xdebug-2.9.1-7.4-vc15-x86_64.dll
* Move the downloaded file to C:\Uwes\Programme\xampp\php\ext
* Edit C:\Uwes\Programme\xampp\php\php.ini C:\WINDOWS\php.ini and add the line
 zend_extension = C:\Uwes\Programme\xampp\php\ext\php_xdebug-2.9.1-7.4-vc15-x86_64.dll
* Restart the webserver
* in addition according to [https://medium.com/d6-digital/installing-xdebug-for-xampp-with-php-in-windows-d2b750861118 here]
* install Chrome xdebug helper extension
* add remote_enable in php.ini

====XAMPP 7.2.27====
* download 64 bit version and install via setup to <code>C:\Uwes\Programme\xampp7.2.27</code>
* configurations in <code>C:\Uwes\Programme\xampp7.2.27\apache\conf\httpd.conf</code>
 Listen 8090
 ServerName localhost:8090

=====[[MySQL|MySQL]]=====
* change by root password (old was DB user = 'root', DB password = '<EMPTY>') by
 C:\Uwes\Programme\xampp7.2.27\mysql\bin>mysqladmin.exe --user=root password "mHalloo0@1m"
* login via
 mysql --user=root --password=mHalloo0@1m

=====Operations=====
* start manually with XAMPP control panel
 C:\Uwes\Programme\xampp7.2.27\xampp-control.exe

====PHPMyAdmin====
* set MySQL password in <code>C:\Uwes\Programme\xampp7.2.27\phpMyAdmin</code>