[Asterisk-Users] Trouble with Realtime

[Nathan Bowyer]

On Fri, 11 Mar 2005 16:38:38 -0600, Nathan Bowyer <nbowyer at gmail.com> wrote:
> On Fri, 11 Mar 2005 15:04:03 -0600, Matthew Boehm <mboehm at cytelcom.com> wrote:
> > You can't have this:
> >
> > [from-sip]
> > switch => Realtime/from-sip at extensions
> >
> > The context in your extensions.conf must be different from your Realtime
> > context.
> 
> Okay, I'll try it, but that doesn't explain why voicemail doesn't
> work.  The extension to access the voicemail is static in
> extensions.conf.
> 
> >
> > -Matthew
> >
> > Nathan Bowyer wrote:
> > > Greetings,
> > >
> > > I'm having some trouble with the realtime engines.  When asterisk
> > > loads, everything looks fine, there don't seem to be any problems via
> > > notices or anything.  Furthermore, cdr_odbc is working, and actively
> > > logging my failed call attempts to db through ODBC using the same DSN.
> > >  unixODBC and the mysql drivers are installed from source.
> > >
> > > Here are the relevant parts of the config:
> > >
> > > Extconfig.conf (Under the [settings] section)
> > >
> > > sipusers => odbc,voip,sip_users
> > > sippeers => odbc,voip,sip_users
> > > voicemail => odbc,voip,voicemail_users
> > > extensions => odbc,voip,extensions_table
> > >
> > > res_odbc.conf
> > >
> > > [asterisk]
> > > dsn => MySQL-asterisk
> > > username => voip
> > > password => temp123
> > > pre-connect => yes
> > >
> > >
> > > Under extensions.conf, in the [from-sip] context:
> > > switch => Realtime/from-sip at extensions.
> > >
> > > Running isql MySQL-asterisk voip <pass> connects to the DB, and
> > > queries return the proper data.
> > >
> > > I have the following tables in the mysql databases:
> > >
> > > +------------------+
> > >> Tables_in_voip   |
> > > +------------------+
> > >> cdr              |
> > >> extensions_table |
> > >> sip_users        |
> > >> voicemail_users  |
> > > +------------------+
> > >
> > > In voicemail_users I have an entry for 100101, and in extensions_table
> > > I have an extension 520, priority 1 to playback tt-monkeys.  Asterisk
> > > fails to acknowlege the existence of either.  sip_users is blank, and
> > > cdr holds the (working) CDR information.
> > >
> > >
> > > In /usr/local/etc/odbc.ini I have:
> > > [MySQL-asterisk]]
> > > Description     = MySQL ODBC Driver Testing
> > > Driver          = MySQL
> > > #Socket          = /var/run/mysqld/mysqld.sock
> > > Server          = 10.10.15.30
> > > User            = voip
> > > Password        = temp123
> > > Database        = voip
> > > Option          = 3
> > > #Port           =
> > >
> > >
> > > and odbcinst.ini:
> > > [MySQL]
> > > Description             = MySQL ODBC MyODBC Driver
> > > Driver          = /usr/lib/libmyodbc3.so
> > > FileUsage               = 1
> > > UsageCount              = 2
> > >
> > > If I've missed some relevant part of the configuration, let me know,
> > > but I think I got all of it.  I'm pretty mistified at the moment,
> > > after a few hours of working on it.
> > >

Oh yes.  I also tried a "realtime update mailbox 100101 password 1357
from the * CLI, but it errored out.  It suggested to check the debug
log, but the debug log shows absolutely nothing about Realtime.  I've
loaded and unloaded app_realtime.so, to no effect.