I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session Initiation Protocol (SIP)) == Registered application 'SIPDtmfMode' And my device(s) won't register. I don't even see them attempt the registration...(from the CLI in vvvvery verbose.) Maybe I'm not using the right version of asterisk??? Is that possible and how would I know? My "show version" gives me this: *CLI> show version Asterisk CVS-v1-0-12/08/04-16:50:05 built by root@myserver.com on a i686 running Linux *CLI> Any help would be appreciated. Thanks! Clay Reiche -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20041214/d7161f6f/attachment.htm
I'm having exactly the same problem. I have sip.conf rows in the sql table (ast_config), and removed the /etc/asterisk/sip.conf file. Now I have no sip devices. It's as though realtime is not looking for the sip.conf rows in the table. This is my extconfig.conf: [settings] ; Static configuration files: ; file.conf => driver,database[,table] sip.conf = > mysql,asteriskcdrdb,ast_config voicemail.conf => mysql,asteriskcdrdb,ast_config This is my res_mysql.conf: [general] dbhost = 127.0.0.1 dbname = asteriskcdrdb dbuser = asterisk dbpass = none dbport = 3306 dbsock = =/var/lib/mysql/mysql.sock These are the startup messages I get when I start * (not voicemail.conf is loaded via mysql but not sip.conf: Dec 14 15:31:01 NOTICE[8102]: res_odbc loaded. Dec 14 15:31:01 NOTICE[8102]: Registered Config Engine odbc Dec 14 15:31:01 NOTICE[8102]: Registered Config Engine mysql Dec 14 15:31:01 NOTICE[8102]: Unable to load config sip.conf, SIP disabled Dec 14 15:31:01 WARNING[8102]: Unable to open IAX timing interface: No such device Dec 14 15:31:01 ERROR[8102]: Unable to load config iax.conf Dec 14 15:31:01 WARNING[8102]: Unable to get our IP address, Skinny disabled Dec 14 15:31:01 WARNING[8102]: Unable to open /dev/dsp: No such device Dec 14 15:31:01 WARNING[8102]: Requested contexts didn't get merged Dec 14 15:31:01 NOTICE[8102]: Loading Config voicemail.conf via mysql engine Dec 14 15:31:01 WARNING[8102]: MySQL database sock file not specified. Using default Bruce Komito High Sierra Networks, Inc. www.servers-r-us.com (775) 236-5815 On Tue, 14 Dec 2004, Clay Reiche wrote:> I'm having trouble with the Realtime setup. I've followed the instructions on > voip-info using odbc but I get this message during asterisk boot: > > > > Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) > > Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load > config sip.conf, SIP disabled > > == Registered channel type 'SIP' (Session Initiation Protocol (SIP)) > > == Registered application 'SIPDtmfMode' > > > > And my device(s) won't register. I don't even see them attempt the > registration...(from the CLI in vvvvery verbose.) > > > > Maybe I'm not using the right version of asterisk??? Is that possible and how > would I know? My "show version" gives me this: > > > > *CLI> show version > > Asterisk CVS-v1-0-12/08/04-16:50:05 built by root@myserver.com on a i686 > running Linux > > *CLI> > > > > Any help would be appreciated. Thanks! > > > > Clay Reiche > > > > > > This message has been categorized as "Legitimate" by Bayesian Analyzer. > If you do not agree, please click on the link below to train the Analyzer. > http://nospam.wpti.net/bt/a.aspx?M=C:%5Csmtpmail%5CBayesTraining%5C2004-12-14%5C45f16737f297472c8726ed904c2e44c6&C=2 > > -- > ----------------------------------------------------------------------- > This message has been inspected by DynaComm i:mail > ----------------------------------------------------------------------- >
Clay,
Can you post your extconfig.conf and your database schema?
If you want to load your static sip configuration into a database, follow
these instructions:
http://www.voip-info.org/tiki-index.php?page=Asterisk%20RealTime%20Static
I haven't loaded a static file into the database using RealTime, but used
this
method and it works great:
http://www.voip-info.org/tiki-index.php?page=Asterisk%20RealTime%20Sip
I placed a timestamp column so I can track when the most recent successful
registration occurred.
--
-- Table structure for table `sip_buddies`
--
CREATE TABLE `sip_buddies` (
`uniqueid` int(11) NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`accountcode` varchar(30) default NULL,
`amaflags` char(1) default NULL,
`callgroup` varchar(30) default NULL,
`callerid` varchar(50) default NULL,
`canreinvite` char(1) default NULL,
`context` varchar(30) default NULL,
`defaultip` varchar(15) default NULL,
`dtmfmode` varchar(7) default NULL,
`fromuser` varchar(50) default NULL,
`fromdomain` varchar(31) default NULL,
`host` varchar(31) NOT NULL default '',
`incominglimit` char(2) default NULL,
`outgoinglimit` char(2) default NULL,
`insecure` char(1) default NULL,
`language` char(2) default NULL,
`mailbox` varchar(50) default NULL,
`md5secret` varchar(32) default NULL,
`nat` varchar(5) default NULL,
`permit` varchar(95) default NULL,
`deny` varchar(95) default NULL,
`pickupgroup` varchar(10) default NULL,
`port` varchar(5) NOT NULL default '',
`qualify` varchar(4) default NULL,
`restrictcid` char(1) default NULL,
`rtptimeout` char(3) default NULL,
`rtpholdtimeout` char(3) default NULL,
`secret` varchar(30) default NULL,
`type` varchar(6) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`allow` varchar(100) default NULL,
`disallow` varchar(100) default NULL,
`regseconds` int(11) NOT NULL default '0',;
`ipaddr` varchar(15) NOT NULL default '',
`ts` timestamp(14) NOT NULL,
PRIMARY KEY (`uniqueid`),
UNIQUE KEY `name` (`name`),
KEY `name_2` (`name`)
) TYPE=MyISAM;
-extconfig.conf-
=========
; Static and realtime external configuration
; engine configuration
;
; Please read doc/README.extconfig for basic table
; formatting information.
;
[settings]
;
; Static configuration files:
;
; file.conf => driver,database[,table]
;
; maps a particular configuration file to the given
; database driver, database and table (or uses the
; name of the file as the table if not specified)
;
;uncomment to load queues.conf via the odbc engine.
;
;sip.conf => odbc,asterisk,sip
;
; Realtime configuration engine
;
; maps a particular family of realtime
; configuration to a given database driver,
; database and table (or uses the name of
; the family if the table is not specified
;
;iaxfriends => odbc,asterisk
sipfriends => mysql,asterisk,sip_buddies
;voicemail => odbc,asterisk
-res_mysql.conf-
;
; Sample configuration for res_config_mysql.c
;
; The value of dbhost may be either a hostname or an IP address.
; If dbhost is commented out or the string "localhost", a connection
; to the local host is assumed and dbsock is used instead of TCP/IP
; to connect to the server.
;
[general]
;dbhost = 127.0.0.1
dbname = asterisk
dbuser = [removed]
dbpass = [removed]
dbport = 3306
dbsock = /var/run/mysqld/mysqld.sock
On Tuesday 14 December 2004 09:50 pm, Clay Reiche wrote:> I'm having trouble with the Realtime setup. I've followed the
instructions
> on voip-info using odbc but I get this message during asterisk boot:
>
>
>
> Parsing '/etc/asterisk/sip.conf': Not found (No such file or
directory)
>
> Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load
> config sip.conf, SIP disabled
>
> == Registered channel type 'SIP' (Session Initiation Protocol
(SIP))
>
> == Registered application 'SIPDtmfMode'
>
>
>
> And my device(s) won't register. I don't even see them attempt the
> registration...(from the CLI in vvvvery verbose.)
>
>
>
> Maybe I'm not using the right version of asterisk??? Is that possible
and
> how would I know? My "show version" gives me this:
>
>
>
> *CLI> show version
>
> Asterisk CVS-v1-0-12/08/04-16:50:05 built by root@myserver.com on a i686
> running Linux
>
> *CLI>
>
>
>
> Any help would be appreciated. Thanks!
>
>
>
> Clay Reiche
--
Brian Wilkins
Software Engineer
brian@hcc.net
Heritage Communications Corporation
Melbourne, FL USA 32935
321.308.4000 x33
http://www.hcc.net
Hi
This works fine in extensions.conf:
exten => _0X./100,1,Dial(SIP/${EXTEN}@sipout-a)
exten => _0X./200,1,Dial(SIP/${EXTEN}@sipout-a)
This will just use different SIP channels for different Caller ID's.
If I write the same to a realtime table, Asterisk always uses sipout-a, no
matter what Caller ID is used.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.digium.com/pipermail/asterisk-users/attachments/20060622/c8477c51/attachment.htm