xrcd2 網路小頑童

2024年10月25日星期五

Execute Perl WEB CGI in Oracle Linux 9

dnf install oracle-epel-release-el9.x86_64

dnf install mod_perl

dnf install perl-CGI perl-CPAN perl-HTTP-Tiny.noarch perl-JSON perl-Encode.x86_64

vi /etc/httd/conf.d/perl.conf

#PerlModule ModPerl::Registry

##PerlModule ModPerl::PerlRun

Alias /cgi /var/www/html/cgi

#SetHandler perl-script

AddHandler perl-script .pl

AddHandler perl-script .cgi

PerlResponseHandler ModPerl::Registry

## PerlResponseHandler ModPerl::PerlRun

PerlOptions +ParseHeaders

Options +ExecCGI

Order allow,deny

Allow from all

</Directory>

systemctl restart httpd

Test reference

https://hostingultraso.com/help/centos/implementing-cgi-perl-ruby-centos

Creating your first Perl CGI script

Now create the following Perl CGI script file by opening the new file vi /var/www/cgi-bin/perl-test.cgi and putting in the following content:

#!/usr/bin/perl

use strict;

use warnings;

use CGI qw(:standard);

print header;

my $now = localtime;

print start_html(-title=>'Server time via Perl CGI'),

h1('Time'), p("The time is $now"),

end_html;

https://www.geeksforgeeks.org/perl-get-vs-post-in-cgi/

Example:

<html>

<body>

<b> Search Your Query:</b><br>

<input type="radio" name="l" value="Web" checked>Web

<input type="radio" name="l" value="India">IND

</FORM>

</body>

</html>

Perl-CGI script for the above GET method form:

#!"c:\xampp\perl\bin\perl.exe"

$buffer = $ENV{'QUERY_STRING'};

#split information into key/value pairs

@pairs = split(/&/, $buffer);

foreach $pair (@pairs)

{

($name, $value) = split(/=/, $pair);

$value =~ tr/+/ /;

$value =~ s/%([a-fA-F0-9] [a-fA-F0-9])/pack("C", hex($1))/eg;

$value =~ s/~!/ ~!/g;

$FORM{$name} = $value;

}

$SearchTerm = $FORM{'q'};

$Location = $FORM{'l'};

print "Content-type:text/html\r\n\r\n";

print "<html>";

print "<head>";

print "<title>GeeksForGeeks - Get Method</title>";

print "</head>";

print "<body>";

print "<h3>Hello You searched '$Location' for '$SearchTerm'<br>

Few Matches Found!<br>

<br>

Match 1<br>

Match 2<br>

Match 3<br>

Match 4<br>

etc.....</h3>";

print "</body>";

print "</html>";

My LAB Test Demo

2024年10月13日星期日

DIY 即時通訊系統(IM)以Openfire(XMPP)為例

Instant Messaging (IM)

Extensible Messaging and Presence Protocol (XMPP)

wiki 上的說明

https://zh.wikipedia.org/zh-tw/XMPP

url 在這裡可以看到一些關於 xmpp 的資訊與相關軟體

https://xmpp.org/

家中測試環境

Server Linux 安裝 openfire (openfire-4.9.0-1.noarch.rpm)

https://www.igniterealtime.org/projects/openfire/

Java

openjdk version "11.0.24"

Client Windows 安裝 spark (spark_3_0_2-with-jre.msi)

https://igniterealtime.org/projects/spark/

Clinet Linux 使用程式語言 Perl

參考 URL

https://haliphax.dev/2011/04/send-xmpp-messages-with-perl-from-the-command-line-too/

Demo

MySQL

[root@WAZUH init.d]# mysql

Welcome to the MariaDB monitor. Commands end with ; or \g.

Your MariaDB connection id is 152

Server version: 10.5.22-MariaDB MariaDB Server

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> CREATE DATABASE xmpp CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> CREATE USER 'xmpp'@'localhost' IDENTIFIED BY 'password';

