On 13 May 2013 03:02, zhengyw <zhengyw@neusoft.com> wrote:

hello daniel:
thank you very much! but I can't find the problem in the asterisk.
attachment is asterisk's configure file, kamailio's configure file and
data.can you help with this problem?

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.

mysql> select * from video1_sipregs;

+----+------+-------------------------+--------+------+----------+-----------+------------+

+----+------+-------------------------+--------+------+----------+-----------+------------+

| 4 | 106 | sip:106@10.11.2.47:5060 | | 0 | 106 | | 1368169282 |

| 5 | 107 | sip:107@10.11.2.47:5060 | | 0 | 107 | | 1368176017 |

| 6 | 108 | | | 0 | | NULL | 0 |

+----+------+-------------------------+--------+------+----------+-----------+------------+

The sipregs table should have this structure for Asterisk 10.7 as far as I know.

CREATE TABLE `sipregs` (

`id` INT(11) NOT NULL AUTO_INCREMENT,

`name` VARCHAR(80) NOT NULL DEFAULT '',

`fullcontact` VARCHAR(80) NOT NULL DEFAULT '',

`ipaddr` VARCHAR(45) DEFAULT NULL,

`port` mediumint(5) UNSIGNED NOT NULL DEFAULT '0',

`username` VARCHAR(80) NOT NULL DEFAULT '',

`regserver` VARCHAR(100) DEFAULT NULL,

`regseconds` INT(11) NOT NULL DEFAULT '0',

`defaultuser` VARCHAR(80) NOT NULL DEFAULT '',

`useragent` VARCHAR(20) DEFAULT NULL,

`lastms` INT(11) DEFAULT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

);

-Barry

ps:asterisk version 10.70, kamailio version 3.3.1, ubuntu version 12.04

Best Regards,
zhengyw kamailio.cfg
<http://sip-router.1086192.n5.nabble.com/file/n118319/kamailio.cfg>
sip.conf <http://sip-router.1086192.n5.nabble.com/file/n118319/sip.conf>
extconfig.conf
<http://sip-router.1086192.n5.nabble.com/file/n118319/extconfig.conf>
extensions.conf
<http://sip-router.1086192.n5.nabble.com/file/n118319/extensions.conf>
db_result.txt
<http://sip-router.1086192.n5.nabble.com/file/n118319/db_result.txt>

--
View this message in context: 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
Sent from the Users mailing list archive at Nabble.com.

_______________________________________________
SIP Express Router (SER) and Kamailio (OpenSER) - sr-users mailing list
sr-users@lists.sip-router.org
http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users