Useful Applications List

Windows Platform

VSCodium is a fork of Microsoft Visual Studio Code Editor, modified to have full open-source access.

https://www.linuxcapable.com/how-to-install-vscodium-on-ubuntu-20-04-lts/

The source code for this product can be found on GitHub, where it is licensed under MIT license and, therefore, will always remain free as long you don’t mind installing extra features via plugins or extensions from third parties like Telemetry transmitting your browsing habits across networks without permission.

Here are the steps to install VSCodium on Ubuntu Linux:

1. Update Ubuntu

1

sudo apt update && sudo apt upgrade

2. Install Dependencies

1

sudo apt install curl apt-transport-https gnupg2 -y

3. Import GPG

1
2

curl https://gitlab.com/paulcarroty/vscodium-deb-rpm-repo/raw/master/pub.gpg | gpg --dearmor \
| sudo tee /usr/share/keyrings/vscodium.gpg >/dev/null

4. Import the Repository

1
2
3

echo "deb [arch=amd64 signed-by=/usr/share/keyrings/vscodium.gpg] \
https://download.vscodium.com/debs vscodium main" \
| sudo tee /etc/apt/sources.list.d/vscodium.list

5. Run APT update to reflect new additional repository

1

sudo apt update

6. Install VSCodium

1

sudo apt install codium -y

7. Launch VSCodium

vscodium for normal launch, while vscodium & will launch it in the background to free up the terminal.

You can also launch it in desktop mode.

8. Update VSCodium

1

sudo apt update && sudo apt upgrade

9. Remove (uninstall) VSCodium

1

sudo apt autoremove codium -y

10. Remove VSCodium Repository

1

sudo rm /etc/apt/sources.list.d/vscodium.list

11. Remove VSCodium GPG key

1

sudo rm /usr/share/keyrings/vscodium.gpg

Data Catalog 3.0 Requirements

A correctly implemented data catalog will provide:

• Intuitive UI clean and easy to navigate to consume and search for data
• Visual Query Builder ability to share queries with other users
• Ability to Share data internally & externally
• Collaboration update business context & data dictionary (driven by end users to promote continuous improvements)
• Ability to Integrate with other apps, APIs, etc
• Security user roles and groups to ensure proper permissions
• Embedded Data Lineage & Data Dictionary
• Ease of Governance / Administration

Setup LAMP Stack

Check Apache

Check location of Apache:

1
2

which apache2
/usr/sbin/apache2

Check status of Apache server:

1

sudo service apache2 status

You may get following result if the service is running properly:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

apache2.service - The Apache HTTP Server
   Loaded: loaded (/lib/systemd/system/apache2.service; enabled; vendor preset: enabled>)
   Active: active (running) since <timestamp>; xxmin ago
   Docs: https://httpd.apache.org/docs/2.4/
   Process: 698 ExecStart=/usr/sbin/apachectl start (code=exited, status=0/SUCCESS)
   Main PID: 836 (apache2)
   Tasks: 55 (limit: 2289)
   Memory: 12.1M
   CGroup: /system.slice/apache2.service
           |-836 /usr/sbin/apache2 -k start
           |-846 /usr/sbin/apache2 -k start
           |-847 /usr/sbin/apache2 -k start
           
Jun 05 14:04:34 xiaoqi-web-002 systemd[1]: Starting The Apache HTTP Server...
Jun 05 14:04:35 xiaoqi-web-002 systemd[1]: Started The Apache HTTP Server.

Start Apache Server if it’s deactive

sudo service apache2 start

Check Hosts File

1
2
3
4

more /etc/hosts
===============
127.0.0.1 localhost
...

Noted: the apache website files are located in /var/www/html/index.html

Edit index.php

1

touch /var/www/html/index.php

Type below content:

1
2
3

<?php
    echo phpinfo();
?>

You can remove the original index.html, then the default website will show the PHP page, if now, you need to install the PHP first.

Install PHP

1
2
3

php -v
# if not installed, please do below
sudo apt-get install php7.4

