[Asterisk-Users] realtime odbc/mysql eating connections

[Frank Sautter]

Matthew Boehm wrote:
> 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.
> 
> 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.

well after changing from res_odbc to res_mysql and cdr_odbc to cdr_mysql 
this problem was gone. but after i looked if everything was working ok, 
i found my real problem: the cdr database was somehow corrupted and i 
had to make a 'myisamchk --recover'!

regards
  frank