[Asterisk-Users] res_odbc not working

[Manuel Wenger]

I have been playing with res_odbc in these last days, but it doesn't want to work.

This is the output when starting Asterisk, so everything seems OK:

 [res_odbc.so] => (ODBC Resource)
  == Parsing '/etc/asterisk/res_odbc.conf': Found
Jul  7 20:11:32 NOTICE[-1084915040]: res_odbc.c:132 load_odbc_config: registered database handle 'mysql' dsn->[MySQL-asterisk]
Jul  7 20:11:32 NOTICE[-1084915040]: res_odbc.c:369 odbc_obj_connect: res_odbc: Connected to mysql [MySQL-asterisk]
Jul  7 20:11:32 NOTICE[-1084915040]: res_odbc.c:402 load_module: res_odbc loaded.
 [res_config_odbc.so] => (Odbc Configuration)
Jul  7 20:11:32 NOTICE[-1084915040]: config.c:880 ast_config_register: Registered Config Engine odbc
  == Parsing '/etc/asterisk/extconfig.conf': Found
Jul  7 20:11:32 NOTICE[-1084915040]: res_config_odbc.c:233 load_module: res_config_odbc loaded.


These are the pertintent config files:

; extconfig.conf
[settings]
queues.conf = config_odbc
sip.conf = config_odbc

; res_odbc.conf
[mysql]
dsn=MySQL-asterisk
username=***
password=***
pre-connect=yes

;
[settings]
table = ast_config
connection = mysql


And that's what I have in my ast_config table:
+----+------------+------------+-----------+-------------+-----------+-------------+-----------------------------------------------------+
| id | cat_metric | var_metric | commented | filename    | category  | var_name    | var_val                        |
+----+------------+------------+-----------+-------------+-----------+-------------+-----------------------------------------------------+
| 27 |          0 |          0 |         0 | queues.conf | test      | Member      | Agent/1000,1234,1     
|  1 |          0 |          0 |         0 | sip.conf    | general   | port        | 5060                
|  2 |          0 |          0 |         0 | sip.conf    | general   | bindaddr    | 0.0.0.0          
|  3 |          0 |          0 |         0 | sip.conf    | general   | context     | default       
|  6 |          0 |          0 |         0 | sip.conf    | general   | disallow    | all                  
|  7 |          0 |          0 |         0 | sip.conf    | general   | allow       | ulaw         
|  8 |          0 |          0 |         0 | sip.conf    | general   | allow       | alaw          
|  9 |          0 |          0 |         0 | sip.conf    | general   | allow       | g729              
| 19 |          0 |          0 |         0 | sip.conf    | 20190     | type        | friend          
| 20 |          0 |          0 |         0 | sip.conf    | 20190     | username    | 20190            
| 21 |          0 |          0 |         0 | sip.conf    | 20190     | secret      | secret        
| 22 |          0 |          0 |         0 | sip.conf    | 20190     | host        | dynamic         
| 23 |          0 |          0 |         0 | sip.conf    | 20190     | context     | auth-out        
| 24 |          0 |          0 |         0 | sip.conf    | 20190     | canreinvite | no           
| 25 |          0 |          0 |         0 | sip.conf    | 20190     | callerid    | 1234567      
| 26 |          0 |          0 |         0 | sip.conf    | 20190     | accountcode | 20190         


The problem is that all of this is ignored. Show queues is empty, and no peers are added, I don't see anything in sip show peers. What did I forget? :-) I don't think it's an ODBC problem, because I use the same datasource for CDR logging.

Thanks
-Manuel


___________________________________________________
Ticinocom SA - Via Stazione 5 - 6600 Muralto
Tel 0844 007070 - Fax 0844 007071
http://www.ticinocom.com