Creating self signed SSL certificate and configuring SSL in Tomcat

"C:\Program Files\Java\jdk1.8.0_241\bin\keytool" -genkey -keyalg RSA -noprompt -alias tomcat -dname "CN=localhost, OU=NA, O=NA, L=NA, S=NA, C=NA" -keystore keystore.jks -validity 9999 -storepass changeme -keypass changeme

 

Then  in server.xml add

<Connector port="443" protocol="HTTP/1.1" SSLEnabled="true"
               maxThreads="150" scheme="https" secure="true"
               clientAuth="false" sslProtocol="TLS"
            keyAlias="tomcat" keystoreFile="C:\Program Files\Java\jdk1.8.0_231\bin\keystore.jks" keystorePass="changeme"/>

After Windows restart SQL server developer edition login stops working on ASP.Net app

 For some reason SQL Server authentication (mixed mode) is disabled on SQL Server Developer Edition so have to enable it. And for some reason all the grants to the user have to reapplied.

Git Add Remote Server

git remote add origin user@<domain>@host:<path_to_repo.git>

In SQL Server add database user to server after version upgrade and restoring database

1) Change user owned schemas to dbo

2) Delete database user
3) Delete server user
4) Recreate server user with user mapping to database

5) Reassign schemas owned by user

In Windows get license information

slmgr /dli which means software license manager display license information

In Postgres generate table structure of table

pg_dump --table=<schema>.<table> -h ip_address -p port -U username -d databasename -s

To deploy Java web archive to Tomcat, set the following environment variables properly

JRE_HOME and CATALINA_HOME

To see output from starting Tomcat on Windows include following code in startup.bat

call "%EXECUTABLE%" start %CMD_LINE_ARGS% 

to

call "%EXECUTABLE%" run %CMD_LINE_ARGS%