VoIP Mailing List Archives

[toufic.khreish at gmai...]

Hello,

I am trying to get CDR works for my asterisk installation.
My OS is Ubuntu 15 with asterisk 13.8 compiled locally on the machine.
MYSQL Server version is 5.6.28-0ubuntu0.15.04.1 (Ubuntu)

I also have another machine Ubuntu 15.04 same os but with asterisk 13.8.1 having the same issue, while same installation on Ubuntu 14.04
with 13.8.1 is working fine.

The only difference I saw is the mysql database engine version number on Ubuntu 14.04 which was 5.5.

While there was no way to downgrade mysql to version 5.5 on Ubuntu 15.04 I upgraded the mysql to version 5.6 on Ubuntu 14.04
surprisingly! the cdr kept on working.

Would appreciate if someone can help solving this issue


The error that I am getting:
[2016-04-15 19:24:34] WARNING[1709]: res_odbc.c:503 load_odbc_config: The 'pooling', 'shared_connections', 'limit', and 'idlecheck' options are deprecated. Please see UPGRADE.txt for information
[2016-04-15 19:24:34] WARNING[1709]: res_odbc.c:503 load_odbc_config: The 'pooling', 'shared_connections', 'limit', and 'idlecheck' options are deprecated. Please see UPGRADE.txt for information
[2016-04-15 19:24:34] WARNING[1709]: res_odbc.c:821 odbc_obj_connect: res_odbc: Error SQLConnect=-1 errno=1045 [unixODBC]
[2016-04-15 19:24:34] NOTICE[1709]: res_odbc.c:585 load_odbc_config: Registered ODBC class 'asteriskcdrdb' dsn->[MySQL-asteriskcdrdb]

.
The command isql MySQL-asteriskcdrdb is working fine.
isql MySQL-asteriskcdrdb
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+



The following command returns errors : module reload cdr_adaptive_odbc.so
Module 'cdr_adaptive_odbc.so' reloaded successfully.
-- Reloading module 'cdr_adaptive_odbc.so' (Adaptive ODBC CDR backend)
== Parsing '/etc/asterisk/cdr_adaptive_odbc.conf': Found
[2016-04-15 19:31:41] WARNING[1758]: cdr_adaptive_odbc.c:135 load_config: No such connection 'MySQL-asteriskcdrdb' in the 'asteriskcdrdb' section of cdr_adaptive_odbc.conf. Check res_odbc.conf.


odbc show, returns the following

ODBC DSN Settings
-----------------

Name: asteriskcdrdb
DSN: MySQL-asteriskcdrdb
Last connection attempt: 2016-04-15 19:24:40



cdr show status

Call Detail Record (CDR) settings
----------------------------------
Logging: Enabled
Mode: Simple
Log unanswered calls: No
Log congestion: No

* Registered Backends
-------------------
Adaptive ODBC
cdr_manager




My ODBC related files:
<![if !supportLists]>1. <![endif]>cdr_adaptive_odbc.conf
[asteriskcdrdb]
connection=MySQL-asteriskcdrdb
loguniqueid=yes
table=cdr
alias start => calldate

<![if !supportLists]>2. <![endif]>odbcinst.ini
[MySQL]
Description = ODBC for MySQL
Driver = /usr/lib/arm-linux/odbc/libmyodbc.so
Setup = /usr/lib/arm-linux/odbc/libodbcmyS.so
FileUsage = 1
polling=no

<![if !supportLists]>3. <![endif]>odbc.ini
[MySQL-asteriskcdrdb]
Description=MySQL connection to 'asteriskcdrdb' database
driver=MySQL
server=localhost
Port=3306
username=asterisk
password=xxxxxxxxxxxxxx
Socket=/run/mysqld/mysqld.sock
option=3
database=asteriskcdrdb


<![if !supportLists]>4. <![endif]>res_odbc_additional.conf
[asteriskcdrdb]
enabled=>yes
dsn=>MySQL-asteriskcdrdb
pooling=>no
limit=>1
pre-connect=>yes
username=>asterisk
password=>xxxxxxxxxxxxxx
database=>asteriskcdrdb

<![if !supportLists]>5. <![endif]>cel_odbc_custom.conf
[cel]
connection=MySQL-asteriskcdrdb
loguniqueid=yes
table=cel

Thank you in advance.