George Konstantoulakis
2004-Nov-30 04:14 UTC
[Asterisk-Users] realTime configuration help needed
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 659d80f14cb431cd@192.168.1.203
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 '659d80f14cb431cd@192.168.1.203' 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
dbpassdbhost=localhost
dbname=asterisk
dbsock=/var/lib/mysql/mysql.sock
Even though you have MySQL RealTime installed and running, you didn't bind any families to it. Change: sipfriends => odbc,asterisk,sip To: sipfriends => mysql,asterisk,sip -Matthew ----- Original Message ----- From: "George Konstantoulakis" <gkon@inaccessnetworks.com> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Sent: Tuesday, November 30, 2004 5:14 AM Subject: [Asterisk-Users] realTime configuration help needed> 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 659d80f14cb431cd@192.168.1.203 > 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 '659d80f14cb431cd@192.168.1.203' 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 > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users