similar to: ASTCC -- semantic note of 'callstart' in cdrs?

Hi, I am having a strange problem with enum and AGI. Here is what happens: I have in my agi something like that: foreach my $resolver ("e164.arpa", "e164.info", "e164.org") { my @enums = get_enums($phone, $resolver); foreach my $enum (@enums) { $dialstring = $enum .

I try to track down an error that causes that Astcc just reports the time, but not the costs. I could narrow the problem down into this sub routine: sub calccost() { my ($adjconn, $adjcost, $answeredtime, $increment) = @_; eval { my $adjtime = int(($answeredtime + $increment - 1) / $increment) * $increment }; my $cost; print STDERR "Adjusted time is $adjtime, cost is $adjcost with

Hello list, I just came into a strange problem wth astcc. the trouble is astcc.agi does not bill some calls. The calls are logged in the cdr-csv/Master.csv file, but with a duration of 0, billsec of 0, an empty dstchannel, and with a lastapp field of "hangup". I suppose that astcc.agi was not able to get the answeredime variable from the SIP channel... I have added a few functions to

Dialing out If the AGI application dials outward by executing Dial, control over the call returns to the dialplan and the script loses contact with the Asterisk server. The script continues to run in the background by itself and is free to clean up and do post-dial processing. If you want your application to initiate a call out without being started through the dialplan: * Asterisk auto-dial

Dialing out If the AGI application dials outward by executing Dial, control over the call returns to the dialplan and the script loses contact with the Asterisk server. The script continues to run in the background by itself and is free to clean up and do post-dial processing. If you want your application to initiate a call out without being started through the dialplan: * Asterisk auto-dial

Hello list, I'm having some problem integrating the SELECT TIMEDIFF() and SELECT DATEDIFF() in my code. The syntax I'm using works without any problems if I run them directly from the MySQL Client, but from the Asterisk Dialplan it just wont work. Is there a limitation in the MySQL() application for the Asterisk dialplan that produces this error? <CODE> context testsql { s =>

Hi List, In one of my AGIs (using DeadAGI) I grab the answered time using: my $res = $agi->exec ("DIAL $dialstring"); my $answeredtime = $agi->get_variable ("ANSWEREDTIME"); However this information differs from what's written in the Master.csv file (which happens to be the correct value!) Any ideas why? I'm using asterisk 1.2.7.1 and the

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, I've been using for a long time asterisk-perl-0.08 for prepaid card applications, and I've identified a problem with the last releases of asterisk-1.2, installed with Trixbox. The command get_variable() raises a signal SIGPIPE when it is called (whatever the variable to get). I made tests with Asterisk 1.2.20, 1.2.21 and 1.2.22, and I

Hi, We have a "simple" AGI script that provides some IVR functionality. It connects to a MySQL database in order to create a call record and capture IVR data. During the IVR process, we need to store the time the call started, so basically we INSERT a new MySQL row with callstart = NOW(), uniqueid = AGI(agi_uniqueid). As the user selects different options, we update the row to reflect

Hi, I have set-up astcc with outgoing sip channel. Call processing works fine but after the call tables, CDR and Cards does not get updated. At the beginning it goes to the database and fetch card details and correctly provides the card balance etc. Also it indeed write the inuse field (so writing and reading from database works fine). I've inserted a break point as such in the code;

Hello, I'm writing a AGI Perl script and use the following lines to initiate a call : $res = $AGI->exec("DIAL $dialstr"); And then : $answeredtime = $AGI->get_variable("ANSWEREDTIME"); The problem is that I need to know immediately when the call has begun. I can have the call duration & establishment time at the end of the call but not in real time when it

Hi I get an error popping up when the call ends as follows: DBD::mysql::db do failed: Unknown column 'callstart' in 'field list' at /var/lib/asterisk/agi-bin/astcc.agi line 90, <STDIN> line 32. Does anyone else get this same thing? Looks as if my database table is wrong, or something else is up...not sure Thanks Clive

I can?t see cdrs for calls completed with astcc app, this is the log in asterisk console: DBD::mysql::db do failed: Unknown column 'callstart' in 'field list' at /var/lib/asterisk/agi-bin/astcc.agi line 90, <STDIN> line 31. -- AGI Script astcc.agi completed, returning 0 cdrs table exist but I am not sure why is empty and why was not created properly, any idea? --

Hi, I am pretty new to Asterisk. I am trying to make sure some human being answers the phone not the voice mail machine. How can I programmatically identify that? Here is my Sub: sub DialPhysician { my ($self, $con, $PhysicianPhone, $call_id, $conv_id) = (@_); to_log($self, "Inside Dial Physician", 2); my $DocPhone = "1".

Hi, I have a * 1.0.3 running on a Gentoo box and I installed Perl AGi from http://asterisk.gnuinter.net/files/asterisk-perl-0.08.tar.gz. When I write this : >#!/usr/bin/perl >use Asterisk::AGI; >my $AGI = new Asterisk::AGI; >$AGI->exec ('Dial SIP/kphone1|30|tTr'); >my $duration = $AGI->get_variable('ANSWEREDTIME'); >print STDERR "\n duration :

I actually need this feature quite badly in my untyped language compiler: since I support first-class functions, I've made the types of all functions a standard vararg (so I can box them). The implementation crashes when I try to read out the value of gc.result. Hints as to what might be wrong? Signed-off-by: Ramkumar Ramachandra <artagnon at gmail.com> ---

Hi All, I have been attempting to get an AGI LCRdialout script to work. Basically what I need to have happen is when someone dials out a number the script check to see if it is local if so, go out the ZAP channel. If the ZAP channel is busy, go out the IAX channels, if IAX is all busy, go out the SIP channels. Here is a sample of what I have in my script. #!/usr/bin/perl use strict; use

Hello, I want to create php rate script and I'm using Deadagi. But I allways get billsec 0 , or nothing. Can you help me to solve this problem... My extension.conf: exten => _123,1,DeadAgi(rate.php) exten => _123,2,hangup And my simple test php script rate.php #!/usr/local/bin/php -q <?php include_once (dirname(__FILE__)."/phpagi.php"); $AGI = new AGI();

Hello, I saw that Asterisk don't calcultate fine the ANSWEREDTIME. I want that when ANSWEREDTIME =~ 5.6 become 6 and if =~10.3 become 10 because, now, if ANSEREDTIME =~ 15.9, it become 15! it isn't correct How can I have a rounded ANSWEREDTIME ? Where have I to manipulate the sources? thank you -- Francois -------------- next part -------------- A non-text attachment was scrubbed...

Hi all, I was coding for Callback application in Perl. I have small question to get the variable name of duration. I seen in CDR table of mysql there is two filed one is duration and second is billsec the billsec value variable is $AGI->get_variable('ANSWEREDTIME') But could you guys tell me the variable name of "duration" field. In this way i want to capture when the first