Yadda ake Haɗa zuwa Database mai nisa a pgAdmin4 da DBeaver

canja wurin fayil.

Hakanan za'a iya amfani da SSH don ƙirƙirar amintaccen rami na sadarwa tsakanin kwamfutoci don tura sauran hanyoyin sadarwar da ba a ɓoye ba, wata dabara da ake kira SSH Tunneling (ko tura tashar jiragen ruwa).

Anan akwai wasu al'amuran gama gari waɗanda za ku yi amfani da rami na SSH ko tura tashar jiragen ruwa:

Idan tashar tashar sabis ta nesa da kuke ƙoƙarin shiga ta toshe a cikin Tacewar zaɓi.
Kuna son haɗawa ta amintaccen sabis zuwa sabis ɗin da ba ya amfani da ɓoyayyen ɓoyewa da sauran su.

Misali, idan kuna son haɗawa zuwa gungu na bayanan PostgreSQL mai nisa da ke gudana akan tashar jiragen ruwa 5432 akan Server A, amma ana ba da izinin zirga-zirga zuwa waccan tashar daga Sabar B (wanda kuna da damar SSH). Kuna iya tuntuɓar zirga-zirga ta hanyar haɗin SSH (ramin rami) ta hanyar Sabar B don samun damar tarin bayanai.

Wannan jagorar tana ɗauka cewa kuna da kayan aikin sarrafa bayanai na pgadmin4 da DBeaver da aka shigar akan tsarin Linux ɗin ku, in ba haka ba, duba waɗannan jagororin:

Yadda ake Sanya PostgreSQL da pgAdmin a cikin CentOS 8
Yadda ake Sanya PostgreSQL da pgAdmin a cikin RHEL 8
Yadda ake Sanya PgAdmin 4 Debian 10/11
Yadda ake Sanya PostgreSQL tare da pgAdmin4 akan Linux Mint 20
Yadda Ake Shigar DBeaver Universal Database Tool a Linux

Sanya SSH Tunneling a pgadmin4

Bude aikace-aikacen pgadmin4 ɗin ku kuma fara da ƙirƙirar sabon haɗin yanar gizo, je zuwa abubuwan abubuwan shafin, sannan danna Ƙirƙiri kuma danna Server. A cikin taga mai bayyanawa, a ƙarƙashin Gaba ɗaya shafin, shigar da sunan uwar garke kamar yadda aka haskaka a cikin hoton da ke biyowa.

Na gaba, danna kan Haɗin shafin don shigar da saitunan haɗin bayanai. Shigar da adireshin IP na uwar garken bayanai ko FQDN (sunan yanki cikakke wanda ya cancanta). Sannan saita tashar jiragen ruwa, sunan bayanai, sunan mai amfani da bayanai, da kuma kalmar sirrin mai amfani.

Kuna iya duba Ajiye kalmar sirri don adana kalmar sirri a gida don kada a sa ku shigar da shi duk lokacin da kuka yi ƙoƙarin haɗi zuwa bayanan.

Na gaba, danna kan SSH Tunnel tab. Kunna zaɓin \Yi amfani da SSH tunneling, shigar da Mai watsa shiri na Tunnel, Tunnel port, sunan mai amfani na SSH. Sannan zaɓi nau'in Tabbatarwa (ko dai kalmar sirri ko fayil ɗin ainihi).

Muna ba da shawarar yin amfani da ingantaccen maɓalli na jama'a don haka zaɓi FILE IDENTITY kuma zaɓi fayil ɗin maɓalli na sirri daga na'urar ku. Sannan danna SAVE kamar yadda aka haskaka a cikin hoton da ke biyowa.

Idan saitunan da aka bayar da takaddun shaida na haɗin bayanai da kuma ramin SSH daidai ne kuma suna aiki, ya kamata a kafa rami da haɗin bayanai cikin nasara.

Sanya Tunneling SSH a DBeaver

Bayan kaddamar da DBeaver, je zuwa Databases tab, sa'an nan danna Sabuwar Database Connection kamar yadda aka nuna a cikin wadannan screenshot.

Zaɓi direban bayanan ku daga lissafin kamar yadda aka yi alama a cikin hoton da ke biyowa sannan danna Next.

Yanzu shigar da saitunan haɗin bayanai, mai masaukin bayanan IP ko FQDN, sunan bayanan bayanai, sunan mai amfani da bayanai, da kalmar wucewa ta mai amfani kamar yadda aka yi haske a cikin hoton da ke biyo baya. Sannan danna shafin SSH don shigar da saitunan haɗin rami kamar yadda aka bayyana a mataki na gaba.

Kunna SSH ta hanyar duba zaɓin Yi amfani da Tunnel SSH. Shigar da Mai watsa shiri na Tunnel, Tunnel port, sunan mai amfani na haɗin SSH, kuma zaɓi hanyar Tabbatarwa.

Kamar koyaushe, muna ba da shawarar amfani da ingantaccen maɓalli na Jama'a. Sannan zaɓi ko shigar da hanyar zuwa maɓallin keɓaɓɓen ku. Sannan danna Gama kamar yadda aka nuna a hoton da ke biyowa.

Lura: Idan maɓallin keɓaɓɓen ku yana da kalmar wucewa, kuna buƙatar samar da shi.

Idan haɗin bayanan ku da saitunan ramin SSH daidai ne kuma yana aiki, haɗin ya kamata ya yi nasara. Yanzu zaku iya aiki amintacce tare da bayananku mai nisa.

Don ƙarin bayani, duba takaddun haɗin DBeaver SSH.