its odbc not config_odbc
so
sip.conf => odbc
bkw
----- Original Message -----
From: "Manuel Wenger" <manuel.wenger@ticinocom.com>
To: <asterisk-users@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@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
>