similar to: MySQL Realtime Driver

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

I'm having trouble with the Realtime setup. I've followed the instructions on voip-info using odbc but I get this message during asterisk boot: Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory) Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load config sip.conf, SIP disabled == Registered channel type 'SIP' (Session

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

You are reading the instructions for the STABLE 1.0 version of asterisk and are using the CVS version. Goto the wiki and read the instructions for RealTime. -Matthew ----- Original Message ----- From: "Muhammad Rizwan Khan" <rizwan@advcomm.net> To: <Asterisk-Dev@lists.digium.com> Sent: Wednesday, January 05, 2005 12:42 PM Subject: [Asterisk-Dev] Asterisk with MySQL >

Sorry to ask such a basic question: I have a * box with 2 nics in the following setup: Internet | 192.168.5.253 (firewall) | 192.168.5.xxx network (gw 192.168.5.253) | 192.168.5.10 (* nic 1) 192.168.6.10 (* nic 2) | 192.168.6.xxx network The netmask for both networks is 255.255.255.0 The 192.168.6.xxx networks has a 48 port switch solely for the use of cicso 7940 phones, the 192.168.5.xxx is

Hello *'s, i am using Realtime Sip drivers but its not working here is my configs: extconfig.conf [settings] ; Realtime configuration engine ; ; maps a particular family of realtime ; configuration to a given database driver, ; database and table (or uses the name of ; the family if the table is not specified ; sipfriends => mysql,asterisk,sip_friends res_mysql.conf [general] dbhost =

I am trying to find where the authoritative sql definitions for Asterisk Realtime Architecture ARA are located. I have found many locations but each and everyone seems to be different. http://www.asteriskdocs.org/en/3rd_Edition/asterisk-book-html/asterisk-book.html http://www.open-voip.org/index.php?title=Asterisk_Full_RealTime_example Files included with the distribution:

Hi there asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs; here some info: *CLI> realtime load sipfriends name 104 Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104' Jan 13 11:52:21 DEBUG[8928]:

I am currently in the process of testing out realtime support for sip.conf. I have followed all of the directions that are listed in the Wiki, but for some reason this does not work. When utilizing a flat file, I am able to register endpoints without any problems, and calls can proceed. One interesting side effect that I have noticed is that when I am using realtime for sip, I am unable to see

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

Hello ppl, Am using realtime odbc storage for voicemail, sip users/peers, static for extensions and so on. My issue is I am not getting MWI for any fones, even tho I've got rtcachefriends=yes in sip.conf WIth tcpdump, I always see the NOTIFY going as Messages-Waiting:.no Voice-Message:.0/0.(0/0) even tho there are legitimate voicemails in the INBOX path for that particular users in the

hi, i'm a bit puzzled because i do not get include and hint to work with the new realtime enginge (cvs-head from 2004-12-09). other things (sipfriends and "normal" extensions) work perfect with the realtime engine. the entries in the static extensions.conf file i used before where: exten => 183,hint,SIP/snom220 exten => 183,1,Macro(stdexten,443,SIP/snom220,183) exten =>

On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph at digium.com> wrote: > > > On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor at telecomabmex.com> > wrote: > >> Has anyone successfully used Mysql realtime PJSIP with Asterisk >> 13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the >> following error now: >>

Has anyone successfully used Mysql realtime PJSIP with Asterisk 13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the following error now: Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql: Realtime table general at ps_contacts: column 'qualify_timeout' cannot be type 'int(10)' (need char) [Sep 12 14:42:35] WARNING[24498]:

On Mon, Sep 12, 2016 at 3:01 PM, Carlos Chavez <cursor at telecomabmex.com> wrote: > On 9/12/16 3:39 PM, George Joseph wrote: > > > > On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph at digium.com> wrote: > >> >> >> On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor at telecomabmex.com> >> wrote: >> >>> Has

Hi all I have asked this question before but have not got any helping input. I'm really new to this and need some explanation about ASTCC. So here is the question again. In the ASTCC web admin there are Trunks, Routes, IAXFriends, SIPFriends, Brands, Cards. As I understand Brands is not used, Cards just makes the cards. Routed in the dialplan and pricelist, Trunks is for ASTCC to

Hi all, Is there a way to keep track in Asterisk of which phones are online in realtime using some MySQL DB table for exemple, much like "sip show peers" does in the CLI? Regards, Ricardo.

Hello all! My basic problem is that we haven't been able to get realtime to use ODBC to store configuration data. Here are the details: We've installed Asterisk on a CentOS machine as follows: 1. Downloaded, compiled, and installed FreeTDS 0.63 2. Downloaded, compiled, and installed unixODBC 2.2.11 3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel from CVS

Hi - I'm looking into realtime and I'm having a bit of a problem with the SIP part. My review of the posts seems to indicate that I should use realtime static for the [general] part of my sip.conf including the registration commands: register=><did>:<secret>@<domain>/<did context> and use realtime realtime (funny name!) for peers and friends: [myprovider]

I have a pjsip install that is not pulling it's realtime registrations from an ODBC database. When I have them directly pull from a MySQL database everything seems to work. I am having trouble finding a requirements document for the pjsip realtime registrations. Is there some kind of special config that has to be used to trigger the connection for realtime registrations over ODBC?