Query OK, 0 rows affected (0.003 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON xmpp.* TO 'xmpp'@'localhost';

Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]>

Java

[root@WAZUH src]# dnf install java-11-openjdk.x86_64

[root@WAZUH src]# cat /etc/environment

JAVA_HOME="/usr/lib/jvm/java-11-openjdk-11.0.24.0.8-2.0.1.el9.x86_64/"

[root@WAZUH src]# echo $JAVA_HOME

/usr/lib/jvm/java-11-openjdk-11.0.24.0.8-2.0.1.el9.x86_64/

[root@WAZUH src]# java -version

openjdk version "11.0.24" 2024-07-16 LTS

OpenJDK Runtime Environment (Red_Hat-11.0.24.0.8-2.0.1) (build 11.0.24+8-LTS)

OpenJDK 64-Bit Server VM (Red_Hat-11.0.24.0.8-2.0.1) (build 11.0.24+8-LTS, mixed mode, sharing)

[root@WAZUH src]#

Openfire

[root@WAZUH bin]# rpm -ql openfire-4.9.0-1.noarch

/etc/init.d/openfire

/etc/sysconfig/openfire

/opt/openfire

/opt/openfire/LICENSE.html

/opt/openfire/README.html

/opt/openfire/bin

/opt/openfire/bin/embedded-db-viewer.sh

/opt/openfire/bin/embedded-db.rc

/opt/openfire/bin/openfire.sh

/opt/openfire/bin/openfirectl

/opt/openfire/changelog.html

/opt/openfire/conf

......

Perl

[root@WAZUH src]# dnf search net-xmpp

Last metadata expiration check: 2:22:11 ago on Sun 13 Oct 2024 10:25:38 AM CST.

================================================================================================ Name Matched: net-xmpp ================================================================================================

perl-Net-XMPP.noarch : Net::XMPP - perl XMPP library

perl-Net-XMPP.src : Net::XMPP - perl XMPP library

[root@WAZUH src]# dnf install perl-Net-XMPP

Last metadata expiration check: 2:22:28 ago on Sun 13 Oct 2024 10:25:38 AM CST.

Dependencies resolved.

========================================================================================================================================================================================================================

Package Architecture Version Repository Size

Installing:

perl-Net-XMPP noarch 1.05-20.el9 ol9_developer_EPEL 154 k

Installing dependencies:

perl-Authen-SASL noarch 2.16-25.el9 ol9_appstream 78 k

perl-GSSAPI x86_64 0.28-37.el9 ol9_appstream 74 k

perl-HTTP-ProxyAutoConfig noarch 0.3-27.el9 ol9_developer_EPEL 27 k

perl-Net-DNS noarch 1.29-6.el9 ol9_appstream 542 k

perl-Tie noarch 4.6-481.el9 ol9_appstream 41 k

perl-XML-Stream noarch 1.24-20.el9 ol9_developer_EPEL 108 k

Transaction Summary

Install 7 Packages

Total download size: 1.0 M

Installed size: 1.8 M

Is this ok [y/N]: y

.....

Windows Client GUI

Linux Perl

Perl 程式參考

2024年8月18日星期日

Synology SFTP + WinScp login with ssh key

使用情境描述:

(1) 在 Synology NAS 中,建立一個 ID: backup 的一般使用者,僅可以透過 SFTP 方式,上傳備份資料至內網的 Synology NAS 上.

(2) 在內網的各 Windows 主機皆透過 ID: backup 及 ssh key 檔,以 SFTP方式登入 NAS, 上傳備份檔.

(3) 以下測試以 WinSCP UI 方式,進行功能驗證,上線再改用 WinSCP CLI + Batch 進行自動備份.

Synology NAS/DSM 預設是不能用一般使用者帳號,透過以 SSH 方式登入,所以必需先以管理者ID方式登入,透過 vi 的設定方式,將 ID: backup 暫時可以使用 bash shell login .

