Displaying 7 results from an estimated 7 matches for "asteriskcdr".
2011 Jan 24
6
Unable to insert cdr-data into mysql-DB
Hello list,
I keep on getting the error :
ERROR[1707] cdr_addon_mysql.c: Cannot connect to database server
127.0.0.1: (1045) Access denied for user 'asteriskcdr'@'localhost'
(using password: YES)
I have a 'cdr' table in my MySQL-DB. On this table the user
'asteriskcdr' has select, insert, update privileges.
GRANT SELECT , INSERT ,UPDATE ON `Asterisk`.`cdr` TO
'asteriskcdr'@'127.0.0.1';
cdr_mysql.conf :
[...
2004 May 26
5
cdr_odbc with mysql on a remote server
...ded /usr/lib/asterisk/modules/cdr_odbc.so => (ODBC CDR Backend)
== Parsing '/etc/asterisk/cdr_odbc.conf': == Parsing
'/etc/asterisk/cdr_odbc.conf': Found
2004-05-26 18:13:54 NOTICE[6151]: cdr_odbc.c:336 odbc_load_module:
cdr_odbc: Logging uniqueid
> cdr_odbc: dsn is AsteriskCDR
> cdr_odbc: username is asteriskcdr
> cdr_odbc: password is [secret]
> cdr_odbc: Error SQLConnect -1
> cdr_odbc: Error Details: [MySQL][ODBC 3.51 Driver]Can't connect
to local MySQL server through socket '/tmp/mysql.sock' (2)
2004-05-26 18:13:54 E...
2014 Sep 24
1
AsteriskCDR
Hello;
I was using the 1.8 version of Asterisk. However, due to a problem I had to
update. Update reporting system is broken when you have made. Current
version 11.10. I installed the modules in the system for problems that are
missing. I getting error as follows.
^[[A[Sep 24 03:16:50] WARNING[3624] loader.c:* Module 'app_mysql.so' was
not compiled with the same compile-time options as
2003 Sep 14
2
cdr_mysql: cannot connect
...tabase residing on localhost. I have
check permissions on the user as well as the password and I have the same error comin up. I have
succesfully connected to the database remotely and with MYPHPAdmin with the same setting below is a
copy of my cdr_mysql.conf
[global]
hostname=192.168.2.9
dbname=asteriskcdr
user=asteriskcdr
password=<password>
port=3306
sock=/tmp/mysql.sock
The error I am getting is:
ERROR[1209214400]: File cdr_mysql.c, Line 71 (mysql_log): cdr_mysql: cannot connect to database
server localhost. Call will not be logged.
I am also getting this message though it might be unrel...
2009 Aug 17
1
- Is Asterisk 1.4.21.2 Zaptel Compatible? -
...ski ) and it collects all the calls
info correctly, but on the CLI there's some Error everytime i make a call:
-----------
[Aug 14 00:21:40] WARNING[22807] res_config_mysql.c: MySQL RealTime: Unable
to select database: general. Still Connected (1049).
------------
My database name is "asteriskcdr", i think "general" is a string in
res_config_mysql.c code, and it comes from [general] context in
res_mysql.conf.
All the calls are collected correctly, no problem with that, the CDR works
fine, the problem is that message, is that an uncompatibility problem?
i have been looking ar...
2013 Feb 21
1
CDR direct executed failed
Hi,
I have configured the cdr throught ODBC with this files:
/etc/cdr_odbc.conf
[global]
dsn=asterisk2
;loguniqueid=yes
dispositionstring=yes
table=cdr ;"cdr" is default table name
usegmtime=no ; set to "yes" to log in GMT
hrtime=yes ;Enables microsecond accuracy with the billsec and duration fields
/etc/cdr.conf
[general]
enable=yes
unanswered =
2009 Dec 14
1
AGI with PHP
...en => 111,n,AGI(GoTalk.php)
exten => 111,n,NoOp(Result is : ${callnum})
exten => 111,n,HangUp()
My php file is:
#!/usr/bin/php
<?php
$start = '5';
$mysql_host = 'localhost';
$mysql_user = 'username';
$mysql_password = 'password';
$my_database = 'asteriskcdr';
$dbtable = 'cdr';
$from_date = '20091205000000';
$to_date = '20100104235959';
$callnum = '0';
$minutes = '0';
$query_duration = "SELECT SUM(billsec) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='A...