its odbc not config_odbc so
sip.conf => odbc bkw ----- Original Message ----- From: "Manuel Wenger" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ 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