(這不是官方正式的作法,而是用一般Linux的操作行為,這裡只是便宜行事)

比較正常的做法-->可能是先將 ID: backup 變成 admin 的群組,在 ID: backup ssh 登入後,生出相關的ssh key 後,再切回一般的使用者群組.

操作記錄如下:

root@DSM:~# su - backup

su: failed to execute /sbin/nologin: No such file or directory

root@DSM:~# vi /etc/passwd

#預設這個帳號是不能登入 ssh 的

backup:x:1027:100::/var/services/homes/backup:/sbin/nologin

#設定成暫時可以 ssh ,在建出 ssh 相關 key 檔後,記得要改回原設定.

backup:x:1027:100::/var/services/homes/backup:/bin/sh

root@DSM:~# su - backup

backup@DSM:~$ id

uid=1027(backup) gid=100(users) groups=100(users)

backup@DSM:~$ pwd

/var/services/homes/backup

backup@DSM:~$ ssh-keygen -t rsa

Generating public/private rsa key pair.

Enter file in which to save the key (/var/services/homes/backup/.ssh/id_rsa):

Created directory '/var/services/homes/backup/.ssh'.

Enter passphrase (empty for no passphrase):

Enter same passphrase again:

Your identification has been saved in /var/services/homes/backup/.ssh/id_rsa

Your public key has been saved in /var/services/homes/backup/.ssh/id_rsa.pub

The key fingerprint is:

SHA256:oCUaIsXjhksKqB2Xcr5ifUhDbsxaCRaTghTuUP5wqlM backup@DSM

The key's randomart image is:

+---[RSA 3072]----+

|o++. |

|++* |

|==++o.o |

|BoBB=+ . |

|=*E%o. S |

|+o. @ |

|o * + |

| .+ + . |

| . . . |

+----[SHA256]-----+

backup@DSM:~$ pwd

/var/services/homes/backup

backup@DSM:~$ cd .ssh

backup@DSM:~/.ssh$ ll

total 8

drwxrwxrwx+ 1 backup users 32 Aug 18 12:41 .

drwxrwxrwx+ 1 backup users 8 Aug 18 12:41 ..

-rwxrwxrwx+ 1 backup users 2590 Aug 18 12:41 id_rsa

-rwxrwxrwx+ 1 backup users 564 Aug 18 12:41 id_rsa.pub

backup@DSM:~/.ssh$ cat id_rsa.pub > authorized_keys

backup@DSM:~/.ssh$ chmod 700 authorized_keys

backup@DSM:~/.ssh$ ls -la

total 12

drwxrwxrwx+ 1 backup users 62 Aug 18 12:43 .

drwxrwxrwx+ 1 backup users 8 Aug 18 12:41 ..

-rwx------ 1 backup users 564 Aug 18 12:43 authorized_keys

-rwxrwxrwx+ 1 backup users 2590 Aug 18 12:41 id_rsa

-rwxrwxrwx+ 1 backup users 564 Aug 18 12:41 id_rsa.pub

backup@DSM:~/.ssh$

backup@DSM:~/.ssh$ cat id_rsa

-----BEGIN OPENSSH PRIVATE KEY-----

..........

KEY......

..............

-----END OPENSSH PRIVATE KEY-----

將上述檔案內容貼回 Windows 內,並存檔預備供 puttygen.exe 轉成 DSM-Backup.ppk 使用.

當然可以用任何習慣的操作行為,將該檔傳回 Windows 也可.不限任何方式.

接下來的操作如下方所示:

https://www.puttygen.com/download-putty

==> puttygen.exe

Import Key ( id_rsa )

==> Save Private Key

https://winscp.net/eng/download.php

宣告使用 DSM-Backup.ppk 方式登入 Synology SFTP 服務.

驗証

2024年8月9日星期五

ThinkStation P3 Tower + NVIDIA RTX A5000 + Rocky Linux 9.X

