You can't have this: [from-sip] switch => Realtime/[EMAIL PROTECTED]
The context in your extensions.conf must be different from your Realtime context. -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. > > Thanks, > Nathan > _______________________________________________ > Asterisk-Users mailing list > [email protected] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users _______________________________________________ Asterisk-Users mailing list [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
