similar to: Problems w/Asterisk Realtime + MySQL + SIP [SOLVED!]

Hi all, Asterisk is great but I'm having issues with setting up realtime for our call center, which is needed for login integration with the rest of our applications (telephonists' web interface, etc.). I have reviewed a large number of previous posts to the mailing list and the voip-info wiki to no avail. Setup is as follows: Linux 2.6.23 (gentoo) / AMD Athlon(tm) 64 Processor 3000+ /

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;

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

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 asterisk users, here is a little problem pulling out iax peers from real time database I have the following peer configured in my database mysql> select name,username,secret,type,context,host,disallow,allow,defaultip,deny,permit, ipaddr,port from iax_users where name='iaxtermination'; +----------------+----------+----------------------------------+------+-----

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

I just finished migrating our web interface from Mysql to SQlite3 and everything seems to be working fine. I just have one detail. The following keeps appearing on my logs: [Apr 29 13:09:32] WARNING[30494]: res_config_sqlite3.c:520 realtime_sqlite3_execute_handle: Could not execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.0.52', "port" =

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`

Hello, Right now there is not a table build script at: http://www.voip-info.org/wiki-Asterisk+RealTime+IAX Therefore I have taken the SIP build script and added a few fields that I use from my iax.conf (could be more out there, please see the complete build script below): `dbsecret` varchar(100) default '', `notransfer` varchar(100) default '', `inkeys` varchar(100)

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

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

Hi, I am using Realtime for sip configuration. When there is an INVITE which arrives at asterisk asterisk makes the following selects: Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name = 'tzl' [Nov

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

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, I've troubles with setting up Asterisk Realtime and MD5 authentication. With clear text passwords everything is working fine. -- Registered SIP 'edwin' at 10.0.0.37 port 5060 expires 600 -- Saved useragent "Cisco-CP7940G/8.0" for peer edwin [2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:651 mysql_reconnect: MySQL RealTime: Everything is fine.

hi all, I'm trying to set up some iax2 trunks in Realtime architecture with the same backend. All work better (make call, receive etc etc) but when I do "iax2 show peers" some asterisk don't show anything and other show the iax2 peers but with status "unknow". Name/Username Host Mask Port Status ctm1/trixbox 10.0.0.131 (S)

Hello list, I'm using asterisk 1.6.2.11 with realtime SIP (mysql DB). I notice that when the SIP peer registers, the fields 'fullcontact', 'ipaddr', 'port', 'regserver', 'regseconds', 'lastms' are filled with values. But after a while, these fields become empty. Asterisk CLI shows : asterisk*CLI> sip show peers Name/username

Hi, according to the both discussions in the last few days I've tried to find a solution for Postfix with a PostgreSQL back-end. Its working nice for regular recipient addresses like user at example.com and addresses with an extension like user+foo at example.com. Alias addresses are currently ignored. * An alias may expand into multiple destinations. If one of this destinations is

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