similar to: mySQL-sipfriend dials to another SIP-endpoint - How to set the from-user

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

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`

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

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

i am getting 403 Forbidden message from asterisk when it try to register my user agent. i am basically useing mysql through ODBC. i hvae checked ODBC connecteion with 'ODBC Show' command. ------------------------------------------------------ *CLI> odbc show Name: mysql1 DSN: asteriskdsn Connected: yes *CLI> ------------------------------------------------------ and user is added to

Anyone know the command that tells * to load a sipfriend from the realtime db rather than saying no such host? I've tried various combinations of the rt commands: rtcachefriends=yes; ;rtcache=yes ;rtAutoClear=yes ;rtautoreg=yes ;rtIgnoreRegExpire=yes ;rtupdate=yes rtfromcontact=yes Basically I have a group of 4 * servers all routing calls, but only two are hearing the phones

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

Is it possible to load phone registration information stored in sipfriends MySQL DB, so that Asterisk "thinks" those phones are already registered? This would be very usefull for a redundant server... Regards, Ricardo Carvalho. -------------- next part -------------- An HTML attachment was scrubbed... URL:

I am using mysql sipfriends and can't seem to get the MWI to work. From what I've read it seems this is not supported with that dynamic system, and probably never will be. I was thinking of just setting a cron job or something to check every minute for voicemail and set our sip NOTIFY messages as needed. Also, the PAP2-NA has the ability to reboot via a sip notify and I would like to be

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 >

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, I am having some issues with Asterisk 1.8.3 extensions with a SIP Phone and an gateway. My setup is that I have my SIP Phone setup to register with the gateway. Then the gateway should sent calls to the Asterisk as a type of friend. This works fine if the SIP Phone configuration username and password isn't already set into the asterisk. The configuration of the SIP Phone username

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 =>

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

Hello I was wandering If I let 2 asterisk boxes (let's name them ast01 and ast02) connect to one SQL realtime iaxfriends/sipfriends database What happens if I register my client to ast01, The ast01 box will update the client's record in the iaxfriends database (ipaddr/port/regseconds) Let's say there is an incoming call then for this client but this call arrives on ast02 (the box

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

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

Hey All, We are looking to expand our usage of Asterisk and I am trying to make as much of the configuration dynamic as I possibly can. The only part that I'm having problems with is sip.conf. I can get asterisk to register each extension with our local SER SIP proxy dynamically by using the "sipfriends" table in the database, but I'm having trouble with the message waiting

I'm authenticating against sipfriends in MySQL, and have just noticed that none of the below commands return any output: sip show users sip show inuse sip show active sip show subscriptions Is this a bug or something wrong on my side? I'm using the stable 1.0 cvs Vahan