[Asterisk-Users] Realtime problem

[Matthew Boehm]

I see that you are connecting to mysql locally. Take a look at this error:

> Dec 14 15:31:01 WARNING[8102]: MySQL database sock file not specified.
Using default

And then take a look at your res_mysql.conf. I see the error, do you?

-Matthew

----- Original Message ----- 
From: "Bruce Komito" <brucek at bagel.com>
To: "Clay Reiche" <creiche at accxx.com>
Cc: <asterisk-users at lists.digium.com>
Sent: Tuesday, December 14, 2004 5:21 PM
Subject: Re: [Asterisk-Users] Realtime problem


> 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 at 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
> > -----------------------------------------------------------------------
> >
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users