Install MySQL

1
2

sudo apt-get install mysql-server
systemctl status mysql.service

With GUI, you can install DBeaver to manage the MySQL database

Information: https://github.com/Alecaddd/virtualhost to get the automatic script for install/delete Apache sites.

This is the starting point for building up mysite - Enterprise Architecture Center, following steps have been done.

Get one Domain

Try godaddy.com and request one domain there, mine is enterprise-architecture.site.

Using the A-record, you can configure the DNS to link domain to your backend web server

Get one Server for Website

Using Azure subscription, request one Ubuntu virtual server, get the basic configuration, with following two basic points –

• Before having https, open SSH (TCP/22) allowing ANY inbound access
• Get one public IP address

Connect via SSH with Client

1. Open the client of y our choice: WSL on Windows, Terminal on Mac or Shell on Linux

2. Ensure you have read-only access to the private key. Chmod is only supported on Linux subsystems (e.g. WSL on Windows or Terminal on Mac).

   1	chmod 400 <keyname>.pem

3. Provide a path to your SSH private key file, normally ~/.ssh/yasenster

4. Run the command below to connect your VM:
   ssh -i <private key path> yasenstar@<VM_IP>

Setup Apache Web Server

SSH to your new Ubuntu server, using following commands to install web server

1

sudo apt install apache2

英文原文:

1
2
3
4

I love three things in this world,
sun, moon, and you,
sun for morning,
moon for night, and you forever.

翻译中文：

1
2
3
4

在这个世界上有千万种事物，而我只爱三样，
太阳，月亮和你。
白天喜欢太阳，
晚上喜欢月亮，而喜欢你则是每时每刻。

翻译古诗：

1
2
3
4

浮世万千，吾爱有三。
日，月与卿。
日为朝，
月为暮，卿为朝朝暮暮。

Thanks the post here:

https://frameboxxindore.com/linux/how-do-i-transfer-files-from-iphone-to-ubuntu.html

Here are the 4 steps to mount iPhone in Debian/Ubuntu Linux –

1. Unlock the screen and connect the iPhone (do the ‘Trust this computer’ part). Check dmesg: dmesg | grep usb. ...

2. Pair the device: idevicepair pair

3. Create a mountpoint (e.g. ~/iPhone) and mount the iPhone using ifuse: mkdir ~/iPhone; ifuse ~/iPhone

4. Do whatever you need to do then, to unmount: fusermount -u ~/iPhone

Tested on Ubuntu 22.04 with iPhone X and they’re working.

While, the new iPhone photo format is by default as heic, see another post to convert them into jpg.

Good luck!

The purpose of this article is to show the practical way of analyzing IIS logs, and using those parsed results for analytical using.

After installing the IIS Log Parser application, let’s assume in Windows OS PC, I’m now using below command to generate one CSV file for all of the traffic hits counted to the log file folder:

The LogParser.exe (v2.2) is by default installed at c:\Program Files (x86)\Log Parser 2.2\, go to this folder then running below –

1

LogParser.exe -i:W3C "SELECT cs-uri-stem as Url, Count(*) As Hits FROM C:\Temp\W3SVC2\* GROUP BY cs-uri-stem ORDER BY Hits DESC" -o:CSV > c:\temp.csv

Thanks Carlos Aguilar, he gives very nice guides here https://blogs.iis.net/carlosag/analyze-your-iis-log-files-favorite-log-parser-queries.

The syntax is: LogParse.exe -i:W3C "Query-From-The-Table-Below" -o:CSV > "destination CSV file path and name"

I’m digesting the useful queries here:

Note: Any time you deal with Date and Time, remember to use the TO_LOCALTIME function to convert the log times to your local time, otherwise you will find it very confusing when your entries seems to be reported incorrectly.

Quick usage

1

youtube-dl --recode-video mp4 (youtube short video URL)

If don’t use --recode-video, then the download will keep the original video format

Full usage

1
2

$ youtube-dl --help
Usage: youtube-dl [OPTIONS] URL [URL...]