similar to: usage of each field

ok so my table looks like this... REATE TABLE `sip` ( `id` int(11) NOT NULL auto_increment, `name` varchar(80) NOT NULL default '', `accountcode` varchar(20) default NULL, `amaflags` varchar(7) default NULL, `callgroup` varchar(10) default NULL, `callerid` varchar(80) default NULL, `canreinvite` char(3) default 'yes', `context` varchar(80) default NULL, `defaultip`

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

Hi all! So far I've always used plaintext passwords for SIP, but now I've decided to use MD5 encryption. For each client I edited its section as follows, then: auth=md5 md5secret=hashed_passwd ;secret=plaintext_passwd where hashed_passwd is the output of echo -n "user:realm:plaintext_passwd" | md5sum When the first SIP clients registers with Asterisk after a "sip

maybe a dumb question but what do we have here??? sip-friends.sql # # Table structure for table `sipfriends` # CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `username` varchar(40) default '', `ipaddr` varchar(20) NOT NULL default '',

Not being an asterisk expert, but having been around the block once or twice when it comes to data and the like, I have made some observations based on the examples given on voip-info.org Sip configs. it appears there is an adjustment to be made in the sip_buddies example table: >>> name Although set to 30 characters, I don't see where it is limited in the text file. In theory,

It seems that when setting qualify = 200 or qualify = yes in the database for a sip friend/peer, RealTime does not update the registration status like it should. I also have several peers which have been offline and Asterisk still reports them as registered, even though the registration seconds are only 200. Asterisk Ver: CVS HEAD 12/1/2004 Layout of sip_buddies: mysql> describe

Hi All, I am trying to configure asterisk realtime. But i am unable to get the extensions listed successfully when i type "sip show peers" in the asterisk CLI . i am unable to see any failure logs when i do a reload i can able to connect to the data source through "odbc show" in the CLI, Any hep in this regard is highly appreciated. Following is the configuration

Hello, I installed 1.2.5 and realtime SIP. The connection to the DB is OK because I can get the values from the CLI. Here are my 3 different cases: 1- If I put an unexisting user, I get 404 and I am not able to dial. 2- If I check "Disable registration" within Firefly it does not register but I am able to dial a destination (...) 3- If I leave registration ON, I get the 404 message

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, I have a problem with a call between 2 webrtc clients. Asterisk removes the ice-related lines from the sdp when it sends the INVITE out, and the called webrtc client rejects the INVITE due to the missing ice lines. Both webrtc clients are defined exactly the same way, same values in all fields except the number of the peer. There's probably something I've changed that causes this

Greetings, I've noticed a problem that might originate from my Asterisk configuration, could use a hand in sorting it out. Problem is a 488 response from Asterisk whenever it gets RTP/SAVPF profile in the SDP. My current setup has Asterisk Kamailio realtime integration, and Kamailio uses dispatcher to route calls for Asterisk to handle. Now I have only one Asterisk, on the same machine as

Hello, I am just asking this because I am note sure if the problem is on my side or not, I saw some comments on SIP realtime today so I was wondering, has anybody has SIP realtime working with a softfone ? If yes, please confirm, that would give me a light. My previous message to the list is below. Thanks. Frederic ----- Original Message ----- From: Frederic Jean To:

When I try to use 1.6.1.1 with ODBC and MySQL, I get these: [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'name' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'ipaddr' [Jun 19 17:19:22] WARNING[5882]

Hi guys, I'm trying to use Asterisk with LDAP integration. I created some schemas and it seems to work fine for sip.conf replacement. When I try to register a softphone to test the service, it seems ok from the softphone point of view (user registred) but when I do a "sip show peers", no one is registered (nor sip show subrscriptions, users...) I put my Asterisk on full debug and I

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

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:

Hello, I'm trying to get calls working between websocket clients and sip clients. For clients I have sip.js based clients on chrome, Zoipers and a Grandstream phone. Challenge here is I'd like to have Kamailio and rtpengine to handle the bridging between different rtp profiles but Asterisk changes them in the sdp bodies along the way. I'm using Asterisk 11.11.0. Is there a way to

Hello, I noticed a strange thing while testing my Asterisk-Kamailio Realtime setup. In an INVITE the From and To headers contain the same number when calling through a Realtime integration setup. This happens when the INVITE leaves Asterisk. Can you guys tell me what might be causing this? I have 660 at testers.com as a websocket client and 700 at testers.com (caller) using a Zoiper client (db

I'm trying to get sipusers working with a realtime odbc database on Asterisk 1.6. We have sippeers working from the database, but need sipusers to be in a separate table for other implementation reasons. sip show user test load returns results from the database. CLI> sip show user test load * Name : test Secret : <Set> MD5Secret : <Not set>

Starting with Asterisk 1.2 I have always used realtime static to load my extensions.conf into Asterisk. It worked perfectly up to version 1.6.0.X but starting from 1.6.1.X and upwards it simply does nothing. I can see that the extensions.conf file is mapped to the database: == Parsing '/etc/asterisk/asterisk.conf': == Found == Parsing '/etc/asterisk/extconfig.conf': ==