發表文章

目前顯示的是 2月, 2023的文章

Jenkins changes in /etc/default/jenkins not working

    systemctl cat jenkins  to see the options and  systemctl edit jenkins  to modify it.. you can change the port. [Service] Environment="JENKINS_PORT=8081" updated java memory and java args Environment="JENKINS_OPTS=" Environment="JENKINS_OPTS=-Xmx2048m" 參考網址: https://stackoverflow.com/questions/71494231/jenkins-changes-in-etc-default-jenkins-not-working 設定Jenkins with SSL Using an Nginx Reverse Proxy on Ubuntu 22.04 ---以下範例:https://dominname/jenkins--- [Service] Environment="JENKINS_PREFIX=/jenkins" https://www.digitalocean.com/community/tutorials/how-to-configure-jenkins-with-ssl-using-an-nginx-reverse-proxy-on-ubuntu-22-04

Oracle 11g以前 Aato_increment

Oracle 11g 開始,  Oracle 中沒有“auto_increment”或“identity”列這樣的東西 。 可以使用序列和触發器輕鬆地對其建模: 創建資料庫 CREATE TABLE SYSTEM_STATUS_ROW ( ROW_ID NUMBER(38,0 ) NOT NULL  PRIMARY KEY , SERVICE VARCHAR2( 50 ) NOT NULL, CREATEDAT TIMESTAMP NOT NULL,   ISALIVE NUMBER(38,0 ) DEFAULT 0, RESPONSECODE NUMBER ); 程序列 CREATE SEQUENCE SYSTEM_STAUTS_LOG_ROW INCREMENT BY 1 START WITH 1 ; 觸發程式(tigger) CREATE OR REPLACE TRIGGER SYSTEM_STAUTS_LOG_ROW BEFORE INSERT ON SYSTEM_STAUTS_LOG FOR EACH ROW BEGIN SELECT SYSTEM_STATUS_ROW .NEXTVAL INTO :new. row_id FROM dual; END; ------------------------------------------- IDENTITY專欄現已在 Oracle 12c 上可用: create table t1 ( c1 NUMBER GENERATED by default on null as IDENTITY , c2 VARCHAR2( 10 ) ); create table t1 ( c1 NUMBER GENERATED ALWAYS as IDENTITY ( START with 1 INCREMENT by 1 ), c2 VARCHAR2( 10 ) ); ------------------------------------------ 或者,Oracle 12 還允許使用序列作為默認值: CREAT...

Ubuntu安裝Nginx 安裝jenkins

Step 1 – Installing Nginx sudo apt update sudo apt install nginx Step 2 – Adjusting the Firewall sudo ufw app list -------- Output Available applications:   Nginx Full   Nginx HTTP   Nginx HTTPS   OpenSSH As demonstrated by the output, there are three profiles available for Nginx: Nginx Full : This profile opens both port 80 (normal, unencrypted web traffic) and port 443 (TLS/SSL encrypted traffic) Nginx HTTP : This profile opens only port 80 (normal, unencrypted web traffic) Nginx HTTPS : This profile opens only port 443 (TLS/SSL encrypted traffic) ---- sudo ufw allow 'Nginx HTTP' sudo ufw status Debian/Ubuntu 安裝java sudo apt update sudo apt install openjdk-11-jre java -version 安裝jenkins curl -fsSL https://pkg.jenkins.io/debian-stable/jenkins.io.key | sudo tee  /usr/share/keyrings/jenkins-keyring.asc > /dev/null echo deb [signed-by=/usr/share/keyrings/jenkins-keyring.asc]  https://pkg.jenkins.io/debian-stable binary/ | sudo tee  /etc/apt/sources.li...