linux

The Problem

When you use docker to run postgresql (ex, postgres:14.5-bullseye) and enabled healthcheck, you might get health status from docker compose ps, but you might see error messages in your docker log.

Sample docker-compose.yml:

其實二月就有嘗鮮版可以測試

• Binary Packages Now Available for the Preview NGINX QUIC+HTTP/3 Implementation

不過正式釋出是昨天的事，不到 24 小時前。

Changes with nginx 1.25.0                                        23 May 2023

    *) Feature: experimental HTTP/3 support.

• http://nginx.org/en/CHANGES

等了好久，終於要開始支援了。

記得寫研究所論文時就爬過 QUIC 程式碼、翻過 spec，找過缺陷問題，然後心心念念期待普及。直至今日。

TON (The Open Network) 或 TONcoin，前身是 Telegram （通訊軟體）發起的 Telegram Open Network.

Miner 算力挖礦 - PoW

支援 GPU 加速挖礦。

AWS g4ad

AMD EPYC CPU + AMD Radeon Pro V520 GPU. - 較便宜、TON 挖礦效能好、CP 值高。 - ETH (ethash) hashrate 算力很低，不適合雙幣挖礦。

建立 instance 時，請確定選擇了用 Ubuntu 18.04，因為 AWS 只提供給 Ubuntu 18.04 的 GPU 驅動程式。

TON (The Open Network), or TONcoin, former Telegram Open Network founded by the instant messaging app Telegram.

Miner - PoW

We can use GPU for mining.

AWS g4ad

AMD EPYC CPU + AMD Radeon Pro V520 GPU.

• Lower price, better TON mining performance, better C/P value.
• ETH (ethash) hash rate is low, so not for dual mining.

Make sure to use Ubuntu 18.04, as AWS doesn't provide Ubuntu 20.04 drivers.

Packaging software might sound scary, but backporting Ubuntu package is actually easy.
When you need some features or bugfix in a newer version of software, which exists in latest Ubuntu release, but need it to be running in your older release of Ubuntu, what you need to do is to port the software from latest Ubuntu to the version you want. And in this HowTo I'll guide you through.

1. Install tools: sudo apt install ubuntu-dev-tools
2. Set developer (YOU) info: export UBUMAIL="Your Name <[email protected]>"
3. Use tool to backport backportpackage -w . the-package-name

最近向我尋求顧問諮詢的組織單位中，其中一個再也受不了微軟的天價授權費勒索，打算用 Linux (Ubuntu) 替換掉所有 Windows Server。用 PHP、Java 以及其他跨平台語言撰寫的服務要轉移很容易。但是其中一些系統使用 MicroSoft SQL Server 作為資料庫。
治本的方法是轉移到 MySQL、MariaDB 或其他 OpenSource 資料庫系統，但那需要時間來處理所有 schema 以及 query 的轉換。
另一個方法是在 Docker 中使用 Linux 版微軟 Microsoft SQL Server 作為暫時性的過渡時期解法。

One of the organizations that recently consulted me for advice, no longer willing to be extortion by Microsoft's high licensing fees, and plans to replace all Windows Server with Linux (Ubuntu). No big deal for services written in PHP, Java, and other cross platform languages. But some of the systems use MicroSoft SQL Server as their Database. The permanent cure is to migrate to MySQL, MariaDB, or other OpenSource Databases. But it takes time to translate all schema and queries. The other solution is to use Microsoft SQL Server on Linux in Docker as a temporary workaround.

Lighttpd + Let’s Encrypt + This HOWTO = A+ score on ssllabs (HTTPS + HSTS)
My A+ report: https://www.ssllabs.com/ssltest/analyze.html?d=geeky.name&s=188.166.188.226