[asterisk-users] issue with CDR ODBC error on Ubuntu 15.04.1

[Toufic Khreish (Gmail)]

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:

1.       cdr_adaptive_odbc.conf

[asteriskcdrdb]

connection=MySQL-asteriskcdrdb

loguniqueid=yes

table=cdr

alias start => calldate

 

2.       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

 

3.       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

 

 

4.       res_odbc_additional.conf

[asteriskcdrdb]

enabled=>yes

dsn=>MySQL-asteriskcdrdb

pooling=>no

limit=>1

pre-connect=>yes

username=>asterisk

password=>xxxxxxxxxxxxxx

database=>asteriskcdrdb

 

5.       cel_odbc_custom.conf

[cel]

connection=MySQL-asteriskcdrdb

loguniqueid=yes

table=cel

 

Thank you in advance.

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20160417/22143273/attachment.html>