similar to: ASTCC - error on call end

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

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

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 =

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

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

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

Hello, I have some problem using ASTCC application. I've installed the application and everything works well. I've created card numbers, routes trunk and others. When I dial the desired number (77) in my case, I'm prompted to enter my card number. All goes well till I'm prompted to enter the destination number. When I enter a destination number, the system says it's not a

I am looking for the most stable version of Asterisk to use with ASTCC for a production environment. It does not appear that any of the Stable versions will be suitable since they do not support US PRI ANI Info digit collection and hence could not apply surcharges for payphone use, etc. Is there a specific CVS Head version date that includes the II updates and has proven to be stable enough to

I set up certain routes in my ASTCC application to be free of charge. When a user attempts to dial one of these numbers, the announcement plays the prompts "This call will cost", "nothing", and then terminates the script, dropping the call, leaving the card locked in the database as being in use. Any ideas? Sincerely, Trevor Hammonds -------------- next

Hi guys, do you know if it's possible to handle more than 1 call per card with astcc ? Thank you.

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

I'm looking at astcc and it seems that setting up a script that will allow multiple people to access a calling card simultaneously would be fairly difficult. Before I endevour to develop this, has anyone already done it/looked at this/can point me in the right direction? Thanks. -- Mike Nugent <asterisk@illuminatus.org>

Hie! I've installed Asterisk CVS-HEAD with ASTCC. The problem i'm facing is that the astcc.agi script completes when the recipient picks up the call. When the astcc.agi completes is returns 0 bill time but both end still able to talk. It occurs intermittently, any one facing the same issue? Asterisk Console ----------------- == Spawn extension (sip, 7777771111, 2) exited non-zero on

I have this error compiling ASTCC: [root@pbx astcc]# make install mkdir -p /var/www mkdir -p /var/www/html/_astcc mkdir -p /var/www/cgi-bin/astcc-admin chmod 755 ./astcc.agi chmod 755 ./astcc-admin.cgi echo | ./astcc.agi >/dev/null Can't locate DBI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.0/i386-linux-thread-multi /usr/lib/perl5/5.8.0

So I have a route with [1-9][0-9][0-9][1-9][0-9]* as a base route that should match NXXNX. Right? I built another route 01144[0-9]* that I thought would match 01144X. and send the call to the UK but the script is matching 01144207108???? With the first route. Can someone smarter than me help with some samples? Please? If I can get one for 1NXXN. and 01144. I should be able to figure the rest

Hi all I am wondering if anyone has had a similar trouble to this: The timeout arguments in the dial command does not work. The caller does not get disconnected when the timeout reaches zero. I am not sure if this is a chan_capi issue, or a asterisk issue. I am using CVS-head and chan_capi CVS head also. Any suggestions or help will be appreciated. Thanks Clive

Hi all I have been using * for a couple of month and now I wanted to install the Asterisk Calling Card. But when I try to install I get the following error: [root@terraserver1 astcc]# make install mkdir -p /var/www/html/_astcc mkdir -p /var/www/cgi-bin/astcc-admin chmod 755 ./astcc.agi chmod 755 ./astcc-admin.cgi echo | ./astcc.agi >/dev/null Detected dry run! ./astcc-admin.cgi

How do you set the expiration date in ASTCC? DO you have to customize the CGI script? A maintenance fee field would be nice as well. Anybody? -- Kelly D Griffin Network Engineer Tantella Wireless http://tantella.com 479.273.9992 Voice 479.464.8998 Fax

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;