<html>
  <head>
    <meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <tt>Hi, Nabeel!<br>
      <br>
      You should set the 'calculate_ha1' to 0 (it is already computed in
      the ha1 column) and set the password_column to 'ha1'.<br>
      <br>
      modparam("auth_db", "calculate_ha1", 0)<br>
      modparam("auth_db", "password_column", "ha1")<br>
      <br>
      Best regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Răzvan Crainea
OpenSIPS Solutions
<a class="moz-txt-link-abbreviated" href="http://www.opensips-solutions.com">www.opensips-solutions.com</a></pre>
    <div class="moz-cite-prefix">On 09/14/2015 12:00 PM, Nabeel wrote:<br>
    </div>
    <blockquote
cite="mid:CA+vx6K+2F7+_ybdbW_RomZ4foyN0WSmR1Lqpcm2i6c=_7diCFQ@mail.gmail.com"
      type="cite">
      <p dir="ltr">Hi razvan,</p>
      <p dir="ltr">By default, the opensips script from menuconfig
        already has 'calculate_ha1' set to 'yes' (and 'password_column'
        set to 'password').  Do you mean set 'calculate_ha1' to '0'? 
        Then should the 'password_column' remain 'password', or should
        it point to the 'ha1' column?  If the column remains 'password',
        should this column contain the encoded ha1 password? </p>
      <p dir="ltr">Please clarify.</p>
      <div class="gmail_quote">On 14 Sep 2015 08:04, "Răzvan Crainea"
        &lt;<a moz-do-not-send="true" href="mailto:razvan@opensips.org">razvan@opensips.org</a>&gt;
        wrote:<br type="attribution">
        <blockquote class="gmail_quote" style="margin:0 0 0
          .8ex;border-left:1px #ccc solid;padding-left:1ex">
          <div bgcolor="#FFFFFF" text="#000000"> <tt>Hi, Nabeel!<br>
              <br>
              By default, OpenSIPS uses the password column to
              authenticate users. If you want to use HA1 authentication,
              you should set the calculate_ha1 parameter[1].<br>
              <br>
              [1] <a moz-do-not-send="true"
                href="http://www.opensips.org/html/docs/modules/2.1.x/auth_db#id293468"
                target="_blank">http://www.opensips.org/html/docs/modules/2.1.x/auth_db#id293468</a><br>
              <br>
              Best regards,<br>
            </tt>
            <pre cols="72">Răzvan Crainea
OpenSIPS Solutions
<a moz-do-not-send="true" href="http://www.opensips-solutions.com" target="_blank">www.opensips-solutions.com</a></pre>
            <div>On 09/13/2015 10:25 AM, Nabeel wrote:<br>
            </div>
            <blockquote type="cite">
              <p dir="ltr">Just tested this and I'm not able to register
                without having the plain text password present in the
                'password' column in db.  How can I make OpenSIPS
                register using only the ha1 hashed value? I tried
                commenting out and changing the 'password_column'
                attribute in config but it didn't work.</p>
              <div class="gmail_quote">On 12 Sep 2015 12:40, "Nabeel"
                &lt;<a moz-do-not-send="true"
                  href="mailto:nabeelshikder@gmail.com" target="_blank">nabeelshikder@gmail.com</a>&gt;

                wrote:<br type="attribution">
                <blockquote class="gmail_quote" style="margin:0 0 0
                  .8ex;border-left:1px #ccc solid;padding-left:1ex">
                  <p dir="ltr">Hi,</p>
                  <p dir="ltr">My SIP client only uses the 'ha1'
                    password field from database to authenticate users
                    and ignores the 'password' field totally.  Will
                    OpenSIPS allow such authentication to complete and
                    register the user by using only the ha1 hashed
                    password?</p>
                </blockquote>
              </div>
              <br>
              <fieldset></fieldset>
              <br>
              <pre>_______________________________________________
Users mailing list
<a moz-do-not-send="true" href="mailto:Users@lists.opensips.org" target="_blank">Users@lists.opensips.org</a>
<a moz-do-not-send="true" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
            </blockquote>
            <br>
          </div>
          <br>
          _______________________________________________<br>
          Users mailing list<br>
          <a moz-do-not-send="true"
            href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
          <a moz-do-not-send="true"
            href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users"
            rel="noreferrer" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
          <br>
        </blockquote>
      </div>
      <br>
      <fieldset class="mimeAttachmentHeader"></fieldset>
      <br>
      <pre wrap="">_______________________________________________
Users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a>
<a class="moz-txt-link-freetext" href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a>
</pre>
    </blockquote>
    <br>
  </body>
</html>