ZEALTECH BLOG

How To Install and Configure Blackbox Exporter for Prometheus

Support

How To Install and Configure Blackbox Exporter for Prometheus

1. Create Docker Container Grafana ” docker run -d –name Grafana -p 3000:3000 -e ” GF_SECURITY_ADMIN_USER= admin” -e ” GF_SECURITY_ADMIN_ PASSWORD= password ” grafana/grafana:latest “ 2. Create Docker Container Prometheus ” docker run -d –name Prometheus -p 9090:9090 -v /opt/prometheus/prometheus.yml:/etc/prometheus/prome theus.yml prom/prometheus –config.file=/etc/prometheus/prometheus.yml “ Before crerating a Prometheus docker container you need to create a […]

nyein.k@zealtechinter.com

May 12, 2023
How to Create Loki , Promtail to show Data logs on Grafana

How to Create Loki , Promtail to show Data logs on Grafana

Support

1. Create Docker container Grafana “ docker run -d –name= Grafana -p 3000:3000 -e “GF_SECURITY_ADMIN_USER= admin” -e “GF_SECURITY_ADMIN_PASSWORD=password” grafana/grafana:latest ” 2. Create Docker Container Loki “ docker run -d –name= Loki -v /opt/Loki+Promtail/loki-config.yml:/mnt/config -p 3100:3100  grafana:loki” After creating a loki docker container you need to create a folder and create .yml  “ mkdir  /opt/Loki+Promtail ”  […]

nyein.k@zealtechinter.com

May 12, 2023
How to config Vue JS on ZTI server (Ubuntu).

How to config Vue JS on ZTI server (Ubuntu).

Configuration

This is the document how to config Vue JS after deploying webapp on ZTI dev server. 1. Create and config .htaccess file on the webapp root project folder. RewriteEngine OnRewriteBase /RewriteRule ^index.html$ – [L]RewriteCond %{REQUEST_FILENAME} !-fRewriteCond %{REQUEST_FILENAME} !-dRewriteRule . /<webapp_path>/index.html [L] 2. Setup new deployment in Jenkins with this template.http://jenkins.ztidev.com/jenkins/view/KHA.ZealNews/job/Dev._KHA-CMS/configure 3. Config Nginx $ vi […]

Teerakorn Bounoy

April 6, 2023
[MongoDB] How to create new database.

[MongoDB] How to create new database.

Configuration

This is the manual how to create new database for developing on ZTI database server. Remote to ZTI database server. Login to mongo$ mongo Authen to with admin account.> use admin;> db.auth(‘<admin_username>’, ‘<admin_password>’);1 Create new database. > use <db_name>;> db.createUser( { user: “<username>”, pwd: “<password>”, roles: [ { role: “readWrite”, db: “<db_name>” } ] });> […]

Teerakorn Bounoy

April 6, 2023
[MariaDB, MySQL] How to create new database.

[MariaDB, MySQL] How to create new database.

Configuration

This is the manual how to create new database for developing on ZTI database server. Remote to ZTI database server. Login to mariadb $ mysql -u root -p Create new database with command > create database <db_name>;> create user ‘<username>‘@’localhost’ identified by ‘<password>‘;> create user ‘<username>‘@’%’ identified by ‘<password>‘;> grant all on <db_name>.* to ‘<username>‘ […]

Teerakorn Bounoy

April 6, 2023
SQL Query Optimization Techniques

SQL Query Optimization Techniques

Knowledge

1. ใช้ EXIST() แทน COUNT() ในการหา ข้อมูลใน Table ข้อมูลที่จะ ได้รับจะเป็น 0 คือไม่มี และ 1 คือมีข้อมูล 2. ใช้ Varchar แทน Char ตัวอย่าง CHAR(100) จะใช้ 100 bytes ของหน่วยความจำเพื่อเก็บ single character ตัวอย่าง VARCHAR(100) จะใช้แค่ 1 byte ของหน่วยความจำเพื่อเก็บ single character. 3. หลีกเลี่ยงการใช้ Subqueries ใน WHERE Clause 4. เรียงลำดับการ JOINs จาก Table ที่มีข้อมูลเยอะกว่าเสมอ 5. ใช้`regexp_like` แทน `LIKE` Ref. https://www.kdnuggets.com/2023/03/sql-query-optimization-techniques.html

purim.n

March 3, 2023
[OBEC.Content Center] How to fixed problem on “OBEC Content Center” And Clear Cache

[OBEC.Content Center] How to fixed problem on “OBEC Content Center” And Clear Cache

Support

1st Step You Need to check 3 Websites & Check Server Status “httpd” is Active or Inactive (Dead) Connect to VPN using Soft Ether VPN Client with IP : 202.29.172.175 Port : 443 Virtual Hub Name: OBEC After Connect Soft Ether VPN Client, Please go and Check all of these 3 Website links http://192.168.232.128/  http://192.168.232.129/  […]

nyein.k@zealtechinter.com

February 10, 2023
1 2 … 6