similar to: CDR problems with MySQL

Hi, I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install. The add-ons pack has been installed for a while, so now I'm trying to add the Mysql config. I've created a mysql database, added the grants 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:

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!

Hi, I have a deltathree account and I can place calls but I can't receive calls. I use Grandstram sip phones. When I call my deltathree phone # the voicemail is answer :(( I need some help and solutions from the guys who allready are using deltathree. I search on Internet and I try all types of configurations... :( This is my configurations files: - sip.conf - [general] port = 5060

Hi, VoiceGlo is comercial version of Asterisk? :))) loooooooooollllllllllllllllllll Take a loock on http://www.voiceglo.com/ The softphone is IAX :) Best regards, Chris HARIGA Techselesta Inc. http://www.techselesta.com/ -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20031201/307c10e9/attachment.htm

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

Hi, Can U tell me the Vonage ATA 186 settings? I would like to try to have a web interface on my adapter :-)) Best regards, Chris Hariga

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

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, si posible on SIP phones to have the dial tone after 9 like on the FXS card? I set ignorepat => 9 on my extensions.conf... Best regards, Chris HARIGA

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

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

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