Hi, I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage (FreeTDS -> Mssql 2008 database). Everything it's working fine, but sometimes I receive this error and Asterisk crashes. [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk /voicemail/default/7002/INBOX'] [Aug 25 13:25:13] WARNING[14032] res_odbc.c: SQL Prepare failed. Attempting a reconnect... [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: Connecting sqlserver [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: res_odbc: Connected to sqlserver [kupalaodbc] Regards Andra? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20100825/33bfc377/attachment.htm
On Wednesday 25 August 2010 07:27:58 Andra? wrote:> I have a strange problem. I'm using Asterisk 1.4.xx with ODBC storage > (FreeTDS -> Mssql 2008 database). Everything it's working fine, but > sometimes I receive this error and Asterisk crashes. > > [Aug 25 13:25:13] WARNING[14032] app_voicemail.c: SQL Prepare > failed![SELECT COUNT(*) FROM pbx_VoiceMail WHERE dir = '/var/spool/asterisk > /voicemail/default/7002/INBOX'] > [Aug 25 13:25:13] WARNING[14032] res_odbc.c: SQL Prepare failed. > Attempting a reconnect... > [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: Connecting sqlserver > [Aug 25 13:25:13] NOTICE[14032] res_odbc.c: res_odbc: Connected to > sqlserver [kupalaodbc] > Regards Andra?Did you enable pooling in res_odbc.conf? It is mandatory when connecting to SQL Server. -- Tilghman Lesher Digium, Inc. | Senior Software Developer twitter: Corydon76 | IRC: Corydon76-dig (Freenode) Check us out at: www.digium.com & www.asterisk.org