[Asterisk-Users] realtime odbc/mysql eating connections

[Matthew Boehm]

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 at 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
>