<p dir="ltr">Hi Bogdan, </p>
<p dir="ltr">I just added the column to the view by adding "NULL AS `callbackextension`" to the SQL view definition. I haven't linked the column to the subscriber column, so this may not be the correct definition. However, it got rid of the error. </p>
<p dir="ltr">About the voicemail.conf file, when I attempted to leave a voicemail to a number in subscriber table, I got an error telling me that the user/mailbox does not exist in voicemail.conf file. After adding that number manually to the file, voicemail was working for that number. I think this may also mean that the integration is not working correctly in my current setup. </p>
<p dir="ltr">Nabeel <br>
</p>
<div class="gmail_quote">On 4 Jul 2016 8:48 a.m., "Bogdan-Andrei Iancu" <<a href="mailto:bogdan@opensips.org">bogdan@opensips.org</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<tt>Hi,<br>
<br>
What is the definition you used for this new column ?<br>
<br>
Best regards,<br>
</tt>
<pre cols="72">Bogdan-Andrei Iancu
OpenSIPS Founder and Developer
<a href="http://www.opensips-solutions.com" target="_blank">http://www.opensips-solutions.com</a></pre>
<div>On 02.07.2016 05:29, Nabeel wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">In the last error message,<i> '</i><span style="font-size:12.8px"><i>callbackextension = ?' </i>suggested
that this column is missing from the sipusers mysql view. So I
added this column to the view and now that error has been
resolved. Only the following error remains now:</span>
<div><span style="font-size:12.8px"><br>
</span></div>
<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">[Jul
2 03:25:48] WARNING[19330][C-00000005]: app.c:1633
__ast_play_and_record: No audio available on
SIP/domain.com-00000005??</blockquote>
<div><br>
</div>
</div>
<div style="font-size:12.8px"><br>
</div>
<div><span style="font-size:12.8px"><br>
</span></div>
<div><span style="font-size:12.8px"><br>
</span></div>
</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 2 July 2016 at 02:36, Nabeel <span dir="ltr"><<a href="mailto:nabeelshikder@gmail.com" target="_blank">nabeelshikder@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div>The issue in my last Email has solved the error about
missing extension. Now the following errors remain:</div>
<div><br>
</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">[Jul
2 02:29:18] WARNING[18226][C-00000001]:
res_config_odbc.c:117 custom_prepare: SQL Prepare
failed![SELECT * FROM sipusers WHERE host = ? AND
callbackextension = ? AND port = ?]<br>
[Jul 2 02:29:22] WARNING[18269][C-00000000]: app.c:1633
__ast_play_and_record: No audio available on
SIP/domain.com-00000000??</blockquote>
<div><br>
</div>
</div>
<div>
<div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 2 July 2016 at 02:23,
Nabeel <span dir="ltr"><<a href="mailto:nabeelshikder@gmail.com" target="_blank"><a href="mailto:nabeelshikder@gmail.com" target="_blank">nabeelshikder@gmail.com</a></a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">
<div class="gmail_extra">The tutorial contains a
mistake where the priority ordering in
extensions.conf should start with 1, not n:</div>
<div class="gmail_extra"><br>
</div>
<div class="gmail_extra">
<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">;
Voicemail <br>
exten => _VMR_.,1,Ringing<br>
exten => _VMR_.,n,Wait(1)<br>
exten => _VMR_.,n,Answer<br>
exten => _VMR_.,n,Wait(1)<br>
exten => _VMR_.,n,Voicemail(${EXTEN:4}|u)<br>
exten => _VMR_.,n,Hangup </blockquote>
<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">;
Allow users to call their Voicemail directly<br>
exten => VM_pickup,1,Ringing<br>
exten => VM_pickup,n,wait(1)<br>
exten =>
VM_pickup,n,VoicemailMain(${CALLERIDNUM}|s)<br>
exten => VM_pickup,n,Hangup</blockquote>
</div>
<div class="gmail_extra"><br>
</div>
<div class="gmail_extra"><br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div>
</blockquote></div>