[asterisk-users] ODBC Connection Problem

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



-- 
Regards,

Chandrakant Solanki
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20121210/2f10dfc6/attachment.htm>