Koneksi ke Linux dari Windows melalui ssh Tanpa Password

Membuat dan instalasi ssh key Jalankan PowerShell (Administrator) Masuk ke folder ssh cd c:\users\{ACCOUNT}\.ssh Buat ssh key ssh-keygen -t rsa Kopikan ssh key ke romote server type $env:USERPROFILE\.ssh\id_rsa.pub | ssh {REMOTE_HOST} "cat >> .ssh/authorized_keys" Tambahkan ssh key ke shell Windows ssh-agent $SHELL Tambahkan ssh key ke Agen Windows ssh-add Setting remote ssh authorized di server (Linux) Masuk ke remote host ssh {REMOTE_HOST} Buat folder ssh mkdir ~/.ssh Ubah permision ke folder ssh chmod 700 ~/.ssh Buat file authorized touch ~/.ssh/authorized_keys Ubah permision ke authorized file chmod 600 ~/.ssh/authorized_keys
Post a Comment

Sales Table

CREATE SEQUENCE sales_sequence AS SMALLINT START 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1;
CREATE TABLE sales ( id INT NOT NULL DEFAULT nextval('sales_sequence'::regclass), name VARCHAR (50) NOT NULL, street VARCHAR (128), city VARCHAR (50) NOT NULL, phone VARCHAR (25) NOT NULL, cell VARCHAR (25), zip VARCHAR (6), created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL );
ALTER TABLE sales ADD CONSTRAINT pk_sales PRIMARY KEY (id);
CREATE UNIQUE INDEX sales_ix_name ON sales USING btree (name);
CREATE TRIGGER sales_trig_create BEFORE INSERT ON sales FOR EACH ROW EXECUTE FUNCTION timestamp_on_create();
CREATE TRIGGER sales_trig_update BEFORE UPDATE ON sales FOR EACH ROW EXECUTE FUNCTION timestamp_on_update();

Comments

Post a Comment

Popular posts from this blog

Order Table

CREATE   FUNCTION  orders_on_create()  RETURNS  trigger    LANGUAGE  plpgsql    AS  $$ BEGIN   NEW.remain_payment = NEW.total - (NEW.cash + NEW.payments);   NEW.updated_at =  now ();    RETURN  NEW; END ; $$; CREATE   SEQUENCE  orders_sequence    AS   INT    START   1   INCREMENT  BY   1    NO  MINVALUE    NO  MAXVALUE   CACHE  1 ; CREATE   TABLE  orders (   id  INT   NOT   NULL   DEFAULT  nextval( 'orders_sequence' ::regclass),   customer_id  SMALLINT   NOT   NULL ,   sales_id  SMALLINT   NOT   NULL ,   due_date  TIMESTAMP   NOT   NULL ,   total  NUMERIC ( 11 ,  2 )  NOT   NULL ,   cash  NUMER...
Read more

Surah Yā Sīn

Surah ke–36 Terdiri atas 83 ayat Termasuk Surat Makkiyyah يٰسۤ ۚ yā sīn yaa siin وَالْقُرْاٰنِ الْحَكِيْمِۙ wal-qur`ānil-ḥakīm Demi Al-Qur’an yang penuh hikmah, اِنَّكَ لَمِنَ الْمُرْسَلِيْنَۙ innaka laminal-mursalīn sungguh, engkau (Muhammad) adalah salah seorang dari rasul-rasul, عَلٰى صِرَاطٍ مُّسْتَقِيْمٍۗ ‘alā ṣirāṭim mustaqīm (yang berada) di atas jalan yang lurus, تَنْزِيْلَ الْعَزِيْزِ الرَّحِيْمِۙ tanzīlal-‘azīzir-raḥīm (sebagai wahyu) yang diturunkan oleh (Allah) Yang Mahaperkasa, Maha Penyayang, لِتُنْذِرَ قَوْمًا مَّآ اُنْذِرَ اٰبَاۤؤُهُمْ فَهُمْ غٰفِلُوْنَ litunżira qaumam mā unżira ābā`uhum fa hum gāfilụn agar engkau memberi peringatan kepada suatu kaum yang nenek moyangnya belum pernah diberi peringatan, karena itu mereka lalai. لَقَدْ حَقَّ الْقَوْلُ عَلٰٓى اَكْثَرِهِمْ فَهُمْ لَا يُؤْمِنُوْنَ laqad ḥaqqal-qaulu ‘alā akṡarihim fa hum lā yu`minụn Sungguh, pasti berlaku perkataan (hukuman) terhadap kebanyakan mereka, karena ...
Read more

cURL Contoh Penggunaan GET, POST, PUT, dan DELETE

Berikut ini contoh-contoh penggunaan cURL dalam pengoperasian data antara server dan client. POST Menyimpan data sales ke server. curl -X POST http://localhost:3000/api/sales \ -H "Content-Type: application/json" \ -d '{"name":"saita","street":"ds. plumbon","city":"Indramayu","phone":"0234","cell":"0895","zip":"45212"}' # result {"id":1,"name":"saita","street":"ds. plumbon","city":"Indramayu","phone":"0234","cell":"0895","zip":"45212","created_at":"2020-12-24T07:43:06.966Z","updated_at":"2020-12-24T07:43:06.966Z"} PUT Mengubah data sales di server. curl -H "Content-Type: application/json" \ -X PUT http://l...
Read more