[asterisk-users] realtime+mysql

Shaun mailinglists at unix-scripts.com
Tue Aug 8 23:59:37 MST 2006


I'm attempting to setup asterisk running real-time with mysql.  Right now I 
can get asterisk to start and run but a show dialplan shows basically 
nothing other than parking extensions.  I'm watching the full log also for 
debug messages and I can see that asterisk is connecting to mysql with out a 
issue but for some reason it does not seam to read the extensions table. 
Below is a few of my configs..

#My slimmed down modules.conf
[root at localhost asterisk]# cat /etc/asterisk/modules.conf
[modules]
autoload=no
load => res_config_mysql.so
load => res_crypto.so
load => res_features.so
load => chan_features.so
load => chan_iax2.so
load => pbx_realtime.so
load => app_realtime.so

#My extconfig.conf
[root at localhost asterisk]# cat /etc/asterisk/extconfig.conf
[settings]
extensions => mysql,asterisk,extensions

#mysqldump of my asterisk database

DROP TABLE IF EXISTS `extensions`;
CREATE TABLE `extensions` (
  `context` varchar(20) NOT NULL default 'default',
  `extension` varchar(20) NOT NULL default '',
  `priority` int(2) NOT NULL default '1',
  `application` varchar(20) NOT NULL default '',
  `args` varchar(50) default NULL,
  `descr` text,
  `flags` int(1) NOT NULL default '0',
  PRIMARY KEY  (`context`,`extension`,`priority`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `extensions`
--

INSERT INTO `extensions` VALUES 
('sortcalls','1949265<snip>',1,'Wait','10','Wait(10)',0)
INSERT INTO `extensions` VALUES 
('sortcalls','_1949265<snip>',1,'Wait','10','Wait(10)',0);


My iax.conf is setup to forward calls to sortcalls context... this is what i 
get when a call comes in..
Aug  8 22:47:58 NOTICE[10074]: chan_iax2.c:7303 socket_read: Rejected 
connect attempt from 64.61.93.87, request '1949265<snip>@sortcalls' does not 
exist
Aug  8 22:47:58 NOTICE[10074]: chan_iax2.c:7303 socket_read: Rejected 
connect attempt from 64.61.93.90, request '1949265<snip>@sortcalls' does not 
exist



Anybody know whats going wrong here?

-- 

~Shaun 






More information about the asterisk-users mailing list