pgadmin4 err

err

(sqlite3.IntegrityError) UNIQUE constraint failed: database.id, database.server
[SQL: INSERT INTO "database" (id, schema_res, server) VALUES (?, ?, ?)]
[parameters: (16384, '', 19)]
(Background on this error at: http://sqlalche.me/e/13/gkpj)

Download and install Zabbix PostgreSQL

Download and install Zabbix

https://www.zabbix.com/download?zabbix=5.0&os_distribution=ubuntu&os_version=20.04_focal&db=postgresql&ws=apache

---

a. Install Zabbix repository

wget https://repo.zabbix.com/zabbix/5.0/ubuntu/pool/main/z/zabbix-release/zabbix-release_5.0-1+focal_all.deb

sudo dpkg -i zabbix-release_5.0-1+focal_all.deb

sudo apt update

err

パッケージリストを読み込んでいます... 完了

依存関係ツリーを作成しています       

状態情報を読み取っています... 完了

アップグレードできるパッケージが 310 個あります。表示するには 'apt list --upgradable' を実行してください。

N: リポジトリ 'http://repo.zabbix.com/zabbix/5.0/ubuntu focal InRelease' がアーキテクチャ 'i386' をサポートしないため設定ファイル 'main/binary-i386/Packages' の取得をスキップ

N: リポジトリ 'http://apt.postgresql.org/pub/repos/apt focal-pgdg InRelease' がアーキテクチャ 'i386' をサポートしないため設定ファイル 'main/binary-i386/Packages' の取得をスキップ

---

b. Install Zabbix server, frontend, agent

sudo apt install zabbix-server-pgsql zabbix-frontend-php php7.4-pgsql zabbix-apache-conf zabbix-agent

---

c. Create initial database

sudo -u postgres createuser --pwprompt zabbix

sudo -u postgres createdb -O zabbix zabbix

---

d. Configure the database for Zabbix server

Edit file /etc/zabbix/zabbix_server.conf

sudo gedit /etc/zabbix/zabbix_server.conf

DBPassword=New_db_password

---

e. Configure PHP for Zabbix frontend

Edit file /etc/zabbix/apache.conf, uncomment and set the right timezone for you.

sudo gedit /etc/zabbix/apache.conf,

php_value date.timezone Asia/Tokyo

---

f. Start Zabbix server and agent processes

Start Zabbix server and agent processes and make it start at system boot.

sudo systemctl restart zabbix-server zabbix-agent apache2

sudo systemctl enable zabbix-server zabbix-agent apache2

---

g. Configure Zabbix frontend

Connect to your newly installed Zabbix frontend: http://server_ip_or_name/zabbix

Follow steps described in Zabbix documentation: Installing frontend

127.0.0.1/zabbix

---

PostGraphile

-------------------------------------------------------

node.js

https://www.digitalocean.com/community/tutorials/how-to-install-node-js-on-ubuntu-20-04-ja

sudo apt update

sudo apt install nodejs

-------------------------------------------------------

npm install -g postgraphile

-------------------------------------------------------

PostgreSQLとPostGraphileでサクッとGraphQLエンドポイントを作成する

https://qiita.com/notakaos/items/2480488f8188f5a71081

-------------------------------------------------------

sudo gedit !/usr/bin/env bash

#!/usr/bin/env bash

pnpx postgraphile \

  --connection postgres:///postgres \

  --watch

-------------------------------------------------------

‣ GraphQL API:         http://localhost:5000/graphql

  ‣ GraphiQL GUI/IDE:    http://localhost:5000/graphiql

  ‣ Postgres connection: postgres://postgres:[SECRET]@localhost/mydb (watching)

  ‣ Postgres schema(s):  public

  ‣ Documentation:       https://graphile.org/postgraphile/introduction/

  ‣ Node.js version:     v10.19.0 on linux x64

  ‣ Join Robert Claypool in supporting PostGraphile development: https://graphile.org/sponsor/