similar to: a2billing

Hello There, I *think* i've setuped the AreskiCC2 Calling Card system right , but i've yet to make any calls out of it , i added a rate card , trunk and defined some rates , generated some users , added 10 dollars in them , okay , now i call any number , it asks me to enter my pin , i do , it tells me i have ten $ , right after that it says sorry you dont have enough funds for this call

Regards! During the use of areski a2billing software I'm getting same problem all the time. Actually, after 15 minutes of speaking to someone over calling card, connection brakes. Installation was as smooth as it could be so I don't think I made same kind of a mess in that domain. This is the only problem in the aplication. In the logs everything seems to be fine. I'am sending You

Hi Folks, After going to the paifull steps of installing AreskiCC and finally being able to access the webinterface, connecting to *, importing rates and setting up accounts I am not being able to make a CALL: No matter what number i try to dial I get the same response: The number you have dialed is currently unavailabel. Please enter thenumber you want to dial starting with 1 for local and

Regards! During the use of areski a2billing software I'm getting same problem all the time. Actually, after 15 minutes of speaking to someone over calling card, connection brakes. Installation was as smooth as it could be so I don't think I made same kind of a mess in that domain. This is the only problem in the aplication. In the logs everything seems to be fine. I'am sending You

Hello All, I manage to configure Asterisk RealTime and now it loads the SIP users/peers from MySQL DB. The table I am using is of A2Billing DB "cc_sip_buddies". Now the only problem I am facing is incoming calls are failing... The ATA which is assigned this DID number is behind NAT and according to Olle's explanations he said "*there's no support for NAT keep-alives

Hello all! I'm currently using Asterisk in conjunction with a2billing and everything seems to be working great so far. Now, all I'm missing is some sort of a GUI to monitor all calls going out through my trunks. I can always do 'sip show channels' or 'sip debug' from the console but I was wondering if there's anything that basically does the same thing but in a nicer,

I am not aware what I have done wrong, but the result is a query of: *Database error:* Invalid SQL: SELECT * FROM WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2005-07-01') ORDER BY calldate DESC LIMIT 0,25 *MySQL Error*: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE

Hi In controller I have this query: @price_stat = Price.find_by_sql("select id, cost, tour_id, unix_timestamp(created_at) from prices") when I try to display result''s created_at column I don''t have any results: <% @price_stat.each do |p| %> <p><%= p.created_at %></p> <% end %> result is empty But if I try without unix_timestamp. ie:

hi, we want to extract the information when the most callers are entering our phone system based on an interval of 15 minutes. this is quite simple (although not perfect) with select calldate, count(*) as anzahl from cdr where calldate > '2019-10-12' group by unix_timestamp(calldate) DIV 900 having ; Unfortunately we have lots of callers who calls multiple times when they are

Hi All, I'm stuck and need some help. I have installed the Asterisk CDR Analyser Version 2.0.1. It mostly works except for the CDR Report. I get the following error even though it lists the CDR details. Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >=

Full_Name: Philip Gross Version: 1.9.0 OS: Linux Redhat 9.0 Submission from: (NULL) (65.57.245.11) Among the many conversions for POSIXct values, there does not seem to be one which will accept an actual POSIX timestamp, e.g. as produced by MySQL's UNIX_TIMESTAMP() function. I have fixed this by adding the following lines to R-1.9.0/src/library/base/R/datetime.R , at line 89:

to use the table asterisk.cdr but I can't find it anywhere. ------_=_NextPart_001_01C92A7E.C6B88024 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <html xmlns:v=3D"urn:schemas-microsoft-com:vml" = xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" =

Hi all, Is there a way to keep track in Asterisk of which phones are online in realtime using some MySQL DB table for exemple, much like "sip show peers" does in the CLI? Regards, Ricardo.