similar to: SIP rt load from db

Hi, I have some mySQL-sipfriends and connectivity to PSTN. When a call from PSTN comes, it shows a callerid, and that callerid is displayed at the called sip phone. When the call comes from another sip user (defined as mySQL-sipfriend), no callerid is displayed at the called sip phone. I turned on sip debug and discovered, that in the last case in the SIP-header to the called phone: From:

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

Dear I installed chan-sccp-b v3 on a powerful virtual machine, with 4 cpu cores and 16GB RAM(enabled in kernel by PAE) about 1,200+ clients are going to register in this machine. all data of clients are saved in ORACLE. The asterisk (1.6.2.18) connected to the database throw odbc(unixodbc). all logging are disabled( verbose, debug and sccp debug) . the asterisk was crashed every few minutes. here

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`

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.

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

Hi All. got this problem that IP phones could not re-register to my server. even if device is power cycled it still would not register. the solution i found was to change the SIP port settings on the phone and it will register. but after registration expires and its time to re-register the same thing will happen, so i have to update the port settings again just to make it work which is

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

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

Hello, Yesterday night we have upgraded our Asterisk from 1.2.32 to 1.4.24.1 with lipbri 1.4.10, dahdi-linux-2.2.0-rc4 and dahdi-tools-2.2.0-rc2. Libpri and dahdi is only for dahdi dummy cause of the meetme function. After the upgrade we had the problem that some Linksys spa941 phone at one location could not dial out. incoming calls to the phones works without any problem, but outbound the

Hi, Is there something wrong with REALTIME (ARA) when used with rtcachefriends parameter? In my sip.conf (Asterisk 1.2.0): rtcachefriends=yes rtupdate=yes rtautoclear=yes Desired configuration is realtime configuration (via odbc) for SIP phones + MWI. Realtime means the following: when I make changes to db they should apply with no extra commands executed in CLI. In order to use MWI with

All, we're running realtime and ast 1.2.7.1 stable. The problem I'm having is when you register a SIP device on ServerA, works fine, sip show peer works fine. When you dial the SIP device from ServerB however, it tries to dial, even does a MySQL query like it should but comes back saying no route to dest. When I do a 'sip show peer ..' on ServerB, the peer comes back fine, it even

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

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

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

I was looking for MySQL table structures for ARA (Asterisk 1.8.X). I found one for SIP friends on, https://wiki.asterisk.org/wiki/display/AST/SIP+Realtime,+MySQL+table+structure But it seems that it is not as per the Asterisk 1.8 SIP options. i.e. it contains 'call-limit' which is deprecated in 1.8 and not the 'callcounter' as one of the fields. Pardon my ignorance, but are