<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body text="#000000" bgcolor="#FFFFFF">
    <tt>Hi,<br>
      <br>
      0. The cfg block you mentioned as removed does not exists in the
      cfg as per tutorial.<br>
      <br>
      1. the "limit" column does not exist in the sipusers as per
      tutorial, so it might have been added in newer asterisk versions;
      not sure what is its meaning, but if setting it to 1 makes
      asterisk happy, it should be fine.<br>
      <br>
      2. with odbc_voicemail, you do not have to add the users in
      voicemail.conf . Are you sure you properly set in </tt><tt>/etc/asterisk/extconfig.conf
      the lines with:<br>
          </tt><tt>       voicemail =&gt; odbc,asteriskcfg,vmusers
      <br>
                 voicemail =&gt; odbc,asteriskcfg,vmaliases
          <br>
      <br>
      Regards,<br>
    </tt>
    <pre class="moz-signature" cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a class="moz-txt-link-freetext" href="http://www.opensips-solutions.com">http://www.opensips-solutions.com</a></pre>
    <div class="moz-cite-prefix">On 03.07.2016 22:59, Nabeel wrote:<br>
    </div>
    <blockquote
cite="mid:CA+vx6KLLsSgE=HOcZ3oXeMRFJvcJQ=q-btBwz82J+DG8bMqkCw@mail.gmail.com"
      type="cite">
      <div dir="ltr">The last error message has been solved by removing
        the following lines from opensips.cfg:
        <div><br>
        </div>
        <div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"> 
               if (!db_does_uri_exist()) {<br>
                                   send_reply("420","Bad Extension");<br>
                                   exit;<br>
                           }<br>
          </blockquote>
          <div> </div>
          <blockquote class="gmail_quote" style="margin:0px 0px 0px
0.8ex;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"> 
                         t_newtran();<br>
                           t_reply("480", "Temporarily Unavailable");</blockquote>
        </div>
        <div><br>
        </div>
        <div><br>
        </div>
        <div>Now voicemail seems to be working, but only if manually
          adding users to the voicemail.conf file. So the following
          questions remain:</div>
        <div><br>
        </div>
        <div>1. Adding "limit = 1" to sipusers mysql view resolves a
          database error. Is this the correct way to fix the error for
          voicemail integration?</div>
        <div><br>
        </div>
        <div>2. How can voicemail.conf file be configured to use
          variable substitution for all users in the OpenSIPS subscriber
          table?</div>
        <div><br>
        </div>
        <div>Nabeel</div>
      </div>
      <div class="gmail_extra"><br>
        <div class="gmail_quote">On 2 July 2016 at 13:41, Nabeel <span
            dir="ltr">&lt;<a moz-do-not-send="true"
              href="mailto:nabeelshikder@gmail.com" target="_blank">nabeelshikder@gmail.com</a>&gt;</span>
          wrote:<br>
          <blockquote class="gmail_quote" style="margin:0 0 0
            .8ex;border-left:1px #ccc solid;padding-left:1ex">
            <p dir="ltr">In the latest version of Asterisk, there is a
              new file voicemail.conf which must be configured correctly
              for voicemail, but the tutorial does not mention this file
              at all. Please let me know how to configure this file for
              integration with OpenSIPS. </p>
            <span class="HOEnZb"><font color="#888888">
                <p dir="ltr">Nabeel</p>
              </font></span></blockquote>
        </div>
        <br>
      </div>
    </blockquote>
    <br>
  </body>
</html>