==> BIOS

Secure Boot [Disabled]

==> Linux

dnf install libglvnd-*

Download & Install

(1) Driver

https://www.nvidia.com/Download/driverResults.aspx/230357/en-us/

==> NVIDIA-Linux-x86_64-550.107.02.run

(2) CUDA Toolkit

https://developer.nvidia.com/cuda-downloads?target_os=Linux&target_arch=x86_64&Distribution=Rocky&target_version=9&target_type=rpm_local

==> cuda-repo-rhel9-12-6-local-12.6.0_560.28.03-1.x86_64.rpm

==> Check

[root@localhost ~]# nvidia-smi

2024年6月21日星期五

How to use OTP Login Windows (VyOS + freeradius + Google Authenticator + pGina)

安裝及設定參考 URL 如下:

https://hackmd.io/@farmer87/enable_2fa

關於這個主題我之前寫的筆記

https://xrcd2.blogspot.com/2015/03/vyos-openvpn-plugin-otp-sop.html

https://xrcd2.blogspot.com/2016/01/cisco-radius-otp.html

https://xrcd2.blogspot.com/2016/09/vyosopenvpnmfa.html

軟體安裝來源

https://vyos.io

http://pgina.org

手動修改重點:

==> SourceList

deb http://ftp.tw.debian.org/debian bookworm main non-free-firmware

==> freeradius.service

/lib/systemd/system/freeradius.service 執行身份改為 => root

DEMO

2024年6月8日星期六

Zabbix 7.0 LTS 版本試裝

備妥 LAPP (Liunx Apache PostgreSQL PHP) 或

LAMP (Liunx Apache MYSQL PHP) ....的運行環境

我的安裝順序 Liunx Apache Mysql (MariadDB) PHP ,

因為之前已測試過 LibreNMS 在 Oracle 9 的運行環境.

故這次僅需加裝上PostgreSQL即可.在安裝之前先看了一下 release_notes 資訊,

進而得知它支援 TimescaleDB 2.13 與 PostgreSQL 16 ,

之前都是亂裝一通導致 Zabbix 裝不起來的情事.GG

所以先行將 PostgreSQL 16 + TimescaleDB 2.13 的組合先行安裝.

https://www.zabbix.com/release_notes

==> Updated max supported TimescaleDB version to 2.13 Server

==> Increased PostgreSQL maximum supported version to 16

PostgreSQL 16 可參考如下 URL

https://www.postgresql.org/download/

因為我是使用 Oracle Linux 所以是看這個.

https://www.postgresql.org/download/linux/redhat/

安裝操作依官網 SOP 即可...

# Install the repository RPM:

sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Disable the built-in PostgreSQL module:

sudo dnf -qy module disable postgresql

# Install PostgreSQL:

sudo dnf install -y postgresql16-server

# Optionally initialize the database and enable automatic start:

sudo /usr/pgsql-16/bin/postgresql-16-setup initdb

sudo systemctl enable postgresql-16

sudo systemctl start postgresql-16

PostgreSQL安裝完成後,重要的設定及安裝程式會放置在這二處

[root@Oracle9 pgsql-16]# pwd

/usr/pgsql-16

[root@Oracle9 16]# pwd

/var/lib/pgsql/16

為方便後續的操作及使用

vi /etc/profile

最下方處加上如下設定.

PATH=$PATH:/usr/pgsql-16/bin/

export PATH

PGDATA=/var/lib/pgsql/16/data

export PGDATA

及做一些必要的 postgresql 服務設定.

vi /var/lib/pgsql/16/data/pg_hba.conf

vi /var/lib/pgsql/16/data/postgresql.conf

===============================================

TimescaleDB 可參考如下 URL

https://packagecloud.io/timescale/timescaledb/install

因為我是要下載及安裝指定版本,故我選擇用手動下載及安裝的方式進行之.

TimescaleDB 2.13 可參考如下 URL

