search for: app_mysql

Hi All, Please refresh my memory. I am trying to install asterisk after 2 years. I hav'nt used it since 2008 (version 1.4.2). Now I am trying to install 1.8.0-rc2 on centos 5.5 but getting the following errors. app_mysql.c:33:25: error: mysql/mysql.h: No such file or directory app_mysql.c: In function ?mysql_ds_destroy?: app_mysql.c:135: warning: implicit declaration of function ?mysql_close? app_mysql.c:138: warning: implicit declaration of function ?mysql_free_result? app_mysql.c: In function ?aMYSQL_connect?: ap...

...version of Asterisk. However, due to a problem I had to update. Update reporting system is broken when you have made. Current version 11.10. I installed the modules in the system for problems that are missing. I getting error as follows. ^[[A[Sep 24 03:16:50] WARNING[3624] loader.c:* Module 'app_mysql.so' was not compiled with the same compile-time options as this version of Asterisk.* [Sep 24 03:16:50] WARNING[3624] loader.c: Module 'app_mysql.so' will not be initialized as it may cause instability. [Sep 24 03:16:50] WARNING[3624] loader.c: Module 'app_mysql.so' could not be...

...y from extensions.conf, there's already a source file floating around for using a MYSQL application to do SELECT queries. We're using the MYSQL app a lot in our exensions.conf, but we missed support for queries that don't return a result like UPDATE or INSERT. Here's an updated app_mysql.c which introduces the Execute command. Sample: exten => s,300,MYSQL(Connect connid ${HOST} ${USER} ${PASSWORD} ${DATABSE}) exten => s,301,MYSQL(Execute resultid ${connid} UPDATE table SET haveSetting = 1 WHERE dnid=\'${CALLERIDNUM}\') exten => s,302,MYSQL(Disconnect ${connid})...

...;SIP/vart-00000336", "Query resultid 4 DELETE FROM pickuptbl WHERE pickmark LIKE "%SIP/vart2-00000336%"") in new stack [May 5 11:46:27] -- Executing [s at sub:5] MYSQL("SIP/vart-00000336", "Clear 6") in new stack [May 5 11:46:27] WARNING[17803]: app_mysql.c:194 find_identifier: Identifier 6, identifier_type 2 not found in identifier list [May 5 11:46:27] WARNING[17803]: app_mysql.c:510 aMYSQL_clear: Invalid result identifier 6 passed in aMYSQL_clear [May 5 11:46:27] -- Executing [s at sub:6] MYSQL("SIP/vart-00000336", "Discon...

Hello all. I am trying to use app_mysql. It works for selects and functions, but does not want to work with procedures. Pls have a look: Calling function: CREATE FUNCTION f_1(a VARCHAR(20)) RETURNS INTEGER RETURN (SELECT count(*) from peer where name = a); Result: -- Executing Macro("IAX2/100-3", "local|100") in...

Thanks a lot for the reply. I did follow that already, but i do have a problem. Here is my extensions.conf part for that particular number exten => 6912345678,1,Answer() exten => 6912345678,n,MYSQL(Connect connid 127.0.0.1 root mypasswd asterisk) exten => 6912345678,n,MYSQL(Query resultid ${connid} SET NAMES utf8) exten => 6912345678,n,GotoIf($["${connid}" =

...I'm trying to connect Asterisk to the MySQL, but I can't execute it. It returns an error, as below: -- Executing [200 at teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200") in new stack [Feb 18 15:55:13] WARNING[7696]: app_mysql.c:393 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200' at line 1 Its seems it can connect to mysql...

Hello everybody, I've been using asterisk 1.2 for quite a long time now, but I thought it's time to try a newer version of asterisk. So I downloaded 1.8.5, extracted the tar, ran configure, make, make install ... Everything looks fine (no obvious compile/link errors). But as soon as I start asterisk, it dies with a segfault. I executed asterisk within strace and last action before the

...CLI> module show like mysql > Module Description Use Count > cdr_mysql.so MySQL CDR Backend 0 > res_config_mysql.so MySQL RealTime Configuration Driver 0 > app_mysql.so Simple Mysql Interface 0 > 3 modules loaded > kc3054*CLI> > kc3054*CLI> sip show users > Username Secret Accountcode Def.Context ACL ForcerPort > j.witvliet geheim...

...rote: > I would still like to know where the Aterisk mysql timeout duration > comes from, and whether it can be configured. In the case of cdr_mysql, the connect timeout is configurable by putting the following in cdr_mysql.conf: [global] timeout = 5 ; Set connect timeout to 5 seconds For app_mysql, setting the connection timeout is shown in the documentation: *CLI> core show application MYSQL Kind regards, Sean

Hello, I am using CDR mysql to log to remote server: in modules.conf, I preload the modules: [modules] preload => cdr_mysql.so preload => app_mysql.so and in cdr_mysql.conf, I have all the details defined (hostname, dbname, table, password, user, port). In a situation when I start asterisk, and the remote database in unreachable, asterisk waits for several minutes before it actually starts (before it loads sip module, etc). And when databas...

> On 2020-06-06 10:38, Antony Stone wrote: > On Saturday 06 June 2020 at 09:18:11, Fourhundred Thecat wrote: > >> In a situation when I start asterisk, and the remote database is >> unreachable, asterisk waits for several minutes before it actually >> starts (before it loads sip module, etc). >> >> And when database is unreachable during operation, when call

I am trying to enable full WebRTC support on asterisk-11.15 for installation on a CentOS 5 machine. Currently the distro cannot be upgraded to any later CentOS series. This CentOS series ships with openssl-0.9.8e, which lacks DTLS-SRTP support required for WebRTC. So I decided to build a parallel install of openssl. I chose the Fedora 21 package, openssl-1.0.1j, and built it on CentOS 5. The