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.
Need your help on this.
Thanks.
--
Regards,
Chandrakant Solanki
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<http://lists.digium.com/pipermail/asterisk-users/attachments/20121210/e480394e/attachment.htm>
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>