similar to: Res: Record CDR in a Oracle database

Hi, I`m trying to use the agent snmp buit in the asterisk-1.4, but I can`t do this... I used this link to do it: http://www.voipphreak.ca/archives/382 but I can't... Does somebody know how to do this or knows a how-to to do this?? Thank's _______________________________________________________ Yahoo! Mail - Sempre a melhor op??o para voc?! Experimente j? e veja as

Hi all, does anybody know any way that when it run "reload app_queue" in the asterisk cli it don't lose the informations from "show queue (queue name)" ? I'm passing for this trouble, because I need this informations (http://www.voip-info.org/wiki/index.php?page=asterisk+cli+command+show+queue) that asterisk cli command "show queue (queue name)" show me

Hi People, I had success to do my asterisk to record CDR in a databese MYSQL... Now, I need to do it to record CDR in Oracle... Does Anybody knows how to do this?? Every hints are welcome.... Thank`s all Everton Goularth Uberlandia - MG - Brazil _______________________________________________________ Yahoo! Mail - Sempre a melhor op??o para voc?! Experimente j? e veja as

Hi all, I have an Asterisk server connected in a PABX (TELEDATA) by channel Unicall.. I`m having problem when somebody call from PABX to Asterisk.. Eg: When somebody dial 1234, I received 1111112222333333444444 in the Asterisk CLI... If somebody can help me... or already saw this... Everton Goularth Uberlandia - MG - Brazil _______________________________________________________

Hi people, I'm tring to configure fax on my asterisk server. I'm using the instructions of: http://www.asteriskguru.com/tutorials/spandsp.html and the files app_rxfax.c, app_txfax.c and apps_Makefile_patch from: http://www.soft-switch.org/downloads/snapshots/spandsp/test-apps-asterisk-1.2/ I have already configure this on other server that the operation system is CentOS 4 and all

Hello All, How can I do to record my asterisk's CDR in a Oracle database? I have to use unixODBC? Can anybody send me a step to step to do this configuration? Thank's All Everton Goularth _______________________________________________________ Yahoo! Mail - Sempre a melhor op??o para voc?! Experimente j? e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/

Hi All, I need to limit outgoing calls in my sip peers... I tried to use "call-limit=1" in these peers in the sip.conf, but it didn't work... Here is my peer configuration in the sip.conf: [sip.broadvoice.com] accountcode=broadvoice type=peer dynamic=yes username=MYUSERNAME fromuser=MYUSERNAME authname=MYUSERNAME user=MYUSERNAME secret=xxxxxxxx host=sip.broadvoice.com

Hello, I am running Linux, I have downloaded instantclient-basiclite-linux32-11.2.0.2.0.zip instantclient-sqlplus-linux32-11.2.0.2.0.zip instantclient-sdk-linux32-11.2.0.2.0.zip instantclient-precomp-linux32-11.2.0.2.0.zip All these tarballs are unzipped in /usr/local/lib/instantclient, I have added this path in the library path of the host. I can run sqlplus and proc, they do not complain

Does anyone have experience on installing the Oracle instantclient and DBD::Oracle on CentOS 4.4. I have been having several issues with getting the RPMs from Oracle's site working with DBD::Oracle. I can get the oracle instant client to install without issue. But I cannot compile/install DBD::Oracle using cpan or cpan2rpm. I found http://freshrpms.net/docs/oracle/ which has a nosrc rpm

I'm trying to add cdr_odbc.so to log my CDR data to a mysql DB. I've managed to compile everything, and seem to almost be ready to head home. I've added a small debug line to cdr_odbc.c as follows: if((ODBC_res != SQL_SUCCESS) && (ODBC_res != SQL_SUCCESS_WITH_INFO)) { if(option_verbose > 10) ast_verbose(

Hi, Has anyone made a successfull instalation of cdr_odbc?? I've install unixODBC-2.2.8 (made my own RPM) and then built the module. I'm trying to send the cdrs to a M$ SQL server. The sql connection works because I can do any query via isql. When I do the calls I get the following output on the asterisk console: -- Executing Hangup("SIP/test1-a5e1", "") in new

Hi, Since a few days I'm experiencing this: > cdr_odbc: Connected to asterisk > cdr_odbc: Error in Query -1 > cdr_odbc: Query FAILED Call not logged! > cdr_odbc: Connected to asterisk > cdr_odbc: Reconnecting to dsn asterisk > cdr_odbc: Trying Query again! > cdr_odbc: Error in Query -2 > cdr_odbc: Query FAILED

I'm trying to get asterisk cdr_odbc configured, but it can't connect through my odbc driver. switchboard*CLI> module load cdr_odbc [May 4 20:06:04] ERROR[17758]: cdr_odbc.c:358 odbc_load_module: cdr_odbc: Unable to connect to datasource: asterisk /etc/odbcinst.ini: [MySQL] Description = MySQL driver Driver = /usr/lib/odbc/libmyodbc.so Setup =

I'm not really being too lucky in the last days. After trying to compile cdr_mysql with no success, I am switching to cdr_odbc. I have installed unixODBC, iODBC and MyODBC correctly, I am even able to make queries with isql. But when trying to "make" in the cdr directory of the latest CVS, that's what I get: # cd /usr/src/asterisk/cdr # make cc -o cdr_odbc.so cdr_odbc.o -lodbc

Hi I have problems trying to load asterisk call data into the cdr table using cdr_odbc config. My unixODBC is properly configured and it's working fine (able to connect, load data, query tables, etc.). unixodbc is configured to use easysoft Oracle ODBC library. Table cdr was created following instructions in asterisk wiki site. My /etc/asterisk/cdr_odbc.conf is configured as follow:

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, I'm working with asterisk on a project and I found a problem with cdr_odbc. As we know, after answering each call a cdr event is raised which is saved in cdr_csv and cdr_odbc. but here my point is on cdr_odbc. some information, including start_time and end_time is given by cdr event but the problem is that these two information(start_time and end_time) is not getting save in cdr_odbc. I

I was finally able to compile asterisk with cdr_odbc.so. But now for some reason I get that error: *CLI> load cdr_odbc.so Jun 22 16:38:53 WARNING[-1084309376]: loader.c:240 ast_load_resource: libiodbc.so.2: cannot open shared object file: No such file or directory Unable to load module cdr_odbc.so But the file is there... # ls -lag /usr/local/lib/libiodbc.so* lrwxrwxrwx 1 root

svn trunk. I'm trying to get cdr to work with my odbc database. I have followed a checklist that I had previously but still can't get it to work. There are no errors (verbose 40 and debug 40), I get [cdr_odbc.so] => (ODBC CDR Backend) == Parsing '/etc/asterisk/cdr_odbc.conf': Found *CLI> cdr status CDR logging: enabled CDR mode: simple CDR registered backend:

I've just noticed that since swapping from the direct mysql cdr driver to cdr_odbc, the call duration (and anything else that's an integer) isn't logged - anyone else seen this and know the reason. The cdr_odbc driver gives no error messages and records any string based fields correctly. Iain