Eric Guo's blog.cloud-mes.com

Hoping writing JS, Ruby & Rails and Go article, but fallback to DevOps note

Install Oracle Instant Client 23.3 - the First macOS ARM64 Driver and Ruby-oci8 Gem

• Permalink

Prerequisite

  • Command line tools for Xcode or Xcode (by executing xcode-select --install) or [Xcode]

Download Oracle Instant Client Packages

Go oracle site and download:

  • instantclient-basiclite-macos.arm64-23.3.0.23.09.dmg
  • instantclient-sdk-macos.arm64-23.3.0.23.09.dmg
  • instantclient-sqlplus-macos.arm64-23.3.0.23.09.dmg

Mount DMG package and prepare folder

hdiutil mount ~/Downloads/instantclient-basiclite-macos.arm64-23.3.0.23.09.dmg 
cd /Volumes/instantclient-basiclite-macos.arm64-23.3.0.23.09 
sh ./install_ic.sh 
hdiutil mount ~/Downloads/instantclient-sdk-macos.arm64-23.3.0.23.09.dmg 
cd /Volumes/instantclient-sdk-macos.arm64-23.3.0.23.09 
sh ./install_ic.sh 
hdiutil mount ~/Downloads/instantclient-sqlplus-macos.arm64-23.3.0.23.09.dmg 
cd /Volumes/instantclient-sqlplus-macos.arm64-23.3.0.23.09 
sh ./install_ic.sh 
sudo mv ~/Downloads/instantclient_23_3 /opt

Install Oracle Instant Client

cd /usr/local/bin 
sudo ln -s /opt/instantclient_23_3/sqlplus sqlplus 
export OCI_DIR=/opt/instantclient_23_3 
gem install ruby-oci8

Put tnsnames.ora

export TNS_ADMIN=/opt/instantclient_23_3/network/admin/

Expose Local Server to the Internet Without Ngrok

• Permalink

Option 1

config/environments/development.rb
Rails.application.configure do 
 config.hosts << ".example.com" 
end
config/puma.rb
ssl_bind "0.0.0.0"，"8443"，{ 
 # Run "certbot certificates" to get these 
 key： "server.key". 
 cert："server.crt" 
}
expose SSH port：
ssh -R 8443:localhost:8443 -N user@example.com

Option 2

ssh -C2qTnN -R 3003:localhost:3003 user@ssss.com 
# Then, configure an Nginx proxy with a 3003 domain name for external access

Option 3

Open cursor, goto port tab to create one.

If meet error goto ‘/Applications/Cursor.app/Contents/Resources/app/bin’ and rename cursor-tunnel to code-tunnel.

Sponge Command Cheetsheet

• Permalink 

go build -o $(which sponge) cmd/sponge/main.go 
go build -o $(which protoc-gen-go-gin) cmd/protoc-gen-go-gin/main.go 
go build -o $(which protoc-gen-go-rpc-tmpl) cmd/protoc-gen-go-rpc-tmpl/main.go 
go build -o $(which protoc-gen-json-field) cmd/protoc-gen-json-field/main.go

Install a New Rails App in Rocky Linux 9.6 at Aliyun

• Permalink

Disable SELinux

sudo vi /etc/selinux/config 
grubby --update-kernel ALL --args selinux=0

Install htop and atop

sudo dnf update 
sudo dnf install epel-release 
sudo dnf install htop 
sudo dnf install atop

Install nginx

sudo dnf install nginx

Install node.js v22

Using nodesource distribution

curl -fsSL https://rpm.nodesource.com/setup_22.x -o nodesource_setup.sh 
sudo bash nodesource_setup.sh 
sudo yum install -y nodejs 
sudo yum groupinstall 'Development Tools'

Install yarn

curl -sL https://dl.yarnpkg.com/rpm/yarn.repo | sudo tee /etc/yum.repos.d/yarn.repo 
sudo yum install yarn

Install rbenv and ruby-build

whoami # should run as a ecs-user 
git clone https://git.thape.com.cn/rails/rbenv.git .rbenv 
echo 'export PATH="$HOME/.rbenv/bin:$PATH"' >> ~/.bash_profile 
~/.rbenv/bin/rbenv init # also edit ~/.bash_profile 
# As an rbenv plugin 
mkdir -p "$(rbenv root)"/plugins 
git clone https://git.thape.com.cn/rails/ruby-build.git "$(rbenv root)"/plugins/ruby-build 
git clone https://git.thape.com.cn/rails/rbenv-china-mirror.git "$(rbenv root)"/plugins/rbenv-china-mirror