https://packagecloud.io/timescale/timescaledb

下載

wget --content-disposition "https://packagecloud.io/timescale/timescaledb/packages/el/9/timescaledb-2-loader-postgresql-16-2.13.0-0.el9.x86_64.rpm/download.rpm?distro_version_id=240"

wget --content-disposition "https://packagecloud.io/timescale/timescaledb/packages/el/9/timescaledb-2-postgresql-16-2.13.0-0.el9.x86_64.rpm/download.rpm?distro_version_id=240"

wget --content-disposition "https://packagecloud.io/timescale/timescaledb/packages/el/9/timescaledb-tools-0.15.0-0.el9.x86_64.rpm/download.rpm?distro_version_id=240"

手動安裝 timescaledb-2-postgresql-16-2.13

[root@Oracle9 tmp]# cd timescaledb-2-pg16/

[root@Oracle9 timescaledb-2-pg16]# ll

total 3032

-rw-r--r-- 1 root root 28055 Nov 29 2023 timescaledb-2-loader-postgresql-16-2.13.0-0.el9.x86_64.rpm

-rw-r--r-- 1 root root 684479 Nov 29 2023 timescaledb-2-postgresql-16-2.13.0-0.el9.x86_64.rpm

-rw-r--r-- 1 root root 2386633 Nov 6 2023 timescaledb-tools-0.15.0-0.el9.x86_64.rpm

[root@Oracle9 timescaledb-2-pg16]# rpm -ivh timescaledb-tools-0.15.0-0.el9.x86_64.rpm

Verifying... ################################# [100%]

Preparing... ################################# [100%]

Updating / installing...

1:timescaledb-tools-0.15.0-0.el9 ################################# [100%]

[root@Oracle9 timescaledb-2-pg16]# rpm -ivh timescaledb-2-loader-postgresql-16-2.13.0-0.el9.x86_64.rpm

Verifying... ################################# [100%]

Preparing... ################################# [100%]

Updating / installing...

1:timescaledb-2-loader-postgresql-1################################# [100%]

Using pg_config located at /usr/pgsql-16/bin/pg_config to finish installation...

[root@Oracle9 timescaledb-2-pg16]# rpm -ivh timescaledb-2-postgresql-16-2.13.0-0.el9.x86_64.rpm

Verifying... ################################# [100%]

Preparing... ################################# [100%]

Updating / installing...

1:timescaledb-2-postgresql-16-2.13.################################# [100%]

Using pg_config located at /usr/pgsql-16/bin/pg_config to finish installation...

TimescaleDB has been installed. You need to update your postgresql.conf file

to load the library by adding 'timescaledb' to your shared_preload_libraries.

The easiest way to do this (and more configuration) is to use timescaledb-tune:

timescaledb-tune --pg-config=/usr/pgsql-16/bin/pg_config

依指示做 timescaledb-tune

[root@Oracle9 timescaledb-2-pg16]# timescaledb-tune --pg-config=/usr/pgsql-16/bin/pg_config

Using postgresql.conf at this path:

/var/lib/pgsql/16/data/postgresql.conf

Is this correct? [(y)es/(n)o]: y

Writing backup to:

/tmp/timescaledb_tune.backup202406091011

shared_preload_libraries needs to be updated

Current:

#shared_preload_libraries = ''

Recommended:

shared_preload_libraries = 'timescaledb'

Is this okay? [(y)es/(n)o]: y

success: shared_preload_libraries will be updated

Tune memory/parallelism/WAL and other settings? [(y)es/(n)o]: y

Recommendations based on 7.31 GB of available memory and 4 CPUs for PostgreSQL 16

Memory settings recommendations

Current:

shared_buffers = 128MB

#effective_cache_size = 4GB

#maintenance_work_mem = 64MB

#work_mem = 4MB

Recommended:

shared_buffers = 1871MB

effective_cache_size = 5614MB

maintenance_work_mem = 958185kB

work_mem = 4790kB

