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 | [EMAIL PROTECTED] |
| 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,[EMAIL PROTECTED] |
+----+------------+------------+-----------+----------------+--------------+------------------+--------------------------------------------------------------------------+
29 rows in set (0.00 sec)
_______________________________________________ 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
