[asterisk-users] ODBC Connection Problem

[Thorsten Göllner]

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/20121210/63807743/attachment.htm>