On Fri, 11 Mar 2005 16:38:38 -0600, Nathan Bowyer <[EMAIL PROTECTED]> wrote: > On Fri, 11 Mar 2005 15:04:03 -0600, Matthew Boehm <[EMAIL PROTECTED]> wrote: > > You can't have this: > > > > [from-sip] > > switch => Realtime/[EMAIL PROTECTED] > > > > 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/[EMAIL PROTECTED] > > > > > > 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. _______________________________________________ Asterisk-Users mailing list Asterisk-Users@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