Re: Enable CDR logging?

[Stefan at WPF <stefan.at.wpf@xxxxxxxxxxxxxx>]

Thank you Doug, but if I don't understand things wrong, you are not using adaptive ODBC?

I meanwhile found out that things work when I manually create the columns. Just wondering, is there any official specifications for the default columns, e.g. which datatype they shall have and so on?

Also, I am getting this errors:

[Aug 19 20:36:11] WARNING[2386]: res_odbc.c:601 ast_odbc_direct_execute: SQL Execute error! Verifying connection to asterisk [asterisk-connector]...

[Aug 19 20:36:11] ERROR[2386]: cdr_odbc.c:162 odbc_log: CDR direct execute failed

I guess they have nothing to do with adaptive odbc?

As a reference, here is my complete configuration for adaptive odbc:

/etc/odbcinst.ini:

[MySQL]

Description = ODBC for MySQL

Driver = /usr/lib/i386-linux-gnu/odbc/libmyodbc.so

Setup = /usr/lib/i386-linux-gnu/odbc/libodbcmyS.so

FileUsage = 1

/etc/odbc.ini:

[asterisk-connector]

Description           = MySQL connection to 'asterisk' database

Driver                = MySQL

Database              = asterisk

Server                = localhost

UserName              = user

Password              = password

Port                  = 3306

Socket                = /var/run/mysqld/mysqld.sock

cdr_adaptive_odbc.conf:

[mytable]

connection = asterisk

table = asterisk_cdr

res_odbc.conf:

[asterisk]

enabled => yes

dsn => asterisk-connector

username => user

password => password

pre-connect => yes

pooling => no

limit => 1

cdr.conf:

[general]

enable = yes

unanswered = yes

2012/8/19 Doug Lytle <support@xxxxxxxxxx>

Stefan at WPF wrote:

Thanks for any hint :-)

/etc/odbc.ini

[MySQL-cdr]
Description     = CDR Database
Driver          = MySQL
Socket          = /var/lib/mysql/mysql.sock
Server          = 172.19.8.9
User            = username
Password        = password
Database        = asteriskcdr
Option          = 3

/etc/asterisk/res_odbc.conf

[MySQL-cdr]
enable => yes
dsn => MySQL-cdr
username => username
password => password
preconnect => yes

/etc/asterisk/cdr_odbc.conf

[global]
dsn=MySQL-cdr
;loguniqueid=yes
dispositionstring=yes
table=cdr
usegmtime=no
;hrtime=yes


Doug


--
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary Safety, deserve neither Liberty nor Safety."


--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
              http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
  http://lists.digium.com/mailman/listinfo/asterisk-users

--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
               http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users