Displaying 20 results from an estimated 1000 matches similar to: "MySQL RealTime Error"
2010 Jan 27
1
Realtime Queue not work in 1.6.2.1
hi,all
i have just upgrade from 1.4.28 to 1.6.2.1. all works fine now except
realtime queue.
it seems queue_table works fine, but queue_member_queue not work, the
two tables works fine when in 1.4.28.
is that something changed related to realtime queue configuration?
more detail about two table definition and data stored in , please see:
http://pastebin.com/m33f9539e
the extconfig.conf file,
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
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]:
2010 Sep 13
0
Upgrade from 1.4 to 1.6 : problems with realtimemysql
This is a problem with extconfig.conf - not your res_ or cdr_ ones.
In your case - extconfig.conf probably contained something like
'sippeers => mysql,MyDBase,sippeers'. The 'problem' is that the middle
parameter is no longer for the database name - it is for the context in
res_mysql.conf. So, the above now becomes 'sippeers =>
mysql,general,sippeers'. Give that a
2016 Mar 31
3
mail filter plugin script doesn't effective
output of *dovecot --version*:
Dovecot version : 2.2.9
-----
output of *doveconf -n:*
auth_debug = yes
>
> auth_mechanisms = plain login
>
> auth_verbose = yes
>
> disable_plaintext_auth = no
>
> mail_debug = yes
>
> mail_location =
> maildir:/var/mail/vhosts/%d/%n:LAYOUT=fs:DIRNAME=dovecot_maildir
>
> mail_plugins = " mail_log notify mail_filter"
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
2010 Jan 25
1
MYSQL grammar diff in 1.6.2.1?
hi, dear all
MYSQL commands work well in 1.4.28 edition, but not in 1.6.21
is that the grammar is different between them?
extensions.conf
exten => s,2,MYSQL(Query resultid ${connid} SELECT\ callerid\ from\
blacklist\ where\ companycode = ${ARG2} and callerid=${ARG1} and
blockenabled = 1)
cli:
-- Executing [s at macro-checkblacklist:2] MYSQL("SIP/1003-00000006",
"Query
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]:
2006 Mar 07
7
res_mysql.conf & DNS SRV lookup
Hi friends,
I am using Real Time Asterisk Architecture where I have put the
Sip users/peers and extensions defining the dialplan in tables in
a mysql database.
Currently, asterisk points to my single database server as configured:
------------------------------------------
/etc/asterisk/res_mysql.conf
------------------------------------------
[general]
dbhost = xxx
dbname =
2014 Jun 10
1
Mixing res_mysql and res_odbc
Hi
Is there any harm in using res_mysql for some things and res_odbc for
others?
We already use res_mysql for ARA but could do with having CEL logged to
MySQL.
Thanks in Advance
Ish
--
Ishfaq Malik
Department: VOIP Support
Company: Packnet Limited
t: +44 (0)845 004 4994
f: +44 (0)161 660 9825
e: ish at pack-net.co.uk
w: http://www.pack-net.co.uk
Registered Address: PACKNET LIMITED, Duplex
2007 May 23
1
Asterisk Realtime problem
Hi,
I have installed asterisk-1.4.4 and asterisk-addon-1.4.1.
I followed every step to configure RealTime but something is not working
properly; the warning that I am geting is:
WARNING[32709]: config.c:1229 find_engine: Realtime mapping for
'sippeers' found to engine 'mysql', but the engine is not available
WARNING[1359]: config.c:1229 find_engine: Realtime mapping for
2006 Feb 23
1
mysql problems
My database machine is broken and I have to use another one.
I made somewhere mistake(s) and get now in the debug file:
[Feb 24 09:05:24] DEBUG[32664]: MySQL RealTime: Query: SELECT * FROM
sip_buddies WHERE name = '886'
[Feb 24 09:05:24] DEBUG[32664]: MySQL RealTime: Query Failed because:
Can't find file: './astconf/sip_buddies.frm' (errno: 13)
[Feb 24 09:05:25]
2011 Feb 17
1
Realtime MySQL - Asterisk 1.8.2
Hi to all.
I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem,
the asterisk don't connect in the base and show this message:
[Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441
realtime_multi_mysql: MySQL RealTime: Invalid database specified:
'asterisk_teste' (check res_mysql.conf)
I checked the asterisk config file (res_mysql.conf) and the configuration
2010 Mar 02
1
Does Asterisk 1.6.2.1 Support SIP TLS encryption
hi, all
i want to realize more secure communication between asterisk sip end users.
so i want to know Does Asterisk 1.6.2.1 Support SIP TLS encryption?
if you can tell me same specific example to do encrypt, it's very appreciated.
Thanks!
--
Best regards,
Sucan
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
2007 Jun 08
5
Write to multiple databases as redundancy scheme
Hi,
Can Asterisk write to multiple MySQL databases in different machines,
at the same time, as a backup scheme?
If it does, where can that be configured? In res_mysql.conf file?
Does anyone ever made it?
Regards,
Ricardo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
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 Nov 02
1
res_mysql versus res_odbc
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 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