Is this okay? [(y)es/(s)kip/(q)uit]: y

success: memory settings will be updated

Parallelism settings recommendations

Current:

missing: timescaledb.max_background_workers

#max_worker_processes = 8

#max_parallel_workers_per_gather = 2

#max_parallel_workers = 8

Recommended:

timescaledb.max_background_workers = 16

max_worker_processes = 23

max_parallel_workers_per_gather = 2

max_parallel_workers = 4

Is this okay? [(y)es/(s)kip/(q)uit]: y

success: parallelism settings will be updated

WAL settings recommendations

Current:

#wal_buffers = -1

min_wal_size = 80MB

Recommended:

wal_buffers = 16MB

min_wal_size = 512MB

Is this okay? [(y)es/(s)kip/(q)uit]: y

success: WAL settings will be updated

Background writer settings recommendations

Current:

Recommended:

Is this okay? [(y)es/(s)kip/(q)uit]: y

success: background writer settings will be updated

Miscellaneous settings recommendations

Current:

#default_statistics_target = 100

#random_page_cost = 4.0

#checkpoint_completion_target = 0.9

#max_locks_per_transaction = 64

#autovacuum_max_workers = 3

#autovacuum_naptime = 1min

#effective_io_concurrency = 1

Recommended:

default_statistics_target = 100

random_page_cost = 1.1

checkpoint_completion_target = 0.9

max_locks_per_transaction = 64

autovacuum_max_workers = 10

autovacuum_naptime = 10

effective_io_concurrency = 256

Is this okay? [(y)es/(s)kip/(q)uit]: y

success: miscellaneous settings will be updated

Saving changes to: /var/lib/pgsql/16/data/postgresql.conf

[root@Oracle9 timescaledb-2-pg16]#

====>　　　systemctl restart postgresql-16

到這裡 Zabbix 安裝的前置作業應該差不多完成了.

==============================================

Zabbix 安裝及設定可參考如下 URL

https://www.zabbix.com/download

我是看這裡操作的.

https://www.zabbix.com/download?zabbix=7.0&os_distribution=oracle_linux&os_version=9&components=server_frontend_agent&db=pgsql&ws=apache

安裝操作依官網 SOP 即可...大致如下....

PS 我是使用 Oracle Linux 9 所以有些許小異動...

# echo "excludepkgs=zabbix*" >> /etc/yum.repos.d/oracle-epel-ol9.repo

# rpm -Uvh https://repo.zabbix.com/zabbix/7.0/oracle/9/x86_64/zabbix-release-7.0-2.el9.noarch.rpm

# dnf clean all

# dnf install zabbix-server-pgsql zabbix-web-pgsql zabbix-apache-conf zabbix-sql-scripts zabbix-selinux-policy zabbix-agent

# sudo -u postgres createuser --pwprompt zabbix

# sudo -u postgres createdb -O zabbix zabbix

#zcat /usr/share/zabbix-sql-scripts/postgresql/server.sql.gz | sudo -u zabbix psql zabbix

vi /etc/zabbix/zabbix_server.conf

....

DBHost=127.0.0.1

DBName=zabbix

DBSchema=public

DBUser=zabbix

DBPassword=zabbix

.....

# systemctl restart zabbix-server zabbix-agent httpd php-fpm

# systemctl enable zabbix-server zabbix-agent httpd php-fpm

=====================================================

[root@Oracle9 data]# netstat -antlp | grep "LISTEN"

tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN 792/sshd: /usr/sbin

tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN 1/systemd

tcp 0 0 0.0.0.0:37989 0.0.0.0:* LISTEN -

tcp 0 0 127.0.0.1:44321 0.0.0.0:* LISTEN 1071/pmcd

tcp 0 0 0.0.0.0:38035 0.0.0.0:* LISTEN 841/rpc.statd

tcp 0 0 0.0.0.0:10050 0.0.0.0:* LISTEN 9173/zabbix_agentd

