Displaying 20 results from an estimated 1100 matches similar to: "Realtime Mysql error"
2005 Aug 08
0
Failed IAX Connection
Hi:
I unseccessfuly tried to place a call from one IAX
behind a nat through another IAX with a real IP. I got
the following error message on Asterisk Console:
Executing Dial("OSS/dsp", "IAX2/wassim/01)") in new
stack
-- Called wassim/01)
Call rejected by 195.112.214.98: No such
context/extensionad:
-- IAX2/wassim-1 is circuit-busy
Aug 8 10:13:38 NOTICE[21759]:
2007 Nov 20
1
Realtime - mysql query gives wrong results??
Hi,
I am using Realtime for sip configuration.
When there is an INVITE which arrives at asterisk
asterisk makes the following selects:
Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect:
MySQL RealTime: Everything is fine.
[Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql:
MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name =
'tzl'
[Nov
2007 Oct 01
0
Astcc does'nt count all calls
Hi:
Iam using astcc on my asterisk server,sometimes astcc does'nt count calls by not writing them into mysql ,example: Not subtracting the call cost from the face value of the entered card number and by not writing it into cdrs table.This problem occured sometimes and not always.
Is it possible that this problem occured due to launching mysql by this command :
/etc/init.d/mysqld start --force
2005 Aug 23
2
RealTime ignoringswitch=>Realtime/context@realti me_ext
I am using the current HEAD of asterisk and for asterisk-addons. I have been
trying to setup realtime mysql voicemail but no sucess. I keep getting this
error below. The necessary modules are loaded, res_config_mysql.so ...
Any pointers will help. Thanks
mail*CLI> realtime mysql status
Aug 24 00:56:50 ERROR[963]: res_config_mysql.c:596 mysql_reconnect: MySQL
RealTime: Failed to connect
2008 Mar 01
7
ASTCC installation error install: invalid user `apache'
I am attempting a fresh install of ASTCC on Ubuntu. Getting install
invalid user as bellow. Has any one seen this? Can some one help out?
/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
Detected dry run!
./astcc-admin.cgi >/dev/null
DBI
2005 Jan 05
1
ASTCC Compiling Problem
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
2005 Jul 20
1
where i put the astcc config? In the extensions.conf or in the astcc-exten.conf?
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
2006 Jan 11
1
Better solution to mysql reconnect timeout
vmail*CLI> realtime mysql status
Jan 11 09:53:04 ERROR[3597]: res_config_mysql.c:623 mysql_reconnect: MySQL
RealTime: Failed to reconnect. Check debug for more info.
vmail*CLI> realtime mysql status
Connected to asterisk_vm@tritonvoice.com, port 3306 with username voicemail
for 1 days, 5 hours, 32 minutes, 7 seconds.
vmail*CLI> realtime mysql status
Connected to
2005 Jun 22
2
ASTCC not making calls
Hi, im trying to setup ASTCC but I'm getting it difficult. I've
correctly set up the mysql database astcc and added a brand, trunk,
route and a card as follows:
brands
+------+----------+------+--------------+------+--------+------+------+
| name | language | inc | publishednum | did | markup | days | fee |
+------+----------+------+--------------+------+--------+------+------+
| FWD
2005 Jan 13
1
asterisk realtime msql
Hi there
asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs;
here some info:
*CLI> realtime load sipfriends name 104
Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104'
Jan 13 11:52:21 DEBUG[8928]:
2005 May 13
1
ASTCC Compilation Error
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
2005 Jul 09
2
Modifying astcc
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");
2005 Jan 26
2
ASTCC Trunks
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
2005 Jul 17
1
* CVS-HEAD and ASTCC Intermittent issue
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
2005 Mar 21
1
ASTCC: perl / mysql or me???
I try to change something in ASTCC, but I am now totally blind, ....
I hang on one line now. I changed:
vpbx:/var/lib/asterisk/agi-bin # diff astcc-original.agi astcc.agi
22c22
< # exten => _00XXXXXXXXX,1,DeadAGI(astcc.agi,${CALLERIDNUM},${EXTEN})
---
> # exten =>
_00XXXXXXXXX,1,DeadAGI(astcc.agi,${CALLERIDNUM},${TARIFF},${EXTEN})
35c35
< # exten =>
2010 Apr 28
2
dialplan
Hi guys:
i need to set an extension in my dialplan?in which?it divert calls if?the extension?contain specific series ,For example?:
I need to divert calls which contain 3333 to specific? extension?(contain ,not start or end with), as i know i should set Gotoif command but i?dont know what to set after that,Any help will be appreciated.???
-------------- next part --------------
An HTML
2005 Jan 13
1
problems with astcc
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
2004 Jul 13
2
ASTCC: Asterisk Calling Card Solution
I am hereby announcing the immediate availablity of ASTCC for *alpha*
testing. ASTCC is an AGI script and CGI script which greatly simplifies
the task of creating a calling card application on Asterisk. Just check
it out of Asterisk CVS as module astcc:
export CVSROOT=:pserver:anoncvs@cvs.digium.com:/usr/cvsroot
cvs login (password is anoncvs)
cvs co astcc
ASTCC is, of course, distributed
2005 Sep 28
3
ASTCC - INUSE Flag
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
2004 Sep 26
1
ASTCC Terms : Help
I have got my ASTCC up and working , but facing a hard time
understanding the terms in ASTCC what actually they are meant for.
1. What is Trunk in ASTCC and what are the meaning of the parameters
such as Technology & Peer/Trunk ?
2. In the routes if I use 0 connect fee that means the user won't be
charged for 0 sec calls right ?
Inc. Seconds refer to interval ? If I set 500 in cost per