Hi Nick, <div><br></div><div>This setup seems to be wrong. If you are not going to register on Asterisk, it does not make sense to use host=dynamic. Use host=opensips_ip or opensips_domain. </div><div><br></div><div>Please check the tutorial <a href="http://www.opensips.org/Resources/DocsTutAsterisk">http://www.opensips.org/Resources/DocsTutAsterisk</a>. Create the view exactly in the way presented. </div>
<div><br></div><div>I'm not sure exactly what you want to to, but during registration, Asterisk write to some columns in the database dynamically. That's why you see the fullcontact column. </div><div><br></div><div>
These are the columns written during registration:</div><div><span class="" style="color:rgb(51,51,51);font-family:Arial,Helvetica,FreeSans,sans-serif;font-size:13px;line-height:17px;border-collapse:separate"><pre style="padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px;text-align:left;font-family:'Courier New',Courier,monospace;line-height:1.3">
`regseconds` int(11) DEFAULT NULL,
`fullcontact` varchar(35) DEFAULT NULL,
`regserver` varchar(20) DEFAULT NULL,
`useragent` varchar(20) DEFAULT NULL,
`lastms` int(11) DEFAULT NULL,</pre></span></div><div><br></div><div>Please, check: </div><div><br></div><div><a href="https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime%2C+MySQL+table+structure">https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime%2C+MySQL+table+structure</a><br>
</div><div><br></div><div>There is a setting on Asterisk in the file res_config_mysql.conf</div><div><span class="" style="border-collapse:separate;color:rgb(0,0,0);font-family:sans-serif;font-size:medium"><pre class="" style="background-color:rgb(204,204,204);font-size:smaller">
requirements=warn ; or createclose or createchar</pre><pre class="" style="background-color:rgb(204,204,204);font-size:smaller">Use requirements=createclose and Asterisk will create the columns automagically for you. </pre>
</span></div><div>Flavio E. Goncalves</div><div><a href="http://www.sippulse.com">www.sippulse.com</a></div><div><br></div><div><br></div><div><br></div><div class="gmail_extra"><br clear="all"><div><div>Flavio E. Goncalves</div>
<div>CEO - V.Office</div><div> </div></div>
<br><br><div class="gmail_quote">2013/1/5 Nick Khamis <span dir="ltr"><<a href="mailto:symack@gmail.com" target="_blank">symack@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hello Everyone,<br>
<br>
Using asterisk friends that are static (i.e., using host=ip address<br>
vs. host=dynamic) everything works fine. However, when setting the UA<br>
as dynamic in Asterisk, the lack of proper registration leads to:<br>
<br>
Name/username Host Dyn<br>
Forcerport ACL Port Status Realtime<br>
1001/<a href="mailto:1001@toronto.example.com">1001@toronto.example.com</a> (Unspecified) D N 0<br>
UNREACHABLE Cached RT<br>
<br>
All my REGISTER and AUTH is handled on the OpenSIPS side, and this is<br>
working fine. Is there any way to bind "contact" from the "location<br>
table", to "fullcontact" in sip_buddies table?<br>
In my rigorous changing escapades, I did see occasions where<br>
"fullcontact" was filled in by Asterisk correctly, I just can't for<br>
the life of me get it to do it again!!!!<br>
<br>
I just wanted to mention that OpenSIPS is setup as a peer in Asterisk<br>
<br>
OpenSIPS/<a href="http://toronto.example.com" target="_blank">toronto.example.com</a> 192.168.2.5 5060 UNKNOWN Cached RT<br>
<br>
I did see how in the past the REGISTER request was passed over to *<br>
however, I do not think that example applies to me?<br>
<br>
Thanks in Advance,<br>
<br>
Nick.<br>
<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.opensips.org">Users@lists.opensips.org</a><br>
<a href="http://lists.opensips.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.opensips.org/cgi-bin/mailman/listinfo/users</a><br>
</blockquote></div><br></div>