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
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
