Hello all, I recently noticed the realTime effort and must say it is a nice idea! I would appreciate any help to get it running ..
I downloaded the code & patches and succefully patched my asterisk (CVS-HEAD-11/29/04-12).
- created a DB called asterisk, and a table sip using the schema supplied at
http://bugs.digium.com/bug_view_page.php?bug_id=0002613.
- entered an entry:
insert into sip(name, host, context, defaultip) values('203', 'dynamic', 'default', '192.168.1.203');
Though I see asterisk connecting to the DB from mySQL-logs, I can't seem to get anything else....
How can I get my configuration from the DB ? Am I doing something worng ? My traces are bellow..
Thanx in advance, for any help, George Konstantoulakis.
------------------------------------------ When I start with vvvcd I get :
[res_config_mysql.so] => (MySQL RealTime Configuration Driver)
Nov 30 12:44:21 DEBUG[3088]: config.c:517 __ast_load: Parsing /home/gkon/slash/etc/asterisk/res_mysql.conf
Nov 30 12:44:21 WARNING[3088]: res_config_mysql.c:413 parse_config: MySQL RealTime: No database port found, using 3306
as default.
Nov 30 12:44:21 DEBUG[3088]: res_config_mysql.c:429 parse_config: MySQL RealTime Host: localhost
Nov 30 12:44:21 DEBUG[3088]: res_config_mysql.c:430 parse_config: MySQL RealTime Port: 3306
Nov 30 12:44:21 DEBUG[3088]: res_config_mysql.c:434 parse_config: MySQL RealTime User: root
Nov 30 12:44:21 DEBUG[3088]: res_config_mysql.c:435 parse_config: MySQL RealTime Password:
Nov 30 12:44:21 DEBUG[3088]: res_config_mysql.c:471 mysql_reconnect: MySQL RealTime: Successfully connected to database.
Nov 30 12:44:21 NOTICE[3088]: config.c:562 ast_config_register: Registered Config Engine mysql
Nov 30 12:44:21 DEBUG[3088]: config.c:517 __ast_load: Parsing /home/gkon/slash/etc/asterisk/extconfig.conf
== Binding sip.conf to odbc/asterisk/sip
== Binding sipfriends to odbc/asterisk/sip
== MySQL RealTime driver loaded.
[chan_sip.so]Nov 30 12:44:21 DEBUG[3088]: config.c:517 __ast_load: Parsing /home/gkon/slash/etc/asterisk/modules.conf
=> (Session Initiation Protocol (SIP))
Nov 30 12:44:21 DEBUG[3088]: config.c:517 __ast_load: Parsing /home/gkon/slash/etc/asterisk/sip.conf
== SIP Listening on 0.0.0.0:5060
== Using TOS bits 0
Nov 30 12:44:21 DEBUG[3088]: channel.c:199 ast_channel_register_ex: Registered handler for 'SIP' (Session Initiation Protocol (SIP))
---------------------------
When I try to make a call to * through a Grandstream phone (with the IP 192.168.1.203)
I get :
Nov 30 12:58:03 DEBUG[3096]: chan_sip.c:2370 sip_alloc: Allocating new SIP call for [EMAIL PROTECTED]
Nov 30 12:58:03 DEBUG[3096]: chan_sip.c:7292 handle_request: Check for res for
Nov 30 12:58:03 DEBUG[3096]: chan_sip.c:1592 update_user_counter: is not a local user
Nov 30 12:58:03 DEBUG[3096]: chan_sip.c:1592 update_user_counter: is not a local user
Nov 30 12:58:03 DEBUG[3096]: chan_sip.c:833 __sip_ack: Stopping retransmission on '[EMAIL PROTECTED]' of Response 50530: Found
------------------------------------------------------
My configuration files are :
extconfig.conf : -------------------- [settings] sip.conf => odbc,asterisk,sip sipfriends => odbc,asterisk,sip
res_mysql.conf: -------------------- [general] dbuser=root dbpass= dbhost=localhost dbname=asterisk dbsock=/var/lib/mysql/mysql.sock _______________________________________________ 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
