similar to: CEL ODBC problem in 1.8.0

Hi, ? I want queues.conf to be stored on a MySQL database using dynamic realtime. I am using asterisk 11.2.1 and?MySQL 5.1.67, the?MySQL database is hosted on?another server but?I can access the?database via ODBC. ? I have created the following tables: ? SQL> show tables; +-----------------------------------------------------------------+ |

> Hi All > > I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. > > The curious thing is I can find them all inside the database. > I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. > > "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e

On Sat, 25 Apr 2015 17:11:34 +0200 jg <webaccounts173 at jgoettgens.de> wrote: > > > Hi All > > > > I have dozens of these messages on CLI complaining about database > > connection and error writing CDR to disk. > > > > The curious thing is I can find them all inside the database. > > I "selected" them using uniqueid and manually

Hi All I have dozens of these messages on CLI complaining about database connection and error writing CDR to disk. The curious thing is I can find them all inside the database. I "selected" them using uniqueid and manually compared each column with the cdr_adaptive_odbc.c error line. "mysqlcheck -a -e -v DBase" and "mysqlcheck -c -e -v DBase" both returned OK for

Hi list, I'm trying to put my voicemail on asterisk realtime with 11.XX, generate tables in a couple of files in the folder realtime / mysql , voicemail_messages.sql and voicemail.sql the connection with mysql and odbc works well isql asterisk useradmin xxx +---------------------------------------+ | Connected! | | | |

Hi, ? I am trying to store queues.conf to a MySQL database using dynamic realtime. I have a working ODBC connection and the queueing system already works but I want to store the queues.conf file to a database. I am following the guide from Asterisk the definitive guide, the ebook can be found at: http://ofps.oreilly.com/titles/9781449332426/asterisk-DB.html ? I have a database called asterisk

I have a project that is requiring the use of MS SQL from asterisk. I get an error when the pjsip contact tries to update the contact table. [Oct 15 21:34:55] WARNING[3033]: res_odbc.c:649 ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 22018: [FreeTDS][SQL Server]Conversion failed when converting the varchar value '3.000000' to data type int. (101) The datatype

>> Hi All >> >> I have dozens of these messages on CLI complaining about database >> connection and error writing CDR to disk. >> >> The curious thing is I can find them all inside the database. I >> "selected" them using uniqueid and manually compared each column >> with the cdr_adaptive_odbc.c error line. >> >>

I have been testing with asterisk 1.4.11 and have found a segmentation fault while using voicemail. It happens when I try to forward a voicemail. As soon as I press the option the server crashes. I ran asterisk up inside gdb and got the following stack trace ==================================================================== Program received signal SIGSEGV, Segmentation fault. 0x00140adf in

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 04/25/2015 10:51 PM, Ethy H. Brito wrote: > > Hi All > > I have dozens of these messages on CLI complaining about database > connection and error writing CDR to disk. > > The curious thing is I can find them all inside the database. I > "selected" them using uniqueid and manually compared each column > with

Hi everyone, I am getting a segmentation fault (seems to occur randomly) using Asterisk 13.7.0-rc2 with PJProject 2.4.5. It appears to be something that libmysqlclient is complaining about when doing a query in ps_endpoint_id_ips. We are using Asterisk Realtime. This also seems to occur in Asterisk 13.5.0. Below is a backtrace that might help a little. I have looked through the change log for

Hi, I am using Asterisk 11.2.0. Channel Event Logging (CEL) ist activated and running. CEL entries are logged into an mysql database. So far so good. I want to do some extra cel logging and try the following via an AGI-Script: EXEC CELGenUserEvent test In the asterisk logfile I can see the following: -- AGI Script Executing Application: (CELGenUserEvent) Options: (test) (no errors or warnings)

Hi, Later Asterisk releases introduced CEL logging as a promising tool to build various billing-related things. How does it now look to use CEL logging ? Is it easy to check telco bills with CEL, for instance ? Regards -------------- next part -------------- An HTML attachment was scrubbed... URL:

Is there the ability in the Asterisk 1.8 CEL logging to log the SIP endpoint IP as weell as the medie enpoint's ID's? Thanks Bryant -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100917/905bafb0/attachment.htm

Anybody know where to find some good information on the new CEL in asterisk 1.8? I'm very anxious to check out the new logging features but can't find anything but the cel.conf.sample file in the source package. I'd like to get this setup with ODBC. Thanks in advance.

I've recently finished an add-on module for CEL logging to MySQL, and it needs to be tested. The feature is being tracked at https://issues.asterisk.org/view.php?id=19058 And the patch is available at https://issues.asterisk.org/file_download.php?file_id=29110&type=bug Thank You, -Jonathan Penny -------------- next part -------------- An HTML attachment was scrubbed... URL:

Dear list. This is probably a complex subject but is that right to consider: a) each distinct linkedid field value in a mysql CEL table as a unique call? b) the duration of a call as the period (eventtime fields) between BRIDGE_END and BRIDGE_START events of the same linkedid sequence? (not considering transfers) Just a start ... Tks. -------------- next part -------------- An HTML attachment

Dear friends, Need to know filenames of conference recordings in Asterisk 11. Besides directory scanning the recordings could use CEL: Filter MySQL rows with eventtype equal CHAN_START and channame like ConfBridgeRecorder and then get the eventtime field and convert to timestamp to complete filename(s). Would you suggest any other approaches? Thanks. -------------- next part -------------- An

Dear friends, In Asterisk 11.7.0, is it possible to receive CEL APP_START and APP_END events from Park application? Queue and Dial apps are generation these events, but Park no. It doesn't seem to make difference when configured. cel.conf ... apps = dial,queue,confbridge,park events = ALL ... localhost*CLI> cel show status ... CEL Tracking Application: queue CEL Tracking Application:

No one on this ? Le 10/07/2020 à 18:06, Administrator a écrit : > Hi, > > On Asterisk 16.11.1 when enabling cel I get error with BRIDGE_START > and BRIDGE_END events > > zone-s*CLI> module reload cel > The module 'cel' reported a reload failure >     -- Reloading module 'cel' (CEL Engine) > [2020-07-10 17:57:01] ERROR[16163]: cel.c:428 >