similar to: MySQL + Realtime + SIP Registration

Greetings, I'm having some trouble with the realtime engines. When asterisk loads, everything looks fine, there don't seem to be any problems via notices or anything. Furthermore, cdr_odbc is working, and actively logging my failed call attempts to db through ODBC using the same DSN. unixODBC and the mysql drivers are installed from source. Here are the relevant parts of the config:

Having problems getting realtime working, I'm trying to use odbc for all of this. I've got Fedora 3 and have been fighting with odbc for a day now. I think I got it working correctly, however I can't seem to get the realtime portion working. In asterisk 'odbc show' shows it connected, I see it on my (odbc) mysql server connected and all, it connects and just idles. So, without

Hi, I'm testing Asterisk with MySql and I would want to insert sip users in a table "sip_users". After I modified extconfig.conf with "sipusers => odbc,asterisk" and I create the table sipusers, which changes must I make to sip.conf? Thank's Maury P.S.: C'? qualche utente italiano nella mailing list? -------------- next part -------------- An HTML attachment

Hi all, we use OpenSER together with Asterisk. All SIP users registers with OpenSER and asterisk is doing the voicemail thing. We use the Asterisk RealtimeArchitecture for voicemail users and SIP peers. The database table for the sip peers is a view from the OpenSER subscriber table. The MWI for a user will only work, if the user object (sip peer) is loaded into memory and visible with the CLI

I have followed the instructions on voip-info.org for Realtime SIP peers, but I get this notice : [Feb 22 20:05:32] NOTICE[15298]: chan_sip.c:15889 handle_request_register: Registration from '<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' - No matching peer found The CLI shows : [Feb 22 19:58:23] == Parsing

I've been going in circles for a few weeks now with Realtime SIP. My extconfig.conf has: sipusers => mysql,dbname,ast_sip_users sippeers => mysql,dbname,ast_sip_users When I do a 'sip show peers' I see all my phones. When I do a 'sip show users' I only see a few of them. I can't work out why this is the case. They are also coming up with NAT as

Guys, I'm having a hellava time getting realtime to work, focused on sipusers right now, followed the wiki and other examples but still no luck. Using mysql on a seperate server, asterisk actually sees the database and can poll the table "realtime load sipusers" at the cli but asterisk realtime engine is no pulling the user info. I'm using 1.2.4 stable and have the database

Still a couple of questions...... I did configure extconfig.conf ... ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk ;sipusers => odbc,asterisk sipusers => mysql,asterisk,sip_devices sippeers => mysql,asterisk,sip_devices ;sippeers => odbc,asterisk ;sipregs => odbc,asterisk ;voicemail => odbc,asterisk ;extensions => odbc,asterisk ;meetme => mysql,general

All, I get this whenever trying to dial to a peer when the peer registered to another server. I'm basically trying to use realtime to check for the peer and dial it. Mar 24 09:16:47 VERBOSE[4527]: -- Executing Dial("SIP/brak-f69f", "IAX2/brak-test/107") in new stack Mar 24 09:16:47 DEBUG[4527]: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_users WHERE name =

Ok, i tried the suggestion: Instead of: sippuser => resource, database_name, table_name sippeer => resource, database_name, table_name I put in: sippuser => resource, context, table_name sippeer => resource, context, table_name Unfortunately, with the same results. btw i tried both "general" as "default" Besids the commands i tried below, isn't there any

Could someone provide some steps for troubleshooting Realtime? I can't see any signs that it's working. I followed and double-checked a few different guides around the net, but haven't been able to figure it out. -------------- next part -------------- An HTML attachment was scrubbed... URL:

Dear all I'm writing to the list for help as a last resort. I've exhausted all other options, so please forgive me. I've lurked here for years but never actually posted. I'm trying to get Asterisk Realtime SIP configuration working, but it refuses to do so. I have all the necessary configuration in place, Asterisk makes a connection to the database, which can be verified with

Hi everybody, First of all i am sorry my English :) i want to configure my asterisk server as a sip server that stores sip users in the mysql database connecting directly over odbc driver. My odbc configuration works as below [root at ao042 asterisk]# isql -v asterisk +---------------------------------------+ | Connected! | | | |

I have configured my mysql database by following this link http://www.voip-info.org/wiki/view/Asterisk+RealTime+Queue The only difference is that I am using ODBC instead of MySQL with Realtime. Within extensions.conf I have the following for my queue exten => 9**2**1611,1,Answer exten => 9**2**1611,2,Queue(irock.com,tT,,,300) exten => *50,1,Answer exten =>

Hi Andrew, OK, (the simple fact that those machines are not connected to internet makes that i have to go to those machines and copy them on a usb-stick, so it causes some delay each time...) -------- Forwarded Message -------- Sorry - I meant extconfig.conf - not cdr_mysql.conf (my mistake). I use (and done for a long time) mySQL for realtime storage - and it's never let me down (touch

Hi, I have 2 databases DBNAME1 and DBNAME2. In each database I have a table called sipusers (so DBNAME1.sipusers and DBNAME2.sipusers). Can I use both sipusers tables in Asterisk RealTime? Something like this: /etc/asterisk/extconfig.conf: [settings] sipusers => odbc,DBNAME1,sipusers sippeers => odbc,DBNAME1,sipusers sipusers => odbc,DBNAME2,sipusers sippeers =>

Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk softphones. I followed the steps of "how to" of voip-org but always have this error: Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime: Failed to query database. Check debug for more info. Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL RealTime:

I have configured asterisk realtime to work with two servers and a seperate MySQL DB. Each sip client registers which server it is connected to in the MySQL DB. This works great as long as the clients are 1. On the same network 2. Behind a NAT and connected to the same asterisk server as the caller. However I need this configuration to work for "NAT-ed" clients on different asterisk

Hello there I'd like to use sip users and peers realtime. I think I done all I need to get asterisk works fine in realtime: res_odbc.conf configuration. extconfig.conf sippeers => odbc,asterisk,sipclient sipusers => odbc,asterisk,sipclient sip.conf [general] rtcachefriends=yes The sipclient table as suggest in this article: SIP Realtime, MySQL table structure (

Okay, so here's the configuration I have for MySQL Realtime (Asterisk version 1.6.2.17): In /etc/asterisk/extconfig.conf: sipusers => mysql,mya2billing,cc_sip_buddies In /etc/asterisk/res_mysql.conf: [mya2billing] dbhost = localhost dbname = mya2billing dbuser = a2billinguser dbpass = REDACTED dbport = 3306 And here's the error messages I get: voip2*CLI> realtime mysql status