Install Ruby 3.2.8

Ruby 3.2.8 need Rust to build JIT.

sudo dnf config-manager --enable crb 
sudo dnf install libffi-devel libyaml-devel readline-devel 
sudo dnf install zlib-devel openssl-devel gdbm-devel ncurses-devel bzip2-devel 
sudo yum install -y rust # version 1.84.1 
rbenv install -l 
rbenv install 3.2.8 
rbenv global 3.2.8 
rbenv shell 3.2.8 
echo "gem: --no-document" > ~/.gemrc 
gem update --system

Prepare the capistrano deploy folder

whoami # should run as a ecs-user 
cd /var/www 
sudo mkdir harman 
sudo chown ecs-user:ecs-user harman/

Add Credentials from the source site

vi .netrc 
machine cnb.cool login cnb password asdasdas

Running IRuby Notebook in Cursor

• Permalink 

brew install ruby 
brew install python3 
brew install zeromq # require by ipykernel 
/opt/homebrew/bin/python3 -m pip install ipykernel -U --user --force-reinstall --break-system-packages 
gem install iruby 
gem install rubygems-requirements-system 
iruby register --force

Also install Jupyter in cursor.

To make mlx-engine running:

python3 -m pip install sentencepiece -U --user --force-reinstall --break-system-packages 
python3 -m pip install outlines -U --user --force-reinstall --break-system-packages 
python3 -m pip install outlines==1.1.1 --user --force-reinstall --ignore-requires-python --break-system-packages 
python3 -m pip install datasets==3.6.0 --user --force-reinstall --ignore-requires-python --break-system-packages 
python3 -m pip install mlx_vlm -U --user --force-reinstall --break-system-packages 
python3 -m pip install mlx-lm -U --user --force-reinstall --break-system-packages

Install Open Project V16 in a Rocky Linux 9

• Permalink

I already install an open project instance one and half year ago, but it’s retired to sync with the production server OS version, which is Rocky Linux 8.10. After Ruby 3.4 released, I found the nokogiri v1.18 version and grpc v1.71 version both need a new GLIBC_2.29 version which is unavailable in Rocky Linux 8 series.

So I decide install a new Open Project instance server for the new production.

Disable SELinux

vi /etc/selinux/config 
grubby --update-kernel ALL --args selinux=0

Install htop and atop

sudo dnf update 
sudo dnf install epel-release 
sudo dnf install htop 
sudo dnf install atop

Install nginx

sudo dnf install nginx

Install node.js v22

Using nodesource distribution

curl -fsSL https://rpm.nodesource.com/setup_22.x -o nodesource_setup.sh 
sudo bash nodesource_setup.sh 
sudo yum install -y nodejs 
sudo yum groupinstall 'Development Tools'

Install yarn

curl -sL https://dl.yarnpkg.com/rpm/yarn.repo | sudo tee /etc/yum.repos.d/yarn.repo 
sudo yum install yarn

Install postgresql 16 client

Following DO manual

dnf module list postgresql 
sudo dnf module enable postgresql:16 
sudo dnf install postgresql-devel glibc-all-langpacks 
sudo dnf install postgresql-contrib # pg_trgm btree_gist require by open project 
sudo dnf install mysql-devel # if need to link to mysql server

Setup open_project user account

adduser open_project 
cd /etc/sudoers.d/ 
echo "open_project ALL=(ALL) NOPASSWD:ALL" > 30-open_project-user 
sudo su - open_project 
mkdir .ssh 
chmod 700 .ssh 
vi .ssh/authorized_keys # and paste your public key 
chmod 600 .ssh/authorized_keys

Install rbenv and ruby-build

whoami # should run as a open_project 
git clone https://git.thape.com.cn/rails/rbenv.git .rbenv 
echo 'export PATH="$HOME/.rbenv/bin:$PATH"' >> ~/.bash_profile 
~/.rbenv/bin/rbenv init # also edit ~/.bash_profile 
# As an rbenv plugin 
mkdir -p "$(rbenv root)"/plugins 
git clone https://git.thape.com.cn/rails/ruby-build.git "$(rbenv root)"/plugins/ruby-build 
git clone https://git.thape.com.cn/rails/rbenv-china-mirror.git "$(rbenv root)"/plugins/rbenv-china-mirror

