Spotfire Server with HTTPS encrypted under Linux

  1. prepare the cert and key:
/opt/tibco/tss-12.5.0.x86_64/jdk/bin$ sudo ./keytool -genkeypair -keystore keystore.p12 -storetype PKCS12 -storepass [yourPassword] -alias [yourHostName] -keyalg RSA -ext SAN=IP:[yourIPaddress] -validity 3650

or

/opt/tibco/tss-12.5.0.x86_64/jdk/bin$ sudo ./keytool -genkeypair -keystore keystore.p12 -storetype PKCS12 -storepass [yourPassword] -alias [yourHostName] -keyalg RSA -ext SAN=DNS:[FQDN] -validity 3650

What is your first and last name? Answer the 1st question.

/opt/tibco/tss-12.5.0.x86_64/jdk/bin$ sudo ./keytool -export -alias [yourHostName] -storepass [yourPassword] -file server.cer -keystore keystore.p12
/opt/tibco/tss-12.5.0.x86_64/jdk/bin$ sudo ./keytool -import -v -trustcacerts -alias [yourHostName] -file server.cer -keystore cacerts.jks -keypass [yourPassword] -storepass [yourPassword]

2. move the certs to /opt/tibco/tss-12.5.0.x86_64/tomcat/certs

3. edit the information in /opt/tibco/tss-12.5.0.x86_64/tomcat/conf/server.xml

comment out the http block and recover https block, edit below:

truststoreFile="./certs/cacerts.jks"
                     truststorePassword="[yourPassword]"
                     truststoreType="jks"

<Certificate certificateKeystoreFile="./certs/keystore.p12"
                     certificateKeystorePassword="[yourPassword]"
                     certificateKeystoreType="PKCS12"
                     certificateKeyAlias="[yourHostName]" />

sometimes it needs to delete certificateKeyAlias="[yourHostName]"

4. change public address setting in uiconfig.

5. restart Spotfire server

How to change domain information in Spotfire Server inside Oracle DB

As from config list-nodes -t pw, we can see the old information remained.
Inside Oracle DB, change the content below:

-- 从所有的表中选取所有记录
select * from tab;

-- 从tab表中选取tname字段的所有记录
select tname from tab;

-- 从tab表中选取tname字段的所有记录，但只返回字段值包含'SERVER'的记录
select tname from tab where tname like ‘%SERVER%’;

-- 描述（获取）node_SERVER_INFO表的结构信息，例如列名，数据类型等
describe node_SERVER_INFO;

-- 从node_server_info表中选取node_id和servername字段的所有记录
select node_id,servername from node_server_info;

-- 描述（获取）user_tab_columns表的结构信息
describe user_tab_columns;

-- 从user_tab_columns表中选取table_name字段的所有记录，但只返回字段值为’SERVERNAME’的记录
select table_name from user_tab_columns where column_name=’SERVERNAME’;

-- 描述（获取）RESOURCE_POOLS_SERVICES_VIEW表的结构信息
describe RESOURCE_POOLS_SERVICES_VIEW;

-- 描述（获取）NODE_SERVER_INFO表的结构信息
describe NODE_SERVER_INFO;

-- 从RESOURCE_POOLS_SERVICES_VIEW表中选取NODE_ID,SERVICE_TYPE,SERVERNAME字段的所有记录
select NODE_ID,SERVICE_TYPE,SERVERNAME from RESOURCE_POOLS_SERVICES_VIEW;

-- 更新node_server_info表，将servername字段值为’XXX.old.co.jp’的记录的servername字段的值改为’XXX.new.co.jp’
update node_server_info SET servername=’XXX.new.co.jp’ WHERE servername=’XXX.old.co.jp’;

-- 提交前面的更新操作，使其生效
commit;

exclude content in db, you need to change the content inside the filese below:

1. C:\tibco\tss\11.4.7\nm\config\nodemanager.properties

2. C:\tibco\tsnm\11.4.7\nm\config \config.json

3. Server alias in uiconfig

Install anydesk on Ubuntu 23.04

install prerequisite:

sudo apt update -y && sudo apt upgrade -y

wget http://ftp.us.debian.org/debian/pool/main/p/pangox-compat/libpangox-1.0-0_0.0.2-5.1_amd64.deb

sudo apt install ./libpangox-1.0-0_0.0.2-5.1_amd64.deb

then install anydesk:

sudo apt update -y && sudo apt upgrade -y

wget -qO - https://keys.anydesk.com/repos/DEB-GPG-KEY | sudo apt-key add -

echo "deb http://deb.anydesk.com/ all main" | sudo tee /etc/apt/sources.list.d/anydesk-stable.list

sudo apt update -y && sudo apt upgrade -y

sudo apt install anydesk -y

sudo vi /etc/gdm3/custom.conf 

WaylandEnable=false
AutomaticLoginEnable = true
AutomaticLogin = $USERNAME

