Hello, I'm having some issues with res_config. I've used BKW's perl program to take a working sip.config and place it into the database. Asterisk doesn't load in the sip table from the database. What am I doing wrong? Here are CLI lines: == Parsing '/etc/asterisk/res_odbc.conf': Found Nov 5 11:53:56 NOTICE[12572]: res_odbc.c:133 load_odbc_config: registered database handle 'mysql1' dsn->[MYSQL-asterisk] Nov 5 11:53:56 NOTICE[12572]: res_odbc.c:345 odbc_obj_connect: Calling 0x8110d68/0x8110d78 Nov 5 11:53:56 NOTICE[12572]: res_odbc.c:359 odbc_obj_connect: res_odbc: Connected to mysql1 [MYSQL-asterisk] Nov 5 11:53:56 NOTICE[12572]: res_odbc.c:385 load_module: res_odbc loaded. [res_config_odbc.so] => (ODBC Configuration) Nov 5 11:53:56 NOTICE[12572]: config.c:556 ast_config_register: Registered Config Engine odbc == Parsing '/etc/asterisk/extconfig.conf': Found == Binding sip.conf to odbc/asterisk/ast_config res_config_odbc loaded. [chan_sip.so] => (Session Initiation Protocol (SIP)) Nov 5 11:53:56 NOTICE[12572]: config.c:492 __ast_load: Loading Config sip.conf via odbc engine == Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Nov 5 11:53:56 NOTICE[12572]: chan_sip.c:8477 reload_config: Unable to load config sip.conf, SIP disabled odbc.conf: [global] dsn=MySQL-asterisk username=<username> password=<password> where username and password are replaced with functional username and password with access to the database/table res_config_odbc.conf: [settings] table => ast_config connection => mysql1 res_odbc.conf: ;;; odbc setup file [mysql1] dsn => MYSQL-asterisk username => <username> password => <password> pre-connect => yes databse table: mysql> select * from ast_config; +----+------------+------------+-----------+----------------+--------------+------------------+--------------------------------------------------------------------------+ | id | cat_metric | var_metric | commented | filename | category | var_name | var_val | +----+------------+------------+-----------+----------------+--------------+------------------+--------------------------------------------------------------------------+ | 1 | 0 | 0 | 0 | sip.conf | general | context | default | | 2 | 0 | 1 | 0 | sip.conf | general | port | 5060 | | 3 | 0 | 2 | 0 | sip.conf | general | bindaddr | 0.0.0.0 | | 4 | 0 | 3 | 0 | sip.conf | general | srvlookup | no | | 5 | 1 | 0 | 0 | sip.conf | 2000 | type | friend | | 6 | 1 | 1 | 0 | sip.conf | 2000 | secret | 2000 | | 7 | 1 | 2 | 0 | sip.conf | 2000 | auth | md5 | | 8 | 1 | 3 | 0 | sip.conf | 2000 | disallow | all | | 9 | 1 | 4 | 0 | sip.conf | 2000 | allow | ilbc | | 10 | 1 | 5 | 0 | sip.conf | 2000 | allow | ulaw | | 11 | 1 | 6 | 0 | sip.conf | 2000 | canreinvite | no | | 12 | 1 | 7 | 0 | sip.conf | 2000 | nat | yes | | 13 | 1 | 8 | 0 | sip.conf | 2000 | mailbox | 2000@test | | 14 | 1 | 9 | 0 | sip.conf | 2000 | callerid | "Test Config" <2000> | | 15 | 1 | 10 | 0 | sip.conf | 2000 | host | dynamic | | 16 | 1 | 11 | 0 | sip.conf | 2000 | qualify | 200 | | 17 | 1 | 12 | 0 | sip.conf | 2000 | context | inbound-sip | | 18 | 0 | 0 | 0 | voicemail.conf | general | format | wav49|gsm|wav | | 19 | 0 | 1 | 0 | voicemail.conf | general | serveremail | asterisk | | 20 | 0 | 2 | 0 | voicemail.conf | general | attach | yes | | 21 | 0 | 3 | 0 | voicemail.conf | general | skipms | 3000 | | 22 | 0 | 4 | 0 | voicemail.conf | general | maxsilence | 10 | | 23 | 0 | 5 | 0 | voicemail.conf | general | silencethreshold | 128 | | 24 | 0 | 6 | 0 | voicemail.conf | general | maxlogins | 3 | | 25 | 0 | 7 | 0 | voicemail.conf | general | sendvoicemail | yes | | 26 | 1 | 0 | 0 | voicemail.conf | zonemessages | eastern | America/New_York|'vm-received' Q 'digits/at' IMp | | 27 | 1 | 1 | 0 | voicemail.conf | zonemessages | central | America/Chicago|'vm-received' Q 'digits/at' IMp | | 28 | 1 | 2 | 0 | voicemail.conf | zonemessages | central24 | America/Chicago|'vm-received' q 'digits/at' H 'digits/hundred' M 'hours' | | 29 | 3 | 0 | 0 | voicemail.conf | test | 2000 | 2000,Test Config,chris@netgeeks.net | +----+------------+------------+-----------+----------------+--------------+------------------+--------------------------------------------------------------------------+ 29 rows in set (0.00 sec)
Chris A. Icide wrote:> Hello, > > I'm having some issues with res_config. I've used BKW's perl program to > take a working sip.config and place it into the database. Asterisk > doesn't load in the sip table from the database. What am I doing wrong? > > > Here are CLI lines: > > == Parsing '/etc/asterisk/res_odbc.conf': Found > Nov 5 11:53:56 NOTICE[12572]: res_odbc.c:133 load_odbc_config: > registered database handle 'mysql1' dsn->[MYSQL-asterisk] > Nov 5 11:53:56 NOTICE[12572]: res_odbc.c:345 odbc_obj_connect: Calling > 0x8110d68/0x8110d78 > Nov 5 11:53:56 NOTICE[12572]: res_odbc.c:359 odbc_obj_connect: > res_odbc: Connected to mysql1 [MYSQL-asterisk] > Nov 5 11:53:56 NOTICE[12572]: res_odbc.c:385 load_module: res_odbc loaded. > [res_config_odbc.so] => (ODBC Configuration) > Nov 5 11:53:56 NOTICE[12572]: config.c:556 ast_config_register: > Registered Config Engine odbc > == Parsing '/etc/asterisk/extconfig.conf': Found > == Binding sip.conf to odbc/asterisk/ast_config > res_config_odbc loaded. > [chan_sip.so] => (Session Initiation Protocol (SIP)) > Nov 5 11:53:56 NOTICE[12572]: config.c:492 __ast_load: Loading Config > sip.conf via odbc engine > == Parsing '/etc/asterisk/sip.conf': Not found (No such file or > directory) > Nov 5 11:53:56 NOTICE[12572]: chan_sip.c:8477 reload_config: Unable to > load config sip.conf, SIP disabled >You need to touch /etc/asterisk/sip.conf - the files still need to exist, but they can (and should) be empty. -- Kristian Kielhofner
Citat "Chris A. Icide" <chris@netgeeks.net>:> Hello, > > I'm having some issues with res_config. I've used BKW's perl program to > take a working sip.config and place it into the database. Asterisk doesn't > > load in the sip table from the database. What am I doing wrong?What version of Asterisk is this ? CVS HEAD ? The format has changed in CVS HEAD, instead of sip.conf => odbc you specify now: sip.conf => odbc,mysql1,ast_config [SNIP]> res_config_odbc.conf: > > [settings] > table => ast_config > connection => mysql1 >and res_config_odbc.conf is not needed anymore (depreciated). Beyond that everything looked fine. Kind regards, Martin List-Petersen -- [May one] doubt whether, in cheese and timber, worms are generated, or, if beetles and wasps, in cow-dung, or if butterflies, locusts, shellfish, snails, eels, and such life be procreated of putrefied matter, which is to receive the form of that creature to which it is by formative power disposed[?] To question this is to question reason, sense, and experience. If he doubts this, let him go to Egypt, and there he will find the fields swarming with mice begot of the mud of the Nylus, to the great calamity of the inhabitants. A seventeenth century opinion quoted by L. L. Woodruff, in *The Evolution of Earth and Man*, 1929