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 [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
