similar to: Query Failed because: Incorrect information in file: './asterisk/sip.frm'

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':

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

Hello I am trying to get asterisk-addons installed so that I can use the mysql cdr feature. OK, I have the MySQL server (mysqld) installed, but I noticed that mysql-devel is also required. I tried to compile asterisk-addons and got a: --CUT--- res_config_mysql.c:422: error: unknown field `realtime_multi_func' specified in initializer res_config_mysql.c:422: warning: excess elements in

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

hello, I tried to compil asterisk-addons-1.6.2.0-rc1, and I have that error: [CC] res_config_mysql.c -> res_config_mysql.o res_config_mysql.c:1367: error: unknown field ?update2_func? specified in initializer res_config_mysql.c: In function ?parse_config?: res_config_mysql.c:1432: error: ?CONFIG_STATUS_FILEMISSING? undeclared (first use in this function) res_config_mysql.c:1432: error:

Hi i have installed a new Asterisk server on Fedora. My first server use Asterisk 1.6.x with a MySQL CDR and realtime. I have a small problems, when i configure on the new server, the same information in MySQL, we have a error: [Jun 3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to connect database server SSI on myhost.myserver.com (err 2003). Check debug for more info.

Hello, I just checked out the latest CVS and compiled and now get the following error: [res_config_mysql.so] => (MySQL RealTime Configuration Driver) Jan 26 13:03:51 WARNING[27081]: config_old.c:27 ast_load: ast_load is deprecated, use ast_config_load instead! == Parsing '/etc/asterisk/res_mysql.conf': Found Jan 26 13:03:51 WARNING[27081]: res_config_mysql.c:561 parse_config: MySQL

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

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

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: >>

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

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]:

Ia had a server overload today because someone did a call forward to their own extension. To do a call forward I write a key called CFWD with the extensi?n number and number to dial . The main script tests if the key/value exists and dials the number stored in the database. What is an easy way to prevent dumb people from creating a loop? -- Telecomunicaciones Abiertas de M?xico S.A. de

Hello using Asterisk 1.8.32. I notice that there is a spontaneous reboot of the Asterisk system from time to time. When I look in the logs (verbose file) I noticed that every time this occurs it's at a moment that there is a MySQL action, be it a lookup or an insert/update/delete. I must say I do have some MySQL queries that occur in my dialplan when a call comes in, to look up

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

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

Dear All, I' I have a problem in installing asterisk 1.4.0. how can i compile res_config_mysql.c in astersisk-addons dir. I've downloaded asterisk-addons-1.4.0 compiling and installing it. But i can't found shared object of res_config_mysql.so. My system is : Debian Linux 3.1 Kernel 2.6.8-11 asterisk-1.4.0 zaptel-1.4.0 asterisk-addons-1.4.0 libmysqlclient using apt-get webserver :

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

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

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