[Asterisk-Users] Trouble with Realtime

[Nathan Bowyer]

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.
> >
> > Thanks,
> > Nathan

>