[Asterisk-Users] res_config_odbc not working

[Dennis Nacino]

Hi,

Can somebody tell me what I've been doing wrong for the res_config_odbc not to work properly. I
already looked on the mailing list for some answer but I can't find one. The closes subject I
found is "res_odbc not working". Btw, I already followed BKW reply on that subject. I guessed the
log below can tell us res_odbc.so is succefully loaded, so it easy to presumed it succesfully
connected to the database. The only problem I can see is the "SQL select error" it encountered
when it's loading sip.conf. But I have tried that sql statement on isql, PhpMyAdmin and it's
succesfully executed. So, why the res_config_odbc.so is returning such error?


[res_odbc.so] => (ODBC Resource)
Aug  7 16:38:43 DEBUG[16384]: config.c:779 __ast_load: Parsing /etc/asterisk/res_odbc.conf
Aug  7 16:38:43 NOTICE[16384]: res_odbc.c:131 load_odbc_config: registered database handle
'mysql1' dsn->[MySQL-asterisk]
Aug  7 16:38:43 NOTICE[16384]: res_odbc.c:375 load_module: res_odbc loaded.

 [res_config_odbc.so] => (ODBC Configuration)
Aug  7 16:38:43 NOTICE[16384]: config.c:880 ast_config_register: Registered Config Engine odbc
Aug  7 16:38:43 DEBUG[16384]: config.c:779 __ast_load: Parsing /etc/asterisk/extconfig.conf
Aug  7 16:38:43 NOTICE[16384]: config.c:1084 read_ast_cust_config: Binding: sip.conf to odbc
Aug  7 16:38:43 NOTICE[16384]: config.c:1084 read_ast_cust_config: Binding: localsip.conf to odbc
Aug  7 16:38:43 NOTICE[16384]: config.c:1084 read_ast_cust_config: Binding: buzzuser.conf to odbc
Aug  7 16:38:43 NOTICE[16384]: res_config_odbc.c:190 load_module: res_config_odbc loaded.

 
 [chan_sip.so]Aug  7 16:38:43 DEBUG[16384]: config.c:779 __ast_load: Parsing
/etc/asterisk/modules.conf
 => (Session Initiation Protocol (SIP))
Aug  7 16:38:43 NOTICE[16384]: config.c:756 __ast_load: Loading Config sip.conf via odbc engine
Aug  7 16:38:43 DEBUG[16384]: config.c:779 __ast_load: Parsing /etc/asterisk/res_config_odbc.conf
Aug  7 16:38:43 WARNING[16384]: res_config_odbc.c:103 config_odbc: SQL select error!
[select * from ast_config where filename='sip.conf' and commented=0 order by filename,cat_metric
desc,var_metric asc,id]

Aug  7 16:38:43 DEBUG[16384]: config.c:810 __ast_load: No file to parse: /etc/asterisk/sip.conf
Aug  7 16:38:43 NOTICE[16384]: chan_sip.c:8249 reload_config: Unable to load config sip.conf, SIP
disabled
Aug  7 16:38:43 DEBUG[16384]: channel.c:198 ast_channel_register_ex: Registered handler for 'SIP'
(Session Initiation Protocol (SIP))

Thanks
-Dennis



		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - Send 10MB messages!
http://promotions.yahoo.com/new_mail