[asterisk-users] Enable CDR logging?

[Stefan at WPF]

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 at drdos.info>

> 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<http://lists.digium.com/mailman/listinfo/asterisk-users>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120819/593640b6/attachment.htm>