[asterisk-bugs] [Asterisk 0015918]: SIP Realtime appears to be completely broken
Asterisk Bug Tracker
noreply at bugs.digium.com
Fri Sep 18 19:39:43 CDT 2009
The following issue has been CLOSED
======================================================================
https://issues.asterisk.org/view.php?id=15918
======================================================================
Reported By: viniciusfontes
Assigned To:
======================================================================
Project: Asterisk
Issue ID: 15918
Category: Addons/res_config_mysql
Reproducibility: always
Severity: major
Priority: normal
Status: closed
Asterisk Version: 1.6.2.0-rc2
JIRA:
Regression: No
SVN Branch (only for SVN checkouts, not tarball releases): N/A
SVN Revision (number only!):
Request Review:
Resolution: no change required
Fixed in Version:
======================================================================
Date Submitted: 2009-09-18 14:17 CDT
Last Modified: 2009-09-18 19:39 CDT
======================================================================
Summary: SIP Realtime appears to be completely broken
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 at 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.
======================================================================
----------------------------------------------------------------------
(0111029) tilghman (administrator) - 2009-09-18 19:39
https://issues.asterisk.org/view.php?id=15918#c111029
----------------------------------------------------------------------
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.
Issue History
Date Modified Username Field Change
======================================================================
2009-09-18 19:39 tilghman Note Added: 0111029
2009-09-18 19:39 tilghman Status new => closed
2009-09-18 19:39 tilghman Resolution open => no change
required
======================================================================
More information about the asterisk-bugs
mailing list