Install Ruby 3.3.8

Ruby 3.3.8 need Rust to build JIT.

dnf config-manager --enable crb 
dnf install libyaml-devel 
yum install -y rust # version 1.79.0 
dnf install clang-devel # for some gem like autocorrect-rb 
rbenv install -l 
rbenv install 3.3.8 
rbenv global 3.3.8 
rbenv shell 3.3.8 
echo "gem: --no-document" > ~/.gemrc 
gem update --system

Prepare the capistrano deploy folder

whoami # should run as a open_project 
cd /var/www 
sudo mkdir open_project 
sudo chown open_project:open_project open_project/

Using mirror when deploy

Run in the release rails root folder

bundle config mirror.https://rubygems.org https://gems.ruby-china.com

Setting the open project settings

/etc/environment
OPENPROJECT_EDITION=bim 
OPENPROJECT_APP__TITLE=天华项目全生命周期管理 
OPENPROJECT_APP__SHORT__TITLE=PLM 
OPENPROJECT_HOST__NAME=plm-staging.thape.com.cn 
OPENPROJECT_EMAIL__DELIVERY__METHOD="smtp" 
OPENPROJECT_SMTP__ADDRESS="smtp.thape.com.cn" 
OPENPROJECT_SMTP__PORT="25" 
OPENPROJECT_SMTP__DOMAIN="thape.com.cn" 
OPENPROJECT_SMTP__AUTHENTICATION="login" 
OPENPROJECT_SMTP__USER__NAME="plm" 
OPENPROJECT_SMTP__PASSWORD="" 
OPENPROJECT_SMTP__ENABLE__STARTTLS__AUTO="true" 
OPENPROJECT_SMTP__OPENSSL__VERIFY__MODE="none" 
OPENPROJECT_ENTERPRISE__TRIAL__CREATION__HOST="https://www.google-analytics.com" 
GRUF_OP_SERVER="172.17.1.1:10009" 
WX_TEMPLATE_ID="" 
WX_WORK_PACKAGE_DETAIL="https://plm.thape.com.cn/work_packages/:id" 
MP_QRCODE_ABS_PATH="/var/www/open_project/shared/public/static/mp_qrcode.jpg" 
LOGO_ABS_PATH="/var/www/open_project/shared/public/static/logo_plm.png" 
CSP_FRAME_SRC="https://ith-workspace.thape.com.cn" 
CSP_CONNECT_SRC="https://analytics.thape.com.cn" 
WECHAT_AUTH_JWT_SECERT="" 
WECHAT_AUTH_ITH_URL="/ith/wechat/ppm/login"
/etc/systemd/system/puma_plm.service
[Unit] 
Description=Puma HTTP Server for open_project (staging) 
 
After=syslog.target network.target 
 
[Service] 
Type=simple 
WatchdogSec=10 
User=open_project 
EnvironmentFile=/etc/environment 
WorkingDirectory=/var/www/open_project/current 
ExecStart=/home/open_project/.rbenv/bin/rbenv exec bundle exec puma -e production 
ExecReload=/bin/kill -SIGUSR1 $MAINPID 
 
# if we crash, restart 
RestartSec=10 
Restart=on-failure 
 
StandardOutput=append:/var/www/open_project/shared/log/puma.log 
StandardError=append:/var/www/open_project/shared/log/puma.log 
 
SyslogIdentifier=puma_plm 
[Install] 
WantedBy=multi-user.target 
sudo systemctl daemon-reload 
bundle exec rake openproject:plugins:register_frontend 
bundle exec rake i18n:js:export 
bundle exec rake db:seed 
sudo journalctl -u puma_plm # check system log and fix errors 
sudo systemctl start puma_plm

Upload custom fonts

/var/www/open_project/shared/public 
gzip -9r op_public_files.zip fonts/ static/ WW_verify_*.txt

Change IP

Rocky 8 network change:

vi /etc/sysconfig/network-scripts/ifcfg-ens192

Rocky 9 network change:

vi /etc/NetworkManager/system-connections/ens192.nmconnection 
nmcli connection reload /etc/NetworkManager/system-connections/ens192.nmconnection 
nmcli connection up /etc/NetworkManager/system-connections/ens192.nmconnection

Install the dependency

sudo yum install ImageMagick

Open the firewall

