<div dir="ltr">On 13 May 2013 03:02, zhengyw <span dir="ltr"><<a href="mailto:zhengyw@neusoft.com" target="_blank">zhengyw@neusoft.com</a>></span> wrote:<br><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
hello daniel:<br>
thank you very much! but I can't find the problem in the asterisk.<br>
attachment is asterisk's configure file, kamailio's configure file and<br>
data.can you help with this problem?<br>
<br></blockquote><div><br></div><div><br></div><div style>Hi</div><div style><br></div><div style>Your video1_sipregs table does not seem correct. Your registered users should have ipaddr and port fields populated. I notice you are missing a few fields which could be a problem. </div>
<div style><br></div><div>mysql> select * from video1_sipregs;</div><div>+----+------+-------------------------+--------+------+----------+-----------+------------+</div><div>| id | name | fullcontact | ipaddr | port | username | regserver | regseconds |</div>
<div>+----+------+-------------------------+--------+------+----------+-----------+------------+</div><div>| 4 | 106 | <a href="http://sip:106@10.11.2.47:5060">sip:106@10.11.2.47:5060</a> | | 0 | 106 | | 1368169282 |</div>
<div>| 5 | 107 | <a href="http://sip:107@10.11.2.47:5060">sip:107@10.11.2.47:5060</a> | | 0 | 107 | | 1368176017 |</div><div>| 6 | 108 | | | 0 | | NULL | 0 |</div>
<div style>+----+------+-------------------------+--------+------+----------+-----------+------------+ </div><div style><br></div><div style><br></div><div style>The sipregs table should have this structure for Asterisk 10.7 as far as I know.</div>
<div style><br></div><div style><div>CREATE TABLE `sipregs` (</div><div> `id` INT(11) NOT NULL AUTO_INCREMENT,</div><div> `name` VARCHAR(80) NOT NULL DEFAULT '',</div><div> `fullcontact` VARCHAR(80) NOT NULL DEFAULT '',</div>
<div> `ipaddr` VARCHAR(45) DEFAULT NULL,</div><div> `port` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',</div><div> `username` VARCHAR(80) NOT NULL DEFAULT '',</div><div> `regserver` VARCHAR(100) DEFAULT NULL,</div>
<div> `regseconds` INT(11) NOT NULL DEFAULT '0',</div><div> `defaultuser` VARCHAR(80) NOT NULL DEFAULT '',</div><div> `useragent` VARCHAR(20) DEFAULT NULL,</div><div> `lastms` INT(11) DEFAULT NULL,</div>
<div> PRIMARY KEY (`id`),</div><div> UNIQUE KEY `name` (`name`)</div><div>);</div><div><br></div><div><br></div><div style>-Barry</div><div style><br></div></div><div style><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
ps:asterisk version 10.70, kamailio version 3.3.1, ubuntu version 12.04<br>
<br>
<br>
Best Regards,<br>
zhengyw kamailio.cfg<br>
<<a href="http://sip-router.1086192.n5.nabble.com/file/n118319/kamailio.cfg" target="_blank">http://sip-router.1086192.n5.nabble.com/file/n118319/kamailio.cfg</a>><br>
sip.conf <<a href="http://sip-router.1086192.n5.nabble.com/file/n118319/sip.conf" target="_blank">http://sip-router.1086192.n5.nabble.com/file/n118319/sip.conf</a>><br>
extconfig.conf<br>
<<a href="http://sip-router.1086192.n5.nabble.com/file/n118319/extconfig.conf" target="_blank">http://sip-router.1086192.n5.nabble.com/file/n118319/extconfig.conf</a>><br>
extensions.conf<br>
<<a href="http://sip-router.1086192.n5.nabble.com/file/n118319/extensions.conf" target="_blank">http://sip-router.1086192.n5.nabble.com/file/n118319/extensions.conf</a>><br>
db_result.txt<br>
<<a href="http://sip-router.1086192.n5.nabble.com/file/n118319/db_result.txt" target="_blank">http://sip-router.1086192.n5.nabble.com/file/n118319/db_result.txt</a>><br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://sip-router.1086192.n5.nabble.com/I-need-you-help-about-Kamailio-3-3-x-and-Asterisk-10-7-0-Realtime-Integration-tp118248p118319.html" target="_blank">http://sip-router.1086192.n5.nabble.com/I-need-you-help-about-Kamailio-3-3-x-and-Asterisk-10-7-0-Realtime-Integration-tp118248p118319.html</a><br>
Sent from the Users mailing list archive at Nabble.com.<br>
<div class=""><div class="h5"><br>
_______________________________________________<br>
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list<br>
<a href="mailto:sr-users@lists.sip-router.org">sr-users@lists.sip-router.org</a><br>
<a href="http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users" target="_blank">http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users</a><br>
</div></div></blockquote></div><br></div></div>