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" <[EMAIL PROTECTED]> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <[EMAIL PROTECTED]> 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 [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 _______________________________________________ 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
