<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<tt>Thank you Nabeel,<br>
<br>
The number you added in voicemail file - does it exist in the
sipuser/subscriber table ??<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 04.07.2016 11:38, Nabeel wrote:<br>
</div>
<blockquote
cite="mid:CA+vx6K+6sZTJn3vVUAMM-3d27_B3j_+xcqHt0x53+-q0581AUg@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true"
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
moz-do-not-send="true"
href="mailto:nabeelshikder@gmail.com"
target="_blank"><a class="moz-txt-link-abbreviated" href="mailto:nabeelshikder@gmail.com">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>
</blockquote>
<br>
</body>
</html>