search for: asteriskcdrdb

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts

Hi Everyone, Just noted that PBXinaFLASH failed me again on yet something else. The uniqueid field didn't update on the asteriskcdrdb in the past few months but it is available in the .csv files in /var/log/asterisk/cdr-csv/*.csv I have already re-did the asterisk-addons install with correct parameters to include future calls "uniqueid" in the table (I have no clue why these flavours of Asterisk chose to remove neccess...

Hi, I have Fedora Core 2 running with a T1 card. I try to put the log on db but I get the error: Aug 20 15:17:47 ERROR[262160]: cdr_addon_mysql.c:378 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database exists and I try with "mysqlaccess localhost asteriskcdrdb" and I get: Access-rights for USER 'localhost', from HOST 'localhost', to DB 'asteriskcdrdb' BEWARE: Everybody can access your DB as user `localhost' from host `localho...

...# yum install zlib-devel # yum install ncurses-devel Install perl support perl -MCPAN -e "install DBD::mysql" I compile /usr/src/asterisk-addons as follows: # ./configure # make clean # make install In the file /etc/asterisk/cdr_mysql.conf [global] hostname=localhost dbname=asteriskcdrdb table=cdr password=strongpass user=asterisk port=3306 userfield=1 In the File asterisk-stat define ("WEBROOT", "http://192.168.190.10/asterisk-stat/"); define ("FSROOT", "/var/www/html/asterisk-stat-v2/"); define ("LIBDIR", FSROOT."lib/&qu...

Can someone tell me what is wrong here: Feb 2 19:45:44 ERROR[1074441696]: cdr_addon_mysql.c:381 my_load_module: Failed to connect to mysql database asteriskcdrdb on localhost. The database is created, cdr table also, the username and password is right. I have tried configuring cdr_mysql.conf to connect via localhost mysql.sock or via tcp port, but in both cases I got this error. Thanks! Tomica Crnek -------------- next part -------------- An HTML at...

...----------+ 1 row in set (0.00 sec) ------------------------------------------------------ i have added values to extconfig.conf ------------------------------------------------------ [settings] queues.conf => odbc,asteriskcdrdb,ast_config sip.conf => odbc,asteriskcdrdb,sip_buddies ------------------------------------------------------ what is the problem with my asterisk i think table is not binded with sip.conf. because when i add user to...

...nts for a user acces, and can run a mysql -u asteriskcdruser -p and can connect to the database. I've been using this as a guide: http://www.757.org/~joat/wiki/index.php/Asterisk#Viewing_CDR_Data_with_A sterisk:_CDR_Analyzer I've created cdr_mysql.conf: [global] hostname=localhost dbname=asteriskcdrdb table=cdr password=password user=asteriskcdruser port=3306 sock=/tmp/mysql.sock userfield=1 But when I start asterisk (1.4 on my test machine), I get: == Parsing '/etc/asterisk/cdr_mysql.conf': Found [Aug 6 21:01:14] ERROR[32512]: cdr_addon_mysql.c:436 my_load_module: Failed to connect...

hello all, I am using the msql cdr module to store cdr in db, I realised that it does't capture the start and end time af a particular call record. Therefore I dive into the source code to add the start and end time into the query (add something like cdr->start, cdr->end), but end up getting segfault. the original version of cdr_mysql.so works fine but I need the start time and end

Hi all, I think I've run out of options in terms of what I know about this. I have created a user called asteriskuser and granted all privileges to the asteriskcdrdb database. Then I created the table via the cdr_mysql.txt file. I have edited the cdr_mysql.conf file to reflect this, and added load => cdr_addon_mysql.so after compiling it from the latest CVS. If I check the Master.csv file in /var/log/asterisk/cdr-csv/ then I can see that Asterisk is i...

I have a bunch of CDR records in the mysql database "asteriskcdrdb" on a FreePBX system. There is a DAHDI trunk defined in FreePBX which uses the "gN" identifier to make calls. So in this setup the trunk is roughly equivalent to a DAHDI logical group. I want to know, given a CDR, which logical group (and therefore, trunk) was used to place the call...

...s taking into consideration your own settings. If you have all the CDR info in the Master.csv too, then delete all the data from the 'cdr' table in MySQL before running the script bellow in oder to prevent dupplicate records. In my example, I have the following config: CDR database: asteriskcdrdb CDR table: cdr CVS file: /var/log/asterisk/cdr-csv/Master.csv 1. Create a file named 'impcdr2sql' with the following content: #!/bin/bash # make a copy of the original Master.csv file to Master.csv.mod cp -vf /var/log/asterisk/cdr-csv/Master.csv /var/log/aster...

