similar to: Real Time CDR

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES

I have two version 1.6 Asterisks running. One is a small hobbyist thing just at home, and the other is handling calls for several customers. On both, I have added the line exten => h,1,Set(CDR(hangupcause)=${HANGUPCAUSE}) to all relevant contexts. On my little hobbyist box this works perfectly; all calls have their hangupcauses recorded with cdr_adaptive_odbc and cdr_custom. On the

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'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 =

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

; ; cdr_odbc.conf ; ;[global] ;dsn=MySQL-test ;username=username ;password=password ;loguniqueid=yes ;dispositionstring=yes ;table=cdr ;"cdr" is default table name ;usegmtime=no ; set to "yes" to log in GMT Though, reading from https://issues.asterisk.org/view.php?id=15021, it seems that lines username= and password= in cdr_odbc.conf are not used

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 =

HI, I am trying to setup CDR with ODBC and MySQL but get the following error :- [Apr 28 21:30:01] ERROR[14567]: cdr_odbc.c:133 odbc_log: Unable to retrieve database handle. CDR failed. I can successfully connect with iSQL so ODBCINST and ODBC ini files must be okay. I have modified /etc/asterisk/cdr_odbc.conf to include :- [global] dsn=asterisk username=asterisk password=*******

Hi, I'm having a bit of a problem with storing voicemail messages in an odbc database. I *think* I've got everything configured correctly but messages are stored on the asterisk server instread of in the database. System info 64 bit redhat RHEL 5.1 Asterisk 1.4.26 unixODBC installed used makemenuselect to instal res_odbc and cdr_odbc Back end database DB2 Database name voiceml

Hi, I am trying now for over 4 hours setting up cdr-logging via odbc into a mysql database. But with no success. Do you have any hint for me? cat /etc/odbc.ini ------------------ [MySQL-asterisk] Description = MySQL ODBC Driver Driver = MySQL Socket = /var/run/mysqld/mysqld.sock Server = localhost User = xxx Password = xxx Database = asterisk Option = 3 Port = and /etc/odbcinst.ini

Hi i am upgrading an asterisk server from 1.2.4 to 1.4. i've installed libpri 1.4 i've installed zaptel 1.4 I've installed the new version of misdn with the script of beronet. i use this configure script: ./configure --with-postgres=/usr/local/pgsql then: make menuselect [*] 1. cdr_csv [*] 2. cdr_custom [*] 3. cdr_manager XXX 4. cdr_odbc [*] 5. cdr_pgsql XXX 6. cdr_radius

Hello, My question is.. How does cdr_manager work? Does it suppose to populate cdr-csv/Master.csv? What about the cdr table on the database? What is the event some people talk about? I have changed (and reloaded) my configuration of cdr_manager.conf to ; ; Asterisk Call Management CDR ; [general] enabled = yes and it doesn't seem to make any difference. After originate a call from the

Hi. Asterisk 1.4.12.1. I get a lot of message like this. Someone knows what this message mean? Do i have to worry about it? [Nov 7 15:24:25] NOTICE[31145]: cdr.c:434 ast_cdr_free: CDR on channel 'Local/152 at local-f137,1' not posted [Nov 7 15:24:25] NOTICE[31145]: cdr.c:434 ast_cdr_free: CDR on channel 'Agent/152' not posted [Nov 7 15:24:25] NOTICE[31247]: cdr.c:434

Hi, When I use NoCDR application I obtain this warning in console log: Mar 1 11:16:08 WARNING[3513]: cdr.c:114 ast_cdr_free: CDR on channel 'SIP/492-7371' not posted Mar 1 11:16:08 WARNING[3513]: cdr.c:116 ast_cdr_free: CDR on channel 'SIP/492-7371' lacks end Can someone explain to me what is due? Thanks.

Good morning, We''ve been testing PE and beginning developing modules for our infrastructure. One of the modules I''m looking to create is an installation for Splunk, with the primary focus at this time, on the Forwarder. I already have the splunkforwarder-5.0.1-143156-linux-2.6-amd64.deb package being fetched from the Master and also performing the installation via dpkg. I

Hello I?ve just install last cvs version (Mon Sep 6) of Asterisk with asterisk-oh323-0.6.3b and pwlib-v1_6_6-src.tar.gz, openh323-v1_13_5-src.tar.gz and . this is the error loading asterisk with chan_oh323 module:: [cdr_csv.so] => (Comma Separated Values CDR Backend) [cdr_manager.so] => (Asterisk Call Manager CDR Backend) == Parsing '/etc/asterisk/cdr_manager.conf': Found

Hi All, I'm using asterisk 1.2.15 and call forwarding doesnt work for me. from my extensions.conf: ; Unconditional Call Forward exten => _*21*X.,1,NoCDR exten => _*21*X.,2,Set(DB(CFIM/${CALLERID(NUM)})=${EXTEN:4}) exten => _*21*X.,3,Playback(vm-saved) exten => _*21*X.,4,Hangup exten => #21#,1,NoCDR exten => #21#,2,DBdel(CFIM/${CALLERID(NUM)}) exten =>

Hello, I've used oggenc with these options before: $ oggenc -q3.0 -m 96 -M 225 somemusic.wav But it's now encoding everything at 1.0kbps. The compression is *awesome* but the found quality is somewhat lacking. Has something changed recently, or am on crack (again)? Cheers, Geoff Ps. I put the above example in the ifp-driver mailing list FAQ.. but now I don't look so smart..

> Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database. > I created the DB and a user for Asterisk on a separate server, then I > configured my cdr_mysql.conf so: > > [global] > hostname=192.168.10.3 > dbname=asterisk > table=cdr > password=MYSECRET > user=asterisk > port=3306 > > and my cdr.conf so: > >

My firewall is using shorewall 3.0.x and CentOS Recently, I found that firewall is attaching from ARP spoofing.. There are a lot of "out of socket memory" in messages log ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and