Since you are using ODBC, this seems more likely to be an ODBC issue. If
you are concerned, you should just use the native MySQL RealTime driver.
It does not exibit the behavior you mentioned.
-Matthew
Frank Sautter wrote:
our asterisk is configured to retrieve sippeers and iaxpeers via odbc
from a mysql database. after each call "show processlist;" within the
mysql console shows 2 more persistent connections which are showing no
further activity and will not go away even after restaring asterisk.
is anybody else experiencing this?
what can i do do resolve this?
this is a "show processlist" on the mysql console
+-----+----------+-----------+----------+---------+-------+-------+----------------+
| Id | User | Host | db | Command | Time | State | Info
+-----+----------+-----------+----------+---------+-------+-------+----------------+
| 7 | asterisk | localhost | asterisk | Sleep | 2 | | NULL
| 8 | asterisk | localhost | asterisk | Sleep | 13596 |
| NULL | 11 | asterisk | localhost | asterisk | Sleep
| 13596 | | NULL
......... stuff deleted ...............
| 171 | asterisk | localhost | asterisk | Sleep | 31 | | NULL
| 172 | asterisk | localhost | asterisk | Sleep | 31 | | NULL
| 173 | asterisk | localhost | asterisk | Sleep | 1 | | NULL
| 174 | asterisk | localhost | asterisk | Sleep | 1 | | NULL
+-----+----------+-----------+----------+---------+-------+-------+----------------+
160 rows in set (0.00 sec)
# less /etc/odbc.ini
[asterisk]
Description = MySQL Asterisk database
Trace = Off
TraceFile = stderr
Driver = MySQL
Socket = /var/run/mysqld/mysqld.sock
Server = localhost
User = asterisk
Password = <obscured>
#Port = 3306
Database = asterisk
# less /etc/asterisk/res_odbc.conf
[asterisk]
dsn => asterisk
username => asterisk
password => <obscured>
pre-connect => yes
# less /etc/asterisk/extconfig.conf
[settings]
iaxusers => odbc,asterisk,iaxfriends
iaxpeers => odbc,asterisk,iaxfriends
sipusers => odbc,asterisk,sipfriends
sippeers => odbc,asterisk,sipfriends
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________
Asterisk-Users mailing list
[email protected]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