sudo reboot
anydesk

Install Python on Ubuntu 22.04

Rather than Default Python 3.10.6, install another Python version:

1. install prerequisite

sudo apt update -y
sudo apt upgrade -y
sudo apt install -y build-essential zlib1g-dev libncurses5-dev libgdbm-dev libnss3-dev libssl-dev libsqlite3-dev libreadline-dev libffi-dev curl libbz2-dev -y

2. prepare installer

cd ~/Downloads
curl -O https://www.python.org/ftp/python/3.8.9/Python-3.8.9.tar.xz
tar -xf Python-3.8.9.tar.xz
cd Python-3.8.9

3. configure the python build

./configure --enable-optimizations

4. compile and install python

sudo make -j $(nproc)
sudo make altinstall

5. If it is successful, you can check the version

python3.8 --version

6.Set the newly installed Python version

sudo update-alternatives --install /usr/bin/python3.8.9 python3.8.9 /usr/local/bin/python3.8 1

7. update pip

python3.8.9 -m ensurepip --default-pip
python3.8.9 -m pip install --upgrade pip

8. If you want to remove it

sudo rm /usr/local/bin/python3.8
sudo rm /usr/local/bin/pip3.8
sudo rm -rf /usr/local/lib/python3.8
sudo update-alternatives --remove python /usr/local/bin/python3.8

Initialize Oracle 21 Configure for Spotfire

make tnsnames.ora:

ORCLPDB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orclpdb)
    )
  )

make listener.ora:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

ADR_BASE_LISTENER = C:\app\oracle

Then restart Listener:

lsnrctl stop
lsnrctl start

Then change the state of the pluggable databases:

sqlplus / as sysdba

/* check the sate: */ 
SQL> select con_id,name,open_mode from v$pdbs;

/* opens the pluggable database named ORCLPDB */ 
SQL> alter pluggable database ORCLPDB open;
/* sets the current session's container context to the ORCLPDB pluggable database */ 
SQL> alter session set container=ORCLPDB;
SQL> commit;

/* check the connected container: */ 
SQL> show con_name;

/* check the pdb name: */ 
SQL> select pdb_name from cdb_pdbs;

/* connect to the pdb: */ 
SQL> alter session set container = ORCLPDB;

/* to keep it starts with the windows server startup, you need to save the PDB’s state: */ 
SQL> alter pluggable database orclpdb save state;

edit the create_databases.bat, eg: 

set SPOTFIREDB_ROOTFOLDER=C:\app\oracle\oradata\ORCL\orclpdb
set DBSERVER_CONNECTIDENTIFIER=//[yourDBIP]/ORCLPDB

install wiregui client on ubuntu 22

sudo apt install wireguard wireguard-tools wireguard-dkms
sudo apt install resolvconf
sudo dpkg -i wiregui_1.8.1_amd64.deb
sudo mkdir /etc/wireguard
sudo cp yourConfig.conf /etc/wireguard/yourConfig.conf
sudo chmod 400 /etc/wireguard/yourConfig.conf

you can run by:

sudo wg-quick up yourConfig
sudo wg-quick down yourConfig

or use wiregui

Install Japanese Input for Pop!_OS

environment:

Operating System: Pop!_OS 22.04 LTS                 
Kernel: Linux 6.2.6-76060206-generic
Architecture: x86-64

Install the required packages:

sudo apt update -y
sudo apt install fcitx fcitx-mozc fcitx-config-gtk kde-config-fcitx fcitx-frontend-qt5 libfcitx-qt5-1
echo 'export GTK_IM_MODULE=fcitx' >> ~/.profile
echo 'export QT_IM_MODULE=fcitx' >> ~/.profile
echo 'export XMODIFIERS="@im=fcitx"' >> ~/.profile
sudo reboot

solve chrome issue:

cp /usr/share/applications/google-chrome.desktop ~/.local/share/applications/
echo 'Exec=env QT_IM_MODULE=fcitx XMODIFIERS="@im=fcitx" /usr/bin/google-chrome-stable %U' >> ~/.local/share/applications/google-chrome.desktop
sudo reboot

for Chinese input, then install this:

sudo apt install fcitx-sunpinyin

Install Microsoft Edge on Pop!_OS

Install Microsoft Edge on Pop!_OS 22.04|20.04|21.04
sudo apt update -y
sudo apt upgrade -y
curl https://packages.microsoft.com/keys/microsoft.asc | gpg --dearmor > microsoft.gpg
sudo install -o root -g root -m 644 microsoft.gpg /etc/apt/trusted.gpg.d/
sudo sh -c 'echo "deb [arch=amd64] https://packages.microsoft.com/repos/edge stable main" > /etc/apt/sources.list.d/microsoft-edge-dev.list'
sudo apt update -y
sudo apt install microsoft-edge-dev -y
通过 WordPress.com 设计一个这样的站点
从这里开始