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@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.
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
