search for: fullcontact

Hi All, Has anyone else noticed that when a sip phone sitting behind a nat registers to asterisk using realtime database, the private IP of the phone is put into the fullcontact field instead of the public contact IP. The database has the correct public IP in the ipaddr field and correct port number in the port field, which is actually what asterisk uses to to contact the device. This eliminates the ability to use the fullcontact URI to directly contact the nat'ed ph...

Hi everyone, in ldap realtime sip peers i need "fullcontact" set to "sip:exten@userip" for asterisk to correctly match the peers (at least for the natted peers to reach them)... anyway, how do I populate fullcontact "on the fly" with information from exten and userip? of course, i could just do it staticaly on ldap but since the...

I''m trying to get link_to_remote to assign a CSS class to the link it generates. My code is as follows: <%= link_to_remote "Show Full Info", :update => "fullcontact" + reparray.last.to_s, :url => "/cm/full_contact/" + reparray.last.to_s, :classname => "contactlink" %> Which produces this HTML: <a href="#" onclick="new Ajax.Updater(''fullcontact7'', ''/cm/full_contact/7'', {as...

...table, newparam, op, newval); .. } then: Apr 25 11:29:46 DEBUG[1480] res_config_mysql.c: MySQL RealTime: Update SQL: UPDATE sip SET ipaddr = 'yyy.yy.yyy.yyy', port = '25766', regseconds = '1145963986', username = '1st Floor Scanner - 137 <sip:xxxxxxxx', fullcontact = '1st Floor Scanner - 137 <sip:xxxxxxxx@yyy.yy.yyy.yyy:5060;user=phone;transport=' WHERE name = '84410662 Apr 25 11:29:46 DEBUG[1480] res_config_mysql.c: MySQL RealTime: Query Failed because: You have an error in your SQL syntax; check the manual that corresponds to your MySQ...

Hi We're using asterisk 1.4.17 with RealTime so our port and fullcontact values in out DB get updated dynamically. We use snom handsets and always set the network identity (port) in each phone to something in the 10000 range, so that each phone in a single location has a different port. When we look in the DB the location always has the port we set but the port va...

...TE "sip_buddies" SET "ipaddr" = '192.168.2.23', "port" = '5060', "regseconds" = '1392692118', "defaultuser" = '2012', "useragent" = 'Aastra 57i/3.2.2.2044', "lastms" = '-1', "fullcontact" WHERE "name" = '2012'': near "2012": syntax error [2014-02-17 19:55:30] WARNING[20569] res_config_sqlite3.c: Could not execute 'UPDATE "sip_buddies" SET "ipaddr" = '192.168.2.215', "port" = '5060', "reg...

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; snprintf(regseconds, sizeof(regseconds), "%d", (int)nowtime); /* Expi...

...ast_MYSQL_fetch: numFields=1 Should I be concerned? Does anyone know what it means? Thanks. JR I'm dialing extension 1001 extensions.conf [lookupmysql] exten => _X.,1,MYSQL(Connect connid 10.10.10.110 asteriskdb password table) exten => _X.,2,MYSQL(Query resultid ${connid} SELECT\ fullcontact\ from\ table_sip\ where\ name=${EXTEN}) exten => _X.,3,MYSQL(Fetch fetchid ${resultid} var1) exten => _X.,4,MYSQL(Clear ${resultid}) exten => _X.,5,MYSQL(Disconnect ${connid}) exten => _X.,6,GotoIf($["${var1}" = ""]?invalid,i,1:${EXTEN},7) exten => _X.,7,ChanIsAva...

...h peer (phone) registers, or a call is made to the peer, Asterisk adds them to the list returned by 'sip show peers'. Correct? Apparently Asterisk doesn't refer to thie list however, when deciding where a peer is located. It uses astdb instead (I have rtcachefriends=yes). I cleared the fullcontact field in the database, and placed a call. The only place that Asterisk could get the peer's IP address from was astdb, as the peer wasn't in 'sip show peers' as I purposefully cleared the fullcontact field for all peers in the database. So... what's the point of this? Is it use...

Ok, I am looking for some input on using dundi. Is anyone using dundi? And how is it working out? -- Best regards, Al Bochter Bochter Services http://www.BochterServices.com/?t=Email (VOIP PBX) 1-866-638-1254 (Voip PBX) Free World DialUp: 780-217 WebSite: http://www.freeworlddialup.com/ We have Toll Free DID's instock http://www.bochterservices.com/?t=TFdid For Information on PBX

...ar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: type LDAP value: friend [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: callerid LDAP value: Pierre Bachelet <2001> [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: fullcontact LDAP value: Pierre Bachelet [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: AstAccountSecret LDAP value: 1234 [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: host LDAP value: dynamic [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289)...

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 tables that munges it together in a manner that makes sense to asterisk, while alleviating some of the managemen...

Hi, If Iam doing UPDATE SQL statements I got an overload for connection. am doing everytime an Disconnect ${connid}) but this is ignored. any idea? best regards Thomas

...11) [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'defaultuser' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'fullcontact' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'regserver' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'u...

Hello there! I was testing Asterisk for the last two weeks using the Realtime driver for MySQL, and leaving "rtcachefriends=yes" configured to enable MWI. Today I started making additional tests with "rtcachefriends=no" because we will probably need to use Asterisk without this cache. For some strange reason, calls stop to get routed between the SIP clients. I've

...tifyringing=yes notifyhold=yes allowsubscribe=yes call-limit=1 and the corresponding realtime entry is: name: 21168 accountcode: NULL amaflags: NULL callgroup: NULL callerid: device <21168> canreinvite: no context: default-sip defaultip: NULL dtmfmode: rfc2833 fromuser: NULL fromdomain: NULL fullcontact: NULL host: dynamic insecure: NULL language: NULL mailbox: 21168 at device md5secret: NULL nat: yes deny: NULL permit: NULL mask: NULL pickupgroup: NULL port: 5061 qualify: no restrictcid: NULL rtptimeout: NULL rtpholdtimeout: NULL secret: xxx type: friend username: 21168 disallow: allow: all music...

Has anyone considered the idea of splitting the sip registration information in a realtime database from the actual configuration of the peers? I mean, instead of having a table full of the configuration information (i.e. name, regexten, secret, etc) and registration information (i.e. ipaddr, fullcontact, etc), you have separate tables with their own information. This way, you can have separate tables with config information, and use a view for the actual compiled configuration, instead of how it is now, where there may be repeating info all over the database. Does any of that make sense? -- Aar...

...`restrictcid` char(3) default NULL, `rtptimeout` char(3) default NULL, `rtpholdtimeout` char(3) default NULL, `secret` varchar(80) default NULL, `setvar` varchar(100) default NULL, `disallow` varchar(100) default 'all', `allow` varchar(100) default 'g729;ilbc;gsm;ulaw;alaw', `fullcontact` varchar(80) NOT NULL default '', `ipaddr` varchar(15) NOT NULL default '', `port` smallint(5) unsigned NOT NULL default '0', `regserver` varchar(100) default NULL, `regseconds` int(11) NOT NULL default '0', `username` varchar(80) NOT NULL default '', P...

Hi, Suppose you have 2 identical Asterisk servers and 1 alias IP address that you assign to either one, according to system failures, etc. Also suppose that all SIP clients register requests go to the alias IP address. Imagine server1 fails and server2 gets the alias IP address. Correct me if I'm wrong but I would have to wait at least 60 seconds before most SIP clients re-register to

...encryption yes avpf yes icesupport yes <---- ICE is enabled ipaddr PU.BL.IC.IP port 5060 regseconds 1410185500 defaultuser 660 fullcontact sip:660 at PU.BL.IC.IP:5060 lastms 0 useragent context default directmedia no deny 0.0.0.0/0.0.0.0 permit PU.BL.IC.IP nat force_...