search for: callstart

Looking at the code, it would appear that the 'callstart' column of the cdrs table should really be called 'callend': $dialstr = "IAX2/$res->{path}/$phone|30|HL(" . ($maxtime * 60 * 1000) . ":60000:30000)"; $res = $AGI->exec("DIAL $dialstr"); $answeredtime...

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? -- rrgv

...risk 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 => { MYSQL(Connect connid ${DBHOST} ${DBUSER} ${DBPASS} ${DB}); MYSQL(Query resultid ${connid} SELECT TIMEDIFF(callend,callstart) FROM tblCall WHERE id=7); MYSQL(fetch fetchid ${resultid} temp); MYSQL(Disconnect ${connid}); } } </CODE> The error I'm getting is below: [Mar 6 08:59:35] WARNING[27116]: app_addon_sql_mysql.c:268 aMYSQL_query: aMYSQL_query: mysql_query failed. Error: You have an error in you...

The time stamps in ASTCC are useless as they are now: Fri Jul 22 15:06:25 2005 Wouldn't it be better to use something like: 2005-07-22 15:06:24 Fri I want to sort the records by date, but with the format now it is impossible... or do I miss something? bye Ronald Wiplinger

...4102 3254102 moh2 3 3254102 3254101 3254102 moh2 4 3254102 3254101 3254101 moh1 Am I possibly doing something wrong with mohsuggest? sip.conf: [general] context=default allowoverlap=no bindport=5060 bindaddr=0.0.0.0 srvlookup=yes [3254101] type = friend context = CallStart username = 3254101 accountcode = 3254101 qualify = yes canreinvite = no host = dynamic dtmfmode = rfc2833 nat = no callerid = Douglas Garstang <3254101> secret = password mohsuggest = moh1 [3254102] type = friend context = CallStart username = 3254102 accountcode = 3254102 qualify = yes can...

...IME"); $dialstatus = $AGI->get_variable("DIALSTATUS"); print LOGFILE "Dialstring: $dialstr DIALSTATUS: $dialstatus\n"; $callstart = time(); if ($dialstatus eq "ANSWERED") { last; } } } } Here's the output from my logfile: Call 1: Dialstring: sip/16416418003569377 at tollfree.sip-happens.com|...

...inc is $carddata->{inc}\n increment is $increment"; $carddata->{used} += $cost; print STDERR "Total used is now $carddata->{used}\n"; &savecdr($cardno, $callerid, $phoneno, $trunk, $res, $answeredtime, $cost,$callstart); &savedata($carddata); The result is: [Jul 23 12:20:29] == Spawn extension (Line-optimize, 901185228376786, 512) exited non-zero on 'Local/901185228376786@Line-optimize-3a9b,2' res is ANSWER, answered time is 26 Adjusted time is , cost is 603 with 0 fee Total co...

Hello. I have set up ASTCC properly, calling it like this: DeadAGI(${ACCOUNTCODE},${EXTEN}) It seems to be working correctly, but I have two questions: - Although the cards' credit seems to be maintained correctly, I cannot see the call details in astcc-admin. When I try to view information on the card, it's just blank. Any ideas? - When does the 2nd, 3rd and 4th trunk get used? I have

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 the user's selection. There are a couple of options within the IVR that allows the user to speak with a live customer service rep. So, in those cases, we do a AGI exec to Dial out to the c...

Hi, i downloaded and installed ( a week ago) ASTCC. I 've read that there was a patch for astcc.agi that corrected cards in use e.t.c. I suppose that this patch was in the latest CVS which i download and installed. I 've also modified the cdrs table by adding the callstart column in astcc db. My calling card applications seems to work but my cdrs only keep the first record for every calling card. If i place a new call from my calling card the new call is not being logged in the mysql. I get a cdr for every card but only one. Even if i call two or three times fro...

hello *'s, Astcc not workin what is correct format for defining 1-database 2-brands 3-trunks 4-routes i define all these things but not workin may be i define in wrong format.I have FXO card installed.can anyone implement it and also my sip phone generates very loud noise wat is that i tried several settings but not hear any voice just noise. sip.conf [general] context=from-sip port=5060

...A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 print LOGFILE "Dialstring: $dialstr > DIALSTATUS: $dialstatus\n"; > > > > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 $callstart =3D time(); > > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 if ($dialstatus eq "ANSWERED") { last; } > > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 } > > =A0=A0=A0=A0=A0=A0=A0=A0=A...

...=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 print LOGFILE "Dialstring: $dialstr > DIALSTATUS: $dialstatus\n"; > > > > = =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 $callstart =3D time(); > > = =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0= =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 if ($dialstatus eq "ANSWERED") { last; } > > =A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0=A0 = } > > =A0=A0=A0=A0=A0=A0=A0=...

hi Today I?ve installed, apache 2.0.52, mysql-4.1.7, asterisk-perl-0.08 and ASTCC prepaid card aplication from CVS, so now I have access to the astcc-admin.cgi from web server http://asterisk/cgi-bin/astcc-admin/astcc-admin.cgi and I?ve been able to create the database from "Configure" menu but I have some doubts to continue: - Do I have to reinstall asterisk with mysql support? -