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
