similar to: ASTCC MySQL CDR

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

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

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 =

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

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

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

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 download and installed ASTCC over the weekend and I am having an issue where the INUSE flag will not get set back to 0 if the user drops a call while the balance is being played. All other times it seems to reset the flag correctly. I have tried both AGI and DeadAGI with the same results. Those of you using it for a while, how did you get around this? Just for fun this is all I am doing in

Hi, alhtough i googled for details concerning ASTCC i did not found an aswer to the following: Should i put in my extensions.conf the configuration of the astcc? I ask this because as i see it, in the end of the extensions.conf there is an include statement : #include /var/lib/astcc/astcc-exten.conf Should the config been done in the astcc-exten.conf file or the initial extensions.conf

Hi, When trying to compile ASTCC i am getting the following error: root@asthome:/usr/src/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 Asterisk/AGI.pm in @INC (@INC contains: /usr/lib/perl5/5.8.6/i486-linux /usr/lib/perl5/5.8.6

Hi: Astcc is working fine, except for one thing. It doesn't give the called party enough time to answer the phone. If nobody picks up in two rings, astcc reports back no answer and hangs-up. The only instant NOANSWER "value" was mentioned in astcc.agi script is: elsif ($res eq "NOANSWER") { $res = &mystreamfile("astcc-noanswer");

Hi all I have asked this question before but have not got any helping input. I'm really new to this and need some explanation about ASTCC. So here is the question again. In the ASTCC web admin there are Trunks, Routes, IAXFriends, SIPFriends, Brands, Cards. As I understand Brands is not used, Cards just makes the cards. Routed in the dialplan and pricelist, Trunks is for ASTCC to

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

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

What has been changed at the ASTCC from the previous head to the current one? How to use the PIN? Can I avoid it? bye Ronald

Hi: Iam using an asterisk server with astcc ,iam facing a problem with astcc that when the call is hangup sometimes astcc doesnt calculate the call cost and the call time and without writing the call status on cdrs table . I tried to run this command "realtime mysql status" on the asterisk console and that what i've got: [Oct 27 01:05:32] ERROR[2607]: res_config_mysql.c:637

Good Day Has anybody here looked closely at the call cost calculation in ASTCC? Can you duplicate the way the cost of a call is calculated? I believe that there is an error in the code. I have fixed it, I think and submitted a patch but we need user comments. I would appreciate if anybody involved would slip over to chech out this link on the bugtracker and provide feedback.

I currently have my astcc databases card lenghts at 7 digits long. I would like to expand this to 10 digits now though. Will I screw things up if I leave the old 7 digit long pins in there and start using/generating 10 digit pins? Thanks