similar to: No subject

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

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:

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

Every once in a while (like 2 out of 7 times), I get the following message: [Nov 14 12:49:02] NOTICE[6855]: cdr.c:434 ast_cdr_free: CDR on channel 'SIP/5000-082508f0' not posted I look in the cdr table in mySQL and indeed, the record is not posted for that call. This makes me want to create hard file and a compare script between the file cdr and the odbc cdr, but I was wondering if

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

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

If I fire up asterisk it connects to my MSSQL server via ODBC just fine. However, if I issue a reload it unloads the ODBC.. then loads it again and I get an error... and keep getting it until I On a fresh start: Aug 26 15:43:14 WARNING[13818] cdr_odbc.c: cdr_odbc: table not specified. Assuming cdr Aug 26 15:43:14 VERBOSE[13818] logger.c: -- cdr_odbc: dsn is MSSQL-asterisk Aug 26 15:43:14

Hi, i want to load the cdr into oracle using unixODBC. I'm using RH 9 2.4.20-30.9smp, unixODBC 2.2.6, easysoft odbc driver for oracle 1.3.1. My unixODBC is working well. With isql i can connect to the database, do selects, inserts and so on. I created the table cdr as described on the asterisk wiki site. When i configure the cdr_odbc.conf with the needed values, then * does not start any

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

Hello, I'm trying to configure Asterisk with Radius cdr support. Asterisk version 1.6.2.13 Server Radius: Freeradius version 1.X Radius client: radiusclient-ng version 0.5.5 With the Asterisk core debug on 1 when a call terminate, on the console appear this error: Unable to create RADIUS record. CDR not recorded! My cdr.conf is: [radius] usegmtime=yes ; log date/time in GMT

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

Hi all, I use astersk 11.7.0 on Ubuntu 12.04.01 TLS (i386). I use cdr_adaptive_odbc to write CDR to my MySQL's cdr table. After my testing, this scenario is working well. After a long idle time, I didn't make any call to the asterisk server. When I try to make a call again after 8 hours, I found that the cdr lost. It cannot be inserted to cdr table. Also, I could not find the insert CDR

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

Luca Bertoncello wrote: > 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

-----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of jg Sent: Monday, July 06, 2015 4:14 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [asterisk-users] CDR in an MySQL-Database > Hi list! > > I'd like to save all information about calls (CDR) in a MySQL-Database.

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 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: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no