...e_limit(6); $stdin = fopen("php://stdin","r"); $stdout = fopen('php://stdout', 'w'); function read() { global $stdin, $debug; $input = str_replace("\n", "", fgets($stdin, 4096)); return $input; } function connect_db() { $database="asteriskcdrdb"; include("./common.php"); include("./dbconnect.php"); } // parse agi headers into array while ($env=read()) { $env = str_replace("\"","",$env); $s = split(": ",$env); $agi[str_replace("agi_","",$s[0])] = trim...

...ist, i have installed elastix 2.4.0 with call center model and i have created an Outgoing Calls <https://192.168.1.251/index.php?menu=outgoing_calls> my question i want to know the name of the tbale where the csv file is uploaded in order to do some works. NB: i found the cdr table in asteriskcdrdb database but the is no information related to my csv file any help please thanks and regards. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20141124/3f7e2212/attachment.html>

...http://www.voip-info.org/tiki-index.php?page=Asterisk+cdr+mysql I've MySQL up and running I'm just not sure what database to create and as the configuration Sample cdr_mysql.conf is not consistent from instruction on: Create the database Do I create database name "cdr" or "asteriskcdrdb"? Whatever name I use I get an error creating the tables. -- #Joseph

Hi Guys I am just looking around for a small billing program but can't really find what I am looking for. It needs to bill straight off the CDR. It should grab all the CDR records from the asteriskcdrdb mysql database then have a rates table to that it calculate a bill from. Is there any open source packages or commercial packages that will account for billing say only 5 extensions? Regards Mark Brooker T: 02 4959 8670 M: 0415 846 865 F: 02 4950 5609 E: mark@mbit.com.au W: http:...

...sql', but the engine is not available WARNING[1359]: config.c:1229 find_engine: Realtime mapping for 'sipusers' found to engine 'mysql', but the engine is not available My cdr_mysql.conf and res_mysql.conf are: /--- cdr_mysql.conf ---/ [global] hostname = localhost dbname = asteriskcdrdb password = passw0rd user = root table = cdr port = 3306 sock = /var/run/mysqld/mysqld.sock userfield = 1 /--- res_mysql.conf ---/ [general] dbhost = localhost dbname = asteriskrealtime dbuser = root dbpass = passw0rd dbport = 3306 dbsock = /var/run/mysqld/mysqld.sock Mysql is working properly, I...

...ing to configure a new server for use in a small Call Center. I want to use realtime queues and agents and after following the instructions I can get the queue to show up on the system but no agents. I am using Asterisk 1.4.4 on a CentOS 5 machine. I have this in extconfig.conf: queues => mysql,asteriskcdrdb,queue_table queue_members => mysql,asteriskcdrdb,queue_member_table I put this into queues.conf: [general] realtime_family = queues,queue_members Here is what I get from queue show: pbxinsol*CLI> queue show henkel has 0 calls (max unlimited) in 'ringall' strategy (0s holdtime...

Hi people, I'm trying to retrieve data from the database (server MySQL). I have the following dial plan: exten => s,1,Noop(Start) exten => s,n,MYSQL(Connect connid localhost user pass asteriskcdrdb) exten => s,n,Noop(Connid: ${connid}) ... The problem is that the 3? line is not showing the connid. How can I know the error? Thanks, _________________________________________________________________ Nuevo Windows Live, un mundo lleno de posibilidades. Desc?brelo. http://www.m...

I have A@H 2.1, running * 1.2.1. I am trying to put information into the userfield with SetCDRUserField and AppendCDRUserField. However, the field is never populated in the cdr - I've checked the csv files and the MySQL asteriskcdrdb table. The field is defined in the MySQL table, but is always empty. The csv files that get created don't have a userfield at all, that is, there isn't an empty string (like "" ) but rather there is nothing. Here's a sample: "5017999","5597337550",&qu...

...command "SET PASSWORD FOR root=PASSWORD("password");" The Konsole give the error message. ERROR 1044: Access denied for user: '@localhost' to database 'mysql' And also when I am trying to create a user by using the command "GRANT ALL PRIVILEGES ON *.* TO asteriskcdrdb@localhost IDENTIFIED BY "password" WITH GRANT OPTION;" The Konsole give the error message ERROR 1045: Access denied for user: '@localhost' (Using password: NO) Please help me to create user with password, database and grant to access all works. Thanks. Dipak; ________...