{"id":2030,"date":"2021-03-09T10:07:28","date_gmt":"2021-03-09T03:07:28","guid":{"rendered":"https:\/\/www.domosquare.com\/tutorial\/?p=2030"},"modified":"2021-03-09T10:07:30","modified_gmt":"2021-03-09T03:07:30","slug":"remote-database-postgresql-di-cpanel-menggunakan-ssh-tunnel","status":"publish","type":"post","link":"https:\/\/www.domosquare.com\/tutorial\/hosting\/remote-database-postgresql-di-cpanel-menggunakan-ssh-tunnel.html","title":{"rendered":"Remote database PostgreSQL di cPanel menggunakan SSH Tunnel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Pada tutorial ini kita akan mempelajari bagaimana mengakses secara remote databse postgreSQL pada cpanel dengan menggunakan SSH Tunnel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Untuk keperluan ini kita akan mengakses menggunakan HeidiSQL, aplikasi ini sangat bermanfaat untuk mengelola SQL server seperti Mysql, MariaDB, dan juga Postgre.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Jika Anda belum mendownload aplikasi HeidiSQL, silahkan download pada URL berikut:<br><a rel=\"noreferrer noopener\" href=\"https:\/\/www.heidisql.com\/download.php\" target=\"_blank\">https:\/\/www.heidisql.com\/download.php<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sudah di download silahkan diinstall \ud83d\ude42<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Hal lain yang perlu diperhatikan adalah fitur SSH sudah diaktifkan pada akun hosting Anda. Hal ini bisa request ke support untuk mengaktifkannya jika paket hosting Anda support untuk fitur ini.<br>Pada Domosquare.com, fitur ini bisa direquest untuk diaktifkan jika Anda memakai <a href=\"https:\/\/www.domosquare.com\/hosting\/enterprise\" target=\"_blank\" rel=\"noreferrer noopener\">paket Enterprise<\/a>.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Konfigurasi koneksi (Session) HeidiSQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Jangan lupa sebelum itu siapkan informasi username, password, dan nama database postgre Anda, jika belum Anda bisa buat di cPanel. Silahkan klik link berikut untuk mengetahui cara membuat database postgreSQL di cPanel:<br><a href=\"https:\/\/www.domosquare.com\/tutorial\/hosting\/cara-membuat-postgresql-di-cpanel.html\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.domosquare.com\/tutorial\/hosting\/cara-membuat-postgresql-di-cpanel.html<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Saat membuka HeidiSQL Anda akan melihat jendela Session Manager. Pada tab Settings pilih Network type PostgreSQL (SSH tunnel)<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-14.png\"><img loading=\"lazy\" decoding=\"async\" width=\"684\" height=\"482\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-14.png\" alt=\"\" class=\"wp-image-2038\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-14.png 684w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-14-300x211.png 300w\" sizes=\"auto, (max-width: 684px) 100vw, 684px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Selanjutnya, Anda isikan data:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Hostname \/ IP, bisa Anda isikan nama domain Anda<\/li><li>User, username database postgreSQL yang sudah Anda buat<\/li><li>Password, password database postgreSQL yang sudah Anda buat<\/li><li>Port, silahkan gunakan default port 5432<\/li><li>Database, Anda bisa tuliskan nama database yang Anda buat<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sudah, berikutnya silahkan klik Tab <strong>SSH tunnel<\/strong>, pada tab ini Anda akan menemukan settingan untuk akses SSH nya.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-15.png\"><img loading=\"lazy\" decoding=\"async\" width=\"680\" height=\"480\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-15.png\" alt=\"\" class=\"wp-image-2041\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-15.png 680w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-15-300x212.png 300w\" sizes=\"auto, (max-width: 680px) 100vw, 680px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Hal yang perlu Anda konfigurasikan di tab SSH Tunnel adalah:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>plink.exe location, silahkan browse lokasi plink.exe Anda, jika Anda belum memilikinya silahkan download di URL berikut:<br><a rel=\"noreferrer noopener\" href=\"https:\/\/the.earth.li\/~sgtatham\/putty\/0.74\/w64\/plink.exe\" target=\"_blank\">https:\/\/the.earth.li\/~sgtatham\/putty\/0.74\/w64\/plink.exe<\/a><\/li><li>SSH host + port, isikan nama domain Anda dan port SSH hosting Anda<\/li><li>Username, isikan username cPanel Anda<\/li><li>Password, isikan password cPanel Anda<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Jika sudah memastikan semuanya benar baik tab Settings ataupun tab SSH tunnel, selanjutnya Anda bisa klik tombol <strong>Open<\/strong>, jika benar semua konfigurasinya maka seharusnya Anda sudah berhasil terhubung ke akun postgreSQL Anda di cPanel \ud83d\ude42<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"> <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-16.png\"><img loading=\"lazy\" decoding=\"async\" width=\"790\" height=\"386\" src=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-16.png\" alt=\"\" class=\"wp-image-2042\" srcset=\"https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-16.png 790w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-16-300x147.png 300w, https:\/\/www.domosquare.com\/tutorial\/wp-content\/uploads\/2021\/03\/image-16-768x375.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/a><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Pada tutorial ini kita akan mempelajari bagaimana mengakses secara remote databse postgreSQL pada cpanel dengan menggunakan SSH Tunnel. Untuk keperluan ini kita akan mengakses menggunakan HeidiSQL, aplikasi ini sangat bermanfaat untuk mengelola SQL server seperti Mysql, MariaDB, dan juga Postgre. Jika Anda belum mendownload aplikasi HeidiSQL, silahkan download pada URL berikut:https:\/\/www.heidisql.com\/download.php Jika sudah di download [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"rating_form_position":"","rating_results_position":"","mr_structured_data_type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[839,1],"tags":[9,837,838],"class_list":["post-2030","post","type-post","status-publish","format-standard","hentry","category-cpanel","category-hosting","tag-cpanel","tag-postgre","tag-postgresql"],"jetpack_featured_media_url":"","multi-rating":{"mr_rating_results":[{"adjusted_star_result":0,"star_result":0,"total_max_option_value":5,"adjusted_score_result":0,"score_result":0,"percentage_result":0,"adjusted_percentage_result":0,"count":0,"post_id":2030}]},"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/2030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/comments?post=2030"}],"version-history":[{"count":1,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/2030\/revisions"}],"predecessor-version":[{"id":2043,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/posts\/2030\/revisions\/2043"}],"wp:attachment":[{"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/media?parent=2030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/categories?post=2030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.domosquare.com\/tutorial\/wp-json\/wp\/v2\/tags?post=2030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}