similar to: Realtime IAX/SIP with 2 asterisk servers but 1 central iax/sipfriends Database

After updating to the latest CVS Feb 17 15:20:03 WARNING[15317]: config.c:819 read_config_maps: The 'sipfriends' table is obsolete, update your config to use sipusers and sippeers, though they can point to the same table. == Binding sipusers to mysql/asterisk/sip == Binding sippeers to mysql/asterisk/sip Feb 17 15:20:03 WARNING[15317]: config.c:823 read_config_maps: The

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]:

Hi, I have a problem with IAX accounts... I set up a few months ago an Asterisk server, with mysql support to load iax accounts. Settings seems fine because apparently the system works as expected. Yesterday I tried to add another iax account in the iax.conf directly. And I have a problem with this new account (named 444). I can authenticate from 444 to the server, and I can receive calls from

Good morning everybody, Can someone explain to me the interconnection between these four things: indications.conf, SetLanguage(), zaptel.conf and ring-back ? If there is any !! :- ) I am having this case where some users cannot hear ring back from a DeadAGI script and it seems to be interconnected to these items. These users are from the iaxfriends table, they _can_ hear ring-back from a

Hello I need to add sip extensions from my UI so without going through sip.conf so i created table CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `username` varchar(40) default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `ipaddr` varchar(20) NOT NULL default '', `port`

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

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 '',

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, i.m. newbie in asterisk. asterisk 1.0.3 is my current version. i like to store usernames and passwords in a sql database. i like to log failed authentification-passwords, to create a blacklist for securityreasons. i thingk a sql-database is a good way to log these actions. i don.t find debugging-options to output invalid login-passwords. Ok, i have made the following: debian is my OS.

Hello I need to add sip extensions from my UI so without going through sip.conf so i created table CREATE TABLE `sipfriends` ( `name` varchar(40) NOT NULL default '', `username` varchar(40) default '', `secret` varchar(40) NOT NULL default '', `context` varchar(40) NOT NULL default '', `ipaddr` varchar(20) NOT NULL default '', `port`

hi using sipfriends from mysql from asterisk 1.0 branch, how can I make asterisk show the true channel's current codec with SIP SHOW CHANNELS? This does not seem to work, and bkw_ said sipfriends from mysql didn't have that info at all. For what it may seem, asterisk uses G.726 as told, giving me a -- Format for call is g726 at the start of the call, but in SIP SHOW CHANNELS all these

Greetings, Is there a way to tie a specific sip username to a IP address when authenticating against mysql sipfriends table? (USE_MYSQL_FRIENDS=1 USE_SIP_MYSQL_FRIENDS=1 in channels/Makefile) The reason is that I'm using Wellgate FXSes that have second/third/fourth FXS ports bugged when I use a password, but work ok when there is no password. Linking the username to a specific ip could

Hi all, I am new to asterisk and I can not find any detailed info on using SIP MySQL support (sipfriends) with clients behind NAT. I've heard that I have to patch chan_sip.c and Makefile to get it working. I tried on voip-info.org but found no answer for my questions. I found some answer on Digium mail list archive: http://lists.digium.com/pipermail/asterisk-cvs/2004-January/000854.html

Hello I change this from chan_sip.conf (see ipsvr): static void realtime_update_peer(const char *peername, struct sockaddr_in *sin, const char *username, const char *fullcontact, int expirey) { char port[10]; char ipaddr[20]; char regseconds[20]; time_t nowtime; -> char ipsvr[20]; time(&nowtime); nowtime += expirey;

Hi guys, im using realtime and I want to show registered users or online users on a webpage and offline users. Im taking regseconds field to make this happend If regseconds value is 0 then user appers offline, it regseconds is something else then its online, but sometimes this works and sometimes it does not. Im using the following options rtcachefriends=yes rtnoupdate=yes

Hello, We use Asterisk Realtime for our billing software. 200+ installations of Asterisk with Realtime, but I see this for the first time. Asterisk 1.4.17, Addons 1.4.5, No patches, no NAT - just plain simple installation. With debug I can see: [Jan 30 22:38:21] DEBUG[27885]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine. [Jan 30 22:38:21] DEBUG[27885]:

I am using Realtime on Asterisk 11.5 with a SQLite3 backend. While everything seems to be working fine I keep getting this error on my log files: [2014-02-17 19:55:18] WARNING[20569] res_config_sqlite3.c: Could not execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.23', "port" = '5060', "regseconds" = '1392692118',

Hello there, I have configured my asterisk to run on Mysql backend. But the Asterisk was unable to pick the peer details from the database. This is how I configured the Asterisk to run with mysql on the backend. Edit /usr/src/asterisk/channels/Makefile, change it to enable the MYSQL_FRIENDS USE_MYSQL_FRIENDS=1 USE_SIP_MYSQL_FRIENDS=1 cd /usr/src/asterisk make

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:

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