<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Am 10.12.2012 06:37, schrieb Chandrakant Solanki:<br>
<blockquote
cite="mid:CAKnB+B35hwUhYuN=TJKs3OTJ20WaAEiYVU7Wo_KTun3dv8wzyA@mail.gmail.com"
type="cite"><span style="font-family:verdana,sans-serif">Hi All,</span><br
style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">OS : CentOS 5 64bit
OS & Machine</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">Asterisk: 1.8.13.0</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">ODBC Packages:</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">unixODBC-2.2.11-7.1</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">mysql-connector-odbc-3.51.12-2.2</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">unixODBC-devel-2.2.11-7.1</span><br
style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">res_odbc.conf</span><br
style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">[telco-ops]</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">enabled => yes</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">dsn => telco-ops</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">username => dba</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">password =>
c3podb@2012</span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">pre-connect => yes</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">sanitysql =>
select 1</span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">idlecheck => 15</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">;isolation =>
repeatable_read</span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">pooling => yes</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">limit => 3600</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">connect_timeout =>
10</span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">negative_connection_cache
=> 30</span><br style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">Above is my
installation package and configuration file (res_odbc.conf),
when I try to execute "odbc show all" it always gives below
output.</span><br style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
*CLI> odbc show all</span><br
style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
ODBC DSN Settings</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
-----------------</span><br
style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
Name: telco-ops</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
DSN: telco-ops</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
Last connection attempt: 1970-01-01 00:00:00</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
Pooled: Yes</span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
Limit: 3600</span><br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
Connections in use: 1</span><br
style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">
- Connection 1: connected</span><br
style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">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.</span><br style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif">Also updated asterisk
with 10.9.0, but same result.</span><br
style="font-family:verdana,sans-serif">
<br style="font-family:verdana,sans-serif">
<span style="font-family:verdana,sans-serif"></span></blockquote>
<br>
Please show us /etc/odbc.ini too.<br>
</body>
</html>