Author: ron (Page 24 of 34)

Importing a Certificate to Java Keystore

November 14, 2019 / ron / 0 Comments

Use the following command in importing a certificate to Java keystore:

The keytool is normally found in $JAVA_HOME/jre/bin (i.e. the $JAVA_HOME variable is where you've installed JDK).

keytool -importcert -alias <ALIAS> -v -keystore <KEYSTORE_FILE> -file <INPUT_FILE> -storepass <KEYSTORE_PASSWORD>

Token	Description
ALIAS	Alias name of the entry to process
KEYSTORE_FILE	The target key store file (e.g. cacerts* found in $JAVA_HOME/jre/lib/security)*
INPUT_FILE	Input file name (i.e. certificate file like cer, crt* or pem)*
KEYSTORE_PASSWORD	The password for accessing the keystore (i.e. the default is changeit)

Using Google SMTP with Archiva in Synology

November 14, 2019 / ron / 0 Comments

Pre-requisite

Configured Archiva in Synology

Procedure

Open the archiva.xml file found in the following location:
```
/volume1/@appstore/Tomcat7/src/conf/Catalina/localhost
```

Update the Resource entry with the name mail/Session to become the following:

<Resource name="mail/Session" auth="Container"
      type="javax.mail.Session"
      mail.smtp.host="smtp.gmail.com"
          mail.smtp.port="587"
          mail.smtp.auth="true"
          mail.smtp.user="<USERNAME>"
          password="<PASSWORD>"
          mail.smtp.starttls.enable="true"
          mail.transport.protocol="smtp"/>

Token	Description
USERNAME	Google Account
PASSWORD	Google App Password

Save the updated file and wait for Archiva to restart.

If you've updated the archiva.xml file and save it, Tomcat will detect it and it will restart the Archiva application.

Artifactory on Ubuntu with MariaDB

November 13, 2019 / ron / 0 Comments

Requirement

Java 8
MariaDB 10.3.x

Preparing MariaDB

Create the database called artdb using the following command:

CREATE DATABASE artdb CHARACTER SET utf8 COLLATE utf8_bin;

Add artifactory as the user to the newly created database using the following command:
```
GRANT ALL on artdb.* TO 'artifactory'@'<HOST>' IDENTIFIED BY '<PASSWORD>';
FLUSH PRIVILEGES;
```
Token Description

HOST The address of machine housing MariaDB

PASSWORD The password for the artifactory user.

Installing Artifactory

Add the artifactory repository to your source list.
```
echo "deb https://jfrog.bintray.com/artifactory-debs <DISTRIBUTION> main" | sudo tee -a /etc/apt/sources.list
```
Token Description
DISTRIBUTION
Use the following command to identify the destribution:

lsb_release -c

The sample output for ubuntu bionic distribution:

Codename: bionic

Download jfrog public key using the following command:

curl https://bintray.com/user/downloadSubjectPublicKey?username=jfrog | sudo apt-key add -

Update your package list using the following command:
```
sudo apt-get update
```
Install the oss artifactory using the following command:
```
sudo apt-get install jfrog-artifactory-oss
```

Artifactory Service Commands

Objective	Command
Checking service status	sudo service artifactory status
Starting the service	sudo service artifactory start
Stopping the service	sudo service artifactory stop
Restarting the service	sudo service artifactory restart

Accessing The Artifactory from the Browser

Use the following address to access the artifactory application:
```
http://localhost:8180/artifactory
```
Use the following default credentails:

Field Value

Username admin

Password password

It is recommended to change the admin password after installation but you can do it after hooking it to MariaDB.

Using the MariaDB Prepared Earliear

Variable	Value
$ARTIFACTORY_HOME	/var/opt/jfrog/artifactory

Using the terminal, change the directory to $ARTIFACTORY_HOME/tomcat/lib and execute the following:
```
sudo wget https://downloads.mariadb.com/Connectors/java/connector-java-2.4.4/mariadb-java-client-2.4.4.jar
```
You can visit https://mariadb.com/downloads/#connectors for a different version of java client.
Copy $ARTIFACTORY_HOME/misc/db/mariadb.properties to $ARTIFACTORY_HOME/etc/db.properties.

This will replace the default db.properties that is using derby as the database.

Update the following fields in the db.properties:

Field	Value
url	jdbc:mariadb://<HOST>:<PORT>/artdb?characterEncoding=UTF-8&elideSetAutoCommits=true&useSSL=false&useMysqlMetadata=true
password	The password you've used on Preparing MariaDB section.

Token	Value
HOST	The host you've indentified on Preparing MariaDB section.
PORT	This is the port where MariaDB is listening (i.e. 3306 or 3307).

Restart the artifactory service using the following command:
```
sudo service artifactory restart
```

Using Google as Your SMTP Server

November 13, 2019 / ron / 0 Comments

Use the following parameters

Parameter	Value
Outgoing Mail (SMTP) Server	smtp.gmail.com
Port	465 (SSL required) or 587 (TLS required)
Use Authentication	Yes
Use Secure Connection	Yes
Username	Google Account
Password	Google App Password

Creating a Google App Password

November 13, 2019 / ron / 0 Comments

Procedure

1. Sign-in to https://accounts.google.com/ using the account to wanted to use.
2. Click Security from the side menu
3. On the Signing in to Google section, click App Passwords.
4. Select the application you wanted to use from google (e.g. Mail, Calendar, Contacts or YouTube).
5. Select the Other (Custom name) for the device, and name it appropriately.
6. Click the generate button.
Now you have your 16-character password that you can use.

Using RSYNC to Sync Some Local Directories to Remote Directory via SSH

November 13, 2019 / ron / 0 Comments

Requirement

SSH Server on Remote Computer

Syntax

To sync some of your local directories to a remote directory via ssh you can use the following syntax:

rsync -av -L --delete -e ssh <DIR1>[[ <DIR2>] <DIRn>] <REMOTE_USER>@<REMOTE_HOST>:<REMOTE_DIR>

Token	Description
DIR1, DIR2, DIRn	These are the local directories you've wanted to be synced remotely. Only DIR1 is required and the rest are optional.
REMOTE_USER	A valid user on the remote machine.
REMOTE_HOST	A valid address of the remote machine.
REMOTE_DIR	The destination directory on the remote machine.

Example

rsync -av -L --delete -e ssh /data/artifactory backup01@10.0.0.204:/volume1/backup

Create a New Azure Function App with .Net Core by Azure Function Core Tools

November 11, 2019 / ron / 0 Comments

Requirements

.Net Core
Azure Functions Core Tools

Procedures

Create a directory to house your azure function codes.
Using the command console, navigate to the newly created directory.
Execute the following command and select dotnet (i.e. usign the arrow keys) and press enter.
```
func init
```
Wait for the command prompt to come back.
On the new prompt, execute the following command and select the template you want (i.e. using the arrow keys) and press enter.
```
func new
```
Type a name for the function and press enter.

Adding a Package Reference into a .Net Core Project

October 18, 2019 / ron / 0 Comments

The simplest way to add a new package reference in a .net core project is to use the following command:

dotnet add package <PACKAGE_NAME> [-v <VERSION>]

Where:

Parameter	Description
PACKAGE_NAME	The name of the package name to be added as reference.
VERSION	The specific version of the package.

Displaying a Mapped Network Drives in Windows

October 16, 2019 / ron / 0 Comments

If you ever wonder where are those mapped network drives are pointing. You can do the following:

Open a console terminal (e.g. cmd).
Run the following command:
```
net use
```

This command will show you the status and mapping of mapped network drives you have.

Publishing to a Single Exe File

October 14, 2019 / ron / 0 Comments

Publish a .Net Core Console Application into a 64-bit single executable file using the following command:

dotnet publish -r win-x64 -c Release /p:PublishSingleFile=true /p:PublishTrimmed=true

Author: ron (Page 24 of 34)

Importing a Certificate to Java Keystore

Using Google SMTP with Archiva in Synology

Pre-requisite

Procedure

Artifactory on Ubuntu with MariaDB

Requirement

Preparing MariaDB

Installing Artifactory

Artifactory Service Commands

Accessing The Artifactory from the Browser

Using the MariaDB Prepared Earliear

Using Google as Your SMTP Server

Creating a Google App Password

Using RSYNC to Sync Some Local Directories to Remote Directory via SSH

Create a New Azure Function App with .Net Core by Azure Function Core Tools

Adding a Package Reference into a .Net Core Project

Displaying a Mapped Network Drives in Windows

Publishing to a Single Exe File

Recent Posts

Recent Comments

Archives

Categories

Meta