[Asterisk-Users] Realtime / sip.conf

[Brian S. Adelson]

Sorry, thought I mentioned that.

In the debug, I do not see it attemping to query the mysql database.
It only makes this attempt when i try to pull information via the
console:


*CLI> realtime load sipfriends name 155
                   Column Name  Column Value                  
          --------------------  --------------------          
                      uniqueid  1                             
                          name  155                           
                      callerid  X-Line Phone                  
                   canreinvite  N                             
                       context  from-internal                 
                      dtmfmode  rfc2833                       
                          host  dynamic                       
                       mailbox  155                           
                           nat  no                            
                          port  5060                          
                        secret  155                           
                          type  friend                        
                      username  155                           
                    regseconds  0         


Jan 14 23:10:57 DEBUG[11834]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_extensions WHERE name = '155'
Jan 14 23:10:57 DEBUG[11834]: MySQL RealTime: Everything is fine.



On Fri, 14 Jan 2005 at 10:12 Matthew Boehm (mboehm at cytelcom.com) wrote:

> What's in your debug?
> 
> -Matthew
> ----- Original Message ----- 
> From: "Brian S. Adelson" <brian at voicenet.com>
> To: "Asterisk Users Mailing List - Non-Commercial Discussion"
> <asterisk-users at lists.digium.com>
> Sent: Friday, January 14, 2005 9:47 AM
> Subject: [Asterisk-Users] Realtime / sip.conf
> 
> 
> >
> > I am currently in the process of testing out realtime support for
> > sip.conf.  I have followed all of the directions that are listed in
> > the Wiki, but for some reason this does not work.
> >
> > When utilizing a flat file, I am able to register endpoints without
> > any problems, and calls can proceed.  One interesting side effect that
> > I have noticed is that when I am using realtime for sip, I am unable
> > to see any debug messages on the console (sip debug). By just
> > commenting out the sipfriends line in extconfig.conf the problem goes
> > away.
> >
> > I do have the system utilizing realtime for Voicemail and Extensions,
> > and I do not have any problems.  Has anyone seen this problem before?
> >
> > extconfig.conf
> > =-==-=-=-=-=-=
> >
> > [settings]
> >
> > realtime_ext => mysql,asterisk,extensions_table
> > voicemail => mysql,asterisk,voicemail_table
> > sipfriends => mysql,asterisk,sip_extensions
> >
> >
> > *CLI> realtime mysql status
> > Connected to asterisk at 127.0.0.1, port 3306 with username asterisk for 10
> minutes, 22 seconds.
> >
> >
> > -Brian
> >
> >
> > _______________________________________________
> > 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