[Home]

Summary:ASTERISK-14849: SIP Realtime appears to be completely broken
Reporter:viniciusfontes (viniciusfontes)Labels:
Date Opened:2009-09-18 14:17:06Date Closed:2011-06-07 14:00:38
Priority:MajorRegression?No
Status:Closed/CompleteComponents:Addons/res_config_mysql
Versions:Frequency of
Occurrence
Related
Issues:
Environment:Attachments:
Description:SIP Realtime doesn't work at all. I get the following on CLI when I try to register a SIP extension:


[Sep 18 16:09:52] WARNING[2767]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: realtime
[Sep 18 16:09:52] WARNING[2767]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: realtime
[Sep 18 16:09:52] WARNING[2767]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: realtime
[Sep 18 16:09:52] NOTICE[2767]: chan_sip.c:21006 handle_request_register: Registration from '<sip:1001@192.168.0.151;transport=UDP>' failed for '192.168.0.69' - No matching peer found


Here's my extconfig.conf:

[settings]
sipusers => mysql,realtime,sip
sippeers => mysql,realtime,sip
sipregs => mysql,realtime,sip

And my res_mysql.conf:

[general]
dbhost = 192.168.0.151
dbname = realtime
dbuser = root
dbpass = canall321
dbport = 3306
dbsock = /tmp/mysql.sock
;requirements=warn ; or createclose or createchar
requirements=createclose


And a dump of the database used:

-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb5+lenny1
-- http://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tempo de Geração: Set 18, 2009 as 04:15 PM
-- Versão do Servidor: 5.0.51
-- Versão do PHP: 5.2.6-1+lenny3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Banco de Dados: `realtime`
--
CREATE DATABASE `realtime` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `realtime`;

-- --------------------------------------------------------

--
-- Estrutura da tabela `sip`
--

CREATE TABLE IF NOT EXISTS `sip` (
 `id` int(11) NOT NULL auto_increment,
 `name` varchar(80) NOT NULL default '',
 `host` varchar(31) NOT NULL default 'dynamic',
 `nat` varchar(5) NOT NULL default 'no',
 `type` enum('user','peer','friend') NOT NULL default 'friend',
 `accountcode` varchar(20) default NULL,
 `amaflags` varchar(13) default NULL,
 `call-limit` smallint(5) unsigned default NULL,
 `callgroup` varchar(10) default NULL,
 `callerid` varchar(80) default NULL,
 `cancallforward` char(3) default 'yes',
 `canreinvite` char(3) default 'no',
 `context` varchar(80) default 'interno',
 `defaultip` varchar(15) default NULL,
 `dtmfmode` varchar(7) default NULL,
 `fromuser` varchar(80) default NULL,
 `fromdomain` varchar(80) default NULL,
 `insecure` varchar(4) default NULL,
 `language` char(2) default NULL,
 `mailbox` varchar(50) default NULL,
 `md5secret` varchar(80) default NULL,
 `deny` varchar(95) default NULL,
 `permit` varchar(95) default NULL,
 `mask` varchar(95) default NULL,
 `musiconhold` varchar(100) default NULL,
 `pickupgroup` varchar(10) default NULL,
 `qualify` char(3) default 'yes',
 `regexten` varchar(80) default NULL,
 `restrictcid` char(3) default NULL,
 `rtptimeout` char(3) default NULL,
 `rtpholdtimeout` char(3) default NULL,
 `secret` varchar(80) default 'asterisk',
 `setvar` varchar(100) default NULL,
 `disallow` varchar(100) default 'all',
 `allow` varchar(100) default 'alaw',
 `fullcontact` varchar(80) NOT NULL default '',
 `ipaddr` varchar(15) NOT NULL default '',
 `port` smallint(5) unsigned NOT NULL default '0',
 `regserver` varchar(100) default NULL,
 `regseconds` int(11) NOT NULL default '0',
 `lastms` int(11) NOT NULL default '0',
 `username` varchar(80) NOT NULL default '',
 `defaultuser` varchar(80) NOT NULL default '',
 `subscribecontext` varchar(80) default NULL,
 PRIMARY KEY  (`id`),
 UNIQUE KEY `name` (`name`),
 KEY `name_2` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=7 ;

--
-- Extraindo dados da tabela `sip`
--

INSERT INTO `sip` (`id`, `name`, `host`, `nat`, `type`, `accountcode`, `amaflags`, `call-limit`, `callgroup`, `callerid`, `cancallforward`, `canreinvite`, `context`, `defaultip`, `dtmfmode`, `fromuser`, `fromdomain`, `insecure`, `language`, `mailbox`, `md5secret`, `deny`, `permit`, `mask`, `musiconhold`, `pickupgroup`, `qualify`, `regexten`, `restrictcid`, `rtptimeout`, `rtpholdtimeout`, `secret`, `setvar`, `disallow`, `allow`, `fullcontact`, `ipaddr`, `port`, `regserver`, `regseconds`, `lastms`, `username`, `defaultuser`, `subscribecontext`) VALUES
(1, '1001', 'dynamic', 'no', 'friend', 'lupa01', NULL, 10, NULL, NULL, 'yes', 'no', 'interno', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, 'asterisk', NULL, 'all', 'alaw', '', '0.0.0.0', 0, '', 1253220319, -1, '1001', '', NULL),
(2, '1002', 'dynamic', 'no', 'friend', 'lupa01', NULL, NULL, NULL, '', 'yes', 'no', 'interno', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, 'asterisk', NULL, 'all', 'alaw', '', '', 0, NULL, 0, 0, '', '', NULL),
(3, '2001', 'dynamic', 'no', 'friend', NULL, NULL, NULL, NULL, NULL, 'yes', 'no', 'interno', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, 'asterisk', NULL, 'all', 'alaw', '', '0.0.0.0', 0, NULL, 1253217556, 0, '2001', '', NULL),
(4, '2002', 'dynamic', 'no', 'friend', NULL, NULL, NULL, NULL, NULL, 'yes', 'no', 'interno', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, 'asterisk', NULL, 'all', 'alaw', '', '', 0, NULL, 0, 0, '', '', NULL),
(5, '3001', 'dynamic', 'no', 'friend', NULL, NULL, NULL, NULL, NULL, 'yes', 'no', 'interno', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, 'asterisk', NULL, 'all', 'alaw', '', '0.0.0.0', 0, NULL, 1253206687, 0, '3001', '', NULL),
(6, '3002', 'dynamic', 'no', 'friend', NULL, NULL, NULL, NULL, NULL, 'yes', 'no', 'interno', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'yes', NULL, NULL, NULL, NULL, 'asterisk', NULL, 'all', 'alaw', '', '', 0, NULL, 0, 0, '', '', NULL);


This very database (and configuration, with few tweaks) used to work on 1.6.0.15 flawlessly.
Comments:By: Tilghman Lesher (tilghman) 2009-09-18 19:39:43

The problem is that you've specified in your res_mysql.conf that the database name is "general", but you're asking for "realtime" in extconfig.conf.  Hence the problem.  Please read UPGRADE.txt.
By: Tilghman Lesher (tilghman) 2009-09-18 19:55:51

Also previously answered on the mailing lists:

http://lists.digium.com/pipermail/asterisk-users/2009-May/232581.html
By: Mr Diep (diep9k39) 2012-05-22 08:56:18.442-0500

Me too,Please help me!