Displaying 20 results from an estimated 1000 matches similar to: "Realtime device update weirdness"
2007 Jan 15
0
Asterisk Realtime and MD5 authentication
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.
2007 Nov 20
1
Realtime - mysql query gives wrong results??
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
2005 Jan 13
1
asterisk realtime msql
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]:
2005 Mar 24
1
realtime - unable to find key
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`
2006 Apr 25
0
SQL update failing/long fullcontact
Hi
We have some users who are supplying very long, broken contact details
(from Cisco 7912 phones):
Apr 25 11:29:46 WARNING[1480] chan_sip.c: No closing bracket found in
'1st Floor Scanner - 137
<sip:xxxxxxxx@yyy.yy.yyy.yyy:5060;user=phone;transport='
Apr 25 11:29:46 NOTICE[1480] chan_sip.c: '1st Floor Scanner - 137
2005 Aug 23
2
RealTime ignoringswitch=>Realtime/context@realti me_ext
I am using the current HEAD of asterisk and for asterisk-addons. I have been
trying to setup realtime mysql voicemail but no sucess. I keep getting this
error below. The necessary modules are loaded, res_config_mysql.so ...
Any pointers will help. Thanks
mail*CLI> realtime mysql status
Aug 24 00:56:50 ERROR[963]: res_config_mysql.c:596 mysql_reconnect: MySQL
RealTime: Failed to connect
2007 Sep 26
0
asterisk-users Digest, Vol 38, Issue 83
Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk
softphones. I followed the steps of "how to" of voip-org but always have
this error:
Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL
RealTime: Failed to query database. Check debug for more info.
Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL
RealTime:
2007 Sep 26
4
Asterisk realtime error
Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk
softphones. I followed the steps of "how to" of voip-org but always have
this error:
Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL
RealTime: Failed to query database. Check debug for more info.
Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL
RealTime:
2007 May 23
0
Problems compiling res_config_mysql (asterisk addons)
Hello All:
I'm having some difficutly getting res_config_mysql from the 1.4.1 addons
package to compile ( I need it for Realtime)
First of all, when I make everything appears to compile ok with no errors
however the res_config_mysql doesn't get compiled. So I tried "make
res_config_mysql" and a whackload of errors starting with the following:
# make res_config_mysql
gcc -g
2009 Mar 21
2
1.6.2 beta 1 crash
Hi,
I'm starting testing 1.6.2 beta. CentOs 5.2
I found my first crash, first I have
[Mar 20 20:30:41] WARNING[11201]: res_config_mysql.c:611 update_mysql:
Attempted to update column 'useragent' in table 'sip', but column does not
exist!
[Mar 20 20:30:41] ERROR[11201]: res_config_mysql.c:581 update_mysql: MySQL
RealTime: Updating on column 'lastms', but
2007 Jun 03
0
Strange problem with channel allocation
Hello I just settup a realtime mysql table for sip_peers. All peers
(friends) is autenticateing but when i want to initiate a call between them
i got the following error. Someone have some ideea? Thank you.
---<Cut Here>---
pbx*CLI>console dial 1014
== Console is full duplex
-- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new
stack
2006 Jan 12
0
Configuration of SIP Mysql peers.
Hi all,
I have configured Asterisk using Mysql database. The peers that
I have mentioned in the database are successfully registered to
Asterisk, But I am getting a warning stating "Mysql realtime: Failed to
query the database" Below I am pasting error. Could anybody please let
me know what's the cause for this warning....
*CLI> -- Registered SIP 'bharat'
2011 Mar 07
2
Asterisk 1.6 MySQL Realtime fails to connect with working username and password.
Okay, so here's the configuration I have for MySQL Realtime (Asterisk
version 1.6.2.17):
In /etc/asterisk/extconfig.conf:
sipusers => mysql,mya2billing,cc_sip_buddies
In /etc/asterisk/res_mysql.conf:
[mya2billing]
dbhost = localhost
dbname = mya2billing
dbuser = a2billinguser
dbpass = REDACTED
dbport = 3306
And here's the error messages I get:
voip2*CLI> realtime mysql status
2015 May 22
1
Problem with realtime mysql I can't seem to resolve
Hello
I have already several Asterisk servers running with similar
configuration, but now I stumble into a problem.
I have mysql configuration res_config_mysql.conf :
[MyAsteriskDB]
dbhost = 127.0.0.1
dbname = MyAsteriskDB
dbuser = astadmin
dbpass = mysecret
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
requirements=warn ; or createclose or createchar
Realtime seems to be loaded :
2005 Aug 24
1
RealTime ignoringswitch=>Realtime/context@realtime_ext
I am getting this error when reload my asterisk
"cdr_addon_mysql.c:264 my_load_module: Unable to load config for mysql
CDR's: cdr_mysql.conf"
I don't have res_mysql.conf in /etc/asterisk/. I have res_odbc.conf
which is attached
Res_odbc.conf
==============
;;; odbc setup file
[mysql1]
dsn => MySQL-asterisk
username => myuser
password => mypass
pre-connect => yes
2006 Jan 11
1
Better solution to mysql reconnect timeout
vmail*CLI> realtime mysql status
Jan 11 09:53:04 ERROR[3597]: res_config_mysql.c:623 mysql_reconnect: MySQL
RealTime: Failed to reconnect. Check debug for more info.
vmail*CLI> realtime mysql status
Connected to asterisk_vm@tritonvoice.com, port 3306 with username voicemail
for 1 days, 5 hours, 32 minutes, 7 seconds.
vmail*CLI> realtime mysql status
Connected to
2011 May 18
1
asterisk18 - realtime/mysql - take 3
Still a couple of questions......
I did configure extconfig.conf
...
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
;sipusers => odbc,asterisk
sipusers => mysql,asterisk,sip_devices
sippeers => mysql,asterisk,sip_devices
;sippeers => odbc,asterisk
;sipregs => odbc,asterisk
;voicemail => odbc,asterisk
;extensions => odbc,asterisk
;meetme => mysql,general
2007 Aug 06
1
CDR/MySQL basic config
Hi,
I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install. The
add-ons pack has been installed for a while, so now I'm trying to add
the Mysql config.
I've created a mysql database, added the grants for a user acces, and
can run a mysql -u asteriskcdruser -p and can connect to the database.
I've been using this as a guide:
2008 Jun 17
2
Problem with realtime?
I get that a lot since moving to 1.4.21 (from 1.4.18 or something).
[Jun 17 09:19:54] WARNING[22053]: res_config_mysql.c:360 update_mysql: MySQL
RealTime: Failed to query database. Check debug for more info.
Question 1: what debug file should I be looking at?
Mick
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2004 Nov 30
1
realTime configuration help needed
Hello all,
I recently noticed the realTime effort
and must say it is a nice idea!
I would appreciate any help to get it running ..
I downloaded the code & patches and succefully patched my asterisk
(CVS-HEAD-11/29/04-12).
- created a DB called asterisk, and a table sip using the schema
supplied at
http://bugs.digium.com/bug_view_page.php?bug_id=0002613.
- entered an entry:
insert into