similar to: CDR/MySQL basic config

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!

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, 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

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

Hi guys, I have recently installed a Asterisk Server with CDR Call Detail Records. I have installed it over a Asterisk 1.2 , but now It do not run . I have installed it with the following procedure: # yum install ncurses #yum install openh323-devel # yum install mysql-server # yum install mysql # yum install php-gd # yum install php-mysql # yum install mysqlclient10 # yum install zlib # yum

i am getting 403 Forbidden message from asterisk when it try to register my user agent. i am basically useing mysql through ODBC. i hvae checked ODBC connecteion with 'ODBC Show' command. ------------------------------------------------------ *CLI> odbc show Name: mysql1 DSN: asteriskdsn Connected: yes *CLI> ------------------------------------------------------ and user is added to

When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off? Thanks Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others. Created by Mark Spencer <markster at digium.com> Asterisk

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

I am getting this error when reload my asterisk "cdr_addon_mysql.c:264 my_load_module: Unable to load config for mysql CDR's: cdr_mysql.conf" I don't have res_mysql.conf in /etc/asterisk/. I have res_odbc.conf which is attached Res_odbc.conf ============== ;;; odbc setup file [mysql1] dsn => MySQL-asterisk username => myuser password => mypass pre-connect => yes

List, I finally decided to break down & start playing with AGI scripts, but for the life of me, I can't figure out what I am doing wrong. Below is a super simple script to run a query in mysql to see how many call records there are for the extension calling in, then print the total in the CLI. This is all I get on the CLI: -- Executing AGI("SIP/216-0baa",

Hi, I have installed asterisk-1.4.4 and asterisk-addon-1.4.1. I followed every step to configure RealTime but something is not working properly; the warning that I am geting is: WARNING[32709]: config.c:1229 find_engine: Realtime mapping for 'sippeers' found to engine 'mysql', but the engine is not available WARNING[1359]: config.c:1229 find_engine: Realtime mapping for

I'm trying to configure CDR records to store them in MySQL database but those instruction are not very clear from: 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

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?

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,

Hello list, 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

Could someone provide some steps for troubleshooting Realtime? I can't see any signs that it's working. I followed and double-checked a few different guides around the net, but haven't been able to figure it out. -------------- next part -------------- An HTML attachment was scrubbed... URL:

Hi all, I'm new to asterisk. I have it installed and 1 x100p card. I'm trying to use kphone to connect out. But, when I start * it gives me sound card busy error. I've checked ps aux and nothing seems to have the sound card. Any ideas? Does starting asterisk automatically take the sound card? Also, can you use the phone connected into the XFO card w/ asterisk or do you need an XFS card

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

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

Hi I am a user of Asterisk-0.5.0. I am a final year student of MCA in IGNOU.All the system are running in Red Hat-7.3 OS. I am able to transfered call in the following procedures: PSTN(INDIA)>>Mediatrix 1204>>Asterisk server>> VOCAL server>>Mediatrix 1204>>PSTN(USA) Now I want to save the cdr data in my Asterisk box.I am using RedHat-7.3 OS. I am using the