similar to: Asterisk Unregisteres IAX Friend Randomly

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

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

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]

We have several Asterisk servers (1.6.2.15) all configured for Realtime, all backed by the same database. The Asterisk servers are all listed under DNS SRV records, and SIP ATAs find us this way. Normally, no matter which Asterisk server an ATA connects to, we get our database fields filled out correctly, such as "regseconds", "lastms", "ipadr", etc. However, with

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

I've been having an odd problem with nmbd and WINS. We have two WINS servers running on NT4.0, and eight solaris machines running samba (2.0.7). Every so often, it appears that WINS loses its db entry for the samba machines. If I stop and restart nmbd, the samba machine reregisters with WINS and all is good. The problem is very sporadic, and doesn't seem to affect all of the machines.

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

I have several (various brand) sip devices with static IP's. I understand that asterisk will not accept a registration from these devices if the host= parameter is not set to 'dynamic' in sip.conf. I want calls to these extensions to be routable even before the device registers. I understand that is what defaultip= is supposed to do, but it doesn't work. I get a busy tone when

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

Hi, I'm currently doing some testing against asterisk 1.6.1.7-rc2 (keep meaning to upgrade) and am having a problem with the GotoIfTime dial plan function. The asterisk book says that day of week field can include the ampersand (&) to combine multiple days / day ranges but this gives me an error. For example mon&wed gives the error (in the asterisk console): [Nov 23 18:04:27]

Hi, Have just been testing asterisk 1.8.0, 1.8.0-rc5 and a trunk version from about half an hour ago. IAX Friends (Zoiper Softphones) don't stay registered for more than a few seconds they start out with status unknown and quickly become unreachable, I am using realtime with postgresql, with tables and configuration that have worked fine for IAX in 1.6 and a trunk release from a few months

Hi, I have been having a problem with asterisk crashing when using local channels and realtime on asterisk 1.8.3-rc2. The example given here is I think the easiest way to reproduce this problem. In extensions.conf I have: [internal] switch => Realtime/extensions/p exten => 301,1,Answer() exten => 301,2,Dial(Local/501 at internal) exten => 301,3,Hangup() exten => 501,1,Answer()

Hi, I have not esatblished a working rsync config on my server, but have found one major problem in which i hope there is a solution to. I'm based in Norway, with scandinavian clients. Of course we use several "special characters" in our keymap, which is not supported in US keyboards etc. I know there is a better word for this, unfortunatly i can't remeber it, so i hope you

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

Dear, Our iax clients's ip and port in the database were removed automatically, after 30 secs. the iax info is saved in odbc and postgresql . asterisk=# select * from iax_buddies where username='9706015'; name | username | type | secret | md5secret | dbsecret | transfer | inkeys | outkeys | auth | accountcode | amaflags | callerid | context | defaultip | host | language

If anyone's interested, I've just put together a sip realtime patch, figured anyone that uses realtime may want to have a look at it. The patch basically takes the stuff asterisk updates (fullcontact, ipaddr, port, regseconds, and username) out of the sippeers table and puts it in it's own table. For those that are using multiple tables, this allows you to create a view of those

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 everybody, First of all i am sorry my English :) i want to configure my asterisk server as a sip server that stores sip users in the mysql database connecting directly over odbc driver. My odbc configuration works as below [root at ao042 asterisk]# isql -v asterisk +---------------------------------------+ | Connected! | | | |

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