sudo firewall-cmd --add-service=http --permanent 
sudo firewall-cmd --add-service=https --permanent 
sudo firewall-cmd --reload

Migrate DB From Redis 7.4 to 7.2 and Skip the RDB Version 12 Error

• Permalink

After I copy redis dump.rdb from redis 7.4 to my Macbook homebrew redis 7.2 I got Can’t handle RDB format version 12 error:

# /opt/homebrew/opt/redis/bin/redis-server /opt/homebrew/etc/redis.conf 
20066:C 17 Apr 2025 10:39:34.935 * oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo 
20066:C 17 Apr 2025 10:39:34.935 * Redis version=7.2.7, bits=64, commit=00000000, modified=0, pid=20066, just started 
20066:C 17 Apr 2025 10:39:34.935 * Configuration loaded 
20066:M 17 Apr 2025 10:39:34.935 * Increased maximum number of open files to 10032 (it was originally set to 256). 
20066:M 17 Apr 2025 10:39:34.935 * monotonic clock: POSIX clock_gettime 
 
 
Redis 7.2.7 (00000000/0) 64 bit 
 
Running in standalone mode 
Port: 6379 
PID: 20066 
 
 
 https://redis.io 
 
 
20066:M 17 Apr 2025 10:39:34.936 # WARNING: The TCP backlog setting of 511 cannot be enforced because kern.ipc.somaxconn is set to the lower value of 128. 
20066:M 17 Apr 2025 10:39:34.936 * Server initialized 
20066:M 17 Apr 2025 10:39:34.936 # Can't handle RDB format version 12 
20066:M 17 Apr 2025 10:39:34.936 # Fatal error loading the DB, check server logs. Exiting.

Two option available, upgrade redis version via redis.io

Using high version

brew tap redis/redis 
brew install --cask redis

The solution is ugly as redis will give you rc version of redis and it depend on the LLVM@18, which takes 1.7GB…

Stay redis 7.2

redis-cli shutdown 
brew uninstall redis 
brew untap redis/redis 
# make sure your DB no need! 
rm /opt/homebrew/var/db/redis/dump.rdb 
rm /opt/homebrew/etc/redis-sentinel.conf 
rm /opt/homebrew/etc/redis.conf 
rm /opt/homebrew/etc/redis.conf.default 
brew install redis 
brew services start redis

Using redis-dump to dump and restore DB.

redis-dump -u 127.0.0.1:6379 -d 0 > db_db0.json 
cat db_db0.json | redis-load -d 0

Make Tabnine Continue Work After Official Stop Support the Sublime Text

• Permalink

Today I found my TabNine stop working and after 2 hours, I found it officially stop support Sublime Text

But if you having the API key here is how to make it continue work in local mode. Goto ‘/Users/[username]/Library/Application Support/Sublime Text/Packages’ and change ‘dl_binaries.sh’ as below.

Change targets to your platform if required.

#!/bin/sh 
set -e 
 
# This script downloads the binaries for the most recent version of TabNine. 
 
version="4.4.25" 
targets='aarch64-apple-darwin' 
 
rm -rf ./binaries 
 
echo "$targets" | while read target 
do 
 mkdir -p binaries/$version/$target 
 path=$version/$target 
 echo "downloading $path" 
 curl -sS https://update.tabnine.com/bundles/$path/TabNine.zip > binaries/$path/TabNine.zip 
 unzip -o binaries/$path/TabNine.zip -d binaries/$path 
 rm binaries/$path/TabNine.zip 
 chmod +x binaries/$path/* 
done 
 
binariesver=$(grep -Eo '!binaries/.*' .gitignore | cut -c10-) 
sed "s+$binariesver+/$version+g" .gitignore >.gitignore.tmp && mv .gitignore.tmp .gitignore

Run it to download, The 4.4.25 is the most stable version and 4.256.0 is the last known version works with sublime text 4 build 4196.

You need also block update.tabnine.com in hosts file to block TabNine auto upgrade, although codota says you can type TabNine::disable_auto_update.

Known model list and support language

  • Universal Small - ce94127b
  • Universal Medium - b8373e4b
  • cpp_specialized_model - b6e9f0da
  • python - 4caf976f
  • ruby_specialized_model - 29b87067
  • go - 598b1f5b
  • java - af421852
  • rust_specialized_model - 46f17fa1

C#, JS, CSS, HTML and PHP belongs to Universal model