search for: sip_conf

...is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE host = '192.168.0.74' AND...

...alTime DBName: ast_config [Nov 28 20:12:02] DEBUG[6581] res_config_pgsql.c: Postgresql RealTime: Everything is fine. [Nov 28 20:12:45] DEBUG[6603] res_config_pgsql.c: Postgresql RealTime: Everything is fine. [Nov 28 20:12:45] DEBUG[6603] res_config_pgsql.c: Postgresql RealTime: Query: SELECT * FROM sip_conf WHERE name = '172.16.0.1' [Nov 28 20:12:45] DEBUG[6603] res_config_pgsql.c: Postgresql RealTime: Query Failed because: connection pointer is NULL [Nov 28 20:12:45] DEBUG[6584] res_config_pgsql.c: Postgresql RealTime: Everything is fine. [Nov 28 20:12:45] DEBUG[6584] res_config_pgsql.c: Post...

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context | secret | defaultuser ------+---------+--------+---------+--------+------------- 1401 | dynamic | friend | pro...

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context | secret | defaultuser ------+---------+--------+---------+--------+------------- 1401 | dynamic | friend | prova | f...

Hi to all the ML. I'm new here. I start to use asterisk with realtime configuration, with pgsql backend connected via odbc. The connection between asterisk and pgsql works fine. I create a table sip_conf with 2 user (for testing purpose), 1401 and 1501. Those are the records: asterisk=> SELECT name,host,type,context,secret,defaultuser from sip_conf; name | host | type | context | secret | defaultuser ------+---------+--------+---------+--------+------------- 1401 | dynamic | friend | pro...

...t shows me this on the console: [Feb 17 12:32:50] WARNING[620]: res_config_pgsql.c:207 realtime_pgsql: Postgresql RealTime: Could not find any rows in table extensions_conf. [Feb 17 12:32:50] WARNING[604]: res_config_pgsql.c:207 realtime_pgsql: Postgresql RealTime: Could not find any rows in table sip_conf. [Feb 17 12:32:50] WARNING[604]: res_config_pgsql.c:207 realtime_pgsql: Postgresql RealTime: Could not find any rows in table sip_conf. [Feb 17 12:32:50] WARNING[9219]: res_config_pgsql.c:207 realtime_pgsql: Postgresql RealTime: Could not find any rows in table extensions_conf. [Feb 17 12:32:50] WA...

...e/mysql/voicemail_messages.sql:CREATE TABLE voicemail_messages ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE extensions_conf ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE cdr ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE sip_conf ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE voicemail_users ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE queue_table ( asterisk-11.9.0/contrib/realtime/postgresql/realtime.sql:CREATE TABLE queue_member_table asterisk-11.9.0/contrib/realtime/pos...

Does someone here configured RealTime Extensions using ODBC connecting to Oracle DB? Im having a problem in dialplan patterns, it doesnt work. Pls. help! -Chris __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com

Hi List: Can someone hlep to provide one or two examples to data entry for sip.conf under the table structure? CREATE TABLE `sip_conf` ( `id` int(11) NOT NULL auto_increment, `cat_metric` int(11) NOT NULL default '0', `var_metric` int(11) NOT NULL default '0', `commented` int(11) NOT NULL default '0', `filename` varchar(128) NOT NULL default '', `category` varchar(128) NOT NULL default...

...;MailboxExists' Dec 17 11:33:05 WARNING[21622]: loader.c:440 load_modules: Loading module app_voicemail.so failed! [root@abox asterisk]# extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc,PostgreSQL,ast_config sip.conf => odbc,PostgreSQL,sip_conf extensions.conf => odbc,PostgreSQL,extensions_conf voicemail.conf => odbc,PostgreSQL,voicemail_conf ~ res_odbc.conf: ;;; odbc setup file [PostgreSQL] dsn => PostgreSQL username => abox password => ecom1091 pre-connect => yes res_config_odbc.conf: [settings] table => ast_c...