[asterisk-users] ODBC Connection Problem

[Thorsten Göllner]

First of all test your odbc-connection via console:
isql telco-ops dba c3podb at 2012 -v
You should see a "Connected!"-Message. Do you?

Second: yes I also had problems setting up odbc. The main 
"problem/error" for me was, that documentation is sometimes confusing. 
Here is my config. Please notice the [section] - namings:

/etc/odbcinst.ini
[MySQL]
Description = MySQL ODBCMyODBC Driver
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc.so
FileUsage = 1

/etc/odbc.ini
[MySQL-asterisk]
Description = MySQL ODBC Driver
Driver = MySQL
Socket = /var/run/mysqld/mysqld.sock
Server = localhost
User = my_username
Password = my_password
Database = my_database
Option = 3
Port =
Charset = utf8

/etc/asterisk/res_odbc.conf
[mysql]
enabled => yes
dsn => MySQL-asterisk
username => my_username
password => my_password
pre-connect => yes

/etc/asterisk/cdr_odbc.conf
[global]
dsn=mysql
loguniqueid=yes
dispositionstring=yes
table=cdr

/etc/asterisk/cel_odbc.conf
[first]
connection=mysql
table=cel|
|
Additionally you will need some configurations for you realtime-config. 
This config above is only for cdr- and cel-logging via odbc.

-Thorsten-

Am 10.12.2012 12:23, schrieb Chandrakant Solanki:
> /etc/odbc.ini
>
> [telco-ops]
> Description     = Asterisk realtime and other FUNC_ODBC access
> Driver          = MySQL
> Server          = 172.18.100.18
> Socket          = /var/lib/mysql/data3306/mysql.sock
> User            = dba
> Password        = c3podb at 2012
> Database        = mytelcoexample
> Port            = 3306
> Option          = 3
>
>
>
> On Mon, Dec 10, 2012 at 4:34 PM, Thorsten Göllner <tg at ovm-group.com 
> <mailto:tg at ovm-group.com>> wrote:
>
>     Am 10.12.2012 06:37, schrieb Chandrakant Solanki:
>
>>     Hi All,
>>
>>     OS : CentOS 5 64bit OS & Machine
>>     Asterisk: 1.8.13.0
>>     ODBC Packages:
>>     unixODBC-2.2.11-7.1
>>     mysql-connector-odbc-3.51.12-2.2
>>     unixODBC-devel-2.2.11-7.1
>>
>>     res_odbc.conf
>>
>>     [telco-ops]
>>     enabled => yes
>>     dsn => telco-ops
>>     username => dba
>>     password => c3podb at 2012
>>     pre-connect => yes
>>     sanitysql => select 1
>>     idlecheck => 15
>>     ;isolation => repeatable_read
>>     pooling => yes
>>     limit => 3600
>>     connect_timeout => 10
>>     negative_connection_cache => 30
>>
>>     Above is my installation package and configuration file
>>     (res_odbc.conf), when I try to execute "odbc show all" it always
>>     gives below output.
>>
>>
>>     *CLI> odbc show all
>>
>>     ODBC DSN Settings
>>     -----------------
>>
>>       Name:   telco-ops
>>       DSN:    telco-ops
>>         Last connection attempt: 1970-01-01 00:00:00
>>       Pooled: Yes
>>       Limit:  3600
>>       Connections in use: 1
>>         - Connection 1: connected
>>
>>     When Insert/Update/Select query will be executed, it can't update
>>     last connection attempt field. In result, ODBC stuck after few
>>     minutes, and in this case I also need to restart asterisk,
>>     because I can't type any command, it can't give any command's output.
>>
>>     Also updated asterisk with 10.9.0, but same result.
>>
>
>     Please show us /etc/odbc.ini too.
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121211/f51fed26/attachment.htm>