[asterisk-users] realtime+mysql

[Sharon Lim]

If i am not mistaken, you need to have another IAX user tables to store all
the iax users. HEre is some example
http://www.voip-info.org/wiki/view/Asterisk+RealTime+IAX
good luck!

On 8/9/06, Shaun <mailinglists at unix-scripts.com> wrote:
>
> 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
>
>
>
> _______________________________________________
> --Bandwidth and Colocation provided by Easynews.com --
>
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20060809/dd57dd25/attachment.htm