Displaying 20 results from an estimated 1000 matches similar to: "Realtime - mysql query gives wrong results??"
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]:
2004 Dec 03
1
compiling asterisk-addons for Mysql-cdr
Hi ALL;
I got the latest Asterisk-addons for Mysql-Cdr, but I have problem compiling that.It says:
# make
.....
........
res_config_mysql.c: In function `realtime_mysql':
res_config_mysql.c:143: warning: passing arg 1 of `ast_strlen_zero' makes pointer from integer without a cast
res_config_mysql.c: In function `realtime_multi_mysql':
res_config_mysql.c:242: warning: passing arg
2005 Feb 02
6
problem in compiling asterisk-addons
there is a problem in compiling asterisk-addons
any one have fixed this problem. i want
res_config_mysql.so any one help me
-----------------------------------------------------
[root@localhost asterisk-addons]# make
cc -fPIC -I../asterisk -D_GNU_SOURCE
-I/usr/include/mysql -c -o res_config_mysql.o
res_config_mysql.c
res_config_mysql.c: In function `realtime_mysql':
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`
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 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
2007 Dec 19
3
Realtime logic in Asterisk 1.4.16.1
Hello,
I have configured one provider in Asterisk Realtime DB without username and password, only host=<providers_IP> and ipaddress=<providers_IP>
Now when I'm trying to send call using this provider I'm using following string: Dial(SIP/NUMBER at Provider)
In Asterisk 1.4.15 debug I see that Realtime engine is using query:
[Dec 20 00:02:15] DEBUG[14634]:
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]:
2010 Sep 08
1
Upgrade from 1.4 to 1.6 : problems with realtime mysql
Hello,
in asterisk 1.4.30 all realtime configurations go well.
In asterisk 1.6.2.11 the following appears on CLI :
[Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql:
MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf)
[Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql:
MySQL RealTime: Invalid database specified: MyDBase (check
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
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.
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
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:
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 :
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
2010 Jan 25
1
MySQL RealTime Error
hi,all
when i upgrade from 1.4.28 to 1.6.2.1, i can't connect to mysql
database anymore, error as follow:
[Jan 25 15:38:25] WARNING[3003]: res_config_mysql.c:325
realtime_mysql: MySQL RealTime: Invalid database specified: asterisk
(check res_mysql.conf)
the content of res_mysql.conf is:
http://www.pastebin.org/81966
i've try command " mysql -uroot -proot" ,i can connect to
2005 Mar 23
0
Asterisk Realtime.
So this is what i've done so far...
my extconfig.conf looks like this
[settings]
;example => odbc,asterisk,alttable
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
sipusers => mysql,voip,sip
sippeers => mysql,voip,sip
voicemail => mysql,voip,voicemail
extensions => mysql,voip,extensions
--------------------
and my extensions.conf has the following lines in it.
2010 Oct 05
0
Chage Asterisk 1.6.1 to 1.6.2
Hi
A question, i have upgraded a beta serveur from Asterisk 1.6.1 to 1.6.2
and now all SIP Relatime user are rejeted :
[Oct 5 05:39:22] DEBUG[15081]: chan_sip.c:21639 handle_incoming: ****
Received REGISTER (2) - Command in SIP REGISTER
[Oct 5 05:39:22] DEBUG[15081]: chan_sip.c:21658 handle_incoming:
Ignoring SIP message because of retransmit (REGISTER Seqno 44199, ours
44199)
[Oct 5
2009 May 03
2
Asterisk not starting up due to database problems
When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off?
Thanks
Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others.
Created by Mark Spencer <markster at digium.com>
Asterisk
2004 Dec 30
1
RealTime Drivers Connectivity Error
Hello *'s,
i am using Realtime Sip drivers but its not working here is my configs:
extconfig.conf
[settings]
; Realtime configuration engine
;
; maps a particular family of realtime
; configuration to a given database driver,
; database and table (or uses the name of
; the family if the table is not specified
;
sipfriends => mysql,asterisk,sip_friends
res_mysql.conf
[general]
dbhost =