Displaying 20 results from an estimated 72 matches for "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);
sn...
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] WARN...
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 i...
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 diffe...
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 s...
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,setva...
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 let...
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_sqlit...
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>...
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 |...