hello
i m using asterisk-1.0.9. i want to connect to db
through odbc. isql is working. but asterisk is not
getting user information from this table. can any one
pls check this
odbc connection is working properly is there some
thing required
/etc/asterisk/extconfig.conf
[settings]
sipusers => odbc,mysql1,sip_buddies
sippeers => odbc,mysql1,sip_buddies
sip.conf => odbc,mysql1,sip_buddies
sipfriends => odbc,mysql1,sip_buddies
/etc/asterisk/res_config_odbc.conf
[settings]
;table => ast_config
connection => mysql1
/etc/asterisk/res_odbc.conf
[mysql1]
dsn => dsn
username => username
password => pass
pre-connect => yes
Messages from asterisk when it asterisk is loaded
[res_odbc.so] => (ODBC Resource)
== Parsing '/etc/asterisk/res_odbc.conf': Found
Aug 23 11:35:58 NOTICE[17603]: res_odbc.c:133
load_odbc_config: registered database handle 'mysql1'
dsn->[dsn]
Aug 23 11:35:58 NOTICE[17603]: res_odbc.c:385
odbc_obj_connect: res_odbc: Connected to mysql1 [dsn]
Aug 23 11:35:58 NOTICE[17603]: res_odbc.c:415
load_module: res_odbc loaded.
[res_config_odbc.so] => (ODBC Configuration)
Aug 23 11:35:58 NOTICE[17603]: config.c:888
ast_config_register: Registered Config Engine odbc
== Parsing '/etc/asterisk/extconfig.conf': Found
Aug 23 11:35:58 NOTICE[17603]: res_config_odbc.c:190
load_module: res_config_odbc loaded.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