tcp 0 0 0.0.0.0:10051 0.0.0.0:* LISTEN 9175/zabbix_server

tcp 0 0 0.0.0.0:2049 0.0.0.0:* LISTEN -

tcp 0 0 127.0.0.1:4330 0.0.0.0:* LISTEN 2544/pmlogger

tcp 0 0 127.0.0.1:199 0.0.0.0:* LISTEN 837/snmpd

tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 7767/postgres

tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 939/mariadbd

tcp 0 0 127.0.0.1:6010 0.0.0.0:* LISTEN 3338/sshd: XXXX

tcp 0 0 0.0.0.0:20048 0.0.0.0:* LISTEN 869/rpc.mountd

tcp6 0 0 :::22 :::* LISTEN 792/sshd: /usr/sbin

tcp6 0 0 :::111 :::* LISTEN 1/systemd

tcp6 0 0 :::80 :::* LISTEN 9923/httpd

tcp6 0 0 ::1:44321 :::* LISTEN 1071/pmcd

tcp6 0 0 :::41563 :::* LISTEN -

tcp6 0 0 :::10050 :::* LISTEN 9173/zabbix_agentd

tcp6 0 0 :::10051 :::* LISTEN 9175/zabbix_server

tcp6 0 0 :::2049 :::* LISTEN -

tcp6 0 0 ::1:5432 :::* LISTEN 7767/postgres

tcp6 0 0 ::1:6010 :::* LISTEN 3338/sshd: XRCD2

tcp6 0 0 ::1:4330 :::* LISTEN 2544/pmlogger

tcp6 0 0 :::3306 :::* LISTEN 939/mariadbd

tcp6 0 0 :::20048 :::* LISTEN 869/rpc.mountd

tcp6 0 0 :::36655 :::* LISTEN 841/rpc.statd

[root@Oracle9 data]#

=================================================================

Zabbix 加裝 timescaledb

https://www.zabbix.com/documentation/current/en/manual/appendix/install/timescaledb

安裝操作依官網 SOP 即可...大致如下....

[root@Oracle9 yum.repos.d]# echo "CREATE EXTENSION IF NOT EXISTS timescaledb CASCADE;" | sudo -u postgres psql zabbix

WARNING:

WELCOME TO

_____ _ _ ____________

|_ _(_) | | | _ \ ___ \

| | _ _ __ ___ ___ ___ ___ __ _| | ___| | | | |_/ /

| | | | _ ` _ \ / _ \/ __|/ __/ _` | |/ _ \ | | | ___ \

| | | | | | | | | __/\__ \ (_| (_| | | __/ |/ /| |_/ /

|_| |_|_| |_| |_|\___||___/\___\__,_|_|\___|___/ \____/

Running version 2.13.0

For more information on TimescaleDB, please visit the following links:

1. Getting started: https://docs.timescale.com/timescaledb/latest/getting-started

2. API reference documentation: https://docs.timescale.com/api/latest

Note: TimescaleDB collects anonymous reports to better understand and assist our users.

For more information and how to disable, please see our docs https://docs.timescale.com/timescaledb/latest/how-to-guides/configuration/telemetry.

CREATE EXTENSION

[root@Oracle9 yum.repos.d]#

[root@Oracle9 timescaledb]# cat /usr/share/zabbix-sql-scripts/postgresql/timescaledb/schema.sql | sudo -u zabbix psql zabbix

NOTICE: function base36_decode(pg_catalog.varchar) does not exist, skipping

DROP FUNCTION

CREATE FUNCTION

NOTICE: function cuid_timestamp(pg_catalog.varchar) does not exist, skipping

DROP FUNCTION

CREATE FUNCTION

NOTICE: PostgreSQL version 16.3 is valid

NOTICE: TimescaleDB extension is detected

NOTICE: TimescaleDB version 2.13.0 is valid

WARNING: column type "character varying" used for "source" does not follow best practices