Displaying 20 results from an estimated 1000 matches similar to: "CDR-MySQL"
2004 May 12
0
(no subject)
Hi Roger!
the databse i have created has all the immaginable permission.....if i try to
access it with dbtools with the
username and the password of asterisk from another pc inside the network, i can
see the table
and i can read/write. Only * can't write into the table. So,cecking the conf
file and the username, password and domain are ok. Need to configure other
modules?or the information
2009 Jan 05
1
cdr_addon_mysql 'Failed to insert into database' stops * call processing
Hi All,
I have some Asterisk 1.2 servers using the cdr_mysql addon (1.2.3)
spitting cdr's over to a MySQL database on another server. All is
working well except for a strange problem I ran into this morning.
During some cdr database maintenance, the cdr table was locked for a
few minutes, during this condition all the Asterisk servers stopped
processing calls and reported this error:
Jan 5
2007 May 14
1
Some problems with mysql CDR
Hello,
We have finally upgraded to Asterisk 1.4, however we've run into two issues
that weren't occurring before the upgrade.
Issue #1: We're an outgoing call center and need to record all calls. We use
the uniqueid field in the CDR to match with the recording, which we labeled
with {UNIQUEID} in MixMonitor. For some reason, the uniqueid is not correct
in the CDR. Here is the
2007 May 31
1
Duplicate UNIQUEID on CDR
Sometimes I get the following error on the console:
[May 31 11:14:01] ERROR[23502]: cdr_addon_mysql.c:230 mysql_log:
mysql_cdr: Failed to insert into database: (1062) Duplicate entry
'1180628004.3214' for key 1 -- Zap/38-1 answered UniCall/11-1
Why would the UNIQUEID be duplicated? Isn't is supposed to be UNIQUE?
This worries me a bit because the customer is losing calls that
2003 Jul 30
4
Grandstream Budgettone 100 & 102
Checking the earlier mails, it stated that the phones were $75 (100) & $85
(102) ref :-
http://lists.digium.com/pipermail/asterisk-users/2003-June/013483.html
Well, I just called Ovislink/dgtimes and was quoted $90 & $100 and the person
said there was no price change.
Anyone on this list actually bought them at the $75 & $85 rate ???
Regards...Martin
--
Too much is just enough.
2013 Sep 14
1
Asterisk-1.8.23.1 mysql cdr
Hi list,
I am using Asterisk1.6.2 form a long time and upgarding to
Asterisk-1.8.23.1.
I am using mysql backend for cdr.
in asterisk-1.6.2 i have usegmtime=yes and it works as expected insert cdr
date in GMT0.
now i tested Asterisk-1.8.23.1 and asterisk-11.5 with same results no
matter what i configure in cdr_mysql.conf "timezone=UTC usegmtime=yes" cdr
always inserted in local time.
I
2003 Sep 24
10
SIP / GrandStream Configuration
Hi there!
I installed the BudgetTone (GrandStream) on my LAN without any problems.
Then, I moved it to another location using a D-Link NAT.
I opened 5060 (SIP) and 5000 to 5008 for RTP. I also fixed the IP address
of the BudgetTone.
When I receive a call on my Asterisk, it would ring my FXS as before.
However, after I pick up, it hangs within a few seconds (Hungup Zap1-1 in
the log).
The
2003 Jul 30
2
Call Transfer, Budgettone 100
hi,
can someone who has used Budgettone phones tell me how to do the
following:
an incoming call comes in and is answered by the receptionist.
she need to put the call on hold, speak to whoever the call is for,
and either (after that) pass on the call, otherwise speak again to
whoever was on the call and hang up ..
so far i've got as far as a blind transfer by pressing transfer button
and
2003 Oct 03
1
Budgettone + G729
hi there ..
I asked sometime ago regarding getting a Budgettone
working with Asterisk over G729.
My system is quite simple, Asterisk server with 1 G 729 license
installed, and 10 Grandstream phones. Only one of them needs
G729, because it's on a remote link via an ADSL bridge. The
rest run happily on G711 on a local network.
I added the lines
disallow=all
allow=g729
to the sip.conf entry
2004 Nov 01
3
ms access --> mysql --> R in Linux
I am trying to use some ms access databases in R (version
1.9.1 or 2.0 on a Debian system). In searching the net for
promising software to do this, I found mdbtools. Mdbtools
claims the ability to convert schemas and tables in MS
Access to MySQL and other databases.
http://mdbtools.sourceforge.net/
I'm wondering if anyone in the R community has tried using
this software to use
2004 Sep 29
1
Asterisk 1.00 Call quality problem
I upgraded from RC2 last night, but have a major call quality issue.
Heres our setup:
1 FXS and 1 FXO card.
Incoming/Outgoing calls via IAX trunking from our provider. G729
running between us and the VoIP provider.
Two handsets, one BudgetTone 102 and a Cisco 7940G running the 7.2
SIP firmware.
Both these phones are using ULAW to the server, and we have plenty of
G729 licenses on the server.
2003 Jul 31
4
SIP calls cause Segmentation Fault
I have an asterisk installation at a client, it's quite simple.
Basically it's an asterisk downloaded from CVS about
a week ago, with 3 Zaptel FXO cards (the digium ones)
and 10 Grandstream Budgettone SIP phones ...
Every now and then, especially when a call is ringing
and not picked up immediately, Asterisk quits with
a segmentation fault error. IT seems quite inexplicable,
my dialplan
2003 Aug 28
6
SIP and ECHO
Hello,
I have read the information on echo and SIP in the FAQ and I have
scoured the mailing list for possible solutions, but as yet I have not
been able to get rid of this echo.
I have a Sip phone, Digium 4 Port FXS, and 3 Digium FXO cards installed
into an asterisk server. If I call between the Sip Phone
(Budgettone-100) and the 4 FXS ports everything sounds great. If I call
out to the PSTN
2003 Dec 24
3
CT1 and callerid / DNIS
On Tue, 2003-12-23 at 19:22, Brian West wrote:
> I'm just double checking.. I was told it wasn't possible but i'm going to
> ask just in case.
>
> Can you set outbound callerid on a channelized T1?
>
>I think there is a way to do something like DID with the 4 digits of
>DTMF passed before the call. It is unlikely though that you will find
>someone interested
2005 Mar 05
4
Newbie guidance requested --- Grandstream Budgetone
Hi-
I am attempting to setup my Budgettone phone for use with my * server and am having problems obtaining an IP address. I have checked the phones settings to
make sure it has dhcp enabled and it is. The display says no IP. I bought the phone but do not have any documentation other than the Wiki, but I am still at a loss.
What could be preventing the phone from picking up an IP address?
Any
2003 Nov 07
7
CDR fields
hi,
i saw the cdr file called Master.csv and i want to
know what these represent. examples
"","","4","incoming","","Zap/1-1","Zap/4-1","Voicemail","u8888","2003-11-07
17:43:04","2003-11-07 17:43:04","2003-11-07
17:43:22","ANSWERED","DOCUMENTATION"
2003 Aug 06
1
Budgettone Newbie
Just got my new Budgettone phone, and I've got a couple of issues.
Most important, it doesn't seem to be querying for the time via NTP. I
put a sniffer on the line, and once it boots up the only outbound
traffic it generates is an attempt to contact a TFTP server, which is
programmed in as 192.168.0.168. . .
Must it first find a config file (it's asking for "cfg.txt")
2005 Apr 29
2
VPN & ping error
Hi everyone..
i have followed this instructions
http://devel.elucid8design.com/el8/devel/tutorials/pptp.php to build a
vpn server with shorewall.
the configuration of my network is:
vpn server (with shorewall installed) with 2 interfaces: 192.168.1.2 -->
net zone
192.168.0.x --> loc zone
when i try to
2004 Jun 07
2
IAX calls dropout on button press
Hello all,
Over the weekend, I setup and linked an Asterisk box at another site to the
Asterisk box here.
The phones here are a mixture of Cisco 7940/7960 and Grandstream BT-100
phones. The phones at the other end are Grandstream BT-100 SIP phones. The
Cisco phones run SIP 7.1 (upgraded last Friday from 6.1), the Grandstream
phones run 1.0.4.68.
Both Asterisk boxes are running stable CVS
2003 Jun 04
5
Budgettone 100 phone Configuration
Hi Just recieved the above phone
Does anyone have sip.conf and extension.conf example for the SIP phone working
with the FXS w100p and the FXO tdm400d
any help would be appreciated
Thanks
Robb