Postgresql ldap authentication











up vote
0
down vote

favorite












I try to use the ldap authentication method to login to postgres with Azure AD.
With ldapsearch from the same machine, I get a connection and can use the searchonly user. But as soon as I use postgres I get:




could not start LDAP TLS session: Can't contact LDAP server




I tried on port 636 and 389. A tcp dump showed me that the connection was made correctly and the search was successful, but it just times out on postgres side.




psql: SSL connection has been closed unexpectedly




Was anyone able to configure postgresql via the ldap authentication against Azure AD?



Using; Debain 9.6, Postgresql 9.6, Azure AD



pg_hba rule:




host all all 0.0.0.0/0 ldap ldapserver="ldaps1.domain.com" ldapbasedn="dc=domain,dc=com" ldapbinddn="cn=searchonly,ou=local,dc=domain,dc=com" ldapbindpasswd="myPW" ldapsearchattribute="userPrincipalName"




Even more strange, using the simple bind method it is working without problems. Why not with bind + search?






postgresql azure ldap







share|improve this question


























    up vote
    0
    down vote

    favorite












    I try to use the ldap authentication method to login to postgres with Azure AD.
    With ldapsearch from the same machine, I get a connection and can use the searchonly user. But as soon as I use postgres I get:




    could not start LDAP TLS session: Can't contact LDAP server




    I tried on port 636 and 389. A tcp dump showed me that the connection was made correctly and the search was successful, but it just times out on postgres side.




    psql: SSL connection has been closed unexpectedly




    Was anyone able to configure postgresql via the ldap authentication against Azure AD?



    Using; Debain 9.6, Postgresql 9.6, Azure AD



    pg_hba rule:




    host all all 0.0.0.0/0 ldap ldapserver="ldaps1.domain.com" ldapbasedn="dc=domain,dc=com" ldapbinddn="cn=searchonly,ou=local,dc=domain,dc=com" ldapbindpasswd="myPW" ldapsearchattribute="userPrincipalName"




    Even more strange, using the simple bind method it is working without problems. Why not with bind + search?






    postgresql azure ldap







    share|improve this question
























      up vote
      0
      down vote

      favorite









      up vote
      0
      down vote

      favorite











      I try to use the ldap authentication method to login to postgres with Azure AD.
      With ldapsearch from the same machine, I get a connection and can use the searchonly user. But as soon as I use postgres I get:




      could not start LDAP TLS session: Can't contact LDAP server




      I tried on port 636 and 389. A tcp dump showed me that the connection was made correctly and the search was successful, but it just times out on postgres side.




      psql: SSL connection has been closed unexpectedly




      Was anyone able to configure postgresql via the ldap authentication against Azure AD?



      Using; Debain 9.6, Postgresql 9.6, Azure AD



      pg_hba rule:




      host all all 0.0.0.0/0 ldap ldapserver="ldaps1.domain.com" ldapbasedn="dc=domain,dc=com" ldapbinddn="cn=searchonly,ou=local,dc=domain,dc=com" ldapbindpasswd="myPW" ldapsearchattribute="userPrincipalName"




      Even more strange, using the simple bind method it is working without problems. Why not with bind + search?






      postgresql azure ldap







      share|improve this question













      I try to use the ldap authentication method to login to postgres with Azure AD.
      With ldapsearch from the same machine, I get a connection and can use the searchonly user. But as soon as I use postgres I get:




      could not start LDAP TLS session: Can't contact LDAP server




      I tried on port 636 and 389. A tcp dump showed me that the connection was made correctly and the search was successful, but it just times out on postgres side.




      psql: SSL connection has been closed unexpectedly




      Was anyone able to configure postgresql via the ldap authentication against Azure AD?



      Using; Debain 9.6, Postgresql 9.6, Azure AD



      pg_hba rule:




      host all all 0.0.0.0/0 ldap ldapserver="ldaps1.domain.com" ldapbasedn="dc=domain,dc=com" ldapbinddn="cn=searchonly,ou=local,dc=domain,dc=com" ldapbindpasswd="myPW" ldapsearchattribute="userPrincipalName"




      Even more strange, using the simple bind method it is working without problems. Why not with bind + search?






      postgresql azure ldap




      postgresql azure ldap






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 14 at 14:02









      Chris

      11




      11





























          active

          oldest

          votes











          Your Answer






          StackExchange.ifUsing("editor", function () {
          StackExchange.using("externalEditor", function () {
          StackExchange.using("snippets", function () {
          StackExchange.snippets.init();
          });
          });
          }, "code-snippets");

          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "1"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });














          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53302025%2fpostgresql-ldap-authentication%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown






























          active

          oldest

          votes













          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes
















          draft saved

          draft discarded




















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.





          Some of your past answers have not been well-received, and you're in danger of being blocked from answering.


          Please pay close attention to the following guidance:


          • Please be sure to answer the question. Provide details and share your research!

          But avoid …



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53302025%2fpostgresql-ldap-authentication%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          -

          Popular posts from this blog

          How to send String Array data to Server using php in android

          Image
          0 I have a String array which contains value string array = {6,37,38,837,7,...} and I have also used some string values. I want to send that all string values and string array to my database which is located at server side. When I am click on submit button the data will stored in table. On the PHP side I want to read this array as it is,other thing i will do at background means PHP side. See my below code then you will get it what I am says. Here is my code: public class Hotels extends Activity { // Declare Variables JSONArray jsonarray = null; private static final String TAG_ID = "id"; public static final String TAG_NAME = "name"; public static final String TAG_LOCATION = "location"; public static final String TAG_DESC = "description"; String f_date, l_date;...
          Read more

          Title Spacing in Bjornstrup Chapter, Removing Chapter Number From Contents

          Image
          up vote 5 down vote favorite 2 I would like to make it so that the vertical space below the title of each chapter is the same when using the Bjornstrup package (i.e. so that the descenders do not affect the spacing - as shown by the red arrow in the picture below). I think I'm fairly happy with the spacing around "A chapter", so I'd really like titles without descenders (e.g. "Contents") to have the same vertical spacing as "A chapter" below the title. I would also like to remove the large "0" in the contents title. Any help appreciated, as always. documentclass[11pt,a4paper]{book} % Packages[![enter image description here][1]][1] usepackage[left=3.5cm, right=3.5cm, top=4.3cm, bottom=4.25cm]{geometry} usepackage[utf8]{inputenc} usepackage{libertine} usepackage[libertine]{newtx...
          Read more

          Is anime1.com a legal site for watching anime?

          Image
          up vote 4 down vote favorite 1 Other anime streaming sites are blocking my IP because I'm Iranian while anime1.com isn't. I wanted to know if it's legal to watch/stream anime from this site. Thanks. anime-production share | improve this question edited Nov 27 at 22:38 W. Are 1,599 2 23 asked Nov 27 at 20:36 mhnajafi 23 3 add a comment ...
          Read more