[Asterisk-Users] res_odbc not working

[Brian K. West]

its odbc not config_odbc

so

sip.conf => odbc

bkw
----- Original Message ----- 
From: "Manuel Wenger" <manuel.wenger at ticinocom.com>
To: <asterisk-users at lists.digium.com>
Sent: Wednesday, July 07, 2004 1:25 PM
Subject: [Asterisk-Users] res_odbc not working


> 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
>
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>