[SR-Users] I need you help-----about Kamailio 3.3.x and Asterisk 10.7.0 Realtime Integration

[Barry Flanagan]

On 13 May 2013 03:02, zhengyw <zhengyw at 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?
>
>

Hi

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;
+----+------+-------------------------+--------+------+----------+-----------+------------+
| id | name | fullcontact             | ipaddr | port | username |
regserver | regseconds |
+----+------+-------------------------+--------+------+----------+-----------+------------+
|  4 | 106  | sip:106 at 10.11.2.47:5060 |        |    0 | 106      |
  | 1368169282 |
|  5 | 107  | sip:107 at 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 at lists.sip-router.org
> http://lists.sip-router.org/cgi-bin/mailman/listinfo/sr-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20130513/8c663025/attachment.html>