search for: regsecond

Displaying 20 results from an estimated 72 matches for "regsecond".

Did you mean: regseconds
2005 Oct 10
1
Realtime regseconds update
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 rtautoclear=yes anyone has any idea? im using...
2007 Feb 11
0
realtime and save ip server in database
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); /* Expiration time */ ast_inet_ntoa(ipaddr, sizeof(ipaddr), sin->sin_addr); s...
2009 Jun 19
1
Strange res_config_odbc error messages in 1.6.1.1
...(-9) unrecognized for column 'ipaddr' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column type (-9) unrecognized for column 'port' [Jun 19 17:19:22] WARNING[5882] res_config_odbc.c: Realtime table supporten_sip at asterisk: column 'regseconds' is not long enough to contain realtime data (needs 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...
2008 Jan 31
0
Realtime device update weirdness
...ND host = 'dynamic' [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine. [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:365 update_mysql: MySQL RealTime: Update SQL: UPDATE devices SET ipaddr = '0.0.0.0', port = '0', regseconds = '0' WHERE name = '109' [Jan 30 22:38:21] DEBUG[27917]: res_config_mysql.c:379 update_mysql: MySQL RealTime: Updated 0 rows on table: devices [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]:...
2014 Feb 18
1
Syntax error for Realtime SQLite3
...ckend. 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', "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] WAR...
2009 Dec 11
1
Asterisk Unregisteres IAX Friend Randomly
...erisk will unregister a IAX friend at random times when the registration should not have expired. I have a Zoiper soft phone client (on windows) connecting to asterisk over a LAN (no firewalls). The default reregister time of 60 seconds is used, but the asterisk server unregisters the client (sets regseconds to 0 in the database) after a seemingly random time after registration say, 15 seconds (which is 45 seconds before registration expiry) I set iax2 debug on, and set the core debug level to 5 so I could see the IAX2 control frames on the console. I use pgAdmin-III to watch the value of regseconds...
2011 Jan 02
1
Realtime SIP, multiple AX servers question
...sk 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 some ATA's we are experiencing a problem as follows: 1. ATA reaches its "re-registration" timeout, which we typically configure to be 60 minutes. 2. ATA re-queries DNS SRV record, and ends up re-registering with a diff...
2004 Dec 14
3
Problems with app_realtime
...type | varchar(6) | | | | | | username | varchar(30) | | | | | | allow | varchar(100) | YES | | NULL | | | disallow | varchar(100) | YES | | NULL | | | regseconds | int(11) | | | 0 | | | ipaddr | varchar(15) | | | | | | ts | timestamp(14) | YES | | NULL | | +----------------+---------------+------+-----+---------+----------------+ 36 rows in...
2011 Apr 20
1
[IAX] Everyone is busy/congested at this time (1:0/0/1)
...isk,iaxfriends iaxpeers => mysql,asterisk,iaxfriends voicemail => mysql,asterisk,voicemail --------- - Mysqldump from iaxfriends --------- INSERT INTO iaxfriends (name,type,phonenumber,username,mailbox,secret,dbsecret,context,regcontext,host,ipaddr,port,defaultip,sourceaddress,mask,regexten,regseconds,accountcode,mohinterpret,mohsuggest,inkeys,outkey,language,callerid,cid_number,sendani,fullname,trunk,auth,maxauthreq,requirecalltoken,encryption,transfer,jitterbuffer,forcejitterbuffer,disallow,allow,codecpriority,qualify,qualifysmoothing,qualifyfreqok,qualifyfreqnotok,timezone,adsi,amaflags,setv...
2008 Mar 21
3
Problem with user regsitration and ldap on SVN version
...: language LDAP value: fr [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: ipaddr LDAP value: 0.0.0.0 [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: port LDAP value: 0 [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: regseconds LDAP value: 1206118346 [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(289) attribute_name: defaultuser LDAP value: 0 [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(482) attribute_name: canreinvite value: no [Mar 21 16:53:54] DEBUG[12002] res_config_ldap.c: LINE(482) attribute_name:...
2009 Dec 11
2
sip realtime question
...secret Deneme01 disallow all allow g729 allow ilbc allow gsm allow ulaw allow alaw port 5060 regseconds 0 lastms 0 username 100 but the following commands returns nothing ao042*CLI> sip show users Username Secret Accountcode Def.Context ACL NAT ao042*CLI> sip show peers Name/username Host...
2006 Jun 28
1
Realtime patch
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 management from you, as well as le...
2007 Feb 21
1
Monitoring which users are online in realtime
Hi all, Is there a way to keep track in Asterisk of which phones are online in realtime using some MySQL DB table for exemple, much like "sip show peers" does in the CLI? Regards, Ricardo.
2009 Jan 31
1
iax clients were unregistered after 30sec
...iax_buddies where username='9706015'; name | username | type | secret | md5secret | dbsecret | transfer | inkeys | outkeys | auth | accountcode | amaflags | callerid | context | defaultip | host | language | mailbox | deny | permit | qualify | disallow | allow | ipaddr | port | regseconds | email | date | user_id ---------+----------+--------+----------+-----------+----------+----------+--------+---------+------+-------------+----------+----------+---------+-----------+---------+----------+---------+------+--------+---------+----------+-------+------...
2010 Jan 27
1
Asterisk Database Configuration
...` 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` int(6) NOT NULL default '0', `regseconds` int(11) NOT NULL default '0', PRIMARY KEY (`name`) ) TYPE=MyISAM then i put sip.conf [general] hostname=localhost dbname=asterisk table= sipfriends password=ahmed user=root then i insert in sql this statment insert into sipfriends values ('555','555','1234',&...
2014 Apr 29
0
SQlite3 realtime
...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" = '5060', "regseconds" = '1398795032', "defaultuser" = '112', "useragent" = 'Zoiper r21999', "lastms WHERE "name" = '112'': near "112": syntax error5060;rinst [Apr 29 13:10:26] WARNING[30494]: res_config_sqlite3.c:520 realtime_sqli...
2006 Mar 21
0
SIP Realtime 1.2.5 and Username/auth name mismatch ?
...type friend username 1111 disallow all allow g729 allow ilbc allow gsm allow ulaw allow alaw regseconds 0 ipaddr 0.0.0.0 cancallforward yes +----------------+--------------+------+-----+-------------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+----...
2005 Jan 13
1
asterisk realtime msql
...name 104 accountcode 104 callgroup 1 context default host dynamic secret abc type friend username 104 regseconds 0 *CLI> realtime mysql status Jan 13 11:57:06 DEBUG[8928]: res_config_mysql.c:637 mysql_reconnect: MySQL RealTime: Everything is fine. Connected to asterisk@192.168.1.10, port 3306 with username root for 4 seconds. in extconfig.conf i have: [settings] ;<family name> => <driver&g...
2008 Nov 12
1
What are the minimum realtime fields for sipusers?
...: Registration from '<sip:test at domain.com>' failed for '10.10.10.10' - No matching peer found What are the minimum fields required for the sipusers table? Currently we have: name | secret | type | nat | host | context | qualify | regserver | regseconds Also is there a way to enable debugging to show the SQL calls being made to the database? -- Eric Chamberlain
2005 Aug 10
1
asterisk query mysql problem or bug?
Hi; I have entries as below in DB, mysql> select * from sip_buddies; +----+------+----------+------------+---------+------------+--------+------- -----+------------+----------+------+ | id | name | context | defaultip | host | mailbox | type | regseconds | ipaddr | username | port | +----+------+----------+------------+---------+------------+--------+------- -----+------------+----------+------+ | 1 | 2000 | from-sip | 10.1.2.192 | dynamic | 2000@local | friend | 1123733887 | 10.1.2.192 | 2000 | 5060 | | 2 | 2001 | from-sip | 10.1.2.220...