Frank Sautter
2005-Aug-10 10:37 UTC
[Asterisk-Users] realtime odbc/mysql eating connections
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
Matthew Boehm
2005-Aug-10 11:25 UTC
[Asterisk-Users] realtime odbc/mysql eating connections
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 > 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 >