HelioHost Posted June 17, 2017 Posted June 17, 2017 Hi! Recently started with the heliohost service and create a database inpostgresql.I want to make a remote connection from pgAdmin 4. The name of the base is"beues17_BuscandoEmpleoUes" and user "beus17_omq" the server is Ricky. Could you please enable remote access from any IP address
beues17 Posted June 17, 2017 Posted June 17, 2017 (edited) Still does'nt connect Unable to connect to server: FATAL: no pg_hba.conf entry for host "ip address", user "beues17_omq", database "postgres", SSL off. Reviewing the information I sent you. The user is wrong forget the letter e The correct user is "beues17_omq" Edited June 17, 2017 by beues17
HelioHost Posted June 18, 2017 Author Posted June 18, 2017 Thanks its working El 17/06/2017 15:38, "Heliohost Support" escribio: > Your message (Remote PostgreSQL Databases Access) has been assigned the> tracking ID [HH#57235]. One of our volunteer community members will reply> to your email as soon as possible.>> Please include the string [HH#57235] in the subject of any future email> regarding this case. You may do that by simply replying to this message.>> Please be aware that our system rejects binary attachements. If you are> submitting a screenshot or attachement please post a link to the file> instead of attaching it to the email.>> You may view the status of your ticket by visiting:>> http://www.helionet.org/index/index.php?showtopic=28462>> Thank you,> Heliohost Support> http://www.heliohost.org/> http://www.helionet.org/>> -----Original Message----->> Return-Path: > Delivered-To: support@heliohost.org> Received: from tommy.heliohost.org> by tommy.heliohost.org (Dovecot) with LMTP id> u0qLMG2hRVlxUwAAY4nxBQ> for ; Sat, 17 Jun 2017 14:38:53 -0700> Return-path: > Envelope-to: support@heliohost.org> Delivery-date: Sat, 17 Jun 2017 14:38:53 -0700> Received: from mail-yw0-f169.google.com ([209.85.161.169]:34764)> by tommy.heliohost.org with esmtps (TLSv1.2:ECDHE-RSA-AES128-GCM-> SHA256:128)> (Exim 4.89)> (envelope-from )> id 1dMLQi-00054f-AM> for support@heliohost.org; Sat, 17 Jun 2017 14:38:53 -0700> Received: by mail-yw0-f169.google.com with SMTP id e142so30206799ywa.1> for ; Sat, 17 Jun 2017 14:38:32 -0700 (PDT)> DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;> d=gmail.com; s=20161025;> h=mime-version:from:date:message-id:subject:to;> bh=+AvI4BiPXagR6lteHfqSqZLuxEryJNjY6fFAXzJANSU=;> b=szsq2/zDBBNdDf8FpmOYJjOyVJPjPeNgMIyx> +FGSbiC5THA/hRB616drzCGEZgzvQr> dXJYYyclnGX43k9s9SDCnE4vZYZfmtBjTduSxcGBIPFDH7ge3Dq7Nxvh876v> h9OZr0OP> 47yP72O0ai+rlhItYBhpC4I9cUEht+R6U4RkQdR/> qWme4lYj5zeW2DBNhpJP+UCqS5rz> y/qHnNWwm1WnMYMriP3pEV/Zz540yIlESThgD8T0ugsluJpdA0rsM> es5RNi/q/fkov8t> Nkf4VsJPNanbWQnoAf4AiMo/RohyTNyfDgVU+18vubRZaWrkNpTn2i5qnH9jypFG+> Akm> r2VQ==> X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;> d=1e100.net; s=20161025;> h=x-gm-message-state:mime-version:from:date:message-id:subject:to;> bh=+AvI4BiPXagR6lteHfqSqZLuxEryJNjY6fFAXzJANSU=;> b=RzfK1ulNuJ11gTXUSkZXssQ6+3Pyiy6zLJQZsb64HKO6KCiuEzTr8OL> jII7g83ihLf> 0haN8Tecnq3ts5Ife5YAvdVT1ucmlJn1Zfk33U9Y0LplCJUsmLgOcbUKFlGk> Sr+96b/E> ZUKrwp/MBqcSt++6M5bDxjE+pOZJjMOlJTBO0Xmr5YB/3Z/> OdSY34UkUvY/IA2fFuIqv> jwYOWv6gkrZtN/ZxbPn5S3h/vahHgDoBl/pji1kEmGPkQuqQuY02pfBs79sHik0u> aqRN> HGSZAkjt4PsWjcnPQTHtdFtWJdSU9c/A1MK1pPywHBPqUfjh2Tm8LsDNGAH+> WtD8zBDX> 17xg==> X-Gm-Message-State: AKS2vOzF5dgW5ur3ECh2F6fOTSrpDK> iaPLk+V89HKfedZREldqh+I67L> LblqjShz95msJVPPswBoT0gl145oCVu0> X-Received: by 10.129.53.132 with SMTP id c126mr14273527ywa.87.> 1497735491280;> Sat, 17 Jun 2017 14:38:11 -0700 (PDT)> MIME-Version: 1.0> Received: by 10.129.72.12 with HTTP; Sat, 17 Jun 2017 14:38:10 -0700 (PDT)> From: Oscar Mario Quintanilla > Date: Sat, 17 Jun 2017 15:38:10 -0600> Message-ID: gmail.com>> Subject: Remote PostgreSQL Databases Access> To: support@heliohost.org> Content-Type: multipart/alternative; boundary="> 001a114216bcece55a05522eb704"> X-Spam-Status: No, score=-1.5> X-Spam-Score: -14> X-Spam-Bar: -> X-Ham-Report: Spam detection software, running on the system "> tommy.heliohost.org",> has NOT identified this incoming email as spam. The original> message has been attached to this so you can view it or label> similar future email. If you have any questions, see> root\@localhost for details.>> Content preview: Hi! Recently started with the heliohost service and> create> a database in postgresql. I want to make a remote connection from> pgAdmin> 4. The name of the base is "beues17_BuscandoEmpleoUes" and user> "beus17_omq"> the server is Ricky. [...]>> Content analysis details: (-1.5 points, 5.0 required)>> pts rule name description> ---- ---------------------- ------------------------------> --------------------> -0.0 RCVD_IN_DNSWL_NONE RBL: Sender listed at http://www.dnswl.org/,> no> trust> [209.85.161.169 listed in list.dnswl.org]> 0.5 RCVD_IN_SORBS_SPAM RBL: SORBS: sender is a spam source> [209.85.161.169 listed in dnsbl.sorbs.net]> -0.0 RCVD_IN_MSPIKE_H3 RBL: Good reputation (+3)> [209.85.161.169 listed in wl.mailspike.net]> 0.0 FREEMAIL_FROM Sender email is commonly abused enduser mail> provider> (osmarquios[at]gmail.com)> -0.0 SPF_PASS SPF: sender matches SPF record> 0.0 HTML_MESSAGE BODY: HTML included in message> -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1%> [score: 0.0000]> -0.1 DKIM_VALID_AU Message has a valid DKIM or DK signature from> author's> domain> -0.1 DKIM_VALID Message has at least one valid DKIM or DK> signature> 0.1 DKIM_SIGNED Message has a DKIM or DK signature, not> necessarily valid> -0.0 RCVD_IN_MSPIKE_WL Mailspike good senders> X-Spam-Flag: NO>> --001a114216bcece55a05522eb704> Content-Type: text/plain; charset="UTF-8">> Hi!>> Recently started with the heliohost service and create a database in> postgresql.> I want to make a remote connection from pgAdmin 4. The name of the base is> "beues17_BuscandoEmpleoUes" and user "beus17_omq" the server is Ricky.>> Could you please enable remote access from any IP address>> --001a114216bcece55a05522eb704> Content-Type: text/html; charset="UTF-8"> Content-Transfer-Encoding: quoted-printable>> Hi! style=3D"color:rgb(40,40,40);=> font-family:helvetica,arial,sans-serif;font-size:14px"> style=3D"color:r=> gb(40,40,40);font-family:helvetica,arial,sans-serif;font-size:14px"> c=> olor=3D"#282828" face=3D"helvetica, arial, sans-serif"> style=3D"font-=> size:14px">Recently started with the heliohost service and create a> databas=> e in postgresql. face=3D"helvetic=> a, arial, sans-serif">I want to make a> remot=> e connection from pgAdmin 4. The name of the base is> "beues17_Buscando=> EmpleoUes" and user "beus17_omq" the server is> Ricky.=> Could you please enable> rem=> ote access=C2=A0from any IP address =3D"color:rgb(40,40,40);font-family:helvetica,arial,sans-> serif;font-size:14=> px"> >> --001a114216bcece55a05522eb704-->>
Recommended Posts