/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@2012 Database = mytelcoexample Port = 3306 Option = 3
On Mon, Dec 10, 2012 at 4:34 PM, Thorsten Göllner <[email protected]> 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@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
-- _____________________________________________________________________ -- 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
