Displaying 20 results from an estimated 4000 matches similar to: "Problem with 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:
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
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
2008 Jan 31
0
Realtime device update weirdness
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]:
2011 May 19
2
[Fwd: FW: realtime mysql - p4]
Ok, i tried the suggestion:
Instead of:
sippuser => resource, database_name, table_name
sippeer => resource, database_name, table_name
I put in:
sippuser => resource, context, table_name
sippeer => resource, context, table_name
Unfortunately, with the same results.
btw i tried both "general" as "default"
Besids the commands i tried below, isn't there any
2009 Feb 20
1
real time connection failed
Dear Sir,
Kindly note that I'm getting the following error when trying to register on
asterisk server:
[Feb 20 17:12:32] WARNING[2865]: res_config_mysql.c:358 update_mysql: MySQL
RealTime: Failed to query database. Check debug for more info.
I can connect to the database using the username and password defined inside
res_mysql.conf but still getting the issue
Regards
-------------- next
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 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:
2008 Mar 25
1
Have problem with realtime sql
Hi,
I am having a strange problem with attempting to get voicemail-to-mysql to
work.
The biggest problem is that I am not able to store voicemail into database.
So, I followed the
instructor found on the web:
Updated the /usr/src/asterisk/apps/Makefile to have
USE_MYSQL_VM_INTERFACE=1 and recompiled asterisk, with
make clean; make; make install
(By the way, is it necessary to update the Makefile
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
2008 Mar 27
1
Problem when leaving voicemail
Hi,
I am investigating an issue with voicemail and realtime.
What we are seeing is the following:
1. Caller calls in and goes to an IVR
2. Presses 101 to go to voicemail
3. app_voicemail start and tries to connect to the database trhough
res_config_mysql. However, it takes too long to be able to connect (~15
minutes)
It seems like it first attemots to connect to the database on 16:25:03 and
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
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
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'
2016 Sep 12
2
Mysql PJSIP realtime > 13.10?
On Mon, Sep 12, 2016 at 3:01 PM, Carlos Chavez <cursor at telecomabmex.com>
wrote:
> On 9/12/16 3:39 PM, George Joseph wrote:
>
>
>
> On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph at digium.com> wrote:
>
>>
>>
>> On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor at telecomabmex.com>
>> wrote:
>>
>>> Has
2016 Sep 02
2
Asterisk 13.11 realtime problem registering phones
I upgraded my office installation from 13.10 to 13.11 yesterday and
now I am having problems registering phones. Here is what I get on the CLI:
[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162 require_mysql:
Realtime table general at ps_contacts: column 'qualify_timeout' cannot be
type 'int(10)' (need char)
[Sep 2 15:38:46] WARNING[2098]: res_config_mysql.c:1162
2016 Sep 12
4
Mysql PJSIP realtime > 13.10?
Has anyone successfully used Mysql realtime PJSIP with Asterisk
13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the
following error now:
Sep 12 14:42:35] WARNING[24498]: res_config_mysql.c:1162 require_mysql:
Realtime table general at ps_contacts: column 'qualify_timeout' cannot be
type 'int(10)' (need char)
[Sep 12 14:42:35] WARNING[24498]:
2016 Sep 12
3
Mysql PJSIP realtime > 13.10?
On Mon, Sep 12, 2016 at 2:31 PM, George Joseph <gjoseph at digium.com> wrote:
>
>
> On Mon, Sep 12, 2016 at 2:14 PM, Carlos Chavez <cursor at telecomabmex.com>
> wrote:
>
>> Has anyone successfully used Mysql realtime PJSIP with Asterisk
>> 13.11? I have tried 13.11, 13.11.1 and 13.11.2 but I always get the
>> following error now:
>>
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 Jul 12
1
bristuff patches and realtime mysql
Hi!
I have a problem compiling the res_config_mysql.so after successfully
compiling and installing asterisk with the bristuff package/patches. I
get lots of compiler errors.
When inserting a previously compiled res_config_mysql.so into the
bristuff-patched Asterisk, I get an error on startup and Asterisk
crashes.
Anyone using res_config_mysql.so with the bristuff package and can help
